… the hot test. All OS caches are dropped at this time as well. These set of queries were tested on the SSB… query in this flight, Q4.3, which is faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM… (merge sort). For the MyISAM tests I used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay…from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…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…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Beware large Query_Cache sizes
March 23, 2007 By 3 Comments
… of consulting projects with MySQL Query Cache being source of serious problems. One would see queries both for MyISAM and Innodb tables mysteriously stalling…. In many cases you may want to disable query cache at all and use external cache such as memcached which does not have this…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… code improvements into the query cache and the interface between it and MySQL. It’s now possible to completely disable it, for example… the query cache, the only possible improvement is to disable the cache completely, and people don’t care beyond that. Here’s my favorite query cache… you used to be able to see that you had MyISAM problems really easily when you had a screen full of…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and delayed key writes etc… really being compatible with such setup. As Oli describes even query cache which was implemented many years ago in 4.0 was…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… that key_cache is a problem is benchmark run with disabled key_cache (=0). Results for MyISAM with key_buffer_size=0 Threads queries/sec… expected, but, funny, we have more queries per second for 4, 8, 16 with disabled key_cache. The results for 2 threads is… can see Falcon perform extremely poorly when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… days. query_cache_type and query_cache_size. The behavior is “no cache” by default still but it is achieved differently now. The query_cache_type is… it was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache_size though would be larger by… change as trying to create Innodb table but getting MyISAM because Innodb was disabled for some reason was very error prone gotcha…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max… WT cache: The second is with WB cache: I couldn’t figure out what exactly happened with setting #3 when WB cache was disabled…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, …cache. You want to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM…all kernels work quite well with swap disabled and there are other reasons against it…
