Mysql: increase the size of innodb_buffer_pool_size

By putting this on your mysql config file: [mysqld] innodb_buffer_pool_size = 2G In dedicated db machines, you can set this to close to 80% of the available memory. This will avoid disk writes and speed up things in general. The mysql configuration file is on : /etc/my.cnf (usually) Restaring mysql, and barabum barabim The typical […]