Variables Removed in MySQL 8.0

geerlingguy / ansible-role-mysql

Ansible Role - MySQL

https://galaxy.ansible.com/geerlingguy/mysql/

MIT License

1.05k stars 862 forks source link

Variables Removed in MySQL 8.0 #486

Closed numediaweb closed 2 years ago

numediaweb commented 2 years ago

This role contains some removed variables that don't allow MySQL server to run/init:

query_cache_type
query_cache_size
query_cache_limit
innodb_large_prefix
innodb_file_format

Checking the sudo cat /var/log/mysql/mysql.err file:

...
2022-04-03T17:41:40.978362Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=16M'.
2022-04-03T17:41:40.978765Z 0 [ERROR] [MY-010119] [Server] Aborting

https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

geerlingguy commented 2 years ago

See related: #477, #454.

stale[bot] commented 2 years ago

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.

stale[bot] commented 2 years ago

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.