… to answer that question by retrying benchmarks on various combinations of hardware and …use following queries: select avg(id) from sbtest$i force key (primary) select count(*) from… –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… at the following benchmark: This is the so-called QPS-mode POINT_SELECT benchmark, i.e. all queries are single-statement SELECT statements in autocommit. Which is the perfect case for read-only optimization in MySQL…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches of fetch and store against both a standard memcached instance and a minimally tuned MySQL 5… (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…select performance, so we will need to measure that also. And, if you want to repeat this benchmark… = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len =…myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Andy, 1) The 1st benchmark is single SELECT queries (i.e. the –skip-trx option to sysbench). The 2nd one is the default sysbench mode, i.e. “BEGIN; SELECT…. 2) There was no fix from Percona at the time MySQL bug #49169 was closed. However, as you can see from…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see… it is often using SELECT SQL_NO_CACHE or disabling QueryCache for the test. This works by blocking query cache but still…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that… captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read… the optimizer’s job to select the best query execution plan. I had noted a similar thing when benchmarking ICP, the optimizer made…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records… Query: SELECT name FROM $tableName WHERE id = %d READ_KEY_POINT Query: SELECT name FROM $tableName WHERE country_id = %d READ_KEY_POINT_LIMIT Query: SELECT…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to… Query: SELECT city FROM $tableName WHERE country_id = %d and state_id between %d and %d READ_KEY_RANGE_NO_DATA_LIMIT Query: SELECT city FROM $tableName WHERE country_id = %d and state_id between %d and %d LIMIT 50 READ_FTS Query: SELECT min…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query. Data… be added. Q9 is an example of such a query. . Query details: — Q1 SELECT DayOfWeek, count(*) AS c from ontime_fact JOIN dim…
