Just to check, is this true?:
DB size is 3.3 MB
It seems so incredibly small.
I just want to make sure,
did you really create a combined index or did you create two indexes, one each column?
I usually name my indexes like:
Then I know which columns that are part of the index by just looking at the name.
In your case my index would be named:
Then I know immediately what this index does.
That was a very small my.cnf.
And that means that you don’t have almost any internal caching configured since MySQL is very conservative with the default values.
Here’s a couple of addtions to your my.conf, just the most important ones for InnoDB:
innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 8M
innodb_log_file_size = 20M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1