… the write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe… “zfs snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to… for the whole setup. A small but yet interesting saving. All put together, ZFS on Linux is a very interesting solution for MySQL…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… (say 500 byte) files mostly, it’s best to use 512-byte blocks, for bigger files 4k may make more sense (you…). You want to know that when setting parameters for file system but when RAID is configured, there’s nothing more you can do… options you usually have to decide on very early when configuring RAID. Disk sectors Most if not all hard disk drives available…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… RAID logical volume that covers all your available drives. This is the easiest setup to configure and maintain and is the best choice for…-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you could also point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | … thought was) the best configuration, I …MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… when can be merged on OS level or RAID controller so we should expect at least as…_ahead configuration. Percona Server still allows me to enable Random Read_Ahead which is not available in MySQL … all together. In both cases for this given workload the performance was best with both read_ahead types …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…also don’t log the resulting errors. The best place to fix these problems is in the…for a monitoring agent or RAID utility software to do this. The pmp-check-unix-memory plugin checks for…this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected …
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… Second is the configuration issue – which can be hardware configuration such as … as disk failing in RAID, resync initiated, BBU starting “learning… and, implement solution not following best practices and do not test… for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space purposes. In this configuration using 600GB… allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best… well taken care of RAID Battery Backed Up cache … dedicated server for Mysql you will still need some memory for the …. Configure as much memory as possible to InnoDB’s buffer pool. For…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… will also tell you what we think is best for you, which is our job). After the kickoff …for several reasons. For one thing, it has a lot of information on the box’s hardware, including RAID…64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ …
