Guidance:
Author: at present, Jiang lexing MySQL DBA maintains two sets of MySQL open-source tools & DBM (DBM agent DBM Center) on github, and has some experience in machine learning and programmed transaction.
Catalog
-
Using dbm to liberate productivity
-
Install & initialize DBM agent
-
One line command to solve the problem of installing a single computer
-
One line command solves the problem of adding slave
-
One line command to solve the problem of building MGR cluster
-
How about the instance quality of DBM agent
1, Using dbm to liberate productivity
For dbm, no matter you are building a single machine, master-slave replication, exclusive or MGR, you only need one line of command to solve it efficiently and high quality, and there is almost no cost (dbm is fully open-source, including dbm agent, dbm Center). Let's test the efficiency improvement of dbm agent.
2, Install & initialize DBM agent
1. Install DBM agent through pip3, a python package management tool
bash sudo su pip3 install dbm-agent Installing collected packages: dbm-agent Running setup.py install for dbm-agent ... done Successfully installed dbm-agent-0.4.2
2. Initialize DBM agent
bash sudo su dbm-agent init # After success, you can see the following directory structure tree /usr/local/dbm-agent/ ├── etc │ ├── dbma.cnf # Configuration file of DBM agent │ ├── init-users.sql # The user name and password in this file will be used to create users in the initialization database │ └── templates │ ├── create-innodb-cluster.js │ ├── init-users.sql.jinja │ ├── mysql-8.0.17.cnf.jinja # Profile template corresponding to mysql-8.0.17 │ ├── mysql-8.0.18.cnf.jinja # Profile template corresponding to mysql-8.0.18 │ ├── mysql-8.0-init-only.jinja # Configuration files used only during initialization │ └── mysqld.service.jinja # MySQL system D profile template ├── logs # DBM agent's log file saving directory (only when there is a daemons mode can the log be written to this time) └── pkg
During init, you can use -- init PWD to set the password of mysql user. If it is not specified, it defaults to dbma @0352
3. Download the binary installation package of mysql and mysql shell to / usr / local / DBM agent / PKG. After completion, the contents of the directory are as follows
bash tree /usr/local/dbm-agent/pkg ├── mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz # Installation package of each software (to download and save it here, DBM agent will not download it automatically └── mysql-shell-8.0.18-linux-glibc2.12-x86-64bit.tar.gz # Installation package of each software (to download and save it here, DBM agent will not download it automatically)
The following content will not be added with sudo su, which runs under root by default
3, One line command to solve the problem of installing a single computer
1. Install an instance listening on port 3306, and limit it to 1G memory
bash dbma-cli-single-instance --port=3306 --max-mem=1024 install 2019-11-17 16:48:03,108 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller.install - im - INFO - 1115 - execute checkings for install mysql 2019-11-17 16:48:03,135 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._create_mysql_user - im - INFO - 864 - create user 'mysql3306' complete 2019-11-17 16:48:03,136 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._create_data_dir - im - INFO - 888 - create datadir '/database/mysql/data/3306' complete 2019-11-17 16:48:03,137 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._create_binlog_dir - im - INFO - 910 - create binary dir '/binlog/mysql/binlog/3306' complete 2019-11-17 16:48:03,138 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._create_backup_dir - im - INFO - 932 - create backup dir '/backup/mysql/backup/3306' complete 2019-11-17 16:48:03,138 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render_template_file - im - INFO - 518 - using template 'mysql-8.0-init-only.jinja' 2019-11-17 16:48:03,138 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.set_template - im - INFO - 457 - using template file 'mysql-8.0-init-only.jinja' 2019-11-17 16:48:03,175 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render - im - INFO - 497 - render mysql config file /tmp/mysql-init.cnf 2019-11-17 16:48:03,175 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render_template_file - im - INFO - 524 - render template file complete 2019-11-17 16:48:03,175 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render_template_file - im - INFO - 548 - using template 'mysql-8.0.18.cnf.jinja' 2019-11-17 16:48:03,175 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.set_template - im - INFO - 457 - using template file 'mysql-8.0.18.cnf.jinja' 2019-11-17 16:48:03,208 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render - im - INFO - 497 - render mysql config file /etc/my-3306.cnf 2019-11-17 16:48:03,208 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render_template_file - im - INFO - 554 - render template file complete 2019-11-17 16:48:03,208 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._render_production_cnf - im - INFO - 956 - render production cnf complete 2019-11-17 16:48:03,209 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._init_database - im - INFO - 1004 - ['/usr/local/mysql-8.0.18-linux-glibc2.12-x86_64/bin/mysqld', '--defaults-file=/tmp/mysql-init.cnf', '--initialize-insecure', '--user=mysql3306', '--init-file=/usr/local/dbm-agent/etc/init-users.sql'] 2019-11-17 16:48:13,963 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._init_database - im - INFO - 1011 - init database complete 2019-11-17 16:48:13,967 - dbm-agent.dbma.mysqldeploy.MySQLSystemdRender.render - im - INFO - 666 - render systemd config file complete 2019-11-17 16:48:13,967 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._config_systemd - im - INFO - 1027 - mysql systemd config complete 2019-11-17 16:48:14,146 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._enable_mysql - im - INFO - 1038 - config mysql auto start on boot complete 2019-11-17 16:48:16,172 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._start_mysql - im - INFO - 1068 - start mysql complete 2019-11-17 16:48:16,173 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._export_path - im - INFO - 1078 - export path complete 2019-11-17 16:48:16,177 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._export_header_file - im - INFO - 1106 - export header file complete 2019-11-17 16:48:16,177 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller._export_so - im - INFO - 1093 - so file has been exported 2019-11-17 16:48:16,177 - dbm-agent.dbma.mysqldeploy.SingleInstanceInstaller.install - im - INFO - 1150 - install mysql single instance complete
2. Check if the process is running
bash ps -ef | grep mysql mysql33+ 7418 1 1 16:48 ? 00:00:02 /usr/local/mysql-8.0.18-linux-glibc2.12-x86_64/bin/mysqld --defaults-file=/etc/my-3306.cnf root 7463 7271 0 16:51 pts/0 00:00:00 grep --color=auto mysql
3. Connect it and test it
sql mysql -h127.0.0.1 -P3306 -uroot -pdbma@0352 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.18 MySQL Community Server - GPL Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user,host from mysql.user order by user; +--------------------+-----------+ | user | host | +--------------------+-----------+ | cloneuser | % | | cloneuser | 127.0.0.1 | | cloneuser | localhost | | dbma | 127.0.0.1 | | innodbclusteradmin | % | | monitor | 127.0.0.1 | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | | repluser | % | | root | 127.0.0.1 | | root | localhost | +--------------------+-----------+ 12 rows in set (0.01 sec)
4, One line command solves the problem of adding slave
The single machine in the previous example is on the 172.16.192.100 host. If you want to use 172.16.192.110 as its slave, you need to "backup", "restore" and "establish master-slave relationship" if you do it manually. DBM agent implements all these logic, and only one command can solve them
1. Suppose you have completed the installation and initialization of DBM agent on the 172.16.192.110 host
bash dbma-cli-build-slave --host=172.16.192.100 --port=3306 build-slave 2019-11-17 17:03:46,620 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.remote_clone - bms - INFO - 1590 - execute checkings for install mysql` 2019-11-17 17:03:46,654 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.install - bms - INFO - 1115 - execute checkings for install mysql 2019-11-17 17:03:46,695 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._create_mysql_user - bms - INFO - 864 - create user 'mysql3306' complete 2019-11-17 17:03:46,698 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._create_data_dir - bms - INFO - 888 - create datadir '/database/mysql/data/3306' complete 2019-11-17 17:03:46,701 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._create_binlog_dir - bms - INFO - 910 - create binary dir '/binlog/mysql/binlog/3306' complete 2019-11-17 17:03:46,704 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._create_backup_dir - bms - INFO - 932 - create backup dir '/backup/mysql/backup/3306' complete 2019-11-17 17:03:46,706 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render_template_file - bms - INFO - 518 - using template 'mysql-8.0-init-only.jinja' 2019-11-17 17:03:46,706 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.set_template - bms - INFO - 457 - using template file 'mysql-8.0-init-only.jinja' 2019-11-17 17:03:46,741 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render - bms - INFO - 497 - render mysql config file /tmp/mysql-init.cnf 2019-11-17 17:03:46,741 - dbm-agent.dbma.mysqldeploy.MyCnfInitRender.render_template_file - bms - INFO - 524 - render template file complete 2019-11-17 17:03:46,742 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render_template_file - bms - INFO - 548 - using template 'mysql-8.0.18.cnf.jinja' 2019-11-17 17:03:46,742 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.set_template - bms - INFO - 457 - using template file 'mysql-8.0.18.cnf.jinja' 2019-11-17 17:03:46,779 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render - bms - INFO - 497 - render mysql config file /etc/my-3306.cnf 2019-11-17 17:03:46,779 - dbm-agent.dbma.mysqldeploy.MyCnfMSRender.render_template_file - bms - INFO - 554 - render template file complete 2019-11-17 17:03:46,779 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._render_production_cnf - bms - INFO - 956 - render production cnf complete 2019-11-17 17:03:46,779 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._init_database - bms - INFO - 1004 - ['/usr/local/mysql-8.0.18-linux-glibc2.12-x86_64/bin/mysqld', '--defaults-file=/tmp/mysql-init.cnf', '--initialize-insecure', '--user=mysql3306', '--init-file=/usr/local/dbm-agent/etc/init-users.sql'] 2019-11-17 17:03:57,934 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._init_database - bms - INFO - 1011 - init database complete 2019-11-17 17:03:57,938 - dbm-agent.dbma.mysqldeploy.MySQLSystemdRender.render - bms - INFO - 666 - render systemd config file complete 2019-11-17 17:03:57,938 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._config_systemd - bms - INFO - 1027 - mysql systemd config complete 2019-11-17 17:03:58,110 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._enable_mysql - bms - INFO - 1038 - config mysql auto start on boot complete 2019-11-17 17:04:00,144 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._start_mysql - bms - INFO - 1068 - start mysql complete 2019-11-17 17:04:00,145 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._export_path - bms - INFO - 1078 - export path complete 2019-11-17 17:04:00,147 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._export_header_file - bms - INFO - 1106 - export header file complete 2019-11-17 17:04:00,148 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave._export_so - bms - INFO - 1093 - so file has been exported 2019-11-17 17:04:00,148 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.install - bms - INFO - 1150 - install mysql single instance complete 2019-11-17 17:04:00,167 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.remote_clone - bms - INFO - 1613 - prepare execute 'set @@global.clone_valid_donor_list='172.16.192.100:3306';' 2019-11-17 17:04:00,168 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.remote_clone - bms - INFO - 1618 - prepare execute 'clone instance from cloneuser@'172.16.192.100':3306 identified by 'dbma@0352'; 2019-11-17 17:04:03,431 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.remote_clone - bms - INFO - 1629 - remote clone complete (mysql will auto restart,please wait) 2019-11-17 17:04:03,432 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.build_slave - bms - INFO - 1689 - wait mysql protocol avaiable 2019-11-17 17:04:14,454 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.build_slave - bms - INFO - 1710 - prepare execute 'change master to master_host='172.16.192.100',master_port=3306,master_user='repluser',master_password='dbma@0352',master_ssl = 1,master_auto_position=1;' 2019-11-17 17:04:14,466 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.build_slave - bms - INFO - 1716 - prepare execute 'start slave;' 2019-11-17 17:04:14,472 - dbm-agent.dbma.mysqldeploy.MySQLBuildSlave.build_slave - bms - INFO - 1728 - rebuild mysql slave complete
2. Check whether the master-slave relationship is normal
sql mysql -uroot -pdbma@0352 -h127.0.0.1 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 8.0.18 MySQL Community Server - GPL Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.16.192.100 Master_User: repluser Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 151 Relay_Log_File: relay.000002 Relay_Log_Pos: 357 Relay_Master_Log_File: mysql-bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes
**5, One line command solves the problem of building MGR cluster
There are no more examples here. You can go directly to github to see the description of DBM agent. MySQL group replication, MySQL shell, InnoDB cluster and MySQL router all support it.
6, How about the instance quality of DBM agent
1. A complete, on-demand optimized & rendered profile
ini #cat /etc/my-3306.cnf [mysqld] # basic user = mysql3306 basedir = /usr/local/mysql-8.0.18-linux-glibc2.12-x86_64 datadir = /database/mysql/data/3306 server_id = 1388 port = 3306 bind_address = * admin_address = 127.0.0.1 mysqlx_port = 33060 admin_port = 33062 socket = /tmp/mysql-3306.sock mysqlx_socket = /tmp/mysqlx-33060.sock pid_file = /tmp/mysql-3306.pid character_set_server = utf8mb4 open_files_limit = 102000 max_prepared_stmt_count = 1048576 skip_name_resolve = 1 super_read_only = OFF log_timestamps = system event_scheduler = OFF auto_generate_certs = ON activate_all_roles_on_login = ON end_markers_in_json = OFF tmpdir = /tmp/ max_connections = 128 autocommit = ON sort_buffer_size = 256K join_buffer_size = 256K eq_range_index_dive_limit = 200 ## table big_tables = OFF sql_require_primary_key = OFF lower_case_table_names = 1 auto_increment_increment = 1 auto_increment_offset = 1 table_open_cache = 4000 table_definition_cache = 2000 table_open_cache_instances = 32 ## net max_allowed_packet = 1G connect_timeout = 10 interactive_timeout = 28800 net_read_timeout = 30 net_retry_count = 10 net_write_timeout = 60 net_buffer_length = 32K ## logs log_output = FILE general_log = OFF general_log_file = general.log # error log_error = err.log log_statements_unsafe_for_binlog = ON # slow slow_query_log = ON slow_query_log_file = slow.log long_query_time = 2 log_queries_not_using_indexes = OFF log_slow_admin_statements = OFF log_slow_slave_statements = OFF # binlog log_bin = /binlog/mysql/binlog/3306/mysql-bin binlog_checksum = none log_bin_trust_function_creators = ON binlog_direct_non_transactional_updates = OFF binlog_expire_logs_seconds = 604800 binlog_error_action = ABORT_SERVER binlog_format = ROW max_binlog_stmt_cache_size = 1G max_binlog_cache_size = 1G max_binlog_size = 1G binlog_order_commits = ON binlog_row_image = FULL binlog_row_metadata = MINIMAL binlog_rows_query_log_events = ON binlog_stmt_cache_size = 32K log_slave_updates = ON binlog_transaction_dependency_history_size =25000 binlog_transaction_dependency_tracking = WRITESET sync_binlog = 1 binlog_cache_size = 96K binlog_group_commit_sync_delay = 0 binlog_group_commit_sync_no_delay_count = 0 ## replication rpl_semi_sync_master_enabled = 1 rpl_semi_sync_slave_enabled = 1 rpl_semi_sync_master_timeout = 1000 rpl_semi_sync_master_wait_point = AFTER_SYNC rpl_semi_sync_master_wait_no_slave = ON rpl_semi_sync_master_wait_for_slave_count = 1 master_info_repository = table sync_master_info = 10000 skip_slave_start = OFF slave_load_tmpdir = /tmp/ plugin_load_add = semisync_master.so plugin_load_add = semisync_slave.so relay_log = relay sync_relay_log = 10000 sync_relay_log_info = 10000 relay_log_info_repository = table slave_preserve_commit_order = ON slave_parallel_type = logical_clock slave_parallel_workers = 2 slave_max_allowed_packet = 1G ## gtid gtid_mode = ON binlog_gtid_simple_recovery = ON enforce_gtid_consistency = ON gtid_executed_compression_period = 1000 ## clone plugin-load-add = mysql_clone.so clone = FORCE_PLUS_PERMANEN # engines default_storage_engine = innodb default_tmp_storage_engine = innodb internal_tmp_mem_storage_engine = TempTable ## innodb innodb_data_home_dir = ./ innodb_data_file_path = ibdata1:64M:autoextend innodb_page_size = 16K innodb_default_row_format = dynamic innodb_log_group_home_dir = ./ innodb_redo_log_encrypt = OFF innodb_online_alter_log_max_size = 256M innodb_undo_directory = ./ innodb_undo_log_encrypt = OFF innodb_undo_log_truncate = ON innodb_max_undo_log_size = 1G innodb_rollback_on_timeout = OFF innodb_rollback_segments = 128 innodb_log_checksums = ON innodb_checksum_algorithm = crc32 innodb_log_compressed_pages = ON innodb_doublewrite = ON innodb_commit_concurrency = 0 innodb_read_only = OFF innodb_dedicated_server = OFF innodb_old_blocks_pct = 37 innodb_old_blocks_time = 1000 innodb_random_read_ahead = OFF innodb_read_ahead_threshold = 56 innodb_max_dirty_pages_pct_lwm = 20 innodb_max_dirty_pages_pct = 90 innodb_lru_scan_depth = 1024 innodb_adaptive_flushing = ON innodb_adaptive_flushing_lwm = 10 innodb_flushing_avg_loops = 30 innodb_buffer_pool_dump_pct = 50 innodb_buffer_pool_dump_at_shutdown = ON innodb_buffer_pool_load_at_startup = ON innodb_buffer_pool_filename = ib_buffer_pool innodb_stats_persistent = ON innodb_stats_on_metadata = ON innodb_stats_method = nulls_equal innodb_stats_auto_recalc = ON innodb_stats_include_delete_marked = ON innodb_stats_persistent_sample_pages = 20 innodb_stats_transient_sample_pages = 8 innodb_status_output = OFF innodb_status_output_locks = OFF innodb_buffer_pool_dump_now = OFF innodb_buffer_pool_load_abort = OFF innodb_buffer_pool_load_now = OFF innodb_thread_concurrency = 0 innodb_concurrency_tickets = 5000 innodb_thread_sleep_delay = 15000 innodb_adaptive_max_sleep_delay = 150000 innodb_read_io_threads = 4 innodb_write_io_threads = 4 innodb_use_native_aio = ON innodb_flush_sync = OFF innodb_spin_wait_delay = 6 innodb_purge_threads = 4 innodb_purge_batch_size = 300 innodb_purge_rseg_truncate_frequency = 128 innodb_deadlock_detect = ON innodb_print_all_deadlocks = ON innodb_lock_wait_timeout = 50 innodb_table_locks = ON innodb_sync_array_size = 1 innodb_sync_spin_loops = 30 innodb_print_ddl_logs = OFF innodb_replication_delay = 0 innodb_cmp_per_index_enabled = OFF innodb_disable_sort_file_cache = OFF innodb_numa_interleave = OFF innodb_strict_mode = ON innodb_sort_buffer_size = 1M innodb_fast_shutdown = 1 innodb_force_load_corrupted = OFF innodb_force_recovery = 0 innodb_temp_tablespaces_dir = ./#innodb_temp/ innodb_tmpdir = ./ innodb_temp_data_file_path = ibtmp1:64M:autoextend innodb_page_cleaners = 4 innodb_adaptive_hash_index = ON innodb_adaptive_hash_index_parts = 8 innodb_flush_log_at_timeout = 1 innodb_fsync_threshold = 0 innodb_fill_factor = 90 innodb_file_per_table = ON innodb_autoextend_increment = 64 innodb_open_files = 100000 innodb_buffer_pool_chunk_size = 128M innodb_buffer_pool_instances = 1 innodb_log_files_in_group = 8 innodb_log_file_size = 64M innodb_flush_neighbors = 0 innodb_io_capacity = 4000 innodb_io_capacity_max = 20000 innodb_autoinc_lock_mode = 2 innodb_change_buffer_max_size = 25 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 256M #### for performance_schema performance_schema =OFF performance_schema_consumer_global_instrumentation =ON performance_schema_consumer_thread_instrumentation =ON performance_schema_consumer_events_stages_current =ON performance_schema_consumer_events_stages_history =ON performance_schema_consumer_events_stages_history_long =OFF performance_schema_consumer_statements_digest =ON performance_schema_consumer_events_statements_current =ON performance_schema_consumer_events_statements_history =ON performance_schema_consumer_events_statements_history_long =OFF performance_schema_consumer_events_waits_current =ON performance_schema_consumer_events_waits_history =ON performance_schema_consumer_events_waits_history_long =OFF performance-schema-instrument ='memory/%=COUNTED' # -- ~ _ ~ ~ _ ~ ~ _ ~ -- # base on mysql-8.0.18 # Generated by https://www.sqlpy.com 21:47:11, October 14, 2019 # wechat: jianglegege # email: 1721900707@qq.com # -- ~ _ ~ --
2. Materialize the specification and process to every link of DBM agent instead of oral or document; for more details, please refer to GitHub DBM agent