dnes ráno se na našem fóru (http://www.metallum.cz) rapidně zvýšila odezva a momentálně nám hosting odstavil DB s následujícím odůvodněním.
Osobně si s tím moc nevím rady, kde hledat chybu, jelikož to začalo z ničeho nic.
Tuší někdo, jak tento problém odstranit?
station.cz píše:Dobry den,
vase databaze metallum_108978, kterou pred chvili kolega odstavil, udelala dnes rano na mysql5-4 pekne dusno, viz nasledujici grafy:
http://www.sdilej.eu/pics/143e4fa39e21c ... 69e886.png
http://www.sdilej.eu/pics/2b18cbdc5143a ... 182082.png
http://www.sdilej.eu/pics/55413341f8b45 ... f9cff9.png
Po jejim odstaveni se situace vratila pred chvili do normalu.
Podle procesu tu visely neustale dotazy tohoto charakteru, i nekolik set sekund:
Ukončit 92750283 metallum.108978 10.0.0.64:35193 metallum_108978 Query 24 closing tables SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750285 metallum.108978 10.0.0.64:35196 metallum_108978 Query 24 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750286 metallum.108978 10.0.0.64:35197 metallum_108978 Query 24 closing tables SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750292 metallum.108978 10.0.0.64:35201 metallum_108978 Query 24 closing tables SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750296 metallum.108978 10.0.0.64:35205 metallum_108978 Query 24 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750297 metallum.108978 10.0.0.64:35206 metallum_108978 Query 24 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750298 metallum.108978 10.0.0.64:35207 metallum_108978 Query 24 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750301 metallum.108978 10.0.0.64:35209 metallum_108978 Query 24 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750421 metallum.108978 10.0.0.64:35277 metallum_108978 Query 21 Sorting result SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Ukončit 92750423 metallum.108978 10.0.0.64:35278 metallum_108978 Query 21 Writing to net SELECT post_subject, forum_id, topic_id, post_id, post_time FROM phpbb_posts WHERE post_approv
Prosime o detailni provereni problemu, po provedeni uprav aby se situace v zadnem pripade neopakovala nas kontaktujte pro spusteni.