Blog
We need more CATs
Before you think I’ve posted an animal story in my MySQL category please read on. For reference, The RAT and the CAT is something I wrote back in 2006, that explains the CAT part.
Handy MySQL documentation indexes
Updated If your wanting to know more about MySQL Indexes on tables, then check out Understanding Different MySQL Index Implementations . I just discovered today in the MySQL 5.1 Reference Manual a handy set of additional indexes in the System Navigation section.
Have you checked your MySQL error log today?
As a consultant I would be rich if I made money every time when asking “Have you checked the MySQL error log?” Today’s special found in a 13GB MySQL server error log.
Getting started with Gearman
Gearman is an open source generic framework for distributed processing. At OSCON 2009 I attended the Gearman: Build Your Own Distributed Platform in 3 Hours tutorial. While it’s very easy to install Gearman, and follow the first example, if you missed the all important additional PHP steps listed on just one slide you may be left with the “‘Class ‘GearmanClient’ not found” error.
Setting up sysbench with MySQL & Drizzle
Sysbench is a open source product that enables you to perform various system benchmarks including databases. Drizzles performs regression testing of every trunk revision with a branched version of sysbench within Drizzle Automation .
configure: error: mysql_config executable not found
If your compiling a product that includes a dependency of MySQL, you can easily get the error configure: error: mysql_config executable not found I generally don’t see this problem, because I use MySQL binary tar files, however if you use MySQL packages, such as Ubuntu, you can easily miss the required dependency.
Understanding Different MySQL Index Implementations
It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.
mysql.com and related sites are down
I tried to go to mysql.com and Planet MySQL over my lunch break at OSCON 2009 to find the websites are down. Seems from conversions with fellow Drizzle colleagues this has been down for some time.
Drizzle Query logging
Currently Drizzle offers three (3) separate query logging plugins. These plugins offer an extensible means of gathering all or selected queries and provide the foundation for a query analyser tool. Additional filtering includes selecting queries by execution time, result size, rows processed and by any given regular expression via PCRE.
What’s new in MySQL 5.4.1
Absolutely nothing? 5.4.0 was released with a change in the MySQL Binary distributions , delivering only 1 64bit Linux platform and two Sun Solaris platforms. This was officially announced on April 21 2009 however the 5.
What to do at 3:25am
Look at MySQL bug reports of course? Well actually I’m writing multiple blog posts, and I was confirming additional reference sources and links when I came across MySQL Bug #29847 – Large CPU usage of InnoDB crash recovery with a big buf pool.
Never let your binlog directory fill up
Recently with a client while running a number of disaster recovery tests I came across a nasty situation which was not part of the original plan and provided a far worse disaster situation then expected.
Getting wireless working on Ubuntu Macbook
I run Ubuntu 9.04 Januty on my Macbook. Previously installing Ubuntu 8.10, wireless worked automatically, for 9.04 it did not. This is what I did to fix it. Verify your Macbook is seeing the Broadcom controller.
Understanding more InnoDB MVCC
As I had written earlier in Understanding InnoDB MVCC , I am trying to understand why InnoDB is taking a lock on data during an UPDATE when I do not expect this to happen.