Bam: MySQL error 28, and suddenly my queries came to a stop.
Error 28 is about disk space, usually the disk space for temp tables. The first thing to do is figure out what filesystem(s) the tables are on. SHOW VARIABLES LIKE “%dir%” will return a number of results, but the ones that matter are tmpdir [...]

Posted May 1, 2007 by Casey
Categories: Technology. Tags: disk space, error, error 28, mysql, mysql optimization, query optimization, table size, temp table. One Comment.

Zach suggested it last week, but it’s only now that I’ve gotten around to setting up MySQL’s slow query log.
It’s easy enough, you’ve just got to put a couple lines like this in your my.cnf (which is in /etc on my server):
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 10
This should get most people running, but this story in [...]

Posted February 13, 2006 by Casey
Categories: Technology. Tags: high performance mysql, mysql, mysql optimization, performance optimization, query optimization, slow queries, slow query log. One Comment.

A couple notes from the past few days of tweaks and fixes:

Hyper-threading has a huge effect on LAMP performance. 
From now on, I’ll have bad dreams about running MySQL without Query Caching in the way that I used to have nightmares about going to school wearing only my underwear. The difference is that big. 
WordPress rocks, but [...]

Posted February 7, 2006 by Casey
Categories: Technology. Tags: hyperthreading, lamp, mysql, mysql optimization, performance optimization, php, server optimization, server performance. 3 Comments.

I have over 1000 posts here at MaisonBisson, but even so, the table with all those posts is under 3MB. Now I’ve got a project with 150,000 posts — yes, 150,000 posts! — and the table is about 500MB. An associated table, structured sort of like WP’s postsmeta, has over 1.5 million records and weighs [...]

Posted January 17, 2006 by Casey
Categories: Technology. Tags: big databases, database optimization, db, mysql, mysql optimization, mytop, optimization, server overload, server sizing. 2 Comments.

I wrote bsuite_speedcache to reduce the number of database queries I was executing per page load. By implementing it on some of the content in my sidebar, I dropped 35 queries for each cache hit. That might not seem like much, but it should average about 525 queries per minute that that my host server [...]

Posted October 3, 2005 by Casey
Categories: Technology. Tags: bsuite, bsuite_speedcache, cache, cache hit, codex, database, database caching, database optimization, database performance, database queries, mysql, mysql caching, mysql optimization, mysql performance, mysql queries, wordpress, wordpress optimization, wordpress performance, wordpress performance optimization, wordpress plugin. 4 Comments.