Lucene/Solr for Searching Memcached for Caching a lot of stuff Varnish for caching too, but that’s a bit different
Comment: What technologies are you running alongside MySQL?
June 19, 2013 By 2 Comments
Lucene/Solr for Searching Memcached for Caching a lot of stuff MongoDB as a job queue
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… pool should be faster than getting them from the OS cache, which is another advantage of InnoDB. SSB Flight #2 Flight…_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size…_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… to small amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc and deduplication both need plenty of) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent…
Comment: MySQL and Percona Server in LinkBench benchmark
June 9, 2013 By 18 Comments
… I tested) might not be from PCI-e flash card (cached etc..). But it might be from LinkBench. The LinkBench (at…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you should be willing…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the…
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: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well…
