Some time ago I had some examples how to setup your local mysql for development
https://www.drupaldump.com/installing-percona-instead-mysql-checking-db-engines-tunning
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
https://dba.stackexchange.com/questions/12611/is-it-safe-to-use-innodb-flush-log-at-trx-commit-2
Other important thing is how to setup innodb_buffer_pool_size, which there is excellent article here
https://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size
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"