Find the answer to your Linux question:
Results 1 to 3 of 3
I have problem, because everyday at 3 am or 4 am my mysql server stops. So my web pages are down... I have looked at logs and checked cron for ...
  1. 10-24-2011 #1
    Blisk
    Blisk is offline
    Just Joined!
    Join Date
    Feb 2007
    Posts
    15

    Troubleshooting

    I have problem, because everyday at 3 am or 4 am my mysql server stops. So my web pages are down...

    I have looked at logs and checked cron for problems but didn't find anything.

    Can someone help me how can I find wha causes mysql sever to stop?

    Is there some tool to find a problem?

    I have installed centos 6
    Reply With Quote Reply With Quote
  2. 10-24-2011 #2
    atreyu
    atreyu is offline
    Linux Guru
    Join Date
    May 2011
    Posts
    1,843
    Have you looked at the mysql log? By default, it should be:
    Code:
    /var/log/mysqld.log
    You could try debugging mode for mysqld, too. I think you can put this in your /etc/my.cnf

    Code:
    DebugLevel=3
    Then restart the service:

    Code:
    /sbin/service mysqld restart
    Or maybe you have to
    Reply With Quote Reply With Quote
  3. 10-26-2011 #3
    vasile002
    vasile002 is offline
    Just Joined!
    Join Date
    Oct 2011
    Posts
    50
    the mysql logs can also go to /var/lib/mysql/SERVERHOSTNAME.err, check that as well
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

...