Monthly Archives - November 2009

Great work Innodb Team

I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability.
Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing […]

Read more

Paul McCullagh answers your questions about PBXT

Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul!
What’s the “ideal” use case for the PBXT engine, and how does it compare in performance?  When would […]

Read more

How innodb_open_files affects performance

Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode.
Unlike MyISAM Innodb does not have to keep open […]

Read more

5.0.87-build20 Percona binaries

Dear Community,
We are pleased to present the 20th build of MySQL server with Percona patches.
Comparing to the previous release it has following new features:

The build is based on MySQL-5.0.87
innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3
To be compatible with RedHat RPM repository, the naming scheme has changed to

Shell

<rpm name>-<mysql version>-<percona build version>.<buildnumber>.<redhat version>.<architecture>.rpm

1

<rpm name>-<mysql version>-<percona […]

Read more