Question: what is ibdata1 file in mysql?
Answer: by Ramesh Natarajan on February 17, 2016. 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.