OK, so OSCON is one of, if not the, largest open source conference in the world. The complete list of sessions and tutorials is staggering. So, for those of you Sakila fans heading out to Portland for the "big gig" next week, I figured I would highlight the MySQL sessions and tutorials and also give my top 6 picks of the sessions you simply shouldn't miss.
MySQL Related
- Monday has both my own "Maximum Velocity MySQL" (on performance tuning and coding) and Brian's "MySQL 5.1 In-Depth" tutorials. Note that Brian is also giving …
I’ve just improved innotop substantially, and released version 0.1.106, and I’m also preparing a series of articles on how to use it for real, practical things. I’d like to know what you think of it, what problems you have, what features you want. It would be a huge help if you’d start it, toggle through its modes, and give me your feedback. Enhancements in version 0.1.106 include: InnoDBParser is much more complete and accurate.
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.
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.
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.
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.
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.
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 …
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]