MySQL Settings¶

Server configuration settings

The default configuration of MySQL comes with a very small memory configuration for InnoDB engine. Although it doesn't consume much memory, it can quickly become a bottleneck when database starts to grow.

So open the file

my.ini

and in the mysqld section, adjust the InnoBD settings

[mysqld]
..
..
..
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 8M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Depending on the database size, the innodb_buffer_pool_size will have to be increased, but the 512M initial size is quite enough for a database with less than 1G of size.