Hi Tom,
Here's the query log - mysqld.slow.log...
/usr/libexec/mysqld, Version: 3.23.58-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 050107 17:40:27
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 446 Rows_examined: 446
use zencarttest;
select configuration_key as cfgkey, configuration_value as cfgvalue
from zen_configuration;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 76 Rows_examined: 76
select configuration_key as cfgkey, configuration_value as cfgvalue
from zen_product_type_layout;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 2
select code, title, symbol_left, symbol_right, decimal_point,
thousands_point, decimal_places, value
from zen_currencies;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3
select * from zen_get_terms_to_filter;
# Time: 050107 17:40:28
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 114
select layout_box_name from zen_layout_boxes where (layout_box_status=1 or
layout_box_status_single=1) and layout_template ='classic' and
layout_box_name='search_header.php';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
select categories_id from zen_categories where categories_status=1 limit 1;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='4' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='421' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='426' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='26' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='29' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='30' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='31' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='34' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='204' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='43' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='46' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='52' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='346' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='427' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='54' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='353' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='355' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='356' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='357' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='303' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='428' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='58' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='369' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='430' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='418' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='380' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='341' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='75' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='78' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='10' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='79' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='80' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='389' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='84' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='425' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='304' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='87' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='89' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='431' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='424' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='109' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='114' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='115' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='422' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='134' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='135' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='419' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='420' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='161' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='163' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='429' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='167' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='168' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='169' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='170' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='300' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='176' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='178' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='432' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='320' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='181' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='183' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='184' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='198' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='199' and product_type_id='3';
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 21
select product_type_id from zen_product_types_to_category where
category_id='200' and product_type_id='3';
# Time: 050107 17:40:34
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
use graphicforum;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:40:41
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 13 Lock_time: 0 Rows_sent: 148 Rows_examined: 1567270
use zencarttest;
select distinct m.manufacturers_id, m.manufacturers_name
from zen_manufacturers m
left join zen_products p on m.manufacturers_id =
p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and
p.products_status= '1'
order by manufacturers_name;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 17
select count(*) as count from zen_banners_history where
banners_id = '0' and date_format(banners_history_date, '%Y%m%d') =
date_format(now(), '%Y%m%d');
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
update zen_banners_history set banners_shown = banners_shown +1 where
banners_id = '0' and date_format(banners_history_date, '%Y%m%d') =
date_format(now(), '%Y%m%d');
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3
select * from zen_get_terms_to_filter;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 449
select configuration_key, configuration_value from zen_configuration where
configuration_key RLIKE 'SHOW_PRODUCT_INFO_MAIN' and configuration_value > 0
order by configuration_value;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 25446
select p.products_id, pd.products_name, products_date_available as
date_expected
from zen_products p, zen_products_description pd
where to_days(products_date_available) >=
to_days(now())
and p.products_id = pd.products_id
and pd.language_id = '1'
order by date_expected desc
limit 10;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 17
select count(*) as count from zen_banners_history where
banners_id = '0' and date_format(banners_history_date, '%Y%m%d') =
date_format(now(), '%Y%m%d');
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
update zen_banners_history set banners_shown = banners_shown +1 where
banners_id = '0' and date_format(banners_history_date, '%Y%m%d') =
date_format(now(), '%Y%m%d');
# Time: 050107 17:40:42
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 1 Lock_time: 0 Rows_sent: 10 Rows_examined: 25498
select distinct p.products_id, pd.products_name, p.products_ordered
from zen_products p, zen_products_description
pd
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '1'
order by p.products_ordered desc,
pd.products_name
limit 10;
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
update zen_counter set counter = '890';
# Time: 050107 17:40:43
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
use graphicguestbookdata;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:06
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
use graphicforum;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 42 Rows_examined: 42
SELECT code, smile_url FROM phpbb_smilies;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
SELECT *
FROM phpbb_config;
# Time: 050107 17:41:07
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 42 Rows_examined: 42
SELECT code, smile_url FROM phpbb_smilies;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 42 Rows_examined: 42
SELECT code, smile_url FROM phpbb_smilies;
# Time: 050107 17:41:09
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
use graphicguestbookdata;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:11
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
use graphicforum;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:33
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:45
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
use graphicguestbookdata;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:59
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 60 Rows_examined: 60
use graphicforum;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:42:11
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
use graphicguestbookdata;
SELECT *
FROM phpbb_config;
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
-----Original Message-----
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 07, 2005 4:03 PM
To: BD
Cc: [email protected]
Subject: RE: Slow queries, need advice on how to improve; key_buffer -
zen-cart?
[snip]
The application I am using for the site is www.zen-cart.com so I'm not sure
I can do anything about changing the table indexes because it is a pre
written php-MySQL open source freeware script. I'm getting the query times
directly from the application and not MySQL.
[/snip]
You could turn on logging in mysql to see what the query is that is taking
so long, then make sure the tables are properly indexed based on this. I
would hope that this software has properly indexed the tables, but you can
verify this on your own.
Add the following to your my.cnf to enable the logging of slow queries.
[mysqld]
set-variable = long_query_time=2
log-long-format
log-slow-queries = /var/log/mysqld.slow.log (or whatever file you want, just
make sure the user mysqld is running as has write permissions to it.)
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
