35 lines
1.2 KiB
Plaintext
35 lines
1.2 KiB
Plaintext
/var/log/mysql/mysql.log
|
|
/var/log/mysql/mysql-err.log
|
|
/var/log/mysql/slow_query.log
|
|
{
|
|
daily
|
|
rotate 7
|
|
missingok
|
|
create 640 mysql mysql
|
|
compress
|
|
sharedscripts
|
|
postrotate
|
|
## - Credential File /usr/local/mysql/sys-maint.cnf might look like:
|
|
## -
|
|
## - [client]
|
|
## - host = localhost
|
|
## - user = sys-maint
|
|
## - password = YbuswBqxHLZtw10t
|
|
## - socket = /tmp/mysql.sock
|
|
## - [mysql_upgrade]
|
|
## - host = localhost
|
|
## - user = sys-maint
|
|
## - password = YbuswBqxHLZtw10t
|
|
## - socket = /tmp/mysql.sock
|
|
## - basedir = /usr
|
|
## -
|
|
MYSQL="/usr/local/mysql/bin/mysql --defaults-file=/usr/local/mysql/sys-maint.cnf"
|
|
MYADMIN="/usr/local/mysql/bin/mysqladmin --defaults-file=/usr/local/mysql/sys-maint.cnf"
|
|
if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
|
|
echo "Warning: no mysqld running or missing sys-maint user?"
|
|
else
|
|
$MYSQL -e 'select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS; select sleep(2); set global long_query_time=@lqt_save;' > /dev/null
|
|
fi
|
|
endscript
|
|
}
|