… query in this flight, Q4.3, which is faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM… table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…cache = 10240 max_allowed_packet = 16M binlog_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
…cache = 2048 max_allowed_packet = 16M binlog_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…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…, as, depending on the size of the partitions, the whole partition can be cached, as opposed to a …same partition will be faster. 4. If you do queries on any other column, these could easily be … least I have seen this happen in a MyIsam environment on similar sized tables). What I am really saying …
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… if your query cache size is in Gigabytes. At the same time check how many queries do you have in cache – Qcache_queries_in_cache – if it…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… – we’ve seen performance issues with large query_cache_size also sort_buffer_size and read_buffer_size may not give you better performance if… the disk during this read-only benchmark. Why ? Because for MyISAM tables table header has to be modified each time the… well cached so the cost of table cache miss is not very high, you may be better of with significantly reduced table cache size…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…query_alloc_block_sizeblogpercona.commanual query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec… the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by 58% in case…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… if you use MyISAM tables exclusively. Right size depends on amount of indexes, data size and workload – remember MyISAM uses OS cache to cache the data… in normal operation. query_cache_size If your application is read intensive and you do not have application level caches this can be great…
