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?

 

[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.

 

[donald22]

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]

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]

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

 

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

 

[Infopro]

Threads merged.

 

[donald22]

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 ?

Yes the VPS has only been up a few days.

 

[thinkbot]

check if its not exceeding RAM memory available, copy mysqltuner results

 

[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!