… looking for. First thing which needs to be understand is – cache hit ratio can be computed differently for different engines. For… was OS or SAN cache hit rate – something you would not see otherwise. The bad luck is – MySQL currently does not provide… would be to look at the number of misses – number of IOs which MySQL needs to do. You better to look at…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | …sure I didn’t miss anything important or write…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… Aker recently published good write up about using MySQL replication. The piece I find missing however is good description of warning about… to have data you’re accessing to be cached in memory by MySQL cache or OS cache. As slaves replicate the same data and often queried in random or round robin fashion their cache would…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to… you want MySQL Server to consume at peak. This can be easily computed by memory needed for OS, File Cache and other… list. On the contrary I’m quite sure I’ve missed something (drop me a note if you have something to…
Comment: MySQL Query Cache
November 2, 2011 By 70 Comments
…cached by MySQL. So is there any other option to cache it “force cache” ? …cache_hits, 0 Ssl_session_cache_hits, 0 Ssl_session_cache_misses, 0 Ssl_session_cache_mode, NONE Ssl_session_cache_overflows, 0 Ssl_session_cache…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
… Avg_row_length: 117 Data_length: 17217646764 Index_length: 11993816064 mysql> show table status like ‘dim1′\G *************************** 1. row *************************** Name: dim1… about the OS cache. This is why an expert is sometimes needed to provide the missing information. If the MySQL optimizer were right…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly…. There were a lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and… is missing now is not the database but rather concept and platform – developers do not want to care about database and caching…
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
Hello, My Mysql server is heavily loaded, now 300 qps average. It uses %… Key cache miss rate is 1 : 63 Key buffer free ratio = 74 % Your key_buffer_size seems to be fine QUERY CACHE Query cache is enabled Current query_cache_size = 256 M Current query_cache_used = 19 M Current query_cache_limit = 1 M Current Query cache…
Post: Getting annoyed with MyISAM multiple key caches.
May 1, 2009 By 11 Comments
… the mappings I can now map tables to be cached in different key caches but there is no way to see the… is cached. See other key cache stats To tune the caches I need to see number of accesses, blocks used, number of misses. Such… surely sad to see the feature of multiple key caches first introduced in MySQL 4.1 was newer quite polished in terms…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… should be safe running Intel X25-M with enabled write cache. Second issue I faced, and which took quite efforts to… by 16K block, etc. In result I had too many cache misses so results were not impressive, I had to move to… I encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are binaries for…
