… openais Current DC: percona1 – partition with quorum Version: … see bellow how to perform this action [root@percona1 percona...MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… 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… is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… partitions are one week each. So, even if the user’s ad hoc query leads to scanning the entire last two partitions, performance is not bad. (The last 2-3 partitions tend to stay in the buffer… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific references…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases… XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
… using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions… partitioned key you will look at one (or some of) partitions, however lookups by other keys will need to perform lookup in all partitions…
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… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…amazing MySQL manual, especially the option and…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: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This… delicate balance. It requires tricks, such as partitioning so all the inserts go into one partition, whose indexes fit in memory. The…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…gain system shows from performance at 1 thread to the peak performance we see the number…select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,…workload and innodb_adaptive_hash_index_partitions=16 available for partitioning adaptive hash index does not…
