Not the answer you need?
Register and ask your own question!

Server starts to work slowly or hangs

DksysDksys EntrantCurrent User Role Beginner
Then server load grows, server starts to work slowly or hangs. In slow log appears queries, witch in normal mode performed immediately and
With this commands I got log file in moment of peak load
FILE=/root/mysql/log/`date +%d-%m-%Y-%H_%M_%S`.log
mysql -uroot -p --auto-vertical-output -e "SHOW ENGINE INNODB STATUS" >> $FILE
mysql -uroot -p --auto-vertical-output -e "SHOW FULL PROCESSLIST" >> $FILE
mysql -uroot -p --auto-vertical-output -e "SELECT * FROM mysql.general_log" >> $FILE

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.