… seems that InnoDB is not alone with its flashing problems. You can see there periodical stalls in…about drops – the drive periodically cleans an internal cache or something. To understand better what kind …interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache… rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is… one to use local memory, Memcache or for example local flash storage for storage. Compression You can see it as a…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache layer… allows to use Flash as cache in front of regular hard drives. The implementation is based on dm-cache and introduces a new…/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2 cache for InnoDB…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least… instead and bundle 512MB cache with 512MB of Flash so when power goes down the cache is stored on Flash ? Or can’t one… this is something where Facebook Flash Cache can be helpful – if it can act instead of hardware BBU cache. Would be interesting to…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
… not seen much use of this kind of cache with MySQL in practice though. If you’re using…2-0 (18252) Driver : 1.1-5 (24702) Boot Flash : 5.2-0 (18252) ——————————————————– Controller ZMM Information ——————————————————– Status :…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… make sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have… comment. Next, I plan to look at IO alignment on Flash cards to see what benefits we can get there from…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…_binlog=1 options are set and write-back cache is not enabled. Write-back cache is must-have for an environment demanding… Percona Server release. It is also interesting to see how Flash cards will handle innodb_flush_log_at_trx_commit=1… binary logs with system without writeback cache impacts performance significantly. And the similar with writeback cache enabled thread trx=1, No binlog…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… ? If we’re speaking about purely disk based SAN (no Flash) the drives are same drives you will see in directly… which will make read caching more efficient in its memory while write buffering can too be done by MySQL and local RAID… to say there is a benefit of read caching on SAN – if you have MySQL/server restart you may have warmup being…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… there are impossible. Furthermore, this optimization is not needed for flash devices, like FusionIO or Virident cards. An additional optimization we…_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred…
Comment: FlashCache: tpcc workload
May 29, 2010 By 18 Comments
… and have been debating using the second one for flash cache or to house MySQL directly. Our data set is about 30GB, but… currently. It looks like using the second drive as a cache might be the way to go. Was the setup difficult…
