donald22

Member
Sep 6, 2013
10
0
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?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.
 

donald22

Member
Sep 6, 2013
10
0
1
cPanel Access Level
Root Administrator
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?
 

popeye

Well-Known Member
May 23, 2013
368
2
18
Texas
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?
I had this problem last night with a vps, and it also effected my other cpanel server in the cluster for some reason
 

donald22

Member
Sep 6, 2013
10
0
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
 

donald22

Member
Sep 6, 2013
10
0
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!