…_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_…near no or no impact”. What is the cause of such difference ? I am not really sure. Apparently… bytes), but I do not know if the effect is the same as on FusionIO. I put …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…to share. I used a nice and effective tool iiBench which has been developed by…= 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method … = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent …
Comment: Adaptive flushing in MySQL 5.6 - cont
September 11, 2012 By 13 Comments
…, interesting. Getting to 75% isn’t really supposed to happen. Adaptive flushing is supposed to be varying up to innodb_max_io…. innodb_flushing_avg_loops does limit how fast it can adjust so you might find that some more tweaking of that helps…. Still lots of older code around but we know about the micro stall issue and how higher throughput make its effect worse…
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
…which caused unnecessary mutex re-acquisitions in adaptive flushing. Bug fixed #1117067 (Laurynas Biveinis). Percona …, which resulted in high false sharing effect in high-concurrent workloads. Bug fixed #1125259 ….4 by implementing an optimized version of the same function. Bug fixed #1130655 (Alexey…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…of server I’m looking at, assuming I’m on a GNU/Linux box (I have to adapt… | | Uptime_since_flush_status | 162626 | +———————————–+———————-+ +———————————–+———————-+ | …effects on the others. Each decision is a consideration of…
