… Data_free > 0 limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space) after this…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
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
… are seeing periodic drops in performance which might be the result of the insert buffer filling up and then decreasing performance…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and… 181G. Now let’s come down to the interesting part. Results With the table purchases_noindex, that has no secondary indexes…
Comment: Testing Fusion-io ioDrive2 Duo
May 12, 2012 By 12 Comments
Rob, You can find scripts there https://code.launchpad.net/~percona-dev/percona-benchmark-result/fusionio-311
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
… , but i will, i have one question about select sorted results from a big mysql tabble, myISAM, with about 2 Milion registers , so , what i can do , to get randomic result from this table, with best perfomance?!!? Do you want to…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
…, Fusion-io driver version: 3.1.1. Now to the results. For this test I also use Cisco UCS C250 server, and on the graph I show the results for both single card and raid (Duo). Random writes, async… general ioDrive2 seems to provide better and more stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d,s…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…. Then the LOAD DATA INFILE command is executed with the resulting file.
