… caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the 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=2048 table_definition_cache=16384 innodb…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the… #65077 from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=500000 max_connect_errors = 10 table_open_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…_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM… #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more… partitioned table, as Mysql can fire off one thread per partition (at least I have seen this happen in a MyIsam environment on similar sized tables). What I am really saying is that its…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
Today I was working with the client loading data to MyISAM tables at very high rate. Hundreds of millions rows are loaded… done than one would hope. As we already discussed MyISAM key cache has serious mutex contention issue as there is global mutex… from key_cache to the thread local space. Happily MyISAM allows you to create multiple key caches . We use “keycache per table” this case…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… read-only benchmark. Why ? Because for MyISAM tables table header has to be modified each time the table is opened. In this case the… table headers) is well cached so the cost of table cache miss is not very high, you may be better of with significantly reduced table cache… 5.1 – in this version table_cache was significantly redone and split in table_open_cache and table_definition_cache and I assumed the behavior may…
Post: More on table_cache
November 26, 2009 By 7 Comments
… basically best case scenario for opening tables as MyISAM table headers which are being modified were fully cached in this case. What does this tell us ? If you can fit your tables in table cache and eliminate (or almost eliminate) table cache misses it is best to size table_cache large enough – even in…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… of items you need to keep into account while using MyISAM tables. Recovery. MySQL was running stable for us, giving us false… watch out. Lack of row cache. MyISAM tables only have indexes cached in key_buffer while data is cached in OS cache. It is performance issue… cases table corruption will be mild, especially on low loaded servers. Many users do not even know you need to check MyISAM tables…
