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.

MySQL problems

Discussion in 'Workarounds and Optimization' started by donald22, Dec 19, 2013.

  1. donald22

    donald22 Member

    Joined:
    Sep 6, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi, I am having a problem with one of my cpanel vps servers, usually overnight I awaken to a sea of database failure emails. When I go and check the mysql sites on the server they are all down but the non mysql sites are up so I go to cpanel and restart mysql and everything is ok. All my security settings are the same as my other server that does not have this problem. I have also tried reseting the mysql root password but it still happens, any ideas?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I recommend checking the MySQL error log to see if you can determine the specific reason it failed. It's located at:

    /var/lib/mysql/$hostname.err

    Also, make sure MySQL is monitored in "WHM Home » Service Configuration » Service Manager" to ensure it's restarted automatically when it's detected down by Chkservd.

    Thank you.
     
  3. donald22

    donald22 Member

    Joined:
    Sep 6, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Mysql was ticked "enabled" but not monitored, I have ticked it now. Also I notice the mysql max packet size is set to 1mb. Should I increase that and if so to what?
     
  4. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    I had this problem last night with a vps, and it also effected my other cpanel server in the cluster for some reason
     
  5. donald22

    donald22 Member

    Joined:
    Sep 6, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Mysql problem

    Hi, I am having the following problem with my mysql server.

    - Link Removed -

    here is the contents of the error logs.

    Code:
    131217 12:08:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    131217 12:08:15 [Note] Plugin 'FEDERATED' is disabled.
    131217 12:08:15 InnoDB: The InnoDB memory heap is disabled
    131217 12:08:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131217 12:08:15 InnoDB: Compressed tables use zlib 1.2.3
    131217 12:08:15 InnoDB: Using Linux native AIO
    131217 12:08:15 InnoDB: Initializing buffer pool, size = 128.0M
    131217 12:08:15 InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    131217 12:08:15  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    131217 12:08:15  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    131217 12:08:15  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: 127 rollback segment(s) active.
    InnoDB: Creating foreign key constraint system tables
    "/var/lib/mysql/host.the-topsite.com.err" 4673L, 475607C
     
  6. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Re: Mysql problem

    Hi i just checked mine and it as loads more than that, most of it errors for customers databases.

    Do you know that's a log just from today or from when the vps went online ?
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,453
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Threads merged.
     
  8. donald22

    donald22 Member

    Joined:
    Sep 6, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: Mysql problem

    Yes the VPS has only been up a few days.
     
  9. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    check if its not exceeding RAM memory available, copy mysqltuner results
     
  10. donald22

    donald22 Member

    Joined:
    Sep 6, 2013
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    It has a relatively high (for a VPS) 4 gig ram. I increased the mysql max packet size from default 1mb to 64 mbs and it hasn't happened again. Yet!
     
Loading...

Share This Page