… | | TABLE_DEFINITION_CACHE | 400 | 1400 | | PORT | 5530 | 5610 | | QUERY_CACHE_TYPE | ON | …in set (0.05 sec) Lets go over to see what are…are less than 200 tables in this system. innodb_stats_on_metadata is disabled by default in MySQL…MySQL to handle larger queries. Makes sense as amount of memory…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
…are not accessed very frequently. Use what you need Both Memcached and the MySQL query cache are limited in size. If you try to cache…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… to hear what you do yourself…memory smarter knowing it does not need to look for pages to swap out or balance memory for reducing a cache…in your application and you ended up with a lots of connections creating large temporary tables and so MySQL running out of memory… are no large spikes in memory…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…What I usually look for MySQL is performance in random reads and random writes. Sequential reads and writes are…memory (or reducing amount of usable memory). The system I’m testing this on has 256MB BBU (Battery Backed up Cache…take a look at another table SysBench displays: per-request statistics: …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL…cached in OS cache. It is performance issue as system call is needed to get data from Operation System even when it is in cache…my list what I think MyISAM tables are good to be…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…whether Query cache was used or not, if Filesort was used, whether tmp table was created in memory or on…these pages in memory. What it says though is that, if this query would run on a cold MySQL instance,…to 32M on the server, so on-disk tables are probably being created because of blob columns …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…memory). With MySQL common sense however does not always works – we’ve seen performance issues with large query_cache…in MySQL 5.1 – in this version table_cache was significantly redone and split in table_open_cache and table_definition_cache…
Comment: Beware of MyISAM Key Cache mutex contention
August 14, 2008 By 10 Comments
…memory is 1G. All the MyISAM tables are in the same structure, the data for them are also similar. Each table…table t1 Thread2: access table test (innodb) After that, we tried cache the table index by following, but things does not change: mysql> CACHE…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in…in theory, but in practice it is problematic. What usually happens is that the full table scans access the table…
