overloading the server with mysql

karevan

Member
سلام
چه مواقعی Query های Mysql موجب Overloading سرور میشن؟
آیا امکان داره که این مشکل بخاطر برنامه نویسی پیش اومده باشه؟
چه راههایی برای رفع این مشکل وجود داره؟
ممنون میشم اگه کسی راهنمایی کنه.

راستی این لاگ رو هم دیتاسنتر برام فرستاده ، کسی میدونه مفهوم این لاگ چیه؟

کد:
| 345841 | atp_u        | localhost       | atp_ads            | Query   | 26    | closing tables     | INSERT INTO `clicks` ( `user_id` , `date` , `ip` , `referrer` , `type` , `price` ,`ad_id` )

| 346012 | atp_u        | localhost       | atp_ads            | Query   | 97    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346054 | atp_u        | localhost       | atp_ads            | Query   | 89    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346065 | atp_u        | localhost       | atp_ads            | Query   | 87    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346079 | atp_u        | localhost       | atp_ads            | Query   | 83    | closing tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,30                                  |

| 346090 | atp_u        | localhost       | atp_ads            | Query   | 81    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346093 | atp_u        | localhost       | atp_ads            | Query   | 80    | closing tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,1                                    |

| 346098 | atp_u        | localhost       | atp_ads            | Query   | 79    | closing tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,30                                  |

| 346102 | atp_u        | localhost       | atp_ads            | Query   | 78    | closing tables     | select * from `text` ORDER BY RAND() LIMIT 0,3                                                       |

| 346103 | atp_u        | localhost       | atp_ads            | Query   | 78    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346104 | atp_u        | localhost       | atp_ads            | Query   | 78    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346108 | atp_u        | localhost       | atp_ads            | Query   | 77    | closing tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,30                                  |

| 346111 | atp_u        | localhost       | atp_ads            | Query   | 77    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346117 | atp_u        | localhost       | atp_ads            | Query   | 71    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346119 | atp_u        | localhost       | atp_ads            | Query   | 71    | Opening tables     | select * from `text` ORDER BY RAND() LIMIT 0,3                                                       |

| 346121 | atp_u        | localhost       | atp_ads            | Query   | 71    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346126 | atp_u        | localhost       | atp_ads            | Query   | 71    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,22                                  |

| 346132 | atp_u        | localhost       | atp_ads            | Query   | 71    | closing tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,11                                  |

| 346134 | atp_u        | localhost       | atp_ads            | Query   | 71    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346135 | atp_u        | localhost       | atp_ads            | Query   | 71    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346136 | atp_u        | localhost       | atp_ads            | Query   | 71    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346141 | atp_u        | localhost       | atp_ads            | Query   | 69    | Opening tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,10                                  |

| 346142 | atp_u        | localhost       | atp_ads            | Query   | 69    | closing tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,1                                    |

| 346143 | atp_u        | localhost       | atp_ads            | Query   | 69    | closing tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,15                                  |

| 346145 | atp_u        | localhost       | atp_ads            | Query   | 69    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346154 | atp_u        | localhost       | atp_ads            | Query   | 69    | closing tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346161 | atp_u        | localhost       | atp_ads            | Query   | 68    | closing tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346167 | atp_u        | localhost       | atp_ads            | Query   | 67    | closing tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,1                                    |

| 346168 | atp_u        | localhost       | atp_ads            | Query   | 67    | Opening tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,1                                    |

| 346179 | atp_u        | localhost       | atp_ads            | Query   | 65    | Creating tmp table | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346180 | atp_u        | localhost       | atp_ads            | Query   | 65    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346182 | atp_u        | localhost       | atp_ads            | Query   | 64    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346183 | atp_u        | localhost       | atp_ads            | Query   | 64    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,50                                  |

| 346188 | atp_u        | localhost       | atp_ads            | Query   | 63    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346190 | atp_u        | localhost       | atp_ads            | Query   | 63    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346191 | atp_u        | localhost       | atp_ads            | Query   | 62    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346194 | atp_u        | localhost       | atp_ads            | Query   | 62    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346195 | atp_u        | localhost       | atp_ads            | Query   | 61    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346198 | atp_u        | localhost       | atp_ads            | Query   | 60    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346199 | atp_u        | localhost       | atp_ads            | Query   | 59    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346203 | atp_u        | localhost       | atp_ads            | Query   | 59    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346211 | atp_u        | localhost       | atp_ads            | Query   | 57    | Opening tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,17                                  |

| 346221 | atp_u        | localhost       | atp_ads            | Query   | 52    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346223 | atp_u        | localhost       | atp_ads            | Query   | 52    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346224 | atp_u        | localhost       | atp_ads            | Query   | 52    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346225 | atp_u        | localhost       | atp_ads            | Query   | 52    | Opening tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,2                                    |

| 346228 | atp_u        | localhost       | atp_ads            | Query   | 52    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,30                                  |

| 346236 | atp_u        | localhost       | atp_ads            | Query   | 51    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,3                                    |

| 346238 | atp_u        | localhost       | atp_ads            | Query   | 50    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346253 | atp_u        | localhost       | atp_ads            | Query   | 47    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,3                                   |

| 346254 | atp_u        | localhost       | atp_ads            | Query   | 47    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346255 | atp_u        | localhost       | atp_ads            | Query   | 47    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346257 | atp_u        | localhost       | atp_ads            | Query   | 47    | Opening tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,30                                  |

