innodb

MySQL (InnoDB) server recovery

Tags: innodbMySQLrecovery

Published on : July 18, 2014 by

MySQL (InnoDB) server recovery

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 […]

Continue Reading...


MySQL & phpMyAdmin – Truncate didnt free the innoDB space

Tags: innodbMySQLphpmyadminTableTruncate

Published on : April 7, 2012 by

MySQL & phpMyAdmin – Truncate didnt free the innoDB space

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 […]

Continue Reading...


MySQL Storage Engines – an overview, their limitations and an attempt for comparison

Tags: comparison of storage enginesinnodbinnodb or myisammyisamMySQLstorage engines

Published on : August 31, 2010 by

MySQL Storage Engines – an overview, their limitations and an attempt for comparison

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 […]

Continue Reading...


Let's Connect

Get new updates

Categories

$0.000 items