View Single Post
  #49  
Old 27th October 2010, 22:55
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Just for the heck of it, today's mysql-slow.log is around 2MB. A clear majority of the log is full of ISPCONFIG related SQL queries. But, here's a snippet from the bottom:

Code:
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208162;
# Time: 101027 15:42:05
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:42:56
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
use dbispconfig;
SELECT access FROM mail_access WHERE source='125.166.191.119' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125.166.191' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125.166' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125' and type = 'client' and active = 'y';
# Time: 101027 15:43:19
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:43:30
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:43:38
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:44:45
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:02
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use dbispconfig;
DELETE FROM monitor_data WHERE type ='harddisk_quota' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208462;
# Time: 101027 15:45:08
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126.177.9' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126.177' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77' and type = 'client' and active = 'y';
# Time: 101027 15:45:16
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='athedsl-362929.home.otenet.gr' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202.145.114' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202.145' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202' and type = 'client' and active = 'y';
# Time: 101027 15:45:22
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:51
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:45:52
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 286  Rows_examined: 327
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:53
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:45:54
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:46:14
# User@Host: c1sebastianlodgu[c1sebastianlodgu] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1sebastianlodge;
DELETE FROM wp_statpress WHERE date < '20100727';
# Time: 101027 15:46:56
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:47:30
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */;
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(DATA_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */;
# Time: 101027 15:47:31
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='MyISAM' */;
# Time: 101027 15:47:32
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' */;
# Time: 101027 15:47:37
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 3  Rows_examined: 375
SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 369
SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY';
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 386
SELECT IFNULL(SUM(INDEX_LENGTH),0) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema') AND ENGINE = 'MyISAM';
# Time: 101027 15:47:50
# User@Host: c1mediawiki[c1mediawiki] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1mediawiki;
UPDATE /* SiteStatsUpdate::doUpdate 67.195.111.161 */ `site_stats` SET ss_total_views=ss_total_views+1;
# Time: 101027 15:48:01
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
use dbispconfig;
SELECT access FROM mail_access WHERE source='athedsl-229737.home.otenet.gr' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74.217.7' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74.217' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85' and type = 'client' and active = 'y';
# Time: 101027 15:48:55
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:49:33
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:50:02
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use dbispconfig;
DELETE FROM monitor_data WHERE type ='harddisk_quota' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208762;
# Time: 101027 15:50:03
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208763;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208763;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208763;
# Time: 101027 15:50:27
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
Yeah it's a single HDD running the server with a slave HDD for backups.

I don't seem to be getting any errors from other daemons UNLESS the whole server goes ape from load/wait issues.
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 27th October 2010 at 22:58.
Reply With Quote