> Повышенная нагрузка на сервер баз данных MySQL:
>
>
> % DATETIME SERVER USER TOTAL_CONNECTIONS CONCURRENT_CONNECTIONS CONNECTED_TIME
> BUSY_TIME CPU_TIME BYTES_RECEIVED BYTES_SENT BINLOG_BYTES_WRITTEN ROWS_FETCHED
> ROWS_UPDATED TABLE_ROWS_READ SELECT_COMMANDS UPDATE_COMMANDS OTHER_COMMANDS
> COMMIT_TRANSACTIONS ROLLBACK_TRANSACTIONS DENIED_CONNECTIONS LOST_CONNECTIONS
> ACCESS_DENIED EMPTY_QUERIES
>
>
> 6.83% - Срд Мар 24 00:02:38 MSK 2010 ******** 185 0 1477 1356
> 82 252538 1159190 0 9312 70 10354409 821 74 370 0 0 0 2 0 122
> 11.83% - Срд Мар 24 00:22:33 MSK 2010 ******** 347 0 410 350
> 142 357754 1663425 0 16741 72 19272343 1615 77 692 0 0 0 0 0 418
> 14.00% - Срд Мар 24 00:42:35 MSK 2010 ******** 404 0 627 529
> 168 424483 2000663 0 20081 56 22577497 1921 60 808 0 0 0 0 0 588
> 4.75% - Срд Мар 24 01:02:32 MSK 2010 ******** 140 0 138 119
> 57 157957 676045 0 7031 41 7815130 600 40 280 0 0 0 0 0 113
> 6.75% - Срд Мар 24 01:22:30 MSK 2010 ******** 198 0 126 103
> 81 233512 986244 0 9778 66 11286805 875 66 396 0 0 0 0 0 149
> 6.83% - Срд Мар 24 01:42:31 MSK 2010 ******** 226 0 122 102
> 82 278301 1123530 0 10694 115 11690109 1009 128 452 0 0 0 0 0 138
> 5.75% - Срд Мар 24 02:02:28 MSK 2010 ******** 177 0 164 140
> 69 218117 809603 0 8768 63 9830596 802 66 352 0 0 0 0 0 128
> 6.33% - Срд Мар 24 02:22:32 MSK 2010 ******** 180 0 110 93 76
> 270544 1042977 0 9415 60 10519603 796 67 360 0 0 0 0 0 92
> 7.33% - Срд Мар 24 02:42:31 MSK 2010 ******** 228 0 109 97 88
> 265406 1224084 0 11096 70 12430918 995 78 456 0 0 0 0 0 178
> 5.00% - Срд Мар 24 03:02:30 MSK 2010 ******** 157 0 73 63 60
> 191124 722235 0 7477 58 8450858 667 58 314 0 0 0 0 0 108
> 6.75% - Срд Мар 24 03:22:32 MSK 2010 ******** 192 0 90 91 81
> 229102 1107922 0 9815 32 11332781 868 34 382 0 0 0 0 0 180
> 15.33% - Срд Мар 24 03:42:30 MSK 2010 ******** 465 0 246 192
> 184 407748 1746521 0 22860 38 25658400 1875 39 930 0 0 0 0 0 377
> 5.75% - Срд Мар 24 04:02:36 MSK 2010 ******** 167 0 90 79 69
> 195933 829923 0 8622 41 9949399 718 50 332 0 0 0 0 0 92
> 6.25% - Срд Мар 24 04:22:33 MSK 2010 ******** 177 0 163 106
> 75 226951 962745 0 9071 49 10381750 780 51 354 0 0 0 4 0 101
> 8.00% - Срд Мар 24 04:43:13 MSK 2010 ******** 240 0 212 179
> 96 303247 1221700 0 11983 74 13328863 1130 78 480 0 0 0 0 0 248
> 8.08% - Срд Мар 24 05:02:30 MSK 2010 ******** 243 0 143 120
> 97 264351 1120428 0 11929 40 13592192 1023 42 486 0 0 0 0 0 194
> 16.00% - Срд Мар 24 05:22:31 MSK 2010 ******** 480 0 251 209
> 192 543431 2156916 0 23982 119 26043618 1829 119 960 0 0 0 0 0 155
> 12.92% - Срд Мар 24 05:42:30 MSK 2010 ******** 374 0 193 168
> 155 396510 1735380 0 19630 55 21333479 1460 55 748 0 0 0 0 0 106
> 11.75% - Срд Мар 24 06:02:32 MSK 2010 ******** 345 0 191 152
> 141 512604 1768808 0 17071 99 18882233 1361 99 690 0 0 0 0 0 112
> 13.17% - Срд Мар 24 06:22:34 MSK 2010 ******** 399 0 234 171
> 158 414220 1680302 0 19850 107 22094466 1593 116 798 0 0 0 0 0 166
> 16.17% - Срд Мар 24 06:42:32 MSK 2010 ******** 439 0 255 214
> 194 536056 2746606 0 23325 131 26205584 1962 132 878 0 0 0 0 0 159
> 9.17% - Срд Мар 24 07:02:32 MSK 2010 ******** 334 0 145 119
> 110 332207 1424653 0 13633 121 14734544 1147 120 668 0 0 0 0 0 72
> 8.83% - Срд Мар 24 07:22:33 MSK 2010 ******** 314 0 124 118
> 106 563258 2150169 0 12521 155 13056814 1209 155 628 0 0 0 0 0 109
> 11.17% - Срд Мар 24 07:42:33 MSK 2010 ******** 397 0 170 143
> 134 476182 2213546 0 15864 197 17178081 1488 197 794 0 0 0 0 0 155
> 16.92% - Срд Мар 24 08:02:35 MSK 2010 ******** 487 0 288 245
> 203 914220 3205618 0 23176 223 25731113 2015 224 974 0 0 0 1 0 140
> 19.58% - Срд Мар 24 08:22:36 MSK 2010 ******** 550 0 267 259
> 235 1085421 3542943 0 27252 250 30138199 2333 253 1098 0 0 0 0 0 173
> 14.92% - Срд Мар 24 08:42:35 MSK 2010 ******** 457 0 226 197
> 179 492238 1983277 0 21698 94 24053430 1825 95 914 0 0 0 0 0 331
> 12.08% - Срд Мар 24 09:02:34 MSK 2010 ******** 367 0 185 149
> 145 314314 1428476 0 17947 46 20289827 1474 50 734 0 0 0 0 0 297
> 10.17% - Срд Мар 24 09:22:34 MSK 2010 ******** 305 0 169 146
> 122 332288 1464788 0 14970 71 17057869 1386 78 610 0 0 0 0 0 339
> 8.67% - Срд Мар 24 09:42:33 MSK 2010 ******** 259 0 169 131
> 104 240473 1095614 0 12865 32 14648183 1130 34 518 0 0 0 0 0 220
> 7.67% - Срд Мар 24 10:02:37 MSK 2010 ******** 227 0 160 112
> 92 224443 1032579 0 11404 31 13088045 1005 35 454 0 0 0 2 0 227
> 8.92% - Срд Мар 24 10:22:38 MSK 2010 ******** 276 0 255 208
> 107 311669 1249320 0 13010 71 14770748 1238 75 552 0 0 0 0 0 274
> 14.33% - Срд Мар 24 10:42:37 MSK 2010 ******** 413 0 333 299
> 172 533524 2789137 0 21224 108 23917281 1852 109 826 0 0 0 0 0 214
> 7.50% - Срд Мар 24 11:02:38 MSK 2010 ******** 224 0 150 106
> 90 239045 978503 0 11018 48 12518473 968 46 448 0 0 0 0 0 220
>
>
> Каждые 20 минут привышение свыше 2%: CPU_TIME (9-ый столбец) / 1200 сек. = %
> нагрузки