…–percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (…max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer…
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… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific… (non-partitioned) table will, at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store a cache object for… 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…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… was fixed in MySQL 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 be different as well. MySQL…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… a table that is already in the Table Cache, any query to a table that has a DDL operation waiting, will block. Why? Because MySQL sees that the old entries in the Table Cache have to be invalidated, and any query that accesses the table will have…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you… down. What you might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
… activity on the given table. Just run “FLUSH TABLES mytable” and examine open tables later – if you see this table in table cache again chances are it is being used. Note however if you’re starting MySQL… started) – MySQL anyway initializes the timer so it would not be much overhead to store that time together in the table cache. This…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… memory allocation target, which could be something like “Prepared Statement Cache“, “Table Cache” etc. For global pools we need just global accounting, for… addition to monitoring it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate as currently they…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted … your key buffer compared to operating system cache. I also use it to see which tables may be worth to review in… whatever database you have active. It does not work with MySQL before 5.0 still of course 
