… will perform the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL… LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11… partition mirror) and I limited the ARC size to 4GB. I don’t want to start a war but ZFS performance level…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity…MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…the entire last two partitions, performance is not bad. (The last 2-3 partitions tend to stay… connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please…the non-partition equivalent. Even single-row writes are likely to be slower in PARTITIONed tables unless…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… 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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 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: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
The use of tmpfs/ramfs as /tmp partition is a common trick to improve the performance of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of partitions are…, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing it to the Binary Log Files…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: … want to partition your large history tables, so it can keep up with the writes and/or …write performance scale with an increasing number of nodes? A: Since all the nodes has to do all the writes…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…and the general issues with distributed writing. This is really a foundation … MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I haven’t explored the performance… archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, …
