…1 thread. For 2 or more, the throughput varies a lot from second to second. I draw boxplots, which show 25-50…MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d….
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the …50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can …
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 … 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 …. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the… files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… was 1 hour so query taking over 1 hour has NA. Times are given in 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…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… we disable doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not a perfect line, …pages and checkpoint age. The dirty page maximum of 50% is still not respected by InnoDB, but the …93 NOTPM. This is 1.4x better than we have with the stable line in MySQL 5.5.8. But, finally, …
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… with 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…’ + interval ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id… 0.00 0.62 944.97 0.82 7582.75 11.50 3791.38 5.75 8.03 1.01 1.07 1.07 101.40 dm-0 0.00 0…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0 2.5 1% 0 23.2 sdj3 0.0 0.0 0.0 0.1 0.0…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
…. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona Server. The… MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01 593.51 531.07 525.80 2 1306.50 1221…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1 19018 19018 0 -1 4202752 198731 0 0 0 347 5303 0 0 20 0 20 0…0 # IO r ops 50 480.18k 0 8 0.28 0.99 0.52 0 # IO r wait 55 3949s 0 466ms 2ms 12ms 7ms 0…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…keep this into account. We move database to MySQL 5.1 As the database size is relatively small we…read traffic from both master and slave. –sample=50 (or similar) option is important to check …- upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL 5.0 to 5.1 Also, …
