DrupalVM, innodb settings

Some time ago I had some examples how to setup your local mysql for development

One of the most important things to speed up your local dev is to set innodb_flush_log_at_trx_commit
to 2, which is not ACID compliant. but would be good enough for your local environment

Other important thing is how to setup innodb_buffer_pool_size, which there is excellent article here

So there are bunch of other mysql config which you can find in  provisioning/roles/geerlingguy.mysql/defaults/main.yml
but I set few of those, most important ones in config.yml

mysql_innodb_buffer_pool_size: "1G"
mysql_innodb_log_file_size: "64M"
mysql_innodb_log_buffer_size: "64M"
mysql_innodb_flush_log_at_trx_commit: "2"