MySQL Forums
Forum List  »  General

Re: databases are lost
Posted by: jm L
Date: March 15, 2021 08:45PM

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

Options: ReplyQuote


Subject
Written By
Posted
March 02, 2021 03:33AM
March 02, 2021 11:25AM
March 09, 2021 08:31PM
March 09, 2021 09:17PM
March 09, 2021 09:25PM
March 10, 2021 10:08AM
March 10, 2021 07:53PM
March 10, 2021 09:23PM
March 11, 2021 12:11AM
March 11, 2021 05:36AM
March 11, 2021 06:39AM
March 11, 2021 09:37AM
March 11, 2021 08:04PM
March 12, 2021 09:11AM
March 12, 2021 07:36PM
March 12, 2021 08:17PM
March 12, 2021 08:41PM
March 13, 2021 09:41AM
March 15, 2021 10:03AM
March 15, 2021 11:34AM
Re: databases are lost
March 15, 2021 08:45PM
March 15, 2021 09:10PM
March 15, 2021 09:26PM
March 15, 2021 09:38PM
March 15, 2021 09:47PM
March 15, 2021 10:30PM
March 16, 2021 09:24PM
March 16, 2021 10:31PM
March 16, 2021 11:09PM
March 17, 2021 07:08AM
March 17, 2021 07:17AM
March 15, 2021 09:56PM
March 17, 2021 11:16AM
March 19, 2021 12:02AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.