Если собственный сервер то для начала размести tmp для MySQL таблиц в памяти tempfs (dev/shm).
На время помогло. Ща заного идут запросы....
16360 root localhost:59073 24kzdbnew Query 1 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16368 root localhost:59089 24kzdbnew Query 1 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16371 root localhost:59095 24kzdbnew Query 1 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16393 root localhost:59142 24kzdbnew Query 0 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16413 root localhost:59187 24kzdbnew Query 2 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16427 root localhost:59217 24kzdbnew Query 1 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16432 root localhost:59227 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16443 root localhost:59251 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16447 root localhost:59260 24kzdbnew Query 1 Copying to tmp table SELECT DISTINCT
cats.name AS cat_name,
cat...
Завершить 16449 root localhost:59268 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16450 root localhost:59269 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16452 root localhost:59272 24kzdbnew Query 2 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16453 root localhost:59275 24kzdbnew Sleep 1 NULL
Завершить 16455 root localhost:59278 24kzdbnew Sleep 1 NULL
Завершить 16456 root localhost:59281 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16458 root localhost:59284 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16459 root localhost:59286 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16464 root localhost:59297 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16466 root localhost:59303 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16470 root localhost:59313 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...
Завершить 16487 root localhost:59353 24kzdbnew Query 1 Sending data SELECT i.*,c.name AS categoryname,c.id AS category...