"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…"
A great place to be!
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
Thomas A. Lekai has not received any gifts yet
Latest Activity
"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…"
"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…"
"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…"
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
"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…"
"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…"
"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"
Comment Wall (4 comments)
- 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,
- 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,
- Welcome Tom! Great talking with you today!
© 2024 Created by Chris.
Powered by
