…partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux…drive in the mirror. Better availability and disk usage On purpose, I allocated mirror … put together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… 1738 4194304 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 1738 145649 1155959808 83 Linux Partition 3 does… 27920383 4194304 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 27920384 2339839999 1155959808 83 Linux Partition 3 does…’s no striping, with RAID0 number of bearing disks is actual number of disks (N), with RAID1+0 (RAID10) it’s N…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2…{OUT OF SPEC} Other … # Disk Schedulers And Queue Size ############################# sda | [… a raw partition I was using full partition size… MySQL configurations, I didn’t try out different MySQL…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… disk space [########################################################] 100% (1/4) installing libmysqlclient [########################################################] 100% (2/4) installing mysql-…Linux command line If you did get a SD card which is larger then 2GB, you can add another partition…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which … at many times the amount of memory MySQL consumes worth of disk space. You have to do couple … anyway as you can put it on different partition etc so you are not risking to run …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… bytes Disk identifier: 0x00051fe9 Device Boot Start End Blocks Id System /dev/sda1 2048 7813119 3905536 82 Linux swap / Solaris Partition 1 does…. Get start boundary of our mysql partition from fdisk: 27344896. See if the Start boundary for our mysql partition falls on a stripe boundary…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…mysql-5.6.html These improvements sound interesting to page flush and i/o problems? Explicit Partition… is not the default schedualer of linux but was recommended for ext4. If …disk not ram for mysql like varnish for http webserver should speed up mysql since its already technically on the disk…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… helped dealing with performance problems (part MySQL related and part related to LAMP in general)… content and serving static content from the disk are different tasks and should not be mixed…static content partition. Some web servers also support for O_NOATIME file open flag on newer Linux versions…
