…to our Dell…to turn off write-cache on SSD – all transactions are in place now, but write speed is only 1200 writes…To have durability we need to disable write cache ( with following performance penalty, how much we need to…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…on has 256MB BBU (Battery Backed up Cache) on…cached reads because they may show latency to the RAID cache if RAID read cache is enabled. If it is disabled…writes are just stored in controller cache and flushed to the disk…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… on our Dell PowerEdge R900 box, using RAID10 over 8 disks…innodb_flush_neighbor_pages=0 , to disable flushing of neighborhood pages …And again, that makes a prediction of how many I/O operations thereÂ…write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache…
Post: RAID System performance surprises
March 5, 2008 By 7 Comments
…differences based on where data is stored on the disk, …Pretty typical controller from Dell installed on PowerEdge 1950, 2950…to the docs. During this time battery backed up cache will be disabled and system will operate with write through cache possibly slowing down write…have and see how they can be …
