Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    158
    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 ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice