I’m not sure how I didn’t see this earlier, but it looks like MySQL 5.1 is coming with a load balancer for replicated servers. I’m absolutely pumped about this – we’ve got a few sites running with multiple db slaves and it’s so annoying having to check if they’re behind the master.

It looks [...]

While I’ve known how floating points are stored, I didn’t know if decimal was stored any differently, or if it was more or less accurate. According to a post on the MySQL list:

Bruno Rodrigues Silva wrote:
> Dear all.
>
> The MySQL Manual inform that Decimal Data Type is [...]

MySQL query cache can be useful, if it works. Here’s how to check it’s effectiveness.

show status like ‘qc%’;
+————————-+———-+
| Variable_name | Value |
+————————-+———-+
| Qcache_free_blocks | 6407 |
| Qcache_free_memory | 24176544 |
| Qcache_hits | 3075026 |
| Qcache_inserts | 2435740 |
| [...]

Let me first state that I’ve only run MySQL on Linux and MacOS X, never Windows.

This is the first I’ve heard of Innodb having massive performance issues.

Check out Karl Seguin’s blog post.

After banging my head against a wall for a while, I finally found this thread from June 2005 in the MySQL support forums regarding using variables in the LIMIT clause. They don’t support it yet. There’s no time table that indicates when it will be supported either. It’s very unfortunate, I was looking forward [...]

Aggregates are awesome. But sometimes you want to do 2 counts in a query, and have one of them be more restrictive than the other. Lets say our database focuses on pictures, and rating them on a scale from 1-100. We want to know the average rating, the minimum rating, the max, the number of [...]