Date: 03/09/06 (Java Web)    Keywords: mysql, database, sql

The MySQL database supporting this blog was consuming massive amount of CPU, which effectively lead to site going down 3-4 times this week. I knew an obvious culprit. However reality differed. I knew for sometime I had a jumbo query, which was not cached, and is likely to contribute to MySQL server load: [...]

Source: http://blog.taragana.com/index.php/archive/mysql-performance-optimization-a-lesson/