…needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, … it hurts – when you do not have RAID with BBU and your workload is very … guess these clarifications work better than 70-80% recommendation and of course you should not stick …
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… in search engine bot activity. It may be RAID writeback cache disabled due to battery learning but …when it tries to put too much load on MySQL as MySQL load stabilizes increasing number of connections higher …you have some means to do that. I’d recommend doing it on user session so some users …
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… go for MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes…-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4, and it’s been working great for… of allocation groups, setting the correct sunit/swidth for the RAID array, or using nobarrier, all have no statistically significant impact…
Comment: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
…=2 I’m comparing replicated setup – MongoDB guys do not recommend running single node in production. In this case if your…, on which MongoDB guys can argue RAID controller melt down will cause database corruption on single MySQL Innodb issue. So the point…
Comment: Beware: ext3 and sync-binlog do not play well together
April 7, 2009 By 19 Comments
Thanks for your quick replies. I am running MySQL on a Dell PowerEdge 2950 with PERC6 (with BBU) 6 x 15K drives configured with Raid 10. Is the recommendation to: 1) mount XFS with -onobarrier 2) write cache disabled for the drive 3) write-back enabled for the controller
