MySQL doesn’t yet provide good tools for some troubleshooting tasks. Fortunately, there is some low-hanging fruit you can pluck. One example is a tool to record who owns a MySQL database connection, so long-running transactions can be traced back to the source. This article demonstrates an easy way to solve that problem. Introduction One of the reasons I wrote the innotop InnoDB and MySQL monitor was to monitor long-running transactions.
Jul
23
2006
Jul
22
2006
One of the most common commands that a MySQL DBA performs is the
SHOW FULL PROCESSLIST command. I can't tell you how many
thousands of times I've run this. The problem is that there is
too much information that I need to filter out before I can focus
on the queries that matter. Fore xample, I don't want to see any
idle connections nor do I want to see my own connection. The
other problem is that if most queries run in under a second, I
miss a lot of queries.
Problem solved!
I have posted a very handy script named proclist.pl to MySQL Forge.This script can be used to
periodically poll the server for queries, with millisecond
precision. Moreover, the output can be imported into a MySQL
database for further analysis.
Jul
22
2006
I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.
The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.
Jul
22
2006
I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.
The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.
Jul
22
2006
I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.
The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.
Jul
22
2006
I'm scribbling this while temporarily stranded in
Vancouver,
Washington. The train had electric trouble so the aircon and
toilets
didn't work (and it's quite a hot day). Now go on
train-sceptics,
have your laugh! But I've seen similar stuff happen in
other
countries, and with airlines also. I'm quite entertained here, I
like
watching people do whatever they do, and there's plenty of that
here.
Amtrak has
been taking good care of us with lots of cold water, ice, and
popsicles... the local fire rescue has come by to check whether
everybody (particularly the older people) were doing ok with the
heat, and just now someone from a local TV station came by …
Jul
22
2006
At OSCON next week, I'm giving a presentation entitled Making Sales While Making Friends: Lessons Learned from Open Source Businesses. I'm in the middle of preparing it, and also reflecting on some conversations I had earlier this week with sales executives from MySQL, Red Hat, JasperSoft, and SugarCRM.
In the course of those conversations, I was surprised by how differently we supposedly similar open source companies run our operations. We're each an open source company, but with varying licensing, sales, and support models. That's a good thing.
But it's also a perplexing thing if you're trying to weave together a common theme between them.
After our meeting, I spent some time on Sourceforge, pulling download data and correlating it to company revenues for these and other open source companies. After awhile, similarities started to …
[Read more]
Jul
22
2006
Many people have complained that the new MySQL Forum misses
an appropriate navigation. Now it's back:
Stay tuned - more enhancements are to come!
Jul
21
2006
Jul
21
2006
Yesterday I received a sample copy of the "SUSE Linux 10.1 OSS - vorkon" DVD, which was assembled by Nicolaus Millin. While I have not installed it yet (as I by now have a very well running installation of SUSE Linux 10.1 on my laptop), the content of the DVD sounds very promising. In addition to incorporating all the updates that have been published since SUSE Linux 10.1 was released (around 100), this version also includes additional drivers like the 3D graphics drivers from ATI and nVidia, network card drivers like ndiswrapper, madwifi and rt2500 as well as drivers for AVM products and Logitech QuickCams. So the base system should already run very smooth …
[Read more]