… considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_…(free space) after this I executed alter table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND… not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
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: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
… look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will be… culture of common decency. That’s where things like the support of ZFS outside of Solaris comes from… people do technical…
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.
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
@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
… 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…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
Interesting results, and well presented. Would you mind sharing the command line you used for your iiBench clients? Also, did you run a test with innodb_flush_log_at_trx_commit = 1?
