Hi,Peter!
My MySQL server an data are all VM.
mysql_upgrade result:
Enter password:
Checking if update is needed.
Checking server version.
Error occurred: The mysql.session exists but is not correctly configured. The mysql.session needs SELECT privileges in the performance_schema database and the mysql.db table and also SUPER privileges.
my.cnf
# For advice on how to change settings please see
#
http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
slave-skip-errors=all
#log_slave_updates
log_bin=master6511
server_id=6511
log-bin-index = binlog.index
auto_increment_increment=2
auto_increment_offset=1
event_scheduler=ON
#并行复制
#slave-parallel-type=LOGICAL_CLOCK
#slave-parallel-workers=16
#master_info_repository=TABLE
#relay_log_info_repository=TABLE
#relay_log_recovery=ON
replicate-wild-ignore-table=account_platform.bcg_msg
replicate-wild-ignore-table=account_platform.bcg_msgservice
replicate-wild-ignore-table=account_platform.bcg_msgtype
replicate-wild-ignore-table=account_platform.bcg_trigger
#replicate-wild-ignore-table=account_platform.tb_device_auth
binlog-do-db=account_platform
binlog-do-db=key_manage_platform
binlog-do-db=card_first
binlog-do-db=card_second
binlog-do-db=obu_first
binlog-do-db=obu_second
binlog-do-db=card_load
binlog-do-db=card_purchase
binlog-do-db=cpc_first
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=sys
expire_logs_days=7
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names = 1
max_connections = 10000
key_buffer_size = 200M
low_priority_updates = 1
table_open_cache = 8000
back_log = 1500
query_cache_type = 0
table_open_cache_instances = 32
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"
innodb_flush_method = O_DIRECT
# files
innodb_file_per_table = 1
innodb_log_file_size = 1024M
innodb_log_files_in_group = 3
innodb_open_files = 8000
# buffers
innodb_buffer_pool_size = 80G
innodb_buffer_pool_instances = 32
innodb_log_buffer_size = 64M
join_buffer_size = 32K
sort_buffer_size = 32K
# innodb
innodb_checksums = 0
innodb_doublewrite = 0
innodb_support_xa = 0
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 2
innodb_max_dirty_pages_pct = 50
innodb_use_native_aio = 1
innodb_stats_persistent = 1
innodb_spin_wait_delay = 6
innodb_sync_spin_loops = 8
sync_binlog=0
# perf special
innodb_adaptive_flushing = 1
innodb_flush_neighbors = 0
innodb_read_io_threads = 32
innodb_write_io_threads = 64
#innodb_io_capacity = 8000
innodb_purge_threads = 4
innodb_adaptive_hash_index = 0
# monitoring
#innodb_monitor_enable = '%'
#performance_schema = OFF
#lock
metadata_locks_hash_instances = 32
default-time-zone = '+8:00'
connection-control-failed-connections-threshold=5
connection-control-min-connection-delay=6000