Re: ibdata1 and undo log
Posted by:
Rick James
Date: November 17, 2011 11:25PM
If the sum total of all the InnoDB tables (data+index) had ever been on the order of 3GB, and then you DELETEd/DROPped lots of rows/tables, that would explain the 3.8GB. (But it sounds like you understand the high-water nature of ibdata1.)
Have you done some huge undo-like thing? Such as deleting a million rows in a single transaction? Or maybe you have autocommit=0 and never issue COMMIT?
(No, I can't explain the pages/numbers you present; where did you find them?)
Subject
Views
Written By
Posted
3857
November 16, 2011 02:18PM
Re: ibdata1 and undo log
1164
November 17, 2011 11:25PM
1212
November 18, 2011 08:04AM
1008
November 18, 2011 12:05PM
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.