…=> true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i = 0; $i < 100000; $i++) { $cache->save(new Object(), “key_$i”); } … pool, so there are no reads from disk. However, there is write activity stemming from the fact that this is …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…InnoDB can’t make 5h run. After 3h the disk is full, and InnoDB data size is about… SECONDARY KEY (hid,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write … 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…and a 4GiB buffer pool. The cache devices were flushed to disk immediately prior to and immediately… all IO would be cached (i.e., no special treatment of sequential writes) and with a …cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101 key…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically … by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the same. … after a crash, it has to get to disk. This has no effect on standard MySQL replication …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… loaded from disk. Replaying Queries Working with Groupon, we have developed a solution to keep the standby server’s caches hot. (See… or insert statements that have duplicate key errors may be faster than an actual database write. The slow logs were split into… same chunk again. We expected everything to be cached if we warmed the cache with the exact same data. All the graphs…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… than the non-partition equivalent. Even single-row writes are likely to be slower in PARTITIONed tables … will, at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries.) (Re… a single row based on a UNIQUE/PRIMARY key and it can prune, the delete involves (1) …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…writes OS Write cache is not as efficient as I would hope, at least on Linux Performance of Disk…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…buffer many writes to the same page, then fewer disk writes are needed. But if your write working …disk controller write-back cache does the same thing. PZ: First Indeed writes are slower with Flash disks … non-hash searches/s HT: Strange, primary key equality searches should work through the adaptive…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the all-important battery-backed write cache, how it’s configured and …terms of performance. There are two key commands for this on most … Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | Bytes_sent …
