Clear Mysql ibdata1

Reading Time: < 1 minute Hi Techrunnr, this document deals with How to shrink ibdata1 file in /var/lib/mysql/. By default ibdata1 file in /var/lib/mysql/ normally consists of 4 types of data Table Data Table Indexes MVCC (Multi versioning Concurrency Control) Data Table Metadata Follow the below steps to shrink the ibdata1 Take the dump of Read more…