1
Discussion & Troubleshooting / Slow Queries
« on: October 02, 2008, 08:36:10 AM »
My server goes down many times by 4images slow queries.
This is an example of my mysql log:
What should I do?
This is an example of my mysql log:
Code: [Select]
# Query_time: 106 Lock_time: 57 Rows_sent: 14 Rows_examined: 149
use *_img;
SELECT cat_id, COUNT(image_id) AS new_images
FROM 4images_images
WHERE image_active = 1 AND image_date >= 1222467568
GROUP BY cat_id
What should I do?