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:
MySQL 101: Parameters to Tune for MySQL Performance - Percona Database Performance Blog
Ten 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 ?