… 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: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
…_name=’abc’ and Data_free > 0 limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space… TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10; still the free space remains the same. that…
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: 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: 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: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
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…
