… to MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix crash after upgrade 5.1.31 -> 5.1.33 fix mysql-test Percona XtraDB 1.0.3-5… in further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… announce release 1.0.2-3 of our XtraDB storage engine. Here is a list of enhancements: Move to MySQL 5.1.31 Scalability fix — ability to use several rollback segments Increasing the number of rseg may be helpful for CPU… in further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… tested 1, 2, 4 parallel threads for tools that support it and different level of compression ( 1,2,3 for qpress; -1 and -5 for other tools… is interesting on Level 5 the compression is worse than in pigz Level 5 pigz is good for compression and faster than pbzip2… see parallel version. There is the patch for it, but it did not apply clean to lzop 1.02, so I skipped it…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…:~/work/mysql-5.0.51a) % ls -l sql/mysqld -rwxr-xr-x 1 macko macko 28467073 2008-04-18 20:31 sql/mysqld… msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…=O_DIRECT DBT2 settings For CPU-bound case number of warehouses was 10(1.31GiB). In case of…0.94 In this case every test was run 5 times and random measurement error was calculated. As…patch itself. Let’s do the same tests but logging to /dev/null. CPU-bound case – 10 warehouses, Database size: 1.31…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…The fix came into MariaDB 5.3 and Mark Callaghan tested it recently . We ported this patch to Percona Server (it… Threads Nofix Group Commit fix 1 21.51 21.99 2 30.62 31.26 4 44.32 51.42…. All results are for binaries with group commit fix. Results with disabled write cache thread trx=1, No binlog trx…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 … 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 …://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_import If you want some internals…_expand_import available only in source code for now, you can get them from Launchpad …
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…and [as a result] increase response time for some random user requests, you are usually…eXtra benefits from Percona slow query log patch), I knew some particular pages were taking…27 0 # Rows examine 1 4.97M 0 445.49k 9.80k 5.73k 49.33k 0…# pages distin 1 67.99k 0 10.64k 1.26k 3.88k 2.47k 31.70 # queue…
