Make sure your tables are well indexed. MySQL tends to be a bit of a CPU hog, so if you have all your tables properly indexed, and you're hitting load issues, it may be time to look at interbase or postgresql for better load handling. In my experience they're both a little slower than mysql at simple stuff, but provide much lower CPU load (i.e. they both tend to be more I/O bound than CPU bound.)
