…. For InnoDB logs and system tablespace I used partition on regular RAID10 with regular hard drives, here I followed Yoshinori Matsunobu’s….7x times better InnoDB-plugin. Now on CPU usage and disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs… on separate partition. And to make reference point, I run the same but with all files on RAID10 with regular disks, the…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… and commodity people. RAID can be indeed slower than direct disks. For example for BoardReader now indexing almost billion of forum… RAID available which is used for OS hard drive. Indeed using RAID for OS partition (software) is what we use even for low end boxes. This has zero cost and offer redundancy in case of hard…
Comment: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…for Transactional Logs you will often wast 4 hard drives from performance standpoint without a good reason. >… whole datadir) and log files on the same partition as well because this makes it very easy…as “protecting” — io by splitting data/logs) and disk writes are not allowed to be globally managed…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
….intel.com/Detail_Desc.aspx?agr=Y&DwnldID=17485) 2) Hard erase the drive after the update to make sure its… has 6 SATA ports. 4) Switch on AHCI for the disk configuration in your bios, it vastly improves small file access… directory on a seperate partition on a standard HDD. It’ll help minimise writes and the standard hard drives are excellent at…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… you have storage build from large number of hard drives. This problem is fixed in Lighttpd 1… static content and serving static content from the disk are different tasks and should not be mixed. … use noatime mount option for your static content partition. Some web servers also support for O_NOATIME …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
…difference in amount of internal and external hard drive connections they provide. Some Newer …: 0 Spinup limit external drives : 0 Defunct disk drive count : 0 Logical devices/Failed/Degraded …Enabled (write-back) when protected by battery/ZMM Partitioned : Yes Protected by Hot-Spare : No Bootable :…
Comment: Effect from innodb log block size 4096 bytes
January 4, 2011 By 19 Comments
…. With value 2 you indeed do not sync() to the disk but you have to do writes to OS cache. If… write is being issued, which is hard as logs and data are on the same partition in this case. I think it…
