… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… going to 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.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… 5.1.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 the… of the release can be found in the 5.1.62-13.3 milestone at Launchpad. New option rewrite-db has been…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… OK, 1 row affected (0.00 sec) root@localhost:test 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows… 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… TO BE GRANTED: RECORD LOCKS space id 57 page no 3 n bits 72 index `GEN_CLUST_INDEX` of table `test…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… IOstat. Tim’s measurements (http://www.tokutek.com/2012/01/1-billion-insertions-%E2%80%93-the-wait-is-over/) on… for version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of the newer… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush… against the table purchases_index which has 3 secondary indexes. Another thing I would like…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
…com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection…awt.EventQueue$3.run(EventQueue.java:664) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1….
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… | eq_ref | PRIMARY | PRIMARY | 4 | oslogs_jan02_db.LinksTbl2.userid | 1 | | | 1 | SIMPLE | FileTbl | eq_ref | PRIMARY,folder_desc_ix | PRIMARY | 4…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…cards. It really makes sense to test it under MySQL workload, but before getting to that, let me …installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev … when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…allocated. This was not much of the problem in MySQL 3.23 when there would only handful of places …where engine=’memory’; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.00 sec) You can …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… are doing a lot of benchmarking of specific MariaDB 5.3 and MySQL 5.6 optimizer improvements, and both of them look… PAM plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it…
