Slow Queries

[omidkorat]

My server goes down many times by 4images slow queries.
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?

[V@no]

I hate to tell you that, but probably change the server...