Здравствуйте, в настройках
/etc/mysql/my.cnf -
max_connections = 400вот вывод
netstat -an | grep mysqlОтображает соединения свыше того, что выводится на экран.
unix 3 [ ] STREAM CONNECTED 184463004 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184462995 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184461219 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184461217 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184459460 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184459458 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184459283 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184459281 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184457474 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184457472 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184450394 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184443357 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184443342 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437725 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437716 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437387 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437385 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437325 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184437323 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184433540 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184433538 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184429120 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184429118 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184424926 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184424924 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184424426 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184424424 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184423626 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184423615 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184422477 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184422475 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184422292 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184416145 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184416143 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184414163 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184414161 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184413786 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184413784 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184413599 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184413596 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184413350 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184410425 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184410398 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184409523 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184409010 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184409008 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407328 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407326 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407267 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407265 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407037 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184407035 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184403606 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184401096 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184401088 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184400812 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184400808 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184399233 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184399221 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184396354 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184396352 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184394434 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184394432 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184392732 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184392730 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184392440 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184392438 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390965 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390963 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390818 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390813 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390309 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184390304 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184388383 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184387862 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184385284 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184384128 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184384126 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184384097 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184384095 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184379039 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184379037 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184377417 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184377415 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184377002 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184377000 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184376817 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184376815 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184376361 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184376355 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375614 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375612 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375194 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375192 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375139 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375137 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184375017 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184374927 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184374925 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184373932 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184373926 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184373300 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184373297 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371315 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371313 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371266 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371264 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371035 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371032 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184371030 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369678 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369630 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369619 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369616 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369399 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369121 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369119 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369024 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184369004 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184368731 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184368729 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184366668 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184365547 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184365542 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184361113 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184361110 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184360450 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184360441 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184358468 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184358460 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184354298 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184354288 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184353002 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184353000 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184351537 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184350920 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184350599 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184350354 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184350031 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184348050 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184347625 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184347622 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184346165 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184346159 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345979 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345973 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345870 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345555 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345552 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345464 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345461 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345408 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345405 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345358 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345247 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345239 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345166 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345090 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184345088 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184344423 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184344420 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342997 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342995 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342771 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342769 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342136 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184342134 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184341223 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184341221 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184339007 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184338999 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184338500 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184338498 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184336067 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184335548 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184333693 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332873 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332867 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332518 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332512 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332264 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332120 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184332112 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184331533 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184331457 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184330837 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184330835 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184329412 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184329410 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328807 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328804 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328590 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328586 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328575 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328573 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328513 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328510 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328507 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328504 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328328 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184328325 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327932 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327928 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327898 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327890 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327850 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327847 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184327621 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326885 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326814 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326497 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326175 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326145 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326096 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326091 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326065 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326062 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184326039 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325589 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325580 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325314 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325305 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325234 /var/run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 184325231 /var/run/mysqld/mysqld.sock
unix 2 [ ] STREAM CONNECTED 184325100 /var/run/mysqld/mysqld.sock
В результате сайт висит, и хоть тресни. При попытке перегрузить MySQL:
root@dionis:/home/trek# sudo /etc/init.d/mysql restart
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
start: Job failed to start
И в
netstat -an | grep mysql пусто.
Подскажите что это моежт быть, или атака, или флудинг по порту мускуля, или кривые скрипты, которые создают соединение с БД, но не закрывают его, через что количество соединений доходит до максимально допустимого в конфиге, и срабатывает защита?
Тспдампом вроде ничего подозрительного не вижу, разве что оно периодами...