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.

Server MySql Crash

Discussion in 'Database Discussions' started by AlexisMeroni, Mar 8, 2013.

  1. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello ,
    I don't understand why my server MySql (local) in 5.5 always crash :mad: :confused: .
    Can you help me please ? :D
    Thanks You, Alexis
     
  2. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    You don't know ? :'(
     
  3. TheVisitors

    TheVisitors Active Member

    Joined:
    Mar 19, 2012
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Have you checked the error logs?

    Telling people that its crashing, but not giving us at least a breadcrumb isn't going to get us to help. We need a hint.
     
  4. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,
    Tanks you for your reply ;)
    Where is the error Log of mysql ?
     
  5. kdean

    kdean Well-Known Member

    Joined:
    Oct 19, 2012
    Messages:
    262
    Likes Received:
    12
    Trophy Points:
    18
    Location:
    Orlando, FL
    cPanel Access Level:
    Root Administrator
    At:

    /var/lib/mysql/

    You should find a file named after your host name with a .err extension.
     
  6. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
  7. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Up Please :s
     
  8. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Hi,

    At first look it seems that you are reaching the open files limit. You will need to increase the limit for max open files:

    1) add to /etc/my.cnf ([mysqld] section) (replace 65K with desired maximum open files limit)
    open_files_limit = 65K

    2)
    echo "mysql soft nofile 65536" >>/etc/security/limits.conf
    echo "mysql hard nofile 65536" >>/etc/security/limits.conf

    3) Stop and restart your mysql service.

    The examples i provided should allow mysql service to accept a maximum of 65K open files. Replace/edit to reflect your environment if needed. Note that I'm not responsible for possible issues , use at your own risk.
     
  9. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I don't understand this lines.....
     
  10. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    You can just copy paste them and they should work. It will ensure that your open files limits will be applied at OS level. You could also manually edit the file /etc/security/limits.conf with your favorite editor. Example with nano:

    nano /etc/security/limits.conf (you will see examples on how to configure that file) , at the end of the file you can add the configuration i provided:

    Code:
    mysql soft nofile 65536
    mysql hard nofile 65536
    or
    Code:
    * soft nofile 65536
    * hard nofile 65536
    You can also check what's your mysql open files limit and how many open files there are:
    Code:
    mysql -e "show status like '%open_files%';" && mysql -e "show variables like '%open_files_limit%';"
     
    #10 InterServed, Mar 11, 2013
    Last edited: Mar 11, 2013
  11. AlexisMeroni

    AlexisMeroni Active Member

    Joined:
    Feb 9, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Ok Thanks you.

    I go test.
     
  12. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Hope it will solve your problem.
     
Loading...

Share This Page