провайдер (mchost) уведомил о резком превышении нагрузки и отключил доступ к БД и в качестве аргумента привел следующее:
Код: Выделить всё
Из статистики MySQL:
+---------------+-------------------+------------------------+----------------+-----------+--------------+--------------+-----------------+-----------------+----------------+---------------------+-----------------------+
| USER | TOTAL_CONNECTIONS | CONCURRENT_CONNECTIONS | CONNECTED_TIME | BUSY_TIME | ROWS_FETCHED | ROWS_UPDATED | SELECT_COMMANDS | UPDATE_COMMANDS | OTHER_COMMANDS | COMMIT_TRANSACTIONS | ROLLBACK_TRANSACTIONS |
+---------------+-------------------+------------------------+----------------+-----------+--------------+--------------+-----------------+-----------------+----------------+---------------------+-----------------------+
| forum | 24281 | 0 | 49879 | 36905 | 747470 | 31397 | 80976 | 32291 | 194 | 0 | 0 |
+---------------+-------------------+------------------------+----------------+-----------+--------------+--------------+-----------------+-----------------+----------------+---------------------+-----------------------+
Примеры запросов:
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user
_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.p
ost_subject, pt.bbcode_uid
FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt
WHERE p.topic_id = 8185
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time ASC
LIMIT 60, 15;
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user
_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.p
ost_subject, pt.bbcode_uid
FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt
WHERE p.topic_id = 8908
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time ASC
LIMIT 45, 15;
заранее спасибо!