| 346261 | atp_u        | localhost       | atp_ads            | Query   | 45    | Opening tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,1                                    |

| 346263 | atp_u        | localhost       | atp_ads            | Query   | 45    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346265 | atp_u        | localhost       | atp_ads            | Query   | 44    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346266 | atp_u        | localhost       | atp_ads            | Query   | 44    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,22                                  |

| 346269 | atp_u        | localhost       | atp_ads            | Query   | 44    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,4                                    |

| 346272 | atp_u        | localhost       | atp_ads            | Query   | 44    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346273 | atp_u        | localhost       | atp_ads            | Query   | 43    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346275 | atp_u        | localhost       | atp_ads            | Query   | 42    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,3                                    |

| 346278 | atp_u        | localhost       | atp_ads            | Query   | 41    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346282 | atp_u        | localhost       | atp_ads            | Query   | 41    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346284 | atp_u        | localhost       | atp_ads            | Query   | 40    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346312 | atp_u        | localhost       | atp_ads            | Query   | 32    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346314 | atp_u        | localhost       | atp_ads            | Query   | 32    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346317 | atp_u        | localhost       | atp_ads            | Query   | 31    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346319 | atp_u        | localhost       | atp_ads            | Query   | 30    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346320 | atp_u        | localhost       | atp_ads            | Query   | 30    | Opening tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,15                                  |

| 346321 | atp_u        | localhost       | atp_ads            | Query   | 30    | Opening tables     | select * from `banner` where `type`='2' ORDER BY RAND() LIMIT 0,2                                    |

| 346322 | atp_u        | localhost       | atp_ads            | Query   | 30    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,2                                    |

| 346326 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,3                                    |

| 346327 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346329 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,7                                    |

| 346332 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346333 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,22                                  |

| 346335 | atp_u        | localhost       | atp_ads            | Query   | 29    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346341 | atp_u        | localhost       | atp_ads            | Query   | 28    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346343 | atp_u        | localhost       | atp_ads            | Query   | 28    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,3                                    |

| 346344 | atp_u        | localhost       | atp_ads            | Query   | 28    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346349 | atp_u        | localhost       | atp_ads            | Query   | 27    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,2                                    |

| 346352 | atp_u        | localhost       | atp_ads            | Query   | 27    | Opening tables     | select * from `text` ORDER BY RAND() LIMIT 0,3                                                       |

| 346358 | atp_u        | localhost       | atp_ads            | Query   | 25    | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346359 | atp_u        | localhost       | atp_ads            | Query   | 24    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346367 | atp_u        | localhost       | atp_ads            | Query   | 22    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346368 | atp_u        | localhost       | atp_ads            | Query   | 22    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,7                                    |

| 346370 | atp_u        | localhost       | atp_ads            | Query   | 21    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346371 | atp_u        | localhost       | atp_ads            | Query   | 21    | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,20                                  |

| 346372 | atp_u        | localhost       | atp_ads            | Query   | 21    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346374 | atp_u        | localhost       | atp_ads            | Query   | 19    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346377 | atp_u        | localhost       | atp_ads            | Query   | 19    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346379 | atp_u        | localhost       | atp_ads            | Query   | 19    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346384 | atp_u        | localhost       | atp_ads            | Query   | 17    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346385 | atp_u        | localhost       | atp_ads            | Query   | 17    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,4                                    |

| 346394 | atp_u        | localhost       | atp_ads            | Query   | 15    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346399 | atp_u        | localhost       | atp_ads            | Query   | 14    | Opening tables     | select * from `linkbox` where `type`='0' ORDER BY RAND() LIMIT 0,30                                  |

| 346400 | atp_u        | localhost       | atp_ads            | Query   | 14    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346402 | atp_u        | localhost       | atp_ads            | Query   | 13    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346406 | atp_u        | localhost       | atp_ads            | Query   | 12    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,7                                    |

| 346408 | atp_u        | localhost       | atp_ads            | Query   | 12    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346413 | atp_u        | localhost       | atp_ads            | Query   | 10    | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346420 | atp_u        | localhost       | atp_ads            | Query   | 9     | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346421 | atp_u        | localhost       | atp_ads            | Query   | 9     | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,2                                    |

| 346422 | atp_u        | localhost       | atp_ads            | Query   | 9     | Opening tables     | select * from `linkbox` where `type`='1' ORDER BY RAND() LIMIT 0,22                                  |

| 346423 | atp_u        | localhost       | atp_ads            | Query   | 9     | Opening tables     | select * from `text` ORDER BY RAND() LIMIT 0,3                                                       |

| 346426 | atp_u        | localhost       | atp_ads            | Query   | 8     | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346427 | atp_u        | localhost       | atp_ads            | Query   | 8     | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,5                                    |

| 346428 | atp_u        | localhost       | atp_ads            | Query   | 8     | Opening tables     | select * from `banner` where `type`='1' ORDER BY RAND() LIMIT 0,2                                    |

| 346431 | atp_u        | localhost       | atp_ads            | Query   | 7     | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346435 | atp_u        | localhost       | atp_ads            | Query   | 6     | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |

| 346439 | atp_u        | localhost       | atp_ads            | Query   | 6     | Opening tables     | select * from `banner` where `type`='0' ORDER BY RAND() LIMIT 0,1                                    |
 

جدیدترین ارسال ها

بالا