… tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx…
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
I actually requested pricing just last week, here are the numbers I received: 365GB MLC = $5,950 785GB MLC = $9,950 1.2TB MLC = $13,900 2.4TB Duo MLC = $28,500
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
Percona is glad to announce the release of Percona Server 5.1.62-13.3 on April 25, 2012 (Downloads are available… Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now the current stable release in the 5.1 series. All of Percona…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… synchronous IO varying amount of threads and with measurements every 1 sec to see how bad are drops. So there is more or less stable performance only for 1 thread. For 2 or more, the throughput varies a lot… 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… run benchmarks. Uniform is stupidly simple: for a table with 1 mln rows, each row gets equal amount of hits. This… distribution – each row is accessed equal times ( for row X: 1/(X^0) ). There is a research that shows that user… many times each row selected for different θ: 0.5, 0.9, 1.1: The curve is very skewed, so I zoomed graphs…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… 5.5 server) I have a complex query w. joins on a table with 10+ million rows. Results are Data & Count Query = 1.8 seconds 1) .90 for the data 2) .90 for the count Data & FOUND_ROWS = .913 1) .90 for the data with SQL_CALC_FOUND_ROWS. No…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… have a few questions: 1. Will the Percona Toolkit version just released work for regular community MySQL 5.5.23 or does it… on what is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a lot of optimizer improvements. Even the standard MySQL 5.5 offers pluggable authentication; you just have to pay for the… plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
… 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1… Select_scan 1 1 1 1 1 Sort_scan 1 1 1 1 1 As you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are…
