global variable to use in percona XtraDB cluster 8.0.19

MySQL & MariaDB Percona XtraDB Cluster 8.x
, ,
1

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?

2

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.

3

“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 ?

4

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

5

 query_cache was deleted from mysql 8.0

6

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