I have a few thoughts for some testing/comparison of mysql tables that I have been curious about. Before starting though, I thought it was prudent that I should give it some thought about the approach. The first thing that came to mind was altering the A Simple But Effective Speed Comparison code to execute a bunch of SQL queries against my local installation.
I really didn't like this approach because of the potential inaccuracy due to the overhead of the language and connecting to mysql before executing the queries. The whole purpose of these potential upcoming articles is to compare mysql, not a specific language integrating with mysql.
Luckily for us, as of Mysql 5.1.4, a tool called mysqlslap is shipped with the server installation. This tool allows us to client emulation against our mysql server!