Hello
I have a very particular problem with the mysql slow logs. In part of mine servers, the mysql-slowlog are saving the history from the begining of the creation my.cnf file, but in the part, it's shows only logs from the current day (and that;s what I wont). The configuration file are the same on the all of the servers.:
The cpanel, mysql, version's are the same. Config too, I don;t know.. - what can it be ?Code:[mysqld] #skip-innodb wait_timeout = 60 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock set-variable = max_connections=300 set-variable = max_connect_errors=20000 set-variable = max_allowed_packet=2500000 safe-show-database set-variable = default-character-set=latin2 set-variable = default-collation=latin2_general_ci set-variable = character_set_server=latin2 init-connect = "SET NAMES latin2" log-slow-queries = mysql-slow.log set-variable = long_query_time=5 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid query_cache_type = 1 query_cache_limit = 524288 query_cache_size = 8388608



LinkBack URL
About LinkBacks
Reply With Quote




