… 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
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb… = InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work… to serve other users too you typically need to reduce concurrency to where it does not overload the system. Unless it… a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting… struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update insert into…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping to 148 MiB… 1-64 threads. The throughput: We are getting to the peak throughput at 8 threads. And response time: For 8 threads, we may…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… results for random write case (8 async IO threads): It seems that InnoDB is not alone with its flashing problems. You can… getting to the peak throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time…
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.
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.
