… vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it … = 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-…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…testing was limited to a subset of Vadim’s test queries (see that post). As this new test schema is normalized, Vadim’s test queries…Query performance continues to improve when grouping and filtering is used. Again, notice Q9. It doesn’t use any features which Shard-Query…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…performed. Let’s see this scenario via a test case: session1 > start transaction; Query…test | Query | 0 | NULL | show processlist | | 6 | msandbox | localhost | test | Query | 3 | Waiting for table metadata lock | RENAME TABLE test_2 to test | | 10 | msandbox | localhost | test…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default… values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql [localhost] {msandbox} (test) > select var55…/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… as MySQL 5.6 is starting to get production battle-tested and there is inflow of real world production performance data hitting MySQL Support… more plans have to be considered for the query the more time the query optimization is likely to take. I also would….6 performance. Here is Sysbench command I used: root@dpe01:/mnt/data/sandboxes/msb_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…very frequent cases with performance problems with MySQL is what they happen every so often or … it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, …Do push concurrency too high Many developers will test script with multiple level of concurrency and…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… PERFORMANCE_SCHEMA, and paths are unique for basedir and datadir I tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL… first query, which uses only one join. Since it is practical for a query with only one join, I’ve tested performance of the query with the join in both directions. Explain for query Q1.1: mysql> select…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket) 7400 Note: The test measures peak performance… MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. This will give us some interesting information about how Shard-Query will perform on each database. To do the size comparison, I… In general, a column store performs about 8x-10x better than a row store for queries which access a significant amount of… user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes for testing…
