… the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS…=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server …_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0…c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… running …query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G…run_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute the test: As seen above, the run_query script will run…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… new MySQL version. Once you have the queries you will most likely able to repeat the problem by running query on old and new MySQL… to create a more complicated test which runs this query concurrently many times or even workload consisting of several query types. Though it is… are. Running query in the loop and getting o_profile sample can also be a good idea. If you found query is executing…
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… as the previous baseline test. This VM was rebooted between tests. A SQL script was fed to the run_query.php script and the output was captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… just for this project. Query Validation It is often hard to ensure queries work same way with different MySQL version, unless you have… use mk-upgrade tool to run comparison. The tool will run SELECT queries on both new and old MySQL installations and check result set…. Stress Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug crashCommitAfter_test 20111221-142500 INFO MASTER_PORT: 9307 20111221-…and/or queries for a test run. Seed values are deterministic as each randgen run with that seed should produce the same queries and data…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… package managers like apt and yum can test and resolve dependencies before even installing …easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike… alter MySQL‘s default behavior i.e. disabling and totally disallowing use of query cache or…
