Buy Percona ServicesBuy Now!

Another scalability fix in XtraDB

 | January 23, 2009 |  Posted In: Benchmarks, Percona Software

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

Read More

5.0.75-build12 Percona binaries

 | January 23, 2009 |  Posted In: Percona Software

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 parameter determines […]

Read More

Fix of InnoDB/XtraDB scalability of rollback segment

 | January 18, 2009 |  Posted In: Benchmarks, Percona Software

Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive insert/delete queries). By our results the problem is in concurrency on rollback segment, which by default is single and all transactions are serialized accessing to segment. Fortunately InnoDB internally has mechanism to […]

Read More

How Percona Develops Open-Source Software

 | January 9, 2009 |  Posted In: Percona 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

 | December 23, 2008 |  Posted In: Percona Software

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

Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

 | December 16, 2008 |  Posted In: Percona Software

Today we officially announce our new storage engine, “Percona XtraDB“, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can use it as a drop-in replacement in your current environment. It is designed to scale better on modern hardware, and includes a variety of other features useful in […]

Read More

MySQL Binaries Percona build10

 | December 11, 2008 |  Posted In: Percona Software

We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were added:

With both slow_query_log = OFF and userstat_running = OFF […]

Read More

The patches are going to Launchpad

 | November 19, 2008 |  Posted In: Percona Software

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

Read More