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: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… for posting the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there? Or is it more complex than that? I‘m new… and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT… 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter table abc…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
… user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation.
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
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Mark, Probably what you are referring to is provided by the configuration option “innodb_ibuf_accel_rate” available in Percona (as mentioned by Justin). Increasing/decreasing the value of innodb_ibuf_accel_rate, you will increase/decrease the insert buffer activity.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Any particular reason for choosing 4 1GB log files instead of 2 2GB?
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
May 21, 2012 By 10 Comments
hi ~ Ovais Tariq ,do you have dbt-3 Implementation document ?
