Buy Percona ServicesBuy Now!

Improved InnoDB rw_lock patch

 | October 20, 2008 |  Posted In: Percona Software

There is patch from Google to improve SMP performance , but for some workloads it showed for us reverse scalability. E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (

Read More

Percona’s patches spread to a wider audience

 | October 13, 2008 |  Posted In: Percona Software

Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen! What does this mean for the Percona patches? […]

Read More

Finding what Created_tmp_disk_tables with log_slow_filter

 | September 22, 2008 |  Posted In: Percona Software

Whilst working with a client recently I noticed a large number of temporary tables being created on disk.

Read More

Unused indexes by single query

 | September 12, 2008 |  Posted In: Percona Software

Usually unused indexes are devil, they waste diskspace, cache, they make INSERT / DELETE / UPDATE operations slower and what makes them worse – it is hard to find them. But now ( with userstatsV2.patch) you can find all unused indexes (since last restart of mysqld) by single query

As you see query […]

Read More

Google’s user_statistics V2 port and changes

 | September 12, 2008 |  Posted In: Percona Software

Recently Google published V2 release of patches, one of them user_statistics we use in our releases. New features are quite interesting so we decided to port it to fresh releases of MySQL. Features includes: New statistics per user (Cpu_time, Bytes_received, Bytes_sent, etc) New command SHOW CLIENT_STATISTICS, which shows statistics per client’s hostname, not per user […]

Read More

Development plans

 | September 8, 2008 |  Posted In: Percona Software

We gathered together our ideas of MySQL improvements on this page and we are going to implement some of them. My favorite one is – make InnoDB files .ibd (one created with –innodb-file-per-table=1) movable from one server to another, however it is sort of challenging. Probably next one patch we want to integrate is […]

Read More

New patches, new builds

 | September 5, 2008 |  Posted In: Percona Software

We made new patches, improved previous and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches. First, just “-percona” release is more stable and contains only stable and proven on many installation patches. Second is “-percona-highperf” release, which contains experimental patches […]

Read More

Userstats patches with information schema support

 | August 4, 2008 |  Posted In: Percona Software

Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table_statistics, index_statistics. One can now use select * from information_schema.user_statistics along with show user_statistics. Links: Patch for 5.0.62 Patch for 5.1.26

Read More

Percona RPMS for RedHat 5 / CentOS 5 x86_64

 | July 31, 2008 |  Posted In: Percona Software

We prepared RPMs of our release for RedHat 5 / CentOS 5 x86_64 platform. There was question what patcheset includes and if there is manuals. We have: microsecond resolution in slow-log extended query plan in slow-log and InnoDB statistics. You can read more here User / Table / Index statistics (Google’s patch). More […]

Read More