1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Where do I find mysqld logs?

Discussion in 'Plesk for Linux - 8.x and Older' started by CloneCommander, Jan 16, 2006.

  1. CloneCommander

    CloneCommander Guest

    0
     
    Hi!

    Could anyone tell me where i can find the logs of the MySQL Daemon?

    I have SuSE Linux 9.2 with Plesk 7.5.4.

    In the /etc.my.cnf is a log file configured, but it is empty...

    Tibor
     
  2. phoenixisp

    phoenixisp Silver Pleskian

    27
    57%
    Joined:
    Feb 2, 2002
    Messages:
    840
    Likes Received:
    0
    Try /var/log/mysqld.log
     
  3. CloneCommander

    CloneCommander Guest

    0
     
    that was also my first idea - but there is no mysql log :(

    the only mysqld.log I found is this:

    /var/lib/mysql/mysqld.log

    but it is emtpy...
     
  4. wagnerch

    wagnerch Guest

    0
     
    What are you looking to find? /var/log/mysqld.log is a error log, if there are no errors then the file would be empty.
     
  5. CloneCommander

    CloneCommander Guest

    0
     
    I have a website which loads ~ 5 sec, and during this time the mysqld has 99% cpu load

    so I hope I could see what the site does during loading to fix it :)
     
  6. wagnerch

    wagnerch Guest

    0
     
    You probably want to turn on the slow query log, then.

    http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html

    Basically you would edit /etc/my.cnf and in the [mysqld] section add a line:

    log-slow-queries=/var/lib/mysql/slow.log
    set-variable = long_query_time=3

    This will log any queries taking longer than 3 seconds into the logfile specified. Odds are you have mysql out of the box and it is not tuned at all.

    I found these sites to be decent references:

    http://www.hackmysql.com/
    http://jeremy.zawodny.com/mysql/
     
Loading...