The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql slow-log-query - wrong log?

Discussion in 'General Discussion' started by Grzeslaw, Jun 4, 2007.

  1. Grzeslaw

    Grzeslaw Well-Known Member

    Joined:
    Jul 11, 2006
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    6
    Location:
    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 ?
     
Loading...

Share This Page