… periodic drops in performance which might be the result of the insert buffer filling up and then decreasing performance until some space…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… have compatible hardware before getting Duo card. I personally ended up with setup like this: I use a separate power supply… 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: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… 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
… problem be 10B rows, the cost of querying will go up by another factor of ten (it will be 100 disk… you are seeing. The periodic performance variation corresponds to filling up a partition and starting a new one. (If I read…, then we start a new partition, and Inno starts catching up and the performance starts getting better, and then the new…
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?
Post: Training in London next week
May 16, 2012 By Leave a Comment
… are still some places left if you want to sign up. You will also get a signed copy of High 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: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… start of pacemaker would be fail. Yesterday, I fix this up very dirty and it works.
