On 12/12/2007, Nicolas BOUTHORS <[EMAIL PROTECTED]> wrote: > Probably not related to the purge script but you will gain performance > by giving a size to the MySQL query cache size. > > Use "SHOW VARIABLES LIKE '%cache%';" to confirm it has the (stupid) > default value of 0. And then add a "query_cache_size = 8M" to to > [mysqld], it WILL ease the SELECT occuring while you purge. > tables too.
This solved the problem, thanks! I'll also get onto the thread which Steve suggested I read.
