[icot]

If the whole database is 2GB, can you get a server big enough to have all your data in memory, or at least the hot part of your data? That would be better.

[__xtrimsky]

It looks like a safe method is to make the innodb_buffer_pool_size a lot bigger, and it will in fact store all the db in memory.

(Otherwise you need to set up a backup or a replication in case the server goes down)

I'll play around with it, thanks!