… considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row…
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
Rob, That seems a little on high level. The feedback I am getting from our customers is that with some negotiations you should be able to drive price down for ~20%
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
Hi, I use percona server 5.5.20, I would be testing xtradb cluster with three nodes. I …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
This benchmark doesn’t test the IO performance of EBS though as you’re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… the monitores working – i created the different tables for the innodb (Standard, Lock,Tablespace,Table) and the server doesn’t report…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
…(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: 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.
