Everything MySQL

A great place to be!

Thomas A. Lekai
  • Male
  • Bedminster, NJ
  • United States
Share on Facebook Share on Facebook Share

Thomas A. Lekai's Friends

  • Chris

Thomas A. Lekai's Discussions

ibdata grows exponentially when file-per-table is configured using InnoDB
4 Replies

Chris, Have you ever heard of this?  I am working with a client that has some crazy growth in their ibdata files, even though they have configured file-per-table option.  They are using a Percona…Continue

Started this discussion. Last reply by Thomas A. Lekai Feb 15, 2010.

 

Thomas A. Lekai's Page

Gifts Received

Gift

Thomas A. Lekai has not received any gifts yet

Give Thomas A. Lekai a Gift

Latest Activity

Thomas A. Lekai replied to Thomas A. Lekai's discussion ibdata grows exponentially when file-per-table is configured using InnoDB
"Just wanted to post a small follow-up. When my client originally reported the issue, they were using one ibdata file, and files-per-table was enabled. Their log was growing at 3 GB per day. The fix that I came up with was to use 3 (2GB) ibdata…"
Feb 15, 2010
Morgan Tocker replied to Thomas A. Lekai's discussion ibdata grows exponentially when file-per-table is configured using InnoDB
"To clarify the impact of the patches: there are two Percona patches which apply here - but both are disabled by default. One is to increase the number of undo slots so that you can have more concurrent…"
Feb 14, 2010
Thomas A. Lekai replied to Thomas A. Lekai's discussion ibdata grows exponentially when file-per-table is configured using InnoDB
"I hear you, and I am actually reading this is normal. I think what is going on is that my client is using a very large innodb log file size (2 GB), and once it flushes, it flushes in a big way. I also read that InnoDB still uses the ibdata files for…"
Jan 26, 2010
Sarah Sproehnle replied to Thomas A. Lekai's discussion ibdata grows exponentially when file-per-table is configured using InnoDB
"Hi Thomas, I haven't used the Percona patches, but I have seen similar issues with the stock InnoDB. The UNDO log entries can get written to the ibdata file(s), even though you may be using innodb_file_per_table. It is possible that there are…"
Jan 26, 2010
Thomas A. Lekai posted a discussion

ibdata grows exponentially when file-per-table is configured using InnoDB

Chris, Have you ever heard of this?  I am working with a client that has some crazy growth in their ibdata files, even though they have configured file-per-table option.  They are using a Percona patch, and my gut is telling me that something is off on the binaries that they are using from Percona.  Let me know if you ever heard of this. Regards, Thomas.See More
Jan 26, 2010
Thomas A. Lekai left a comment for Thomas A. Lekai
"Gotcha, even though I worked with Oracle in 9i and 10g, it has been a little while. I am going to brush up on the weekend, but most of that work I just hold in the reference part of my mind, and I focus on being a MySql DBA. I have done several 24X7…"
Jan 22, 2010
Chris left a comment for Thomas A. Lekai
"It was great interviewing you as well. I am hoping that Yancy gives you a call soon! Sri, the lead oracle DBA is out today but prolly will set up an interview with you early next week. Remember, 10g and 11g RAC and attitude will be a focus. If you…"
Jan 22, 2010
Chris and Thomas A. Lekai are now friends
Jan 22, 2010
Thomas A. Lekai left a comment for Thomas A. Lekai
"Thanks man, great little site. I am going to have to explore my site a little more and start jazzing it up. Do me a favor, send me a mail to arbifox@hotmail.com, I wanted to add you into my contacts. T"
Jan 22, 2010
Chris left a comment for Thomas A. Lekai
"Welcome Tom! Great talking with you today!"
Jan 21, 2010
Thomas A. Lekai is now a member of Everything MySQL
Jan 21, 2010

Comment Wall (4 comments)

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

At 12:23pm on January 22, 2010, Thomas A. Lekai said…
Gotcha, even though I worked with Oracle in 9i and 10g, it has been a little while. I am going to brush up on the weekend, but most of that work I just hold in the reference part of my mind, and I focus on being a MySql DBA. I have done several 24X7 roles (S&P, Y&R, FortuneCity, PRNewswire, Vonage), so I am not new to that. Send me your private mail at arbifox@hotmail.com.
At 12:00pm on January 22, 2010, Chris said…
It was great interviewing you as well. I am hoping that Yancy gives you a call soon! Sri, the lead oracle DBA is out today but prolly will set up an interview with you early next week. Remember, 10g and 11g RAC and attitude will be a focus. If you have been in a 24x7 DBA ops role before that is also key! Let me know if you have any questions.

Chris
At 8:06am on January 22, 2010, Thomas A. Lekai said…
Thanks man, great little site. I am going to have to explore my site a little more and start jazzing it up. Do me a favor, send me a mail to arbifox@hotmail.com, I wanted to add you into my contacts.

T
At 10:16pm on January 21, 2010, Chris said…
Welcome Tom! Great talking with you today!
 
 
 

© 2017   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service