Re: ibdata1 and undo log

2011-11-19 Thread Johan De Meersman
Rozeboom [DAS]" > To: mysql@lists.mysql.com > Sent: Friday, 18 November, 2011 5:06:44 PM > Subject: RE: ibdata1 and undo log > > Thanks for the response, Johan. > > It would really help if I could determine when the ballooning is > occurring. Do you know of any way to

RE: ibdata1 and undo log

2011-11-18 Thread Rozeboom, Kay [DAS]
: mysql@lists.mysql.com Subject: Re: ibdata1 and undo log - Original Message - > From: "Kay Rozeboom [DAS]" > > 1) Can anyone verify that the additional (presently unused) > space was allocated for the undo log? > 2) Are the many 1-page segments a leftove

Re: ibdata1 and undo log

2011-11-16 Thread Johan De Meersman
- Original Message - > From: "Kay Rozeboom [DAS]" > > 1) Can anyone verify that the additional (presently unused) > space was allocated for the undo log? > 2) Are the many 1-page segments a leftover from a large undo > log? I'm not too hot on the InnoDB internals, but yes, the

ibdata1 and undo log

2011-11-16 Thread Rozeboom, Kay [DAS]
We are running MySQL 5.0.77, and implemented our first production InnoDB database a few months ago. The database is on a dedicated server and is composed of 14 tables. No tables have been added or dropped since creation. The "ibdata1" file is growing much faster than the database itself. The