EmergencyEMERGENCY? Get 24/7 Help Now!

Percona build7 with latest patches

 | November 14, 2008 |  Posted In: Percona Software

We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes:

and -percona-highperf release additionaly includes

You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there

Read More

Adaptive checkpointing

 | November 13, 2008 |  Posted In: Benchmarks, Percona Software

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the […]

Read More

More patches

 | November 11, 2008 |  Posted In: Percona Software

After some pause we are going to announce bunch of patches we made and ported for last period. Ported patches (ported from Google V2 patch): – innodb_fsync_source.patch – Show information about callers of fsync, more info – innodb_io_tune.patch – Port of two patches InnodbIOTune and InnodbAsync, more info – innodb_extra_status.patch – Show more information about […]

Read More

Mirrored Binlogs patch

 | October 25, 2008 |  Posted In: Percona Software

Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for: Backup of binary logs in real time High availability, to switch master load to slave with mirrored binary logs By […]

Read More

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 (http://bugs.mysql.com/bug.php?id=26442)

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