Morgan Tocker (mtocker) wrote,
Morgan Tocker

Initial findings on EC2

Yesterday I reported that I was looking into EC2 to see how it performed as a MySQL Server. Well, I got around to running some benchmarks today. My home machine (AMD64 3000 (I think), Ubuntu 7.10, 7200RPM drive, 1G RAM) can handle almost 730 transactions/second on a basic sysbench test:

sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 --mysql-socket=/var/run/mysqld/mysqld.sock  prepare
sysbench --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --mysql-socket=/var/run/mysqld/mysqld.sock --oltp-read-only run

What does EC2 (small instance) rate? 132.26 transactions/second.

I've got to say - I'm a little disappointed, since that's more than 5 times worse. I will test the other instance types over the coming days, and try and make my environment a little more controlled.

Databases are often disk i/o bound. Maybe they've considered this and improved it in the other available options? There's no details mentioning it though. Sigh. Correction: There is some mention.
Tags: mysql

  • On Testing MySQL Knowledge

    I can't read posts like this one without at least a little chuckle. Is the number one question you should be asking people how to start and stop…

  • My MySQL Conference Submission 2010: Workarounds

    I just submitted an abstract for the MySQL Conference 2010. What do I want to talk about? Workarounds. Domas likes to do tricks with GDB. Sheeri…

  • Hidden gems in 5.1

    I think 5.1 gets some bad press for not being a compelling upgrade. It's not the big features that make the difference, but the subtle ones. I…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.