Comments on DBA Dojo: Sysbench fileio vs XLarge EC2 Part 3

Thanks for the comment.Yes. I did a bunch of work ...

2008-08-27T19:11:00.000-07:00

Thanks for the comment.

Yes. I did a bunch of work on getting MySQL running with DBRD and was going to publish, however it is pretty useless information now there is Amazon EBS.

I am always open to requests for info/work for readers, so yes, I am planning on rerunning the benchmarks on EBS.

Have Fun

I wonder if you plan to run MySQL and other I/O be...

2008-08-27T18:56:00.000-07:00

I wonder if you plan to run MySQL and other I/O benchmarks on EBS in the near future. Btw, your discovery re: horrible /mnt performance are confirmed by our SPA Management application which took a dive on filesort (on fairly small datasets of 50-100K rows). Some non-trivial optimizations and wrestling with MySQL optimizer were required to avoid filesort altogether.

I'm also waiting for a persitent storage account ;...

2008-04-16T15:06:00.000-07:00

I'm also waiting for a persitent storage account ;-)
In the meantime let's use what is available.

Reading your recommandations, could you explain some points.
1. /dev/sda/ : do you mean that it would be better to separate the tables of the database or simply use /dev/sda (if 10GB is enough for DB storage)
2. I found info about db caching (http://dev.mysql.com/doc/refman/5.0/