… memory. Each row is on the order of 30 bytes in the primary table, and so a …for version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages …version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1.1 driver. Thanks!
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: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter…
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
@Time Callaghan, I did not test with innodb_flush_log_at_trx_commit=1 because the durability requirements are not that stringent. And following is how I invoked iiBench: iibench -T $tbl_name -D iiBench -r 200000000 -M 1 -s 1000000 -t 100000 -I 1 -a -S
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… are not that stringent and I can afford to loose 1 second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because IO times on EBS are not very consistent.
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… Server 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 current stable release in the 5.1 series. All of Percona…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… Server 5.5.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… the details of the release can be found in the 5.5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server…
Post: Percona Server 5.5.22-25.2 released!
April 26, 2012 By Leave a Comment
… Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now… the details of the release can be found in the 5.5.22-25.2 milestone at Launchpad. Bugs Fixed: While running…
