
21-09-2011, 15:04:40
|
| |
MySQL Sorunu | | Merhaba. Hosting şirketi, sistemi aşırı yorduğumu söyledi ve alttaki loğ dosyasını gönderdi. Açıkçası pek bişey anlamadım. Bir açıklamasını yapibilir misiniz? ve sorunun çözümü nedir? Alıntı: |
MySQL Process List Main >> SQL Services >> Show MySQL Processes Id User Host db Command Time State Info 430604 Query 363 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 4788 ORDER BY `meta_count` DE 430733 Query 47 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 6333 ORDER BY `meta_count` DE 430959 Query 59 Locked UPDATE `wp_options` SET `option_value` = 'a:5:{i:1316289592;a:1:{s:8:\"ddp_cron\";a:1:{s:32 :\"40cd75 430967 Query 58 Locked UPDATE `wp_options` SET `option_value` = 'a:5:{i:1316289592;a:1:{s:8:\"ddp_cron\";a:1:{s:32 :\"40cd75 431012 Query 395 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 1361 ORDER BY `meta_count` DE 431179 Query 426 update INSERT INTO wp_stt2_meta ( `post_id`,`meta_value`,`meta_count` ) VALUES ( '34086', 'wolfteam indir', 431193 Query 53 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 5945 ORDER BY `meta_count` DE 431244 Query 118 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 652 ORDER BY `meta_count` DES 431260 Query 424 Locked INSERT INTO wp_stt2_meta ( `post_id`,`meta_value`,`meta_count` ) VALUES ( '34086', 'wolfteam indir', 431264 Query 393 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 31940 ORDER BY `meta_count` D 431269 Query 115 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431270 Query 97 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431275 Query 384 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431278 Query 73 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 29996 ORDER BY `meta_count` D 431282 Query 380 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431283 Query 59 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431287 Query 57 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431288 Query 61 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431286 Query 53 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431284 Query 91 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 29996 ORDER BY `meta_count` D 431277 Query 96 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 29996 ORDER BY `meta_count` D 431290 Query 53 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431299 Query 117 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 652 ORDER BY `meta_count` DES 431302 Query 386 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 34702 ORDER BY `meta_count` D 431306 Query 53 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 29996 ORDER BY `meta_count` D 431308 Query 361 Locked SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 12434 ORDER BY `meta_count` D .....
| |