Re: ibdata1 and undo log

2011-11-19 Thread Johan De Meersman
] kay.rozeb...@iowa.gov 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 do that? -- Bier met grenadyn

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] kay.rozeb...@iowa.gov 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

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

Re: ibdata1 and undo log

2011-11-16 Thread Johan De Meersman
- Original Message - From: Kay Rozeboom [DAS] kay.rozeb...@iowa.gov 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