…/O Performance: High API name: m2.4xlarge As for the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… to assert that XFS is the way to go for MySQL, but I’m not sure how frequently they benchmark XFS… developments in the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation), so maybe… correct sunit/swidth for the RAID array, or using nobarrier, all have no statistically significant impact on performance, which seems to indicate…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking…, to support new types of RAID controllers. Percona Toolkit is a hot topic at the upcoming MySQL Conference and there will be…’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download today…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
…about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). It is…———————————————————————- Logical device number 0 Logical device name : RAID10-A RAID level : 10 Status of logical device : Optimal Size : …
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
… about MySQL Performance or about Performance at all, but I guess it should be interested to many MySQL DBAs and other people involved running MySQL… it is much better than loosing everything. Unfortunately neither RAID BIOS nor RAID tools do not provide you with such feature. Happily… to perform “Verify Media” which can be used to scan hard drive and remap bad blocks. After remapping is done RAID mode…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… cycle which switches RAID cache in write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model … performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…
Post: RAID System performance surprises
March 5, 2008 By 7 Comments
Implementing MySQL database in 24/7 environments we typically hope for uniform component performance, or at least would like to be able… also tend to accumulate in predictable fashion. If you have RAID controller this well may not be the case – to protect your data RAID controller may implement bunch of algorithms which can affect performance dramatically. For example speaking about PERC5…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may… the case. There are whole classes of systems where Disk performance is not that important – consider for example systems where most… LVM for backups while assuming you have BBU on the raid volume impact on transactional log write speed is usually minimal…
