… the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled… 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…’ The ‘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
…that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103… (see MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to …5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results… wheel, here is a link to the full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5… 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
….6/en/innodb-memcached-internals.html there are some caching settings to play with: “Table cache_policies specifies whether to use InnoDB as the… (caching). In the last case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table.” I’d like to see the results with all settings.
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… buffer pool that’s much smaller than the working set, the no-cache approach is fairly crippled and ineffectual. FlashCache does substantially…=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…
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…_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…=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB comes with good settings out-of…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the same. If we… makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… i want to store a cache object for only 12 hours. In memcached side I can set cache life time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain permanent? for doing cache clearing off table do i need…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…, set as a Primary Key, it will probably be quicker, or the same response, on a normal table as against a partitioned table… partitioned table, as, depending on the size of the partitions, the whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more…
