…perform the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL…need to and align the partition correctly. We got decent tpcc performance, nearly 37k NoTPM using…start the snapshot while holding a “flush tables with read lock” and the flush …
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…MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB… preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking…there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all …
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 …a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please …row (non-partitioned) table will, at worst, hit the disk only 5 times. (Usually 4 of the 5 …
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… to improve the performance of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of partitions are very limited… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… bring to the table with this kind of architecture. Case …of PXC/Galera and give some helpful instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance…using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa,…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…. OK, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is… a table structure with no secondary indexes. Other important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B+tree, having multiple buffer pool…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings… fix that (not verified). 6. Added LVM on top of aligned partition table, used proper file system alignment. Benchmark results I had a…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
…partitioned key you will look at one (or some of) partitions, however lookups by other keys will need to perform lookup in all partitions…of partitions made replication less efficient but the number of selects the table…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance… 1 partition insert took 50 seconds to complete, 10 partitions 52, 100 partitions 72, 1000 partitions 290 seconds. The performance loss with large number of partitions …
