Skip to main content

MySQL problems

donald22
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?

Comments

9 comments

Date Votes
  • cPanelMichael
    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.
    0
  • donald22
    [quote="cPanelMichael, post: 1533312">Hello :) 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.
    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?
    0
  • popeye
    [quote="donald22, post: 1533222">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?
    I had this problem last night with a vps, and it also effected my other cpanel server in the cluster for some reason
    0
  • donald22
    Mysql problem Hi, I am having the following problem with my mysql server. - Link Removed - here is the contents of the error logs. 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
    0
  • popeye
    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 ?
    0
  • Infopro
    Threads merged.
    0
  • donald22
    Re: Mysql problem [quote="popeye, post: 1533542">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 ?
    Yes the VPS has only been up a few days.
    0
  • thinkbot
    check if its not exceeding RAM memory available, copy mysqltuner results
    0
  • donald22
    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!
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post