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 : 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 […]
Published on : October 19, 2010 by George K.
Simple 🙂 Issue the mysql command
Published on : August 31, 2010 by Sharafuddin M.A
MySQL is a database management system. Most of us are using MySQL database and majority don’t know how to choose the data base engines, what are the different types of storage engines available in mysql and how they differ from each other. In this article let me give you a brief idea about the Storage […]