Tag: ib_logfile0

A MySql ibdata1 Optimization Technique

A MySql database needed to be removed and upon deletion of that single database, the extremely large three gigabite ibdata1 (data) file remained. Here are the steps I took to reduce or shrink the file once the database was removed. Since there was no other use for this MySql installation, there remained the MySql system databases. Show Databases Backup Databases…

Read More »