So I started the daunting task of reviewing the slow_query_log and found it littered with entries like this:
Code:
# Fri Sep 9 05:49:08 2011
# Query_time: 1.300991 Lock_time: 0.000094 Rows_sent: 1 Rows_examined: 3
use database_name;
select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url
from banners
where status = 1 and ( banners_group = 'SideBox-Banners') order by rand()
One for each banner group for every request made. So for one product view, there are 5 entries like this for the banners.
1.3 seconds doesn't sound like a long time, but when I only get every 300th of a clock tick to process, it takes FOREVER.
I get these for every domain on the server. Do I need to drop the banners table and recreate it? think this table is corrupt on each domain?
Bookmarks