Not the answer you need?
Register and ask your own question!

global variable to use in percona XtraDB cluster 8.0.19

DBA100DBA100 Current User Role Patron
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?

Best Answer


  • DBA100DBA100 Current User Role Patron
    "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 ?
  • DBA100DBA100 Current User Role Patron
    I try my own setting in xtraDB cluster 8.0.19, can't even start ! any idea on which one is not good ?
  • MirSosMirSos Current User Role Contributor
     query_cache was deleted from mysql 8.0
  • DBA100DBA100 Current User Role Patron
    any good recommendation on what variable we have to use for 8.0.19 ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.