… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B+tree, having…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse and worse as a partition… because you are writing 4 times fewer B…mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance…
Comment: Make your file system error resilient
April 26, 2012 By 8 Comments
…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway it just would be wasted if… block count: 0″ is nearly full, this generates file fragmentation, performance issues, unless you manually apply e2defrag regularily. Not a good…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 14 Comments
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL… Write-Through and then to Write-Back. 1. Baseline – misalignment on the partition …thread performance improvement is marginal however WB cache brings single thread random write performance …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual… Key_write_requestsblogpercona….Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…anyway as you can put it on different partition etc so you are not risking to …mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing…expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… advanced” than using a database. Sharding and Partitioning Sharding is inevitable if your write workload exceeds the capacity of a single server… change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases…, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload. The…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…partitioning of MySQL. Added the following clause to the HISTORY table definition. “PARTITION BY HASH(REF_OBJECT) PARTITIONS 16″ Now the performance became to “+partitioned…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…write cache enabled Partitioning You want to run only MySQL on this box, and you want to ensure your MySQL…performance from the box. Fiddling with how to allocate drives and drive space from partition to partition…mysql partition from fdisk: 27344896. See if the Start boundary for our mysql partition…
