global variable to use in percona XtraDB cluster 8.0.19

hi,

we are using percona xtraDB cluster 5.7 and will migrate to 8.0.19, the following is using in xtraDB cluster 5.7:

MySQL VARIABLES

max_connections = 10000
key_buffer_size =256000000
myisam_sort_buffer_size=67108864
read_buffer_size =1048576
read_rnd_buffer_size=4194304
sort_buffer_size=1048576
query_cache_size=16777216

lock_wait_timeout=300
wait_timeout=28800
interactive_timeout=28800
connect_timeout=30

sort_buffer_size=256000000
max_allowed_packet = 1073741824

lower_case_table_names=1
autocommit=0
open_files_limit=10000

log_timestamps = SYSTEM

transaction_isolation=“READ-COMMITTED”
sql_mode=“ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

I am not sure if percona xtraDB 8.0.19 should keep using this, please suggest.

and what is the suggest value for 8.0.19?

I would recommend you to check the following articles:
https://www.percona.com/blog/2020/06/30/mysql-101-parameters-to-tune-for-mysql-performance/
https://www.percona.com/blog/2014/01/28/10-mysql-performance-tuning-settings-after-installation/
Even they mention 5.7, the same parameters are valid for 8.0 too.

"Even they mention 5.7, the same parameters are valid for 8.0 too."
so I Just plug in my parameter it will works great on 8.0.19 ?
also listed in my.cnf ?

I try my own setting in xtraDB cluster 8.0.19, can’t even start ! any idea on which one is not good ?

 query_cache was deleted from mysql 8.0

any good recommendation on what variable we have to use for 8.0.19 ?