… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1.1 driver. Thanks!
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, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now… release can be found in the 5.5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server would crash on…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
….62-13.3 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now… release can be found in the 5.1.62-13.3 milestone at Launchpad. New option rewrite-db has been added…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… with all 4 indexes the data itself is 2 or 3 times bigger, and the B-tree nodes are filled perhaps only 3/4 full, making the database a total of, say, 4… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
… at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect….EventQueue.access$000(EventQueue.java:101) at java.awt.EventQueue$3.run(EventQueue.java:666) at java.awt.EventQueue…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… primary index, and against the table purchases_index which has 3 secondary indexes. Another thing I would like to share is…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root@localhost:test 14… 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update insert…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… query with a couple of mins gap on the same mysql prod instance . The first SQL query executed in 0.03… query when using index merge executes in 3.8 secs. I dont understand why MySQL uses index merge after a couple of…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the… biggest installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… is allocated. This was not much of the problem in MySQL 3.23 when there would only handful of places where memory… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
