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: 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: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… location. VPS and shared hosting are unreliable in that context – tuning might work superb today, average tomorrow, and occasionally backfire too.
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… these does help in many cases. Whatever powerful and well tuned system you have if you put too heavy of concurrent…
Post: Benchmarks challenges of XtraDB Cluster
April 20, 2012 By 4 Comments
… network communication between nodes also, and that makes a network tuning as the critical part of a cluster setup. This is…
Comment: Percona Announces New Relic Partnership
April 11, 2012 By 2 Comments
we’re working on it, Marcus! Stay tuned.
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
… under centos linux, we are had enough resource left, RAM, CPU in server. My question is: Does mysql enterprise edition helps…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… can be done in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression was only possible…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… Throughput scales with thread count – each thread runs at 100% CPU utilsation, and XFS gets up to 3x as much throughput… million 4k overwrite IOPS to a single file when completely CPU bound… So, basically, XFS is still the filesystem you want…
