Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the … : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock… Creation Time : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Raid Devices : 6 Avail Dev Size : 5851089777 (2790.02 GiB…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it… to over 2000 per second – a lot more than this software RAID could do in real IOPs. I started to experiment with…_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… about death of the RAID. I think this is far from the case especially if you consider Software RAID here. For many workloads you would like to get RAID just for the sake of BBU. As Jeremy mentioned RAID is… as far as I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity does…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…/07/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks. Benchmark date…, 16MB, SATA. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity… with operating system and other system software involved. In could be even system which queries mysql. I’ve seen monitoring updates which…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… as device in your OS, so you can easily make software RAID from several volumes. So I created 4 volumes ( I used… EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with others, and… get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
…: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with baseline Fusion-io ioDrive card Hardware… ioDrive 640GB, Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… above – you can’t change the disks either. Both software RAID striping the internal disks on an extra large EC2 instance… volumes is still going to be slower than a good RAID 10 controller with a battery backed write cache. If you…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…; it is not unheard of for a monitoring agent or RAID utility software to do this. The pmp-check-unix-memory plugin…
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 8, 2010 By 20 Comments
… MySQL systems. They tried several configurations (usually 4 drives, they tried hardware RAID, software RAID, RAID 1+0 and RAID 0), but in all cases the RAID controller or software couldn’t predict when the…
