Add additional innodb tunables to configuration

[zeryl]

I just recently started down the path of Ansible to configure boxes. One thing that I noticed another role (@bbatsche's mysql role) allows for a couple of items that would really benefit this role, I believe:

• Tunable percentage for InnoDB Buffer Pool Size (i.e. 80% of ram)
• innodb_buffer_pool_instances (ideally, a number. I typically set to the numeric part of the ram, to give 1gb per instance)

With being so new to Ansible, I'm sure there is a way to "override" this today, but I am unaware, and would love to see it natively supported.

[phanimullapudi]

@zeryl - You can modify like this - here i am using 75% of my memory

File - my.cnf.j2

innodb_buffer_pool_size = {{ ((ansible_memtotal_mb * 1024) * 0.75)|int|abs }} 

[zeryl]

Where do you set that? Do I need to edit the role, to set that?

[stale[bot]]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[github-actions[bot]]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.