… am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer_size=6M mrr_buffer_size=6M Note that… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer…
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
Thanks Peter, it worked! 
I am using python and MySql 5.5, I have an XML file which I parse and the … and then child, after setting innodb_buffer_pool_instances to 8, I don’t see any difference. I guess I am…
Comment: InnoDB's gap locks
April 13, 2012 By 14 Comments
…” I have two sessions with REPEATABLE READ transaction isolation level. mysql> show create table t\G *************************** 1. row *************************** Table: t Create Table…`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> select * from t; +——+——–+ | i | c | +——+——–+ | 1 | miguel | | 3 | andy | | 5 | aaron | | 8 | repls | +——+——–+ Then I start two…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… see that even within MySQL 5.5 GA we’ve gone from InnoDB plugin version 1.1.4->1.1.8. Also, take a look at the changes in 5.5 from here: http://dev.mysql.com/doc/refman/5.5/en/news… in MySQL 5.1. Note that this is an incompatible change between 5.5.10 and earlier 5.5 versions, so client programs that use the 5.5…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per… been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17… the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
… ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004… function grows very fast – 7! = 5040, while 8! = 40320. The worst-case complexity of MySQL‘s join optimizer is N!. The goal… the potential pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and should…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response … interval is far from being strict 0.5 sec, but 0.5 is the mean of this random …? You can see it from following graph (1-8 threads): The queue piles up, waiting time grows, …
