MySQL has a number of different caches. Most of those are dependent on the storage engine that is used. The key buffer for example caches the indexes for MyISAM tables while the caching of data is left to the OS. InnoDB has the buffer pool for both data and indexes and so on. The query [...]
MySQL Query Cache, Good or Bad?
April 21st, 2009 · 1 Comment
Tags: MySQL · Performance
Enabling and using the slow query log in MySQL
August 26th, 2008 · 2 Comments
By special request here is a post about the MySQL slow query log. MySQL has a wonderful feature that lets you keep track of all queries that took longer than a certain time to complete. To enable it simply add the following line to your my.cnf file:
log-slow-queries = [path to the log file]
Secondly it is [...]
Tags: MySQL · Performance
