…, there was no caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge… innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… the resultset is huge, it eventually starts creating a temp table on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size…
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… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
….51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i = 0… replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE id=’key_id’”); id is PK of the container table While…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
…/en/innodb-memcached-internals.html there are some caching settings to play with: “Table cache_policies specifies whether to use InnoDB as the… to use the traditional memcached engine as the backstore (cache-only), or both (caching). In the last case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table…
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 = 0 query_cache_type…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…=500000 max_connect_errors = 10 table_open_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_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… case — * The entire table is too big to be cached, but * One partition is small enough to be cached, and * Your accesses are… (non-partitioned) table will, at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries.) (Re #2) I have rambled on about things as a preface to rebutting “delete records from this table…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8… sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
