mysql:slowlog_rotate_manual
スローログの手動ローテート
# cd /var/log/mysql # ll 合計 134308 -rw-rw---- 1 mysql mysql 137367185 11月 7 01:20 mysql-slow.log -rw-r----- 1 mysql mysql 22898 9月 27 01:04 mysql.log # mv mysql-slow.log mysql-slow.log.old # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 304599784 Server version: 5.5.27-log MySQL Community Server (GPL) by Remi Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> flush slow logs; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
# スローログ mysql> flush slow logs; # 一般クエリログ mysql> flush general logs; # バイナリログ mysql> flush binary logs;
mysql/slowlog_rotate_manual.txt · 最終更新: 2014/02/26 08:20 by clownclown