pt-variable-advisor
官方文档：https://www.percona.com/doc/percona-toolkit/3.0/pt-variable-advisor.html
获得库的配置文件建议
pt-variable-advisor u=yq,P=3306,h=192.168.66.101,p=123456
# WARN delay_key_write: MyISAM index blocks are never flushed until necessary.
# WARN key_buffer_size: The key buffer size is set to its default value, which is not good for most production systems.
# NOTE read_buffer_size-1: The read_buffer_size variable should generally be left at its default unless an expert determines it is necessary to change it.
# WARN read_buffer_size-2: The read_buffer_size variable should not be larger than 8MB.
# NOTE read_rnd_buffer_size-1: The read_rnd_buffer_size variable should generally be left at its default unless an expert determines it is necessary to change it.
# WARN read_rnd_buffer_size-2: The read_rnd_buffer_size variable should not be larger than 4M.
# CRIT slave_skip_errors: You should not set this option.
# NOTE sort_buffer_size-1: The sort_buffer_size variable should generally be left at its default unless an expert determines it is necessary to change it.
# NOTE sort_buffer_size-2: The sort_buffer_size variable should generally be left at its default unless an expert determines it is necessary to change it.
# NOTE tx_isolation-1: This server's transaction isolation level is non-default.
# NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later.
# WARN myisam_recover_options: myisam_recover_options should be set to some value such as BACKUP,FORCE to ensure that table corruption is noticed.
# NOTE tmp_table_size: The effective minimum size of in-memory implicit temporary tables used internally during query execution is min(tmp_table_size, max_heap_table_size), so max_heap_table_size should be at least as large as tmp_table_size.
