5 ms·
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.
by icot 12y ago
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 12y agoIt 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!