Monthly Archives - November 2009

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

New TokuDB 2.2.0 feature: more query progress information

Last spring, we added a feature that allows the user to see the progress of writes in a statement. Vadim liked it. In 2.2.0, in “show processlist”, we add progress information on reads.

Here is an example of what “show processlist” displays on an update:

Shell

mysql> show processlist G
*************************** 1. row ***************************
Id: 1
User: root
Host: localhost
db: test
Command: […]

Read more

Chicago & Atlanta -last two training locations of the year

A final update on training for this year – registration for InnoDB/XtraDB training in Chicago (8th December) and Atlanta (10th December) are now open.
While in Atlanta I’ll be giving a talk at the Atlanta PHP User Group on Optimizing MySQL Performance (details to be posted to their website shortly).  If you’re in Chicago and […]

Read more