… draw boxplots, which show 25-50-75 percentiles. So there is no grow… still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe…MySQL and SSD” on May-9. It will be the same as my talk on Percona Live MySQL…){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d…
Post: 5.0.75-build11 percona binaries
December 23, 2008 By 7 Comments
As you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our ….com/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 http://www.percona.com/mysql/5.0.75-b11…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… to see symptoms of problem with Insert buffer. http://www.percona.com/docs/wiki/patches:innodb_io_patches * innodb_flush_neighbor… to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the each user threads… (RPMS x86_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… Analyzing Percona‘s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona Server… disable doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not a perfect line…run, but with innodb_max_dirty_pages_pct=75. The 75% dirty pages line is at a …
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… InnoDB several times, some links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often recurring… catch up with flushing changed data. With widely adoption of MySQL 5.5 and servers with big memory configuration I expect we will… size” * 0.75 , then InnoDB is in “sync” mode. What to do? I whish I could say you should use Percona Server with…
Comment: 5.0.75-build12 Percona binaries
January 24, 2009 By 18 Comments
…://www.percona.com/mysql/5.0.75-b12/source/mysql-5.0.75-percona-b12-src.tar.gz, but each time I try to decompress it, I get an error: mysql-5.0.75/Docs/INSTALL-BINARY mysql-5.0.75…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…+4 striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU… take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… queries are logged. In general logging all queries can hurt MySQL and you should consider the load while using it, especially…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… video will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want…/vadim/mysql/export/ xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql… 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85…
Post: Xtrabackup, doing once...
March 5, 2009 By 6 Comments
… in code / not fully scripted builds / not fully tested all MySQL versions, but backups work just fine! I am able to… solution for InnoDB / XtraDB engines for MySQL 5.0 / 5.1 versions. Currently we tested only for 5.0.75 / 5.0.77 and it works just fine. We… available only in source code version on Launchpad lp:~percona-dev/percona-xtrabackup/alpha-0.2 , after some polishing and more testing we…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…customer’s server. The server is running a Percona build of 5.0.84, so I have microsecond logging in …to execute. To give some context, normally these take 75 microseconds. I can see it clearly when I …about it — and that’s where improvements to the MySQL source code are necessary. But in many cases …
