… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… is that I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional… query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now as…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
….23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.23….3 milestone at Launchpad. Bugs Fixed: Percona Server would crash on a DDL statement if an XtraDB internal SYS_STATS table…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
…: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there? Or… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… index maintenance. Transaction-id is auto-incremented, and so partitioning on transaction-id makes the insertions easy. Basically you fill in… read your graph correctly, you didn’t graph the performance on the first 100M rows). The minimum performance troughs occur just… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
Partitioning probably reduces the stress on the insert buffer. Does XtraDB/Percona Server have an option to use more IO for insert buffer merges when the ibuf gets too big?
Post: Training in London next week
May 16, 2012 By Leave a Comment
I’m going to deliver MySQL Training next week (May 21-24) in London. This is …. You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
On my boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql…, Yves fixed this in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Rob, Easiest way – just put everything on the Fusion-io card. For more fine tuning it can be something more complex, but it is case-by-case.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because…
