innodb_file_per_table Example

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