… of production database servers and will perform the backups. The write load is not excessive so a single server can easily… snapshot, like LVM but… since it is a copy on write filesystem, the snapshots are free, no performance penalty. You can… explain this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… at Launchpad. New Features: Percona Server has ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature adds atomic write support for directFS filesystem on Fusion-io devices. This feature… a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… lot (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing the problem. It happened that the… to 20 on a 48GB server, allowing nearly 10GB of “write cache“. A quick survey of the servers I have access to…. I simply set the dirty_ratio to 2 (1GB of write cache) and the issue is gone since. So, add to your…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i… plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But there…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… the original node where the transaction is committed) Galera prevents writing conflicts to these pending transactions while they are inflight in… it with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the same. If we… more latency waiting for a write to go through, and possibly some poor user experience. batch writes Instead of updating global counters…
Comment: The write cache: Swap insanity tome III
April 20, 2013 By 5 Comments
Nice write up. I’m not clear what was being swapped out starting at 10:03:36… Is Linux swapping out mysql malloc’d memory to make room for all those dirty buffers in the write cache?
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B. The next… up such that all IO would be cached (i.e., no special treatment of sequential writes) and with a 50% dirty page… about 12500. FlashCache came in around 7500 or so. Sysbench writes came in just under 8000 for vCache + time-based flushing…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… note the transaction produces 4 INSERTs and workload is very write intensive. So what are results in this case: InnoDB gradually…_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…. I am not able to find any information how memcached cache time expiry being apply into MySQL 5.6 memcached. e… apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain… comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently I…
