…sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=… = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…and 5.5.x clusters with not just simple queries or simple transactions but high concurrency with complex …a-mysql-private-cloud-step-1/ — this will be a series of posts over time (as I have spare time for non-work related fun load tests that is..) which …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… Shard-Query over Hive is that it works with existing MySQL data sets and queries. Another advantage is that it works with all MySQL… improve query response times significantly. These queries are a great test of Shard-Query features. It is currently approaching RC status. If you decide to test…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… impact in our query response times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query for yourself…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229… [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.117904 Lock_time: 0.002886 Rows_…. Let’s analyze another query, this time query ranked #4 by pt-query-digest. # Query 4: 0.12 QPS,…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
…: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned…, I was testing, as I said before, index condition pushdown. Let’s have a look at the EXPLAIN output: mysql> EXPLAIN SELECT…-party, independent and technical opinion about the new features of MySQL query planner? Are you not yet familiar with terms like MRR…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…Time | State | Info | +—-+———-+———–+——+———+——+———————————+—————————–+ | 1 | msandbox | localhost | test | Sleep | 49 | | NULL | | 2 | msandbox | localhost | test | Query | 35 | Waiting for table metadata lock | RENAME TABLE test…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…query times. # Query 7: ID 0x76323E2525BA457C at byte 0 _______________________________ # Found 441 differences in 510 samples: # checksums 0 # column counts 0 # column types 0 # query times…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… quality control queries automatically, we can run them at any time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar… same SQL queries for quality control: mysql> CREATE TABLE test.MY_KEY_COLUMN_USAGE LIKE INFORMATION_SCHEMA.KEY_COLUMN_USAGE; mysql> INSERT INTO test.MY…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… time for this test 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… we set cut-off time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784…
