What is stored in ibdata1
Could somebody enlighten me and tell me what is exactly stored in the ibdata1 file on an instance where the file_per_table global variable is active and all tables have been made after this variable became active.
On an Oracle course the instructor told us that in this scenario the only data kept in the ibdata1 file is redo/undo logs/data. On the Mysqlperformanceblog, Miguel Nieto states that in this scenario the ibdata1 file stores some sort of table definition. (I thought this was all in the tables .frm file)
Can anybody be more specific as to what data is stored in the ibdata1 file in this scenario?
Subject
Views
Written By
Posted
What is stored in ibdata1
42753
June 17, 2013 06:44AM
21318
June 18, 2013 08:54PM
10733
June 19, 2013 01:05AM
10358
June 19, 2013 08:44PM
5248
June 20, 2013 01:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.