КАК ЧИСТЯТСЯ ТАБЛИЦЫ
КАК ЧИСТЯТСЯ ТАБЛИЦЫ
Я не силен в mysql но беда пришла не предупредив tsave дает ошибку и почитав пришел к выводу что таблицы переполнены подскажите как енто сделать .... ОЧЕНЬ ВАЖНО поверьте не поленитесь черканите пару строк как
Re: КАК ЧИСТЯТСЯ ТАБЛИЦЫ
http://www.mysql.ru/docs/man/hobot писал(а):Я не силен в mysql но беда пришла не предупредив tsave дает ошибку и почитав пришел к выводу что таблицы переполнены подскажите как енто сделать .... ОЧЕНЬ ВАЖНО поверьте не поленитесь черканите пару строк как
Ежемесячно после бухгалтерского отчёта выполняю следующий скрипт, изменяя дату предыдущего месяца:
use UTM;
flush tables;
DELETE FROM UTM_logs WHERE event_date < unix_timestamp('2005-04-01 00:00:00');
repair table UTM_logs extended;
optimize table UTM_logs;
DELETE FROM ip_addr_used WHERE use_start_date < unix_timestamp('2005-04-01 00:00:00');
repair table ip_addr_used extended;
optimize table ip_addr_used;
DELETE FROM balance_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table balance_history extended;
optimize table balance_history;
DELETE FROM bills_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table bills_history extended;
optimize table bills_history;
DELETE FROM discount_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table discount_current extended;
optimize table discount_current;
DELETE FROM discount_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table discount_history extended;
optimize table discount_history;
DELETE FROM prod_discount WHERE discount_date < unix_timestamp('2005-04-01 00:00:00');
repair table prod_discount extended;
optimize table prod_discount;
DELETE FROM prod_discount_history WHERE discount_date < unix_timestamp('2005-04-01 00:00:00');
repair table prod_discount_history extended;
optimize table prod_discount_history;
DELETE FROM radius_packets_access WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_access extended;
optimize table radius_packets_access;
DELETE FROM radius_packets_accounting WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_accounting extended;
optimize table radius_packets_accounting;
DELETE FROM radius_packets_td WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_td extended;
optimize table radius_packets_td;
DELETE FROM sessions WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table sessions extended;
optimize table sessions;
DELETE FROM sessions_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table sessions_history extended;
optimize table sessions_history;
DELETE FROM traffic WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic extended;
optimize table traffic;
DELETE FROM traffic_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_current extended;
optimize table traffic_current;
DELETE FROM traffic_day WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_day extended;
optimize table traffic_day;
DELETE FROM traffic_discount_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_discount_current extended;
optimize table traffic_discount_current;
DELETE FROM traffic_discount_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_discount_history extended;
optimize table traffic_discount_history;
DELETE FROM traffic_month WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_month extended;
optimize table traffic_month;
DELETE FROM traffic_opt_day WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_day extended;
optimize table traffic_opt_day;
DELETE FROM traffic_opt_month WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_month extended;
optimize table traffic_opt_month;
DELETE FROM traffic_opt_year WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_year extended;
optimize table traffic_opt_year;
DELETE FROM traffic_tmp WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_tmp extended;
optimize table traffic_tmp;
DELETE FROM traffic_year WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_year extended;
optimize table traffic_year;
repair table users extended;
optimize table users;
use UTM;
flush tables;
DELETE FROM UTM_logs WHERE event_date < unix_timestamp('2005-04-01 00:00:00');
repair table UTM_logs extended;
optimize table UTM_logs;
DELETE FROM ip_addr_used WHERE use_start_date < unix_timestamp('2005-04-01 00:00:00');
repair table ip_addr_used extended;
optimize table ip_addr_used;
DELETE FROM balance_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table balance_history extended;
optimize table balance_history;
DELETE FROM bills_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table bills_history extended;
optimize table bills_history;
DELETE FROM discount_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table discount_current extended;
optimize table discount_current;
DELETE FROM discount_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table discount_history extended;
optimize table discount_history;
DELETE FROM prod_discount WHERE discount_date < unix_timestamp('2005-04-01 00:00:00');
repair table prod_discount extended;
optimize table prod_discount;
DELETE FROM prod_discount_history WHERE discount_date < unix_timestamp('2005-04-01 00:00:00');
repair table prod_discount_history extended;
optimize table prod_discount_history;
DELETE FROM radius_packets_access WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_access extended;
optimize table radius_packets_access;
DELETE FROM radius_packets_accounting WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_accounting extended;
optimize table radius_packets_accounting;
DELETE FROM radius_packets_td WHERE recv_date < unix_timestamp('2005-04-01 00:00:00');
repair table radius_packets_td extended;
optimize table radius_packets_td;
DELETE FROM sessions WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table sessions extended;
optimize table sessions;
DELETE FROM sessions_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table sessions_history extended;
optimize table sessions_history;
DELETE FROM traffic WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic extended;
optimize table traffic;
DELETE FROM traffic_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_current extended;
optimize table traffic_current;
DELETE FROM traffic_day WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_day extended;
optimize table traffic_day;
DELETE FROM traffic_discount_current WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_discount_current extended;
optimize table traffic_discount_current;
DELETE FROM traffic_discount_history WHERE date < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_discount_history extended;
optimize table traffic_discount_history;
DELETE FROM traffic_month WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_month extended;
optimize table traffic_month;
DELETE FROM traffic_opt_day WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_day extended;
optimize table traffic_opt_day;
DELETE FROM traffic_opt_month WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_month extended;
optimize table traffic_opt_month;
DELETE FROM traffic_opt_year WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_opt_year extended;
optimize table traffic_opt_year;
DELETE FROM traffic_tmp WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_tmp extended;
optimize table traffic_tmp;
DELETE FROM traffic_year WHERE ftime < unix_timestamp('2005-04-01 00:00:00');
repair table traffic_year extended;
optimize table traffic_year;
repair table users extended;
optimize table users;