# /usr/bin/perl 5.010001 # OptionParser:190 27677 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:199 27677 =item --ask-pass # OptionParser:218 27677 Option has no attributes # OptionParser:226 27677 Short help: Prompt for a password when connecting to MySQL # OptionParser:199 27677 =item --charset # OptionParser:226 27677 Short help: Default character set # OptionParser:199 27677 =item --config # OptionParser:226 27677 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:199 27677 =item --daemonize # OptionParser:218 27677 Option has no attributes # OptionParser:226 27677 Short help: Fork to the background and detach from the shell # OptionParser:199 27677 =item --defaults-file # OptionParser:226 27677 Short help: Only read mysql options from the given file # OptionParser:199 27677 =item --help # OptionParser:218 27677 Option has no attributes # OptionParser:226 27677 Short help: Show help and exit # OptionParser:199 27677 =item --host # OptionParser:226 27677 Short help: Connect to host # OptionParser:199 27677 =item --ignore-rules # OptionParser:226 27677 Short help: Ignore these rule IDs # OptionParser:199 27677 =item --password # OptionParser:226 27677 Short help: Password to use when connecting # OptionParser:199 27677 =item --pid # OptionParser:226 27677 Short help: Create the given PID file when daemonized # OptionParser:199 27677 =item --port # OptionParser:226 27677 Short help: Port number to use for connection # OptionParser:199 27677 =item --set-vars # OptionParser:226 27677 Short help: Set these MySQL variables # OptionParser:199 27677 =item --socket # OptionParser:226 27677 Short help: Socket file to use for connection # OptionParser:199 27677 =item --source-of-variables # OptionParser:226 27677 Short help: Read SHOW VARIABLES from this source # OptionParser:199 27677 =item --user # OptionParser:226 27677 Short help: User for login if not current user # OptionParser:199 27677 =item --verbose # OptionParser:226 27677 Short help: Increase verbosity of output # OptionParser:199 27677 =item --version # OptionParser:218 27677 Option has no attributes # OptionParser:226 27677 Short help: Show version and exit # OptionParser:265 27677 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL # OptionParser:303 27677 ask-pass type: undef # OptionParser:265 27677 Parsing opt spec: group => default spec => charset|A=s desc => Default character set # OptionParser:303 27677 charset type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => config=A desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:303 27677 config type: A # OptionParser:265 27677 Parsing opt spec: group => default spec => daemonize desc => Fork to the background and detach from the shell # OptionParser:303 27677 daemonize type: undef # OptionParser:265 27677 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read mysql options from the given file # OptionParser:303 27677 defaults-file type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => help desc => Show help and exit # OptionParser:303 27677 help type: undef # OptionParser:265 27677 Parsing opt spec: group => default spec => host|h=s desc => Connect to host # OptionParser:303 27677 host type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => ignore-rules=h desc => Ignore these rule IDs # OptionParser:303 27677 ignore-rules type: h # OptionParser:265 27677 Parsing opt spec: group => default spec => password|p=s desc => Password to use when connecting # OptionParser:303 27677 password type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => pid=s desc => Create the given PID file when daemonized # OptionParser:303 27677 pid type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => port|P=i desc => Port number to use for connection # OptionParser:303 27677 port type: i # OptionParser:265 27677 Parsing opt spec: group => default spec => set-vars=s desc => Set these MySQL variables (default wait_timeout=10000) # OptionParser:303 27677 set-vars type: s # OptionParser:310 27677 set-vars default: wait_timeout=10000 # OptionParser:265 27677 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection # OptionParser:303 27677 socket type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => source-of-variables=s desc => Read SHOW VARIABLES from this source (default mysql) # OptionParser:303 27677 source-of-variables type: s # OptionParser:310 27677 source-of-variables default: mysql # OptionParser:265 27677 Parsing opt spec: group => default spec => user|u=s desc => User for login if not current user # OptionParser:303 27677 user type: s # OptionParser:265 27677 Parsing opt spec: group => default spec => verbose|v+ desc => Increase verbosity of output (default 1) # OptionParser:303 27677 verbose type: undef # OptionParser:310 27677 verbose default: 1 # OptionParser:265 27677 Parsing opt spec: group => default spec => version desc => Show version and exit # OptionParser:303 27677 version type: undef # OptionParser:325 27677 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:381 27677 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:357 27677 Strict mode disabled by rule # OptionParser:109 27677 Parsing DSN OPTIONS # OptionParser:199 27677 =item * A # OptionParser:226 27677 Short help: Default character set # OptionParser:199 27677 =item * D # OptionParser:226 27677 Short help: Default database # OptionParser:199 27677 =item * F # OptionParser:226 27677 Short help: Only read default options from the given file # OptionParser:199 27677 =item * h # OptionParser:226 27677 Short help: Connect to host # OptionParser:199 27677 =item * p # OptionParser:226 27677 Short help: Password to use when connecting # OptionParser:199 27677 =item * P # OptionParser:226 27677 Short help: Port number to use for connection # OptionParser:199 27677 =item * S # OptionParser:226 27677 Short help: Socket file to use for connection # OptionParser:199 27677 =item * u # OptionParser:226 27677 Short help: User for login if not current user # DSNParser:1075 27677 DSN option: copy=1, dsn=charset, desc=Default character set, key=A # DSNParser:1075 27677 DSN option: copy=1, dsn=database, desc=Default database, key=D # DSNParser:1075 27677 DSN option: copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file, key=F # DSNParser:1075 27677 DSN option: copy=1, dsn=host, desc=Connect to host, key=h # DSNParser:1075 27677 DSN option: copy=1, dsn=password, desc=Password to use when connecting, key=p # DSNParser:1075 27677 DSN option: copy=1, dsn=port, desc=Port number to use for connection, key=P # DSNParser:1075 27677 DSN option: copy=1, dsn=mysql_socket, desc=Socket file to use for connection, key=S # DSNParser:1075 27677 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u # OptionParser:153 27677 pt-variable-advisor 2.1.1 # OptionParser:465 27677 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:465 27677 Cannot open /etc/percona-toolkit/pt-variable-advisor.conf: No such file or directory # # OptionParser:465 27677 Cannot open /root/.percona-toolkit.conf: No such file or directory # # OptionParser:465 27677 Cannot open /root/.pt-variable-advisor.conf: No such file or directory # # OptionParser:653 27677 Nothing to validate for option password type s value undef # OptionParser:653 27677 Nothing to validate for option pid type s value undef # OptionParser:653 27677 Nothing to validate for option user type s value undef # OptionParser:653 27677 Nothing to validate for option ignore-rules type h value undef # OptionParser:653 27677 Nothing to validate for option charset type s value undef # OptionParser:653 27677 Nothing to validate for option port type i value undef # OptionParser:653 27677 Nothing to validate for option set-vars type s value wait_timeout=10000 # OptionParser:653 27677 Nothing to validate for option defaults-file type s value undef # OptionParser:653 27677 Nothing to validate for option host type s value undef # OptionParser:653 27677 Nothing to validate for option socket type s value undef # OptionParser:653 27677 Nothing to validate for option source-of-variables type s value mysql # DSNParser:1091 27677 Setting set-vars property # OptionParser:727 27677 Getting description and usage from SYNOPSIS in /usr/bin/pt-variable-advisor # OptionParser:980 27677 Parsing SYNOPSIS in /usr/bin/pt-variable-advisor # OptionParser:993 27677 Raw SYNOPSIS text: Usage: pt-variable-advisor [OPTION...] [DSN] # # pt-variable-advisor analyzes variables and advises on possible problems. # # # OptionParser:731 27677 Description: pt-variable-advisor analyzes variables and advises on possible problems. # Usage: pt-variable-advisor [OPTION...] [DSN] # VariableAdvisorRules:2236 27677 66 rules # PodParser:1724 27677 Parsing POD in /usr/bin/pt-variable-advisor # PodParser:1736 27677 cmd: head1 name: NAME # PodParser:1753 27677 In section NAME # PodParser:1736 27677 cmd: head1 name: SYNOPSIS # PodParser:1753 27677 In section SYNOPSIS # PodParser:1736 27677 cmd: head1 name: RISKS # PodParser:1753 27677 In section RISKS # PodParser:1736 27677 cmd: head1 name: DESCRIPTION # PodParser:1753 27677 In section DESCRIPTION # PodParser:1736 27677 cmd: head1 name: RULES # PodParser:1753 27677 In section RULES # PodParser:1736 27677 cmd: over name: # PodParser:1736 27677 cmd: item name: auto_increment # PodParser:1766 27677 RULES item: auto_increment # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Are you trying to write to more than one ... # PodParser:1736 27677 cmd: item name: concurrent_insert # PodParser:1766 27677 RULES item: concurrent_insert # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Holes (spaces left by deletes) in MyISAM ... # PodParser:1736 27677 cmd: item name: connect_timeout # PodParser:1766 27677 RULES item: connect_timeout # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: A large value of this setting can create ... # PodParser:1736 27677 cmd: item name: debug # PodParser:1766 27677 RULES item: debug # PodParser:1799 27677 Item attributes: severity: crit # PodParser:1825 27677 Item desc: Servers built with debugging capability ... # PodParser:1736 27677 cmd: item name: delay_key_write # PodParser:1766 27677 RULES item: delay_key_write # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: MyISAM index blocks are never flushed un ... # PodParser:1736 27677 cmd: item name: flush # PodParser:1766 27677 RULES item: flush # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This option might decrease performance g ... # PodParser:1736 27677 cmd: item name: flush_time # PodParser:1766 27677 RULES item: flush_time # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This option might decrease performance g ... # PodParser:1736 27677 cmd: item name: have_bdb # PodParser:1766 27677 RULES item: have_bdb # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The BDB engine is deprecated. If you ar ... # PodParser:1736 27677 cmd: item name: init_connect # PodParser:1766 27677 RULES item: init_connect # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The init_connect option is enabled on th ... # PodParser:1736 27677 cmd: item name: init_file # PodParser:1766 27677 RULES item: init_file # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The init_file option is enabled on this ... # PodParser:1736 27677 cmd: item name: init_slave # PodParser:1766 27677 RULES item: init_slave # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The init_slave option is enabled on this ... # PodParser:1736 27677 cmd: item name: innodb_additional_mem_pool_size # PodParser:1766 27677 RULES item: innodb_additional_mem_pool_size # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This variable generally doesn't need to ... # PodParser:1736 27677 cmd: item name: innodb_buffer_pool_size # PodParser:1766 27677 RULES item: innodb_buffer_pool_size # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The InnoDB buffer pool size is unconfigu ... # PodParser:1736 27677 cmd: item name: innodb_checksums # PodParser:1766 27677 RULES item: innodb_checksums # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: InnoDB checksums are disabled. Your dat ... # PodParser:1736 27677 cmd: item name: innodb_doublewrite # PodParser:1766 27677 RULES item: innodb_doublewrite # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: InnoDB doublewrite is disabled. Unless ... # PodParser:1736 27677 cmd: item name: innodb_fast_shutdown # PodParser:1766 27677 RULES item: innodb_fast_shutdown # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: InnoDB's shutdown behavior is not the de ... # PodParser:1736 27677 cmd: item name: innodb_flush_log_at_trx_commit-1 # PodParser:1766 27677 RULES item: innodb_flush_log_at_trx_commit-1 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: InnoDB is not configured in strictly ACI ... # PodParser:1736 27677 cmd: item name: innodb_flush_log_at_trx_commit-2 # PodParser:1766 27677 RULES item: innodb_flush_log_at_trx_commit-2 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Setting innodb_flush_log_at_trx_commit t ... # PodParser:1736 27677 cmd: item name: innodb_force_recovery # PodParser:1766 27677 RULES item: innodb_force_recovery # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: InnoDB is in forced recovery mode! This ... # PodParser:1736 27677 cmd: item name: innodb_lock_wait_timeout # PodParser:1766 27677 RULES item: innodb_lock_wait_timeout # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This option has an unusually long value, ... # PodParser:1736 27677 cmd: item name: innodb_log_buffer_size # PodParser:1766 27677 RULES item: innodb_log_buffer_size # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The InnoDB log buffer size generally sho ... # PodParser:1736 27677 cmd: item name: innodb_log_file_size # PodParser:1766 27677 RULES item: innodb_log_file_size # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The InnoDB log file size is set to its d ... # PodParser:1736 27677 cmd: item name: innodb_max_dirty_pages_pct # PodParser:1766 27677 RULES item: innodb_max_dirty_pages_pct # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The innodb_max_dirty_pages_pct is lower ... # PodParser:1736 27677 cmd: item name: flush_time # PodParser:1766 27677 RULES item: flush_time # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This setting is likely to cause very bad ... # PodParser:1736 27677 cmd: item name: key_buffer_size # PodParser:1766 27677 RULES item: key_buffer_size # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The key buffer size is unconfigured. In ... # PodParser:1736 27677 cmd: item name: large_pages # PodParser:1766 27677 RULES item: large_pages # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Large pages are enabled. # PodParser:1736 27677 cmd: item name: locked_in_memory # PodParser:1766 27677 RULES item: locked_in_memory # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The server is locked in memory with --me ... # PodParser:1736 27677 cmd: item name: log_warnings-1 # PodParser:1766 27677 RULES item: log_warnings-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Log_warnings is disabled, so unusual eve ... # PodParser:1736 27677 cmd: item name: log_warnings-2 # PodParser:1766 27677 RULES item: log_warnings-2 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Log_warnings must be set greater than 1 ... # PodParser:1736 27677 cmd: item name: low_priority_updates # PodParser:1766 27677 RULES item: low_priority_updates # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The server is running with non-default l ... # PodParser:1736 27677 cmd: item name: max_binlog_size # PodParser:1766 27677 RULES item: max_binlog_size # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The max_binlog_size is smaller than the ... # PodParser:1736 27677 cmd: item name: max_connect_errors # PodParser:1766 27677 RULES item: max_connect_errors # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: max_connect_errors should probably be se ... # PodParser:1736 27677 cmd: item name: max_connections # PodParser:1766 27677 RULES item: max_connections # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: If the server ever really has more than ... # PodParser:1736 27677 cmd: item name: myisam_repair_threads # PodParser:1766 27677 RULES item: myisam_repair_threads # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: myisam_repair_threads > 1 enables multi- ... # PodParser:1736 27677 cmd: item name: old_passwords # PodParser:1766 27677 RULES item: old_passwords # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Old-style passwords are insecure. They ... # PodParser:1736 27677 cmd: item name: optimizer_prune_level # PodParser:1766 27677 RULES item: optimizer_prune_level # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The optimizer will use an exhaustive sea ... # PodParser:1736 27677 cmd: item name: port # PodParser:1766 27677 RULES item: port # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The server is listening on a non-default ... # PodParser:1736 27677 cmd: item name: query_cache_size-1 # PodParser:1766 27677 RULES item: query_cache_size-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The query cache does not scale to large ... # PodParser:1736 27677 cmd: item name: query_cache_size-2 # PodParser:1766 27677 RULES item: query_cache_size-2 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The query cache can cause severe perform ... # PodParser:1736 27677 cmd: item name: read_buffer_size-1 # PodParser:1766 27677 RULES item: read_buffer_size-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The read_buffer_size variable should gen ... # PodParser:1736 27677 cmd: item name: read_buffer_size-2 # PodParser:1766 27677 RULES item: read_buffer_size-2 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The read_buffer_size variable should not ... # PodParser:1736 27677 cmd: item name: read_rnd_buffer_size-1 # PodParser:1766 27677 RULES item: read_rnd_buffer_size-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The read_rnd_buffer_size variable should ... # PodParser:1736 27677 cmd: item name: read_rnd_buffer_size-2 # PodParser:1766 27677 RULES item: read_rnd_buffer_size-2 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: The read_rnd_buffer_size variable should ... # PodParser:1736 27677 cmd: item name: relay_log_space_limit # PodParser:1766 27677 RULES item: relay_log_space_limit # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Setting relay_log_space_limit can cause ... # PodParser:1736 27677 cmd: item name: slave_net_timeout # PodParser:1766 27677 RULES item: slave_net_timeout # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This variable is set too high. This is ... # PodParser:1736 27677 cmd: item name: slave_skip_errors # PodParser:1766 27677 RULES item: slave_skip_errors # PodParser:1799 27677 Item attributes: severity: crit # PodParser:1825 27677 Item desc: You should not set this option. If repl ... # PodParser:1736 27677 cmd: item name: sort_buffer_size-1 # PodParser:1766 27677 RULES item: sort_buffer_size-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The sort_buffer_size variable should gen ... # PodParser:1736 27677 cmd: item name: sort_buffer_size-2 # PodParser:1766 27677 RULES item: sort_buffer_size-2 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The sort_buffer_size variable should gen ... # PodParser:1736 27677 cmd: item name: sql_notes # PodParser:1766 27677 RULES item: sql_notes # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: This server is configured not to log Not ... # PodParser:1736 27677 cmd: item name: sync_frm # PodParser:1766 27677 RULES item: sync_frm # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: It is best to set sync_frm so that .frm ... # PodParser:1736 27677 cmd: item name: tx_isolation-1 # PodParser:1766 27677 RULES item: tx_isolation-1 # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: This server's transaction isolation leve ... # PodParser:1736 27677 cmd: item name: tx_isolation-2 # PodParser:1766 27677 RULES item: tx_isolation-2 # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Most applications should use the default ... # PodParser:1736 27677 cmd: item name: expire_log_days # PodParser:1766 27677 RULES item: expire_log_days # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Binary logs are enabled, but automatic p ... # PodParser:1736 27677 cmd: item name: innodb_file_io_threads # PodParser:1766 27677 RULES item: innodb_file_io_threads # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: This option is useless except on Windows ... # PodParser:1736 27677 cmd: item name: innodb_data_file_path # PodParser:1766 27677 RULES item: innodb_data_file_path # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Auto-extending InnoDB files can consume ... # PodParser:1736 27677 cmd: item name: innodb_flush_method # PodParser:1766 27677 RULES item: innodb_flush_method # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Most production database servers that us ... # PodParser:1736 27677 cmd: item name: innodb_locks_unsafe_for_binlog # PodParser:1766 27677 RULES item: innodb_locks_unsafe_for_binlog # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: This option makes point-in-time recovery ... # PodParser:1736 27677 cmd: item name: innodb_support_xa # PodParser:1766 27677 RULES item: innodb_support_xa # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: MySQL's internal XA transaction support ... # PodParser:1736 27677 cmd: item name: log_bin # PodParser:1766 27677 RULES item: log_bin # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Binary logging is disabled, so point-in- ... # PodParser:1736 27677 cmd: item name: log_output # PodParser:1766 27677 RULES item: log_output # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Directing log output to tables has a hig ... # PodParser:1736 27677 cmd: item name: max_relay_log_size # PodParser:1766 27677 RULES item: max_relay_log_size # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: A custom max_relay_log_size is defined. # PodParser:1736 27677 cmd: item name: myisam_recover_options # PodParser:1766 27677 RULES item: myisam_recover_options # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: myisam_recover_options should be set to ... # PodParser:1736 27677 cmd: item name: storage_engine # PodParser:1766 27677 RULES item: storage_engine # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The server is using a non-standard stora ... # PodParser:1736 27677 cmd: item name: sync_binlog # PodParser:1766 27677 RULES item: sync_binlog # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: Binary logging is enabled, but sync_binl ... # PodParser:1736 27677 cmd: item name: tmp_table_size # PodParser:1766 27677 RULES item: tmp_table_size # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: The effective minimum size of in-memory ... # PodParser:1736 27677 cmd: item name: old mysql version # PodParser:1766 27677 RULES item: old mysql version # PodParser:1799 27677 Item attributes: severity: warn # PodParser:1825 27677 Item desc: These are the recommended minimum versio ... # PodParser:1736 27677 cmd: item name: end-of-life mysql version # PodParser:1766 27677 RULES item: end-of-life mysql version # PodParser:1799 27677 Item attributes: severity: note # PodParser:1825 27677 Item desc: Every release older than 5.1 is now offi ... # PodParser:1736 27677 cmd: back name: # PodParser:1752 27677 End items in RULES # PodParser:1736 27677 cmd: head1 name: OPTIONS # PodParser:1753 27677 In section OPTIONS # PodParser:1825 27677 Item desc: This tool accepts additional command-lin ... # PodParser:1736 27677 cmd: over name: # PodParser:1736 27677 cmd: item name: --ask-pass # PodParser:1766 27677 OPTIONS item: ask-pass # PodParser:1825 27677 Item desc: Prompt for a password when connecting to ... # PodParser:1736 27677 cmd: item name: --charset # PodParser:1766 27677 OPTIONS item: charset # PodParser:1825 27677 Item desc: short form: -A; type: string # PodParser:1825 27677 Item desc: Default character set. If the value is ... # PodParser:1736 27677 cmd: item name: --config # PodParser:1766 27677 OPTIONS item: config # PodParser:1799 27677 Item attributes: type: Array # PodParser:1825 27677 Item desc: Read this comma-separated list of config ... # PodParser:1736 27677 cmd: item name: --daemonize # PodParser:1766 27677 OPTIONS item: daemonize # PodParser:1825 27677 Item desc: Fork to the background and detach from t ... # PodParser:1736 27677 cmd: item name: --defaults-file # PodParser:1766 27677 OPTIONS item: defaults-file # PodParser:1825 27677 Item desc: short form: -F; type: string # PodParser:1825 27677 Item desc: Only read mysql options from the given f ... # PodParser:1736 27677 cmd: item name: --help # PodParser:1766 27677 OPTIONS item: help # PodParser:1825 27677 Item desc: Show help and exit. # PodParser:1736 27677 cmd: item name: --host # PodParser:1766 27677 OPTIONS item: host # PodParser:1825 27677 Item desc: short form: -h; type: string # PodParser:1825 27677 Item desc: Connect to host. # PodParser:1736 27677 cmd: item name: --ignore-rules # PodParser:1766 27677 OPTIONS item: ignore-rules # PodParser:1799 27677 Item attributes: type: hash # PodParser:1825 27677 Item desc: Ignore these rule IDs. # PodParser:1825 27677 Item desc: Specify a comma-separated list of rule I ... # PodParser:1736 27677 cmd: item name: --password # PodParser:1766 27677 OPTIONS item: password # PodParser:1825 27677 Item desc: short form: -p; type: string # PodParser:1825 27677 Item desc: Password to use when connecting. # PodParser:1736 27677 cmd: item name: --pid # PodParser:1766 27677 OPTIONS item: pid # PodParser:1799 27677 Item attributes: type: string # PodParser:1825 27677 Item desc: Create the given PID file when daemonize ... # PodParser:1736 27677 cmd: item name: --port # PodParser:1766 27677 OPTIONS item: port # PodParser:1825 27677 Item desc: short form: -P; type: int # PodParser:1825 27677 Item desc: Port number to use for connection. # PodParser:1736 27677 cmd: item name: --set-vars # PodParser:1766 27677 OPTIONS item: set-vars # PodParser:1799 27677 Item attributes: type: string; default: wait_timeout=10000 # PodParser:1825 27677 Item desc: Set these MySQL variables. Immediately ... # PodParser:1736 27677 cmd: item name: --socket # PodParser:1766 27677 OPTIONS item: socket # PodParser:1825 27677 Item desc: short form: -S; type: string # PodParser:1825 27677 Item desc: Socket file to use for connection. # PodParser:1736 27677 cmd: item name: --source-of-variables # PodParser:1766 27677 OPTIONS item: source-of-variables # PodParser:1799 27677 Item attributes: type: string; default: mysql # PodParser:1825 27677 Item desc: Read C from this source. ... # PodParser:1736 27677 cmd: item name: --user # PodParser:1766 27677 OPTIONS item: user # PodParser:1825 27677 Item desc: short form: -u; type: string # PodParser:1825 27677 Item desc: User for login if not current user. # PodParser:1736 27677 cmd: item name: --verbose # PodParser:1766 27677 OPTIONS item: verbose # PodParser:1825 27677 Item desc: short form: -v; cumulative: yes; default ... # PodParser:1825 27677 Item desc: Increase verbosity of output. At the de ... # PodParser:1736 27677 cmd: item name: --version # PodParser:1766 27677 OPTIONS item: version # PodParser:1825 27677 Item desc: Show version and exit. # PodParser:1736 27677 cmd: back name: # PodParser:1752 27677 End items in OPTIONS # PodParser:1736 27677 cmd: head1 name: DSN OPTIONS # PodParser:1753 27677 In section DSN OPTIONS # PodParser:1825 27677 Item desc: These DSN options are used to create a D ... # PodParser:1736 27677 cmd: over name: # PodParser:1736 27677 cmd: item name: * A # PodParser:1766 27677 DSN OPTIONS item: A # PodParser:1799 27677 Item attributes: dsn: charset; copy: yes # PodParser:1825 27677 Item desc: Default character set. # PodParser:1736 27677 cmd: item name: * D # PodParser:1766 27677 DSN OPTIONS item: D # PodParser:1799 27677 Item attributes: dsn: database; copy: yes # PodParser:1825 27677 Item desc: Default database. # PodParser:1736 27677 cmd: item name: * F # PodParser:1766 27677 DSN OPTIONS item: F # PodParser:1799 27677 Item attributes: dsn: mysql_read_default_file; copy: yes # PodParser:1825 27677 Item desc: Only read default options from the given ... # PodParser:1736 27677 cmd: item name: * h # PodParser:1766 27677 DSN OPTIONS item: h # PodParser:1799 27677 Item attributes: dsn: host; copy: yes # PodParser:1825 27677 Item desc: Connect to host. # PodParser:1736 27677 cmd: item name: * p # PodParser:1766 27677 DSN OPTIONS item: p # PodParser:1799 27677 Item attributes: dsn: password; copy: yes # PodParser:1825 27677 Item desc: Password to use when connecting. # PodParser:1736 27677 cmd: item name: * P # PodParser:1766 27677 DSN OPTIONS item: P # PodParser:1799 27677 Item attributes: dsn: port; copy: yes # PodParser:1825 27677 Item desc: Port number to use for connection. # PodParser:1736 27677 cmd: item name: * S # PodParser:1766 27677 DSN OPTIONS item: S # PodParser:1799 27677 Item attributes: dsn: mysql_socket; copy: yes # PodParser:1825 27677 Item desc: Socket file to use for connection. # PodParser:1736 27677 cmd: item name: * u # PodParser:1766 27677 DSN OPTIONS item: u # PodParser:1799 27677 Item attributes: dsn: user; copy: yes # PodParser:1825 27677 Item desc: User for login if not current user. # PodParser:1736 27677 cmd: back name: # PodParser:1752 27677 End items in DSN OPTIONS # PodParser:1736 27677 cmd: head1 name: ENVIRONMENT # PodParser:1753 27677 In section ENVIRONMENT # PodParser:1736 27677 cmd: head1 name: SYSTEM REQUIREMENTS # PodParser:1753 27677 In section SYSTEM REQUIREMENTS # PodParser:1736 27677 cmd: head1 name: BUGS # PodParser:1753 27677 In section BUGS # PodParser:1736 27677 cmd: over name: # PodParser:1736 27677 cmd: item name: * Complete command-line used to run the tool # PodParser:1736 27677 cmd: item name: * Tool L<"--version"> # PodParser:1736 27677 cmd: item name: * MySQL version of all servers involved # PodParser:1736 27677 cmd: item name: * Output from the tool including STDERR # PodParser:1736 27677 cmd: item name: * Input files (log/dump/config files, etc.) # PodParser:1736 27677 cmd: back name: # PodParser:1736 27677 cmd: head1 name: DOWNLOADING # PodParser:1753 27677 In section DOWNLOADING # PodParser:1736 27677 cmd: head1 name: AUTHORS # PodParser:1753 27677 In section AUTHORS # PodParser:1736 27677 cmd: head1 name: ABOUT PERCONA TOOLKIT # PodParser:1753 27677 In section ABOUT PERCONA TOOLKIT # PodParser:1736 27677 cmd: head1 name: COPYRIGHT, LICENSE, AND WARRANTY # PodParser:1753 27677 In section COPYRIGHT, LICENSE, AND WARRANTY # PodParser:1736 27677 cmd: head1 name: VERSION # PodParser:1753 27677 In section VERSION # Advisor:2037 27677 Loading rules from VariableAdvisorRules # Advisor:2060 27677 Loading rule info from VariableAdvisorRules # DSNParser:1162 27677 DSN string made from options: # DSNParser:1100 27677 No DSN to parse # DSNParser:1103 27677 Parsing localhost # DSNParser:1115 27677 Interpreting localhost as h= localhost # DSNParser:1121 27677 Finding value for S # DSNParser:1131 27677 Copying value for S from defaults # DSNParser:1121 27677 Finding value for F # DSNParser:1131 27677 Copying value for F from defaults # DSNParser:1121 27677 Finding value for A # DSNParser:1131 27677 Copying value for A from defaults # DSNParser:1121 27677 Finding value for P # DSNParser:1131 27677 Copying value for P from defaults # DSNParser:1121 27677 Finding value for p # DSNParser:1131 27677 Copying value for p from defaults # DSNParser:1121 27677 Finding value for u # DSNParser:1131 27677 Copying value for u from defaults # DSNParser:1121 27677 Finding value for h # DSNParser:1121 27677 Finding value for D # DSNParser:1131 27677 Copying value for D from defaults # DSNParser:1212 27677 DBI:mysql:;host=localhost;mysql_read_default_group=client # DSNParser:1258 27677 DBI:mysql:;host=localhost;mysql_read_default_group=client undef undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0 # DSNParser:1267 27677 DBI::db=HASH(0x1892078) SELECT @@SQL_MODE # DSNParser:1274 27677 DBI::db=HASH(0x1892078) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/ # DSNParser:1293 27677 DBI::db=HASH(0x1892078) : SET wait_timeout=10000 # DSNParser:1319 27677 DBH info: DBI::db=HASH(0x1892078) $VAR1 = {'@@hostname' => 'lilith','VERSION()' => '5.5.24-55','DATABASE()' => undef,'CONNECTION_ID()' => '67'}; Connection info: Localhost via UNIX socket Character set info: $VAR1 = [{Value => 'latin1',Variable_name => 'character_set_client'},{Value => 'latin1',Variable_name => 'character_set_connection'},{Value => 'latin1',Variable_name => 'character_set_database'},{Value => 'binary',Variable_name => 'character_set_filesystem'},{Value => 'latin1',Variable_name => 'character_set_results'},{Value => 'latin1',Variable_name => 'character_set_server'},{Value => 'utf8',Variable_name => 'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.016 $DBI::VERSION: 1.611 # pt_variable_advisor:2912 27677 Connected dbh DBI::db=HASH(0x1892078) # pt_variable_advisor:2994 27677 Getting variables from dbh DBI::db=HASH(0x1892078) # pt_variable_advisor:2996 27677 DBI::db=HASH(0x1892078) SHOW /*40003 GLOBAL*/ VARIABLES # VersionParser:1416 27677 5.5.24-55 parses to 005005024 # VersionParser:1445 27677 InnoDB support: DEFAULT # VersionParser:1457 27677 InnoDB version: 1.1.8-rel26.0 # pt_variable_advisor:2941 27677 MySQL version 005005024 InnoDB version 1.1.8-rel26.0 Code for rule concurrent_insert caused an error: Argument "AUTO" isn't numeric in numeric gt (>) at /usr/bin/pt-variable-advisor line 2770. # Advisor:2095 27677 Matches rule delay_key_write # Advisor:2095 27677 Matches rule innodb_log_file_size # Advisor:2095 27677 Matches rule innodb_max_dirty_pages_pct # Advisor:2095 27677 Matches rule log_warnings-2 # Advisor:2095 27677 Matches rule slave_net_timeout # Advisor:2095 27677 Matches rule sort_buffer_size-1 # Advisor:2095 27677 Matches rule innodb_data_file_path # Advisor:2095 27677 Matches rule innodb_flush_method # Advisor:2095 27677 Matches rule log_bin # Advisor:2095 27677 Matches rule sync_binlog # Linux lilith 2.6.35-32-generic #67-Ubuntu SMP Mon Mar 5 19:39:49 UTC 2012 x86_64 GNU/Linux # Arguments: _[localhost]_ # WARN delay_key_write: MyISAM index blocks are never flushed until necessary. # WARN innodb_log_file_size: The InnoDB log file size is set to its default value, which is not usable on production systems. # NOTE innodb_max_dirty_pages_pct: The innodb_max_dirty_pages_pct is lower than the default. # NOTE log_warnings-2: Log_warnings must be set greater than 1 to log unusual events such as aborted connections. # WARN slave_net_timeout: This variable is set too high. # 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 innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later. # NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance. # WARN log_bin: Binary logging is disabled, so point-in-time recovery and replication are not possible. # WARN sync_binlog: Binary logging is enabled, but sync_binlog isn't configured so that every transaction is flushed to the binary log for durability.