Published on : August 16, 2014 by George K.
A cPanel account restore using the script /scripts/restorepkg immediately after the termination fails with the above message. All traces of the account including the db user are already purged from the server. Simple Fix: Wait some more time say 5 minutes and try once again. Most cases it will be resolved Explanation: When you delete […]
Published on : July 20, 2014 by George K.
This was one of the rare issues I encountered. The MySQL server on one of the client’s server was getting restarted quite frequently at random intervals. The server logs were quite identical with a forced process termination and the server recovered itself in the majority of the cases. This is quite different from a crash/FS error […]
Published on : July 18, 2014 by George K.
InnoDB server rarely crashes. In majority of the cases, the corruption in the db can be fixed by repairing the table alone. Here we are discussing a severe table space corruption in ibdata1, ib_logfile0,ib_logfile1 files and the server fails to start even after multiple attempts. I shall try to explain the issue in view of […]
Published on : October 7, 2012 by George K.
Mysql server optimization requires customization of various values based on the requirement and availability of resources. An admin needs to be shrewd while making a decision about the values to be placed for each variable to fine-tune it to provide excellent performance. To avoid the overhead of calculating each variable, most admins prefer to copy […]
Published on : April 7, 2012 by George K.
Situation :In cPanel database management we have come across the issue that the truncate didn’t free the innoDB space. The issue is that we have Configured the MySQL server with innodb per table. There was a table comments having approximate 600+ MB size all because of comment spamming. I went to the table field in […]