…to second. I draw boxplots, which show 25-50-75 percentiles. So there is no grow in throughput after… 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);js…
Post: Some fun with R visualization
February 23, 2012 By 5 Comments
… 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
… us following intervals (in sec) between events: 0.61, 0.43, 1.55, 0.18, 0.01, 0.76, 0.09, 1.26, … Or if we…): As you see interval is far from being strict 0.5 sec, but 0.5 is the mean of this random generation function. On… best 99% response time (15.74ms final), 32 threads: 16.75 ms, 64 threads: 25.14ms. And with 128 threads we…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… 4.078571 96 101 506 5.009901 128 89 486 5.460674 192 79 484 6.126582 256 75 495 6.600000 As you can see, on the big datasizes we have 5… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
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 85…99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…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…) 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…) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…,000,000 rows each. Total database size ~58GB. MySQL version: 5.5.16 Initial benchmark, which InnoDB configured for this hardware innodb… 3800M. InnoDB usually takes 75% mark as limit for “sync” stage ( 3800M * 0.75 = 2850M ). That is checkpoint age exceeds 75% sync mark, that… (“Log flushed up to” – “Last checkpoint at”) > “total log size” * 0.75 , then InnoDB is in “sync” mode. What to do? I…
Comment: 5.0.75-build12 Percona binaries
January 24, 2009 By 18 Comments
I downloaded http://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/Docs/manual.chm gzip: stdin: invalid compressed data…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 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.4Ratio Query1370.50372.161… more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99 Query2NANANA Query3NANANA Query4NANANA Query5NANANA…
