…to second. I draw boxplots, which show 25-50-75 percentiles. So there is no grow in throughput …sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in…(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response… see interval is far from being strict 0.5 sec, but 0.5 is the mean of this random generation … response time (15.74ms final), 32 threads: 16.75 ms, 64 threads: 25.14ms. And with …
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 …99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! …the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information…
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 … to build 10 http://www.mysqlperformanceblog.com/2008/12/11/mysql-binaries-percona-build10/, only change: it includes bugfix for https…_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
… buffer. To restrict to the too small value (e.g. 0) is not recommended for performance. If you don’t like… to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the each user threads…_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99…
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… 3800M. InnoDB usually takes 75% mark as limit for “sync” stage ( 3800M * 0.75 = 2850M ). That is checkpoint age exceeds 75% sync mark, that…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…Percona’s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona Server:…we 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 stable…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice…-sz await svctm %util sda 0.00 0.62 944.97 0.82 7582.75 11.50 3791.38 5.75 8.03 1.01 1…
Comment: 5.0.75-build12 Percona binaries
January 24, 2009 By 18 Comments
….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…
