Increase innodb_buffer_pool_size to 128MB
RAM is much cheaper nowadays, so we can afford allocating a little bit more memory to MySQL. This will decrease I/O and improve latency as MySQL should be able to fit larger chunk of indexes into memory, especially on larger tables.
parent
287ad0c6
Please register or sign in to comment