see http://stackoverflow.com/questions/9947671/performance-difference-between-innodb-and-myisam-in-mysql
If you are using a relatively modern version of MySQL, run the following command before running the query:
set profiling = 1;
That will turn on query profiling for your session. After running the query, run
show profiles;