mysql log slow query not working

Discussion in 'Databases' started by dethfire, Apr 11, 2013.

  1. #1
    mysqltuner.pl returns [OK] Slow queries: 0% (138/682K)
    I want to see those 138 queries.
    In my my.cnf I have
    slow_query_log = 1
    log_slow_queries ="/var/log/mysql-slow.log"
    long_query_time = 1
    however if I go to /var/log there is no mysql-slow.log file
    any ideas?
     
    dethfire, Apr 11, 2013 IP
  2. vangel

    vangel Active Member

    Messages:
    145
    Likes Received:
    6
    Best Answers:
    2
    Trophy Points:
    98
    #2
    Can u try to make an empty file at that location and chmod it to 0777. Restart mysql and test wih a known slow query. Usually ones that run on unindexed columns
     
    vangel, Apr 11, 2013 IP
  3. dethfire

    dethfire Well-Known Member

    Messages:
    230
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    118
    #3
    that worked, thanks!
     
    dethfire, Apr 12, 2013 IP