…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: Some fun with R visualization
February 23, 2012 By 5 Comments
… there are results for 4 and 16 tables cases running MySQL 5.5.20. Let me remind how I do measurements. I run…
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 …
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…use Percona Server 5.5.19. I should mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly…078571 96 101 506 5.009901 128 89 486 5.460674 192 79 484 6.126582 256 75 495 6….(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);…
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…
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…
