MySQL: Why InnoDB Engine stores all databases in one file (ibdata1)?

In this post, I am going to discuss one of the important topics related to InnoDB Storage Engine of MySQL. What is a role of the InnoDB ibdata1 file (.idb file)? The ibdata1 is a file which is using for the purpose of shared tablespace. I have noticed that this is one of the most … Continue reading MySQL: Why InnoDB Engine stores all databases in one file (ibdata1)?