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"