Tag - Patches

Another scalability fix in XtraDB

Recent scalability fixes in InnoDB and also Google’s and your SMP fixes almost made InnoDB results acceptable in primary key lookups queries, but secondary indexes were forgotten for some time. Now having Dell PowerEdge R900 on board (16CPU cores, 16GB RAM) I have some time for experiments, and I played with queries

Shell

SELECT name […]

Read more

5.0.75-build12 Percona binaries

After several important fixes to our patches we made binaries for build12.
Fixes include:
Control of InnoDB insert buffer to address problems Peter mentioned https://www.percona.com/blog/2009/01/13/some-little-known-facts-about-innodb-insert-buffer/, also check Bug 41811 to see symptoms of problem with Insert buffer.
https://www.percona.com/docs/wiki/patches:innodb_io_patches
* innodb_flush_neighbor_pages (default 1) – When the dirty page are flushed (written to datafile), this […]

Read more

How Percona Develops Open-Source Software

Percona has been building and contributing to open-source software since the company was founded, and individually we’ve been doing the same thing for many years.  We think it’s a huge value for our customers and the community.
We’re involved in a dozen or so open-source projects, but our three core efforts at the moment are […]

Read more

5.0.75-build11 percona binaries

As you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our patchset.
Patches are mostly equal to build 10
https://www.percona.com/blog/2008/12/11/mysql-binaries-percona-build10/, only change:
it includes bugfix for https://bugs.launchpad.net/percona-patches/+bug/308849
You can download binaries (RPMS x86_64) and sources with patches here
https://www.percona.com/mysql/5.0.75-b11/

Read more

The patches are going to Launchpad

After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects.
We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main repository for the patches.
We advise to use Launchpad bug system to report bugs and also for feature requests.

Read more

Adaptive checkpointing

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 buffer […]

Read more

More patches

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 InnoDB […]

Read more