Partition Tables in MySQL

One of the big deciding factors in the performance of your database is the design of the database. Research from various parties, including Oracle, has found that poor database design is a major factor in poor database performance and unscheduled system downtime. One great way to improve the performance of your MySQL database is to…

Isolate Slow MySQL Processes

Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just increase the resources available to the…