… fit. But 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…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-…_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_…, and against the table purchases_index which has 3 secondary indexes. Another thing I would like to …
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… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread… TO BE GRANTED: RECORD LOCKS space id 57 page no 3 n bits 72 index `GEN_CLUST_INDEX` of table `test…
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…!=1) AND (FileTbl.hidden_element!=1) AND (FileTbl.folder_desc<2) AND (FileTbl.deactive!=1) AND (LinksTbl2.converted_from_id IS…
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… has biggest installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 23, 2012 By 9 Comments
1. Percona Toolkit works for all flavors of MySQL. 2. I am the lead author of the second and third …, but O’Reilly may not agree with me on that! 3. It sounds like you are Doing Something Wrong, but that…
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…: 16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: tmp… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Percona Toolkit 2.0.4 released
March 8, 2012 By Leave a Comment
… place all new features into the upcoming series (currently the 2.1 series) and only fix bugs in the current (2.0) series. When 2.1 is released as GA, we will freeze its features and begin work on 2.2, and so on. After the 2.0.3 release, which included complete rewrites of some…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… at the upcoming MySQL Conference and there will be many talks about various parts of the toolkit: A 3-hour tutorial about…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… 3 years,” and Robert Hodges agreed that it was “the best in years.” Darren Cassar called it “one of the best MySQL… Percona Live New York, which will be held October 1-2, 2012 at the Sentry Conference Center in New York City… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and…
