June 19, 2013

Post: Virident vCache vs. FlashCache: Part 2

…sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30…–mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL…= 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size…

Post: Benchmarking Percona Server TokuDB vs InnoDB

… is expected) and by the end of 5 hours averages at 2700 tps. With TokuDB…insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_…errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size =…

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

…’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql [localhost] {msandbox} (test) > select… scaled down compared to MySQL 5.5 default values. Such as performance_schema auto scales to count up to 445 tables and 224 threads… in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache

Post: Review of MySQL 5.6 Defaults Changes

… just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good… actually need DOS prevention this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files… 5000 tables. There is also little “savings” in keeping this value low – 64K or even more would be good default. query_cache

Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

… parallelized purge: in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5.6.2 one… innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better presentation let’s… further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important to remember that 5.6.2 multiple…

Post: table_cache negative scalability

… problem was fixed in MySQL 5.1 – in this version table_cache was significantly redone and split in table_open_cache and table_definition_cache and I assumed… not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4.2 has higher default table_open_cache so I took… MySQL 5.0 and MySQL 5.1 with small table cache. With table_open_cache increased to 16384 the test took 750 seconds so the problem exists in MySQL 5

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

… RAID 10 array with 512MB write-back cache  Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in seconds…, MySQL 5.6 outperformed MySQL 5.5.30 with the big buffer pool. Why is the MySQL 5.6.10 with default settings test significantly slower than MySQL 5.5….173893 | 13.027019 | 4979 | 21399 | 0 | 0 | 90 | 90 | | 5 | Opening tables | 0.270664 | 0.295955 | 0.025996 | 0.024996 | 34 | 35…

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

…’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5… on MariaDB 5.5 is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table above and…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

…I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever…—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysqltable. -rw-rw—-. 1 mysql mysql 98304 Feb 20 18:57 FTS_0000000000000025_ADDED.ibd -rw-rw—-. 1 mysql mysql