I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program … one user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of a program is worth…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there? Or is it more complex than that? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… it returned the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter table abc engine=innodb… 10; still the free space remains the same. that means that table could not be defragmented. is there any other way to defragment innodb tables…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Rob, Easiest way – just put everything on the Fusion-io card. For more fine tuning it can be something more complex, but it is case-by-case.
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Mark, Probably what you are referring to is provided by the configuration option “innodb_ibuf_accel_rate” available in Percona (as mentioned by Justin). Increasing/decreasing the value of innodb_ibuf_accel_rate, you will increase/decrease the insert buffer activity.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… am not testing IO performance and instead trying to optimize writes, also the durability requirements are not that stringent and I can afford to loose 1 second worth of data, hence I did not test…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
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 17, 2012 By 11 Comments
Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.
