… think you can show a program where row-locks are used by one user to lock records for edit/update, so the…
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 you configure MySQL, what portion of it resides …
Comment: ext4 vs xfs on SSD
May 18, 2012 By 23 Comments
Benoit, nice little script you’ve got there; using it!
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: Make your file system error resilient
April 26, 2012 By 8 Comments
…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway it just would be …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… basically that factor of 4. The variance is lower with only the primary key because the entire table fits in main… times bigger, and the B-tree nodes are filled perhaps only 3/4 full, making the database a total of, say… URL for version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… numbers: uniform, special and gaussian. I mostly use uniform and special, and I feel that …looking for alternatives, and Zipfian distribution seems decent one. This distribution has a parameter θ (theta), …very skewed, so I zoomed graphs to show only 0-100k level: I implemented Zipf for sysbench…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… But if it’s left on, the replication logic only replicates that “command” across the slaves, not the … with a production setup that I have, with one slave having the data file in the same … ‘/tmp/data.out’ INTO TABLE some_data_table; Using this strategy, replication continues to happen without a …
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
… too much system resources. Here are some specific techniques to use. Do push concurrency too high Many developers will test script… doing work from 32 processes is faster than just having one process. This is true if you have system completely at…. Unless it is really time critical process I would not use more than 4 parallel processes heavily writing to database. Introduce…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…. Another important configuration that I am using is that I am using “estimate” flushing method available only on Percona Server. The “estimate” method… the table purchases_noindex which has no secondary index and only a primary index, and against the table purchases_index which…
