WHM taking too much time to respond restoring backups and terminating accounts
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
-
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! 0 -
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 0 -
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 ? 0 -
[quote="Lordemma, post: 1534581">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.0 -
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 0 -
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 ? 0 -
This comment may be of some use to you: Re: MYSQL Configuration - cPanel Forums HTH! :) 0 -
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 [COLOR="silver">- - - Updated - - - [quote="Infopro, post: 1534782">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. Thanks0 -
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 0 -
The primary error message I see is: [QUOTE][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.0
Please sign in to leave a comment.
Comments
10 comments