WHM taking too much time to respond restoring backups and terminating accounts

[Lordemma]

I noticed this recently. My whm is taking too much time restoring cpanel backups as well as terminating accounts.
I recieved a cron mail with this info
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95'

Please help.
what could be wrong and what can I do to fix this ?
Thanks

 

[Infopro]

Your post reads like you've got 3 different issues. Restoring takes too long, Terminating takes too long, and your MySQL connection is dropping for some reason.

How big of an account are you restoring, and how are you restoring it? Explaining your steps and providing more Info that leads to the issue might be helpful.

Thanks!

 

[Lordemma]

The last thing I can remember I did was editing my etc/my.cnf file adding some lines.
I guess the problem is with my sql.
I tried restarting it ang got this error
"Waiting for mysql to restart....................................................................finished.


mysql has failed, please contact the sysadmin (result was "mysql is not running").
Please what can I do to resolve this ? sorry for my nob question please

 

[Lordemma]

I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error
"Permission Denied"
please how can I access the log file ?

 

[cPanelMichael]

I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error
"Permission Denied"
please how can I access the log file ?

You can not enter a log file name directly into the command line. You have to use a utility such as "cat" or "tail -f" to view it. EX:

tail -500 /var/lib/mysql/$hostname.err

Thank you.

 

[Lordemma]

Thanks for that! it works well now.
But I guess my problem is with the etc/my.cnf file I edited.
Can someone please provide me with a Good etc/my.cnf file I can just use to replace mine ?
please help if you can please with probably the one you are using.
Thanks

 

[Lordemma]

mysql is not running

please my mysql is not running. I tried restarting it but got this error

"Waiting for mysql to restart....................................................................finished.


mysql has failed, please contact the sysadmin (result was "mysql is not running").
The error log is not giving me any tip as to whyy it's failing and I just edited my /etc/my.cnf file if that will fix it but to no avail.
Please help. How do I resolve this ?

 

[Infopro]

This comment may be of some use to you:
Re: MYSQL Configuration - cPanel Forums

HTH!

 

[Lordemma]

here is what is in my cnf file


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 2M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M

open_files_limit=12048
[mysqldump]
quick
max_allowed_packet = 16M


The log is not giving me any clue...I'm just getting fraustrated now..please help please

- - - Updated - - -

This comment may be of some use to you:
Re: MYSQL Configuration - cPanel Forums

HTH!

I have gone through that thread but no useful post. Please help.
Thanks

 

[Lordemma]

root@bestservers [/]# tail -f /var/lib/mysql/$(hostname).err
131223 00:47:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131223 0:47:34 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
131223 0:47:34 [Note] Plugin 'InnoDB' is disabled.
131223 0:47:34 [Note] Plugin 'FEDERATED' is disabled.
131223 0:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
131223 0:47:34 [ERROR] Aborting

131223 0:47:34 [Note] /usr/sbin/mysqld: Shutdown complete

131223 00:47:34 mysqld_safe mysqld from pid file /var/lib/mysql/bestservers.gurushost.com.pid ended

 

[cPanelMichael]

The primary error message I see is:

[ERROR] Unknown/unsupported storage engine: InnoDB

Are you sure there are no InnoDB references in your /etc/my.cnf file, and that there are no additional issues in your MySQL error log related to InnoDB? What version of MySQL is installed?

Thank you.