Перегрузка баз (mysql overload)

[oosoo]

Трекер стоит на зарубежном хосте.Дня 2 назад сайт отключили по причине перегрузка mysql

В ответь мне говорит:

Код: Выделить всё

DataBase ecmjapa_kol chmoded to zero

Time: 13% (2008 sec) Amount: 14% (133 queries) Rows Examined/Sent: 235 / 103 Avg. Query Exec/Lock Time: 15 / 4 sec.
use ecmjapa_kol; SELECT tp.ip, tp.port FROM kol_tracker_peers tp WHERE tp.torrent = '506' AND tp.id!='30118';

Time: 11% (1756 sec) Amount: 13% (125 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 14 / 3 sec.
use ecmjapa_kol; DELETE FROM kol_tracker_peers WHERE torrent='911' AND id!='31211' AND userid='130';

Time: 9% (1465 sec) Amount: 10% (92 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 15 / 6 sec.
use ecmjapa_kol; UPDATE kol_tracker_snatched SET port = '53357', connectable = 'no', last_action = '1260270926', seeder = 'yes', to_go='0' WHERE torrent = '280' AND userid = '2';

Time: 9% (1461 sec) Amount: 11% (107 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 13 / 3 sec.
use ecmjapa_kol; UPDATE kol_tracker_peers tp SET ip = '124.158.74.139', port = '42336', last_action = '1260283245', prev_action = '1260282642', agent = 'BitTorrent/6200(15918)', seeder = 'yes', to_go='0' WHERE tp.torrent = '404' AND tp.peer_id='TTYtMi0wLS0uPiqUeTjZenbXJqs=';

Time: 7% (1164 sec) Amount: 8% (80 queries) Rows Examined/Sent: 147 / 80 Avg. Query Exec/Lock Time: 14 / 3 sec.
use ecmjapa_kol; SELECT SUM(IF(seeder='yes', 1, 0)) seeder, SUM(IF(seeder='no', 1, 0)) leecher FROM kol_tracker_peers WHERE torrent='220';

Time: 5% (799 sec) Amount: 5% (50 queries) Rows Examined/Sent: 1724 / 50 Avg. Query Exec/Lock Time: 15 / 4 sec.
use ecmjapa_kol; SELECT SUM(IF(seeder='yes', 1, 0)) seed, SUM(IF(seeder='no', 1, 0)) leech FROM kol_tracker_peers WHERE userid='130' AND '1260283295' - last_action < 1800;

Time: 5% (777 sec) Amount: 4% (40 queries) Rows Examined/Sent: 40 / 40 Avg. Query Exec/Lock Time: 19 / 9 sec.
use ecmjapa_kol; SELECT tt.id, tt.seeders, tt.leechers, tt.times_completed, tt.added, tt.free, tt.size, tt.upload, tt.forb, tt.last_cleanup, tt.req_ratio, tt.req_upload, tt.poster_id, u.user_id, u.user_uploaded, u.user_downloaded, u.user_permissions, u.user_bonus, u.user_type FROM kol_tracker_torrents tt LEFT JOIN kol_users u ON u.user_passkey = '83ebe9d2880689541e7ab69da2451352' WHERE tt.info_hash='e1df5b09684e7613b67289575ad5427dccb83480' AND u.user_type IN (0, 3) LIMIT 1;

Time: 4% (617 sec) Amount: 3% (31 queries) Rows Examined/Sent: 40 / 31 Avg. Query Exec/Lock Time: 19 / 7 sec.
use ecmjapa_kol; SELECT a.attach_id, a.in_message, a.extension, p.post_id, f.forum_id, f.forum_status, f.forum_password, f.forumas, tp.seeder, tp.last_action, tp.id, tp.uploaded, tp.downloaded, IF(tp.userid = '130', tp.rights, 0) rights FROM kol_attachments a LEFT JOIN kol_posts p ON p.post_id=a.post_msg_id LEFT JOIN kol_forums f ON f.forum_id=p.forum_id LEFT JOIN kol_tracker_peers tp ON tp.torrent = '866' AND tp.peer_id='TTYtMi0wLS0uPiqUeTjZenbXJqs=' WHERE a.attach_id = '866' LIMIT 1;

Total Time : 10047 sec / Date : 2009-12-09

На Трекере стоит обновление 21 (виноват сам не обновлял, каюс ).

Как решить вопрос с чем это связона?

[PPK]

1. Обновится до последней версии
2. Оптимизировать таблицу kol_tracker_peers (да и все остальные таблицы, и периодически это делать)
3. Увеличить время аннонс интервала (опция: Интервал обращений к трекеру)
4. Сменить хостера?