June 19, 2013

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…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…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… 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 =…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

… behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement that opened a table only held… a table that is already in the Table Cache, any query to a table that has a DDL operation waiting, will block. Why? Because MySQL sees that the old entries in the Table Cache have to be invalidated, and any query that accesses the table will have…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , ,

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

…’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…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: Review of MySQL 5.6 Defaults Changes

October 8, 2012 By 10 Comments

… 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…

Filed Under: Insight for DBAs, MySQL

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

May 3, 2011 By 13 Comments

… 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…

Filed Under: MySQL

Post: table_cache negative scalability

November 16, 2009 By 23 Comments

… 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…

Filed Under: Benchmarks Tagged With:

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

March 11, 2013 By 7 Comments

… 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…

Filed Under: MySQL Tagged With: , , , , ,

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By 4 Comments

…’ 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…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

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

February 26, 2013 By 1 Comment

…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 mysql …table. -rw-rw—-. 1 mysql mysql 98304 Feb 20 18:57 FTS_0000000000000025_ADDED.ibd -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts
Newer Posts »