… introduced a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the importance of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star… the hot test. All OS caches are dropped at this time as well. These set of queries were tested on the SSB… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance …0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS…_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration …cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache… = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…user’s ad hoc query leads to scanning the entire last two partitions, performance is not bad. (…There are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are …times. (Usually 4 of the 5 are cached from previous queries.) (Re #2) I have rambled on …
Comment: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
…/03/mysql-56-single-threaded-read-only.html. All of the conclusions assume a benchmark with fast (100 to 200 usecs) queries: * performance… a big win * 5.6 was ~9% slower for a cached database whether or not the PS was disabled
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… done with MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so… data about Query Cache content and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform performance as you…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query Cache is… for high performance is Query Cache performs query lookup in the cache before query parsing, so if result is served from query cache, query parsing step is saved. Queries must be…
