≡ Menu

Optimize MySQL Table Example

How to Shrink MySQL ibdata1 Size using innodb_file_per_table

In MySQL, when you are using InnoDB, all the tables and indexes are stored under the MySQL system tablespace. MySQL system tablespace is ibdata1, which is located under /var/lib/mysql The single ibdata1 file contains all the tables and indexes in your MySQL database. So, if you have a big database, this file size will grow [...]

{ 9 comments }