… to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to…
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 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?
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…periodic drops in performance which might be the result of the insert buffer filling up and then…which insert buffer pages are flushed to disk (innodb_ibuf_accel_rate) which might be interesting to…rate when increased insert buffer flushing was enabled (using the FB patch, not XtraDB but difference …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which… I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… UPDATE ” on my server ,and my results are as follow: Transaction1: root…); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root… be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION … 1100101952 inserting mysql tables in use 1, locked 1 LOCK WAIT …
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it…). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you… them). The end result was: I could only use mysqldump to import all the data into a clean/fresh innodb system! Good luck…
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_… the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter table abc engine=innodb and re… not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… you have compatible hardware before getting Duo card. I personally ended up with setup like this: I use a separate power supply… to the results. For this test I also use Cisco UCS C250 server, and on the graph I show the results for both… general ioDrive2 seems to provide better and more stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d,s…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… too much system resources. Here are some specific techniques to use. Do push concurrency too high Many developers will test script…. Unless it is really time critical process I would not use more than 4 parallel processes heavily writing to database. Introduce…
