… show a program where row-locks are used by one user to lock records for edit/update, so the transaction is not… a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation…
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: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Thanks for posting the benchmarks. They are very informative. One question: when …
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
Any particular reason for choosing 4 1GB log files instead of 2 2GB?
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.
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… my needs when I run benchmarks. Uniform is stupidly simple: for a table with 1 mln rows, each row gets equal… distribution good to test cache, but it is hard to emulate high IO load. That’s why I was looking for alternatives… times ( for row X: 1/(X^0) ). There is a research that shows that user behavior can be described by this distribution…
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
… in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… be 10B rows, the cost of querying will go up by another factor of ten (it will be 100 disk seeks… expect Inno starts hitting disk. Perhaps you could verify that by watching IOstat. Tim’s measurements (http://www.tokutek.com/2012…. And it’s still a good challenge. The URL for iibench is slightly incorrect. The correct URL for version you used is http…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… to run at the source and it’s probably a good idea to turn off the session’s binary log in… without the file. This is a great strategy if you wish to load up huge chunks of data in the slave… a pain, but it’s better than replication clogging up for hours!
