Has anyone here encountered such scenario before where and update statement took longer time to run when innodb_buffer_pool_size is bigger.
I've run a few tests using the same statements on around 2500 rows of data on a single table, here are the data that I manage to get.
innodb_buffer_pool_size = 16M Time taken for SQL to complete - 1 min 25 sec
innodb_buffer_pool_size = 1G Time taken for SQL to complete - 3 min 45 sec
innodb_buffer_pool_size = 2G Time taken for SQL to complete - 4 min 53 sec
I'm running MariaDB 5.5 on an AWS EC2 instance with m1.large size. Does anyone has any idea how could this happened?