… did not expect such a table_cache issue – the LRU for cache management is classics and there are scalable algorithms to deal with it… 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…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
… a comment on http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/ asking about open_file_limit. One thing I see that… and I believe is non-biased to MyISAM and InnoDB table types. If the max open_file_limit is 65535, does…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…You can call me person with negative mind but I tend to … master, even on completely unrelated table, replication lag may increase dramatically. … to be cached in memory by MySQL cache or OS cache. As slaves … write load This is needed to avoid scalability problems of single thread and resource…
