mysql slow-log-query - wrong log?

Grzeslaw

Well-Known Member
Jul 11, 2006
76
1
158
Poland
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.:

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
The cpanel, mysql, version's are the same. Config too, I don;t know.. - what can it be ?