# /usr/bin/perl 5.018002 # Linux Slave6vm 3.16.0-30-generic #40~14.04.1-Ubuntu SMP Thu Jan 15 17:43:14 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux # Arguments: _[--recursion-method=dsn=h=10.0.10.110,D=percona,t=dsns]_ _[--nocheck-replication-filters]_ _[--check-interval=2]_ _[--max-lag=60]_ _[--critical-load]_ _[Threads_running=30]_ _[--alter]_ _[ADD GyroStupMin float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values', ADD GyroStupMax float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values';]_ _[h=10.0.10.110,D=ATDB,t=AccelGyroTestSpec,u=perconatool,p=snakeskin]_ _[--dry-run]_ # OptionParser:290 11720 Option rule: --dry-run and --execute are mutually exclusive. # OptionParser:290 11720 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:299 11720 =item --alter # OptionParser:326 11720 Short help: The schema modification, without the ALTER TABLE keywords # OptionParser:299 11720 =item --alter-foreign-keys-method # OptionParser:326 11720 Short help: How to modify foreign keys so they reference the new table # OptionParser:299 11720 =item --ask-pass # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Prompt for a password when connecting to MySQL # OptionParser:299 11720 =item --charset # OptionParser:326 11720 Short help: Default character set # OptionParser:299 11720 =item --[no]check-alter # OptionParser:326 11720 Short help: Parses the --alter specified and tries to warn of possible unintended behavior # OptionParser:299 11720 =item --check-interval # OptionParser:326 11720 Short help: Sleep time between checks for --max-lag # OptionParser:299 11720 =item --[no]check-plan # OptionParser:326 11720 Short help: Check query execution plans for safety # OptionParser:299 11720 =item --[no]check-replication-filters # OptionParser:326 11720 Short help: Abort if any replication filter is set on any server # OptionParser:299 11720 =item --check-slave-lag # OptionParser:326 11720 Short help: Pause the data copy until this replica's lag is less than --max-lag # OptionParser:299 11720 =item --chunk-index # OptionParser:326 11720 Short help: Prefer this index for chunking tables # OptionParser:299 11720 =item --chunk-index-columns # OptionParser:326 11720 Short help: Use only this many left-most columns of a --chunk-index # OptionParser:299 11720 =item --chunk-size # OptionParser:326 11720 Short help: Number of rows to select for each chunk copied # OptionParser:299 11720 =item --chunk-size-limit # OptionParser:326 11720 Short help: Do not copy chunks this much larger than the desired chunk size # OptionParser:299 11720 =item --chunk-time # OptionParser:326 11720 Short help: Adjust the chunk size dynamically so each data-copy query takes this long to execute # OptionParser:299 11720 =item --config # OptionParser:326 11720 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line # OptionParser:299 11720 =item --critical-load # OptionParser:326 11720 Short help: Examine SHOW GLOBAL STATUS after every chunk, and abort if the load is too high # OptionParser:299 11720 =item --database # OptionParser:326 11720 Short help: Connect to this database # OptionParser:299 11720 =item --default-engine # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Remove ENGINE from the new table # OptionParser:299 11720 =item --defaults-file # OptionParser:326 11720 Short help: Only read mysql options from the given file # OptionParser:299 11720 =item --[no]drop-new-table # OptionParser:326 11720 Short help: Drop the new table if copying the original table fails # OptionParser:299 11720 =item --[no]drop-old-table # OptionParser:326 11720 Short help: Drop the original table after renaming it # OptionParser:299 11720 =item --[no]drop-triggers # OptionParser:326 11720 Short help: Drop triggers on the old table. --no-drop-triggers forces --no-drop-old-table # OptionParser:299 11720 =item --dry-run # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Create and alter the new table, but do not create triggers, copy data, or replace the original table # OptionParser:299 11720 =item --execute # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Indicate that you have read the documentation and want to alter the table # OptionParser:299 11720 =item --force # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: This options bypasses confirmation in case of using alter-foreign-keys-method = none , which might break foreign key constraints # OptionParser:299 11720 =item --help # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Show help and exit # OptionParser:299 11720 =item --host # OptionParser:326 11720 Short help: Connect to host # OptionParser:299 11720 =item --max-lag # OptionParser:326 11720 Short help: Pause the data copy until all replicas' lag is less than this value # OptionParser:299 11720 =item --max-load # OptionParser:326 11720 Short help: Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than their thresholds # OptionParser:299 11720 =item --new-table-name # OptionParser:326 11720 Short help: New table name before it is swapped. %T is replaced with the original table name # OptionParser:299 11720 =item --password # OptionParser:326 11720 Short help: Password to use when connecting # OptionParser:299 11720 =item --pid # OptionParser:326 11720 Short help: Create the given PID file # OptionParser:299 11720 =item --plugin # OptionParser:326 11720 Short help: Perl module file that defines a pt_online_schema_change_plugin class # OptionParser:299 11720 =item --port # OptionParser:326 11720 Short help: Port number to use for connection # OptionParser:299 11720 =item --print # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Print SQL statements to STDOUT # OptionParser:299 11720 =item --progress # OptionParser:326 11720 Short help: Print progress reports to STDERR while copying rows # OptionParser:299 11720 =item --quiet # OptionParser:326 11720 Short help: Do not print messages to STDOUT (disables --progress) # OptionParser:299 11720 =item --recurse # OptionParser:326 11720 Short help: Number of levels to recurse in the hierarchy when discovering replicas # OptionParser:299 11720 =item --recursion-method # OptionParser:326 11720 Short help: Preferred recursion method for discovering replicas # OptionParser:299 11720 =item --set-vars # OptionParser:326 11720 Short help: Set the MySQL variables in this comma-separated list of variable=value pairs # OptionParser:299 11720 =item --socket # OptionParser:326 11720 Short help: Socket file to use for connection # OptionParser:299 11720 =item --statistics # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Print statistics about internal counters # OptionParser:299 11720 =item --[no]swap-tables # OptionParser:326 11720 Short help: Swap the original table and the new, altered table # OptionParser:299 11720 =item --tries # OptionParser:326 11720 Short help: How many times to try critical operations # OptionParser:299 11720 =item --user # OptionParser:326 11720 Short help: User for login if not current user # OptionParser:299 11720 =item --version # OptionParser:318 11720 Option has no attributes # OptionParser:326 11720 Short help: Show version and exit # OptionParser:299 11720 =item --[no]version-check # OptionParser:326 11720 Short help: Check for the latest version of Percona Toolkit, MySQL, and other programs # OptionParser:365 11720 Parsing opt spec: spec => alter=s desc => The schema modification, without the ALTER TABLE keywords group => default # OptionParser:403 11720 alter type: s # OptionParser:365 11720 Parsing opt spec: spec => alter-foreign-keys-method=s desc => How to modify foreign keys so they reference the new table group => default # OptionParser:403 11720 alter-foreign-keys-method type: s # OptionParser:365 11720 Parsing opt spec: desc => Prompt for a password when connecting to MySQL spec => ask-pass group => default # OptionParser:403 11720 ask-pass type: undef # OptionParser:365 11720 Parsing opt spec: group => default spec => charset|A=s desc => Default character set # OptionParser:403 11720 charset type: s # OptionParser:365 11720 Parsing opt spec: group => default spec => check-alter! desc => Parses the --alter specified and tries to warn of possible unintended behavior (default yes) # OptionParser:403 11720 check-alter type: undef # OptionParser:410 11720 check-alter default: yes # OptionParser:365 11720 Parsing opt spec: spec => check-interval=m desc => Sleep time between checks for --max-lag (default 1) group => default # OptionParser:403 11720 check-interval type: m # OptionParser:410 11720 check-interval default: 1 # OptionParser:365 11720 Parsing opt spec: desc => Check query execution plans for safety (default yes) spec => check-plan! group => default # OptionParser:403 11720 check-plan type: undef # OptionParser:410 11720 check-plan default: yes # OptionParser:365 11720 Parsing opt spec: group => default spec => check-replication-filters! desc => Abort if any replication filter is set on any server (default yes) # OptionParser:403 11720 check-replication-filters type: undef # OptionParser:410 11720 check-replication-filters default: yes # OptionParser:365 11720 Parsing opt spec: group => default desc => Pause the data copy until this replica's lag is less than --max-lag spec => check-slave-lag=s # OptionParser:403 11720 check-slave-lag type: s # OptionParser:365 11720 Parsing opt spec: group => default spec => chunk-index=s desc => Prefer this index for chunking tables # OptionParser:403 11720 chunk-index type: s # OptionParser:365 11720 Parsing opt spec: group => default desc => Use only this many left-most columns of a --chunk-index spec => chunk-index-columns=i # OptionParser:403 11720 chunk-index-columns type: i # OptionParser:365 11720 Parsing opt spec: group => default desc => Number of rows to select for each chunk copied (default 1000) spec => chunk-size=z # OptionParser:403 11720 chunk-size type: z # OptionParser:410 11720 chunk-size default: 1000 # OptionParser:365 11720 Parsing opt spec: group => default spec => chunk-size-limit=f desc => Do not copy chunks this much larger than the desired chunk size (default 4.0) # OptionParser:403 11720 chunk-size-limit type: f # OptionParser:410 11720 chunk-size-limit default: 4.0 # OptionParser:365 11720 Parsing opt spec: group => default desc => Adjust the chunk size dynamically so each data-copy query takes this long to execute (default 0.5) spec => chunk-time=f # OptionParser:403 11720 chunk-time type: f # OptionParser:410 11720 chunk-time default: 0.5 # OptionParser:365 11720 Parsing opt spec: desc => Read this comma-separated list of config files; if specified, this must be the first option on the command line spec => config=A group => default # OptionParser:403 11720 config type: A # OptionParser:365 11720 Parsing opt spec: spec => critical-load=A desc => Examine SHOW GLOBAL STATUS after every chunk, and abort if the load is too high (default Threads_running=50) group => default # OptionParser:403 11720 critical-load type: A # OptionParser:410 11720 critical-load default: Threads_running=50 # OptionParser:365 11720 Parsing opt spec: desc => Connect to this database spec => database|D=s group => default # OptionParser:403 11720 database type: s # OptionParser:365 11720 Parsing opt spec: spec => default-engine desc => Remove ENGINE from the new table group => default # OptionParser:403 11720 default-engine type: undef # OptionParser:365 11720 Parsing opt spec: spec => defaults-file|F=s desc => Only read mysql options from the given file group => default # OptionParser:403 11720 defaults-file type: s # OptionParser:365 11720 Parsing opt spec: desc => Drop the new table if copying the original table fails (default yes) spec => drop-new-table! group => default # OptionParser:403 11720 drop-new-table type: undef # OptionParser:410 11720 drop-new-table default: yes # OptionParser:365 11720 Parsing opt spec: spec => drop-old-table! desc => Drop the original table after renaming it (default yes) group => default # OptionParser:403 11720 drop-old-table type: undef # OptionParser:410 11720 drop-old-table default: yes # OptionParser:365 11720 Parsing opt spec: desc => Drop triggers on the old table. --no-drop-triggers forces --no-drop-old-table (default yes) spec => drop-triggers! group => default # OptionParser:403 11720 drop-triggers type: undef # OptionParser:410 11720 drop-triggers default: yes # OptionParser:365 11720 Parsing opt spec: desc => Create and alter the new table, but do not create triggers, copy data, or replace the original table spec => dry-run group => default # OptionParser:403 11720 dry-run type: undef # OptionParser:365 11720 Parsing opt spec: desc => Indicate that you have read the documentation and want to alter the table spec => execute group => default # OptionParser:403 11720 execute type: undef # OptionParser:365 11720 Parsing opt spec: spec => force desc => This options bypasses confirmation in case of using alter-foreign-keys-method = none , which might break foreign key constraints group => default # OptionParser:403 11720 force type: undef # OptionParser:365 11720 Parsing opt spec: desc => Show help and exit spec => help group => default # OptionParser:403 11720 help type: undef # OptionParser:365 11720 Parsing opt spec: desc => Connect to host spec => host|h=s group => default # OptionParser:403 11720 host type: s # OptionParser:365 11720 Parsing opt spec: group => default desc => Pause the data copy until all replicas' lag is less than this value (default 1s) spec => max-lag=m # OptionParser:403 11720 max-lag type: m # OptionParser:410 11720 max-lag default: 1s # OptionParser:365 11720 Parsing opt spec: group => default desc => Examine SHOW GLOBAL STATUS after every chunk, and pause if any status variables are higher than their thresholds (default Threads_running=25) spec => max-load=A # OptionParser:403 11720 max-load type: A # OptionParser:410 11720 max-load default: Threads_running=25 # OptionParser:365 11720 Parsing opt spec: group => default desc => New table name before it is swapped. %T is replaced with the original table name (default %T_new) spec => new-table-name=s # OptionParser:403 11720 new-table-name type: s # OptionParser:410 11720 new-table-name default: %T_new # OptionParser:365 11720 Parsing opt spec: spec => password|p=s desc => Password to use when connecting group => default # OptionParser:403 11720 password type: s # OptionParser:365 11720 Parsing opt spec: spec => pid=s desc => Create the given PID file group => default # OptionParser:403 11720 pid type: s # OptionParser:365 11720 Parsing opt spec: desc => Perl module file that defines a pt_online_schema_change_plugin class spec => plugin=s group => default # OptionParser:403 11720 plugin type: s # OptionParser:365 11720 Parsing opt spec: spec => port|P=i desc => Port number to use for connection group => default # OptionParser:403 11720 port type: i # OptionParser:365 11720 Parsing opt spec: spec => print desc => Print SQL statements to STDOUT group => default # OptionParser:403 11720 print type: undef # OptionParser:365 11720 Parsing opt spec: group => default desc => Print progress reports to STDERR while copying rows (default time,30) spec => progress=a # OptionParser:403 11720 progress type: a # OptionParser:410 11720 progress default: time,30 # OptionParser:365 11720 Parsing opt spec: group => default spec => quiet|q desc => Do not print messages to STDOUT (disables --progress) # OptionParser:403 11720 quiet type: undef # OptionParser:419 11720 Deferring check of disables rule for HASH(0x320e188) disables --progress) # OptionParser:365 11720 Parsing opt spec: group => default spec => recurse=i desc => Number of levels to recurse in the hierarchy when discovering replicas # OptionParser:403 11720 recurse type: i # OptionParser:365 11720 Parsing opt spec: desc => Preferred recursion method for discovering replicas (default processlist,hosts) spec => recursion-method=a group => default # OptionParser:403 11720 recursion-method type: a # OptionParser:410 11720 recursion-method default: processlist,hosts # OptionParser:365 11720 Parsing opt spec: spec => set-vars=A desc => Set the MySQL variables in this comma-separated list of variable=value pairs group => default # OptionParser:403 11720 set-vars type: A # OptionParser:365 11720 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection # OptionParser:403 11720 socket type: s # OptionParser:365 11720 Parsing opt spec: group => default spec => statistics desc => Print statistics about internal counters # OptionParser:403 11720 statistics type: undef # OptionParser:365 11720 Parsing opt spec: spec => swap-tables! desc => Swap the original table and the new, altered table (default yes) group => default # OptionParser:403 11720 swap-tables type: undef # OptionParser:410 11720 swap-tables default: yes # OptionParser:365 11720 Parsing opt spec: desc => How many times to try critical operations spec => tries=a group => default # OptionParser:403 11720 tries type: a # OptionParser:365 11720 Parsing opt spec: desc => User for login if not current user spec => user|u=s group => default # OptionParser:403 11720 user type: s # OptionParser:365 11720 Parsing opt spec: group => default desc => Show version and exit spec => version # OptionParser:403 11720 version type: undef # OptionParser:365 11720 Parsing opt spec: spec => version-check! desc => Check for the latest version of Percona Toolkit, MySQL, and other programs (default yes) group => default # OptionParser:403 11720 version-check type: undef # OptionParser:410 11720 version-check default: yes # OptionParser:425 11720 Parsing rule: --dry-run and --execute are mutually exclusive. # OptionParser:481 11720 Participants for --dry-run and --execute are mutually exclusive. : dry-run execute # OptionParser:433 11720 dry-run execute are mutually exclusive # OptionParser:425 11720 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. # OptionParser:481 11720 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. : # OptionParser:457 11720 Strict mode disabled by rule # OptionParser:481 11720 Participants for disables --progress) : progress # OptionParser:467 11720 Option quiet disables progress # OptionParser:209 11720 Parsing DSN OPTIONS # OptionParser:299 11720 =item * A # OptionParser:326 11720 Short help: Default character set # OptionParser:299 11720 =item * D # OptionParser:326 11720 Short help: Database for the old and new table # OptionParser:299 11720 =item * F # OptionParser:326 11720 Short help: Only read default options from the given file # OptionParser:299 11720 =item * h # OptionParser:326 11720 Short help: Connect to host # OptionParser:299 11720 =item * p # OptionParser:326 11720 Short help: Password to use when connecting # OptionParser:299 11720 =item * P # OptionParser:326 11720 Short help: Port number to use for connection # OptionParser:299 11720 =item * S # OptionParser:326 11720 Short help: Socket file to use for connection # OptionParser:299 11720 =item * t # OptionParser:326 11720 Short help: Table to alter # OptionParser:299 11720 =item * u # OptionParser:326 11720 Short help: User for login if not current user # DSNParser:2070 11720 DSN option: desc=Default character set, key=A, dsn=charset, copy=1 # DSNParser:2070 11720 DSN option: desc=Database for the old and new table, dsn=database, copy=1, key=D # DSNParser:2070 11720 DSN option: desc=Only read default options from the given file, copy=1, dsn=mysql_read_default_file, key=F # DSNParser:2070 11720 DSN option: desc=Connect to host, dsn=host, copy=1, key=h # DSNParser:2070 11720 DSN option: desc=Password to use when connecting, key=p, dsn=password, copy=1 # DSNParser:2070 11720 DSN option: desc=Port number to use for connection, copy=1, dsn=port, key=P # DSNParser:2070 11720 DSN option: desc=Socket file to use for connection, key=S, copy=1, dsn=mysql_socket # DSNParser:2070 11720 DSN option: desc=Table to alter, copy=, dsn=table, key=t # DSNParser:2070 11720 DSN option: dsn=user, copy=1, key=u, desc=User for login if not current user # OptionParser:253 11720 pt-online-schema-change 2.2.14 # OptionParser:575 11720 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory # # OptionParser:575 11720 Cannot open /etc/percona-toolkit/pt-online-schema-change.conf: No such file or directory # # OptionParser:575 11720 Cannot open /root/.percona-toolkit.conf: No such file or directory # # OptionParser:575 11720 Cannot open /root/.pt-online-schema-change.conf: No such file or directory # # OptionParser:543 11720 Got option recursion-method = dsn=h=10.0.10.110,D=percona,t=dsns # OptionParser:543 11720 Got option check-replication-filters = 0 # OptionParser:543 11720 Got option check-interval = 2 # OptionParser:543 11720 Got option max-lag = 60 # OptionParser:543 11720 Got option critical-load = Threads_running=30 # OptionParser:543 11720 Got option alter = ADD GyroStupMin float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values', ADD GyroStupMax float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values'; # OptionParser:543 11720 Got option dry-run = 1 # OptionParser:763 11720 Nothing to validate for option host type s value undef # OptionParser:763 11720 Nothing to validate for option database type s value undef # OptionParser:763 11720 Nothing to validate for option chunk-index-columns type i value undef # OptionParser:763 11720 Nothing to validate for option recurse type i value undef # OptionParser:763 11720 Nothing to validate for option defaults-file type s value undef # OptionParser:763 11720 Nothing to validate for option alter type s value ADD GyroStupMin float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values', ADD GyroStupMax float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values'; # OptionParser:763 11720 Nothing to validate for option chunk-index type s value undef # OptionParser:763 11720 Nothing to validate for option socket type s value undef # OptionParser:763 11720 Nothing to validate for option pid type s value undef # OptionParser:763 11720 Nothing to validate for option chunk-size-limit type f value 4.0 # OptionParser:763 11720 Nothing to validate for option alter-foreign-keys-method type s value undef # OptionParser:763 11720 Nothing to validate for option plugin type s value undef # OptionParser:763 11720 Nothing to validate for option charset type s value undef # OptionParser:714 11720 Parsing option check-interval as a time value # OptionParser:719 11720 No suffix given; using s for check-interval (value: 2 ) # OptionParser:728 11720 Setting option check-interval to 2 # OptionParser:753 11720 Parsing option chunk-size as a size value # OptionParser:763 11720 Nothing to validate for option tries type a value undef # OptionParser:763 11720 Nothing to validate for option chunk-time type f value 0.5 # OptionParser:763 11720 Nothing to validate for option new-table-name type s value %T_new # OptionParser:763 11720 Nothing to validate for option port type i value undef # OptionParser:763 11720 Nothing to validate for option password type s value undef # OptionParser:763 11720 Nothing to validate for option check-slave-lag type s value undef # OptionParser:714 11720 Parsing option max-lag as a time value # OptionParser:719 11720 No suffix given; using s for max-lag (value: 60 ) # OptionParser:728 11720 Setting option max-lag to 60 # OptionParser:763 11720 Nothing to validate for option user type s value undef # OptionParser:1157 11720 --set-vars: $VAR1 = { # innodb_lock_wait_timeout => { # default => 1, # val => '1' # }, # lock_wait_timeout => { # default => 1, # val => '60' # }, # wait_timeout => { # default => 1, # val => '10000' # } # }; # # DSNParser:2086 11720 Setting set-vars property # DSNParser:2158 11720 DSN string made from options: # DSNParser:2095 11720 No DSN to parse # DSNParser:2098 11720 Parsing h=10.0.10.110,D=ATDB,t=AccelGyroTestSpec,u=perconatool,p=snakeskin # DSNParser:2117 11720 Finding value for t # DSNParser:2117 11720 Finding value for F # DSNParser:2127 11720 Copying value for F from defaults # DSNParser:2117 11720 Finding value for P # DSNParser:2127 11720 Copying value for P from defaults # DSNParser:2117 11720 Finding value for p # DSNParser:2117 11720 Finding value for u # DSNParser:2117 11720 Finding value for S # DSNParser:2127 11720 Copying value for S from defaults # DSNParser:2117 11720 Finding value for h # DSNParser:2117 11720 Finding value for A # DSNParser:2127 11720 Copying value for A from defaults # DSNParser:2117 11720 Finding value for D # pt_online_schema_change:9601 11720 --tries: $VAR1 = { # copy_rows => { # tries => 10, # wait => '0.25' # }, # create_triggers => { # tries => 10, # wait => 1 # }, # drop_triggers => { # tries => 10, # wait => 1 # }, # swap_tables => { # tries => 10, # wait => 1 # }, # update_foreign_keys => { # tries => 10, # wait => 1 # } # }; # # OptionParser:837 11720 Getting description and usage from SYNOPSIS in /usr/local/bin/pt-online-schema-change # OptionParser:1090 11720 Parsing SYNOPSIS in /usr/local/bin/pt-online-schema-change # OptionParser:1103 11720 Raw SYNOPSIS text: Usage: pt-online-schema-change [OPTIONS] DSN # # pt-online-schema-change alters a table's structure without blocking reads or # writes. Specify the database and table in the DSN. Do not use this tool before # reading its documentation and checking your backups carefully. # # # OptionParser:841 11720 Description: pt-online-schema-change alters a table's structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. # Usage: pt-online-schema-change [OPTIONS] DSN # DSNParser:2158 11720 DSN string made from options: # DSNParser:2095 11720 No DSN to parse # DSNParser:2211 11720 DBI:mysql:ATDB;host=10.0.10.110;mysql_read_default_group=client # DSNParser:2260 11720 DBI:mysql:ATDB;host=10.0.10.110;mysql_read_default_group=client perconatool snakeskin ShowErrorStatement=>1, AutoCommit=>1, mysql_enable_utf8=>0, PrintError=>0, RaiseError=>1 # DSNParser:2288 11720 DBI::db=HASH(0x3457c50) SELECT @@SQL_MODE # DSNParser:2419 11720 DBI::db=HASH(0x3457c50) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 11720 DBI::db=HASH(0x3457c50) SET SESSION lock_wait_timeout=60 # DSNParser:2419 11720 DBI::db=HASH(0x3457c50) SET SESSION wait_timeout=10000 # DSNParser:2319 11720 DBI::db=HASH(0x3457c50) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 11720 DBH info: DBI::db=HASH(0x3457c50) $VAR1 = { # '@@hostname' => 'ChiefDB1', # 'CONNECTION_ID()' => '192', # 'DATABASE()' => 'ATDB', # 'VERSION()' => '5.6.23-log' # }; # Connection info: 10.0.10.110 via TCP/IP 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/local/database/live/mysql-5.6.23-linux-glibc2.5-x86_64/share/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.025 $DBI::VERSION: 1.63 # Cxn:3808 11720 DBI::db=HASH(0x3457c50) Setting dbh # Cxn:3813 11720 DBI::db=HASH(0x3457c50) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 11720 DBI::db=HASH(0x3457c50) hostname: ChiefDB1 110 # Cxn:3796 11720 DBI::db=HASH(0x3457c50) Connected dbh to ChiefDB1 h=10.0.10.110 # DSNParser:2158 11720 DSN string made from options: # DSNParser:2095 11720 No DSN to parse # DSNParser:2211 11720 DBI:mysql:ATDB;host=10.0.10.110;mysql_read_default_group=client # DSNParser:2260 11720 DBI:mysql:ATDB;host=10.0.10.110;mysql_read_default_group=client perconatool snakeskin AutoCommit=>1, ShowErrorStatement=>1, RaiseError=>1, PrintError=>0, mysql_enable_utf8=>0 # DSNParser:2288 11720 DBI::db=HASH(0x34598b0) SELECT @@SQL_MODE # DSNParser:2419 11720 DBI::db=HASH(0x34598b0) SET SESSION innodb_lock_wait_timeout=1 # DSNParser:2419 11720 DBI::db=HASH(0x34598b0) SET SESSION lock_wait_timeout=60 # DSNParser:2419 11720 DBI::db=HASH(0x34598b0) SET SESSION wait_timeout=10000 # DSNParser:2319 11720 DBI::db=HASH(0x34598b0) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/ # DSNParser:2328 11720 DBH info: DBI::db=HASH(0x34598b0) $VAR1 = { # '@@hostname' => 'ChiefDB1', # 'CONNECTION_ID()' => '193', # 'DATABASE()' => 'ATDB', # 'VERSION()' => '5.6.23-log' # }; # Connection info: 10.0.10.110 via TCP/IP 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/local/database/live/mysql-5.6.23-linux-glibc2.5-x86_64/share/charsets/', # Variable_name => 'character_sets_dir' # } # ]; # $DBD::mysql::VERSION: 4.025 $DBI::VERSION: 1.63 # Cxn:3808 11720 DBI::db=HASH(0x34598b0) Setting dbh # Cxn:3813 11720 DBI::db=HASH(0x34598b0) SELECT @@server_id /*!50038 , @@hostname*/ # Cxn:3815 11720 DBI::db=HASH(0x34598b0) hostname: ChiefDB1 110 # Cxn:3796 11720 DBI::db=HASH(0x34598b0) Connected dbh to ChiefDB1 h=10.0.10.110 # Percona::XtraDB::Cluster:7621 11720 ChiefDB1 SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:7623 11720 $VAR1 = undef; # # VersionParser:1950 11720 VersionParser got a dbh, trying to get the version # VersionParser:1998 11720 InnoDB support: DEFAULT # VersionParser:2010 11720 InnoDB version: 5.6.23 # VersionCheck:7077 11720 FindBin::Bin: /usr/local/bin # VersionCheck:7237 11720 SELECT CONCAT(@@hostname, @@port) # VersionCheck:7258 11720 MySQL instance: ee3e534ebd9cd1de81a3161d9824710b ChiefDB13306 $VAR1 = { # A => undef, # D => 'ATDB', # F => undef, # P => undef, # S => undef, # h => '10.0.10.110', # p => 'snakeskin', # t => 'AccelGyroTestSpec', # u => 'perconatool' # }; # # VersionCheck:7057 11720 Version check file percona-version-check in /tmp # VersionCheck:7172 11720 Version check file /tmp/percona-version-check contents: 0,1439469518 # 14bd02a1a18bb8ab37cfe3c39a0f608c,1439317999 # 4633f4fdd5e3af70a64248e20fda5a4d,1439471509 # 5e898cdd217c3fdc1491a88d14ef6465,1439469518 # 644a0421cbbe82e6377c48a2a1c135fe,1439317999 # 970cef52dc5cdcd08bc7d5aae750d561,1438974266 # da3804fa308ab02b7e4b8c416c8af520,1439317999 # ee3e534ebd9cd1de81a3161d9824710b,1439488158 # VersionCheck:7180 11720 Intsance ee3e534ebd9cd1de81a3161d9824710b last checked 1439488158 now 1439492551 diff 4393 hours until next check 22.78 # VersionCheck:7180 11720 Intsance 0 last checked 1439469518 now 1439492551 diff 23033 hours until next check 17.60 # VersionCheck:7100 11720 0 instances to check # TableParser:3290 11720 Checking `ATDB`.`AccelGyroTestSpec` # TableParser:3294 11720 SHOW TABLES FROM `ATDB` LIKE 'AccelGyroTestSpec' # TableParser:3308 11720 Table ATDB AccelGyroTestSpec exists # pt_online_schema_change:10009 11720 SHOW TRIGGERS FROM `ATDB` LIKE 'AccelGyroTestSpec' # TableParser:3119 11720 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:3124 11720 DBI::db=HASH(0x3457c50) USE `ATDB` # TableParser:3128 11720 SHOW CREATE TABLE `ATDB`.`AccelGyroTestSpec` # TableParser:3138 11720 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ # TableParser:3316 11720 Storage engine: InnoDB # TableParser:3170 11720 Table cols: `specindex`, `part_no`, `asic`, `accelsenseelement`, `gyrosenseelement`, `spectype`, `approved`, `approvedby`, `createdby`, `dateapproved`, `dateobsolete`, `basedon`, `comments`, `reelsize`, `auditparts`, `tpgmpath`, `devicename`, `humidityscrn`, `temperaturesetpts`, `prommask`, `promimage`, `defaultramimage`, `registermask`, `i2c_address`, `vdd`, `vddio`, `vddratiohigh`, `vddratiolow`, `regulatortarget`, `regulatortol`, `osctarget`, `osctol`, `vcotarget`, `vcotol`, `wdttarget`, `wdttol`, `currentmin`, `currentmax`, `altcurrent1min`, `altcurrent1max`, `altcurrent2min`, `altcurrent2max`, `disabledcurrentmin`, `disabledcurrentmax`, `tempsensoroutputtol`, `tempsensorfgmin`, `tempsensorfgmax`, `tempsensorfomin`, `tempsensorfomax`, `accelbitresolution`, `accelrangehighmin`, `accelrangelowmax`, `accelstabilitytol`, `accelsensex`, `accelsensey`, `accelsensez`, `accelsensetolx`, `accelsensetoly`, `accelsensetolz`, `accelsensetolxy`, `accelsensetolxz`, `accelsensetolyx`, `accelsensetolyz`, `accelsensetolzx`, `accelsensetolzy`, `accelsensethermalslopetolx`, `accelsensethermalslopetoly`, `accelsensethermalslopetolz`, `accelsenseratiometricerrortolx`, `accelsenseratiometricerrortoly`, `accelsenseratiometricerrortolz`, `acceloffx`, `acceloffy`, `acceloffz`, `accelofftolx`, `accelofftoly`, `accelofftolz`, `accelscreentolsingleaxis`, `accelscreentolallaxes`, `acceloffthermalslopetolx`, `acceloffthermalslopetoly`, `acceloffthermalslopetolz`, `acceloffratiometricerrortolx`, `acceloffratiometricerrortoly`, `acceloffratiometricerrortolz`, `accelselftesttargetx`, `accelselftesttargety`, `accelselftesttargetz`, `accelselftesttrimtolx`, `accelselftesttrimtoly`, `accelselftesttrimtolz`, `accelposselftestminx`, `accelposselftestminy`, `accelposselftestminz`, `accelposselftestmaxx`, `accelposselftestmaxy`, `accelposselftestmaxz`, `accelnegselftestminx`, `accelnegselftestminy`, `accelnegselftestminz`, `accelnegselftestmaxx`, `accelnegselftestmaxy`, `accelnegselftestmaxz`, `accellinearityerrortolx`, `accellinearityerrortoly`, `accellinearityerrortolz`, `accelcgminx`, `accelcgminy`, `accelcgminz`, `accelcgmaxx`, `accelcgmaxy`, `accelcgmaxz`, `accelfgminx`, `accelfgminy`, `accelfgminz`, `accelfgmaxx`, `accelfgmaxy`, `accelfgmaxz`, `accelfominx`, `accelfominy`, `accelfominz`, `accelfomaxx`, `accelfomaxy`, `accelfomaxz`, `acceltclowx`, `acceltclowy`, `acceltclowz`, `acceltchighx`, `acceltchighy`, `acceltchighz`, `acceltcminx`, `acceltcminy`, `acceltcminz`, `acceltcmaxx`, `acceltcmaxy`, `acceltcmaxz`, `gyrobitresolution`, `gyrorangehighmin`, `gyrorangelowmax`, `gyrostabilitytol`, `gyrosensex`, `gyrosensey`, `gyrosensez`, `gyrosensetolx`, `gyrosensetoly`, `gyrosensetolz`, `gyrosensetolxy`, `gyrosensetolxz`, `gyrosensetolyx`, `gyrosensetolyz`, `gyrosensetolzx`, `gyrosensetolzy`, `gyrosensethermalslopetolx`, `gyrosensethermalslopetoly`, `gyrosensethermalslopetolz`, `gyrooffx`, `gyrooffy`, `gyrooffz`, `gyroofftolx`, `gyroofftoly`, `gyroofftolz`, `gyroscreentolallaxes`, `gyroscreentolsingleaxis`, `gyrooffthermalslopetolx`, `gyrooffthermalslopetoly`, `gyrooffthermalslopetolz`, `gyrooffratiometricerrortolx`, `gyrooffratiometricerrortoly`, `gyrooffratiometricerrortolz`, `gyrofg1mint1`, `gyrofg1mint2`, `gyrofg1mint3`, `gyrofg1maxt1`, `gyrofg1maxt2`, `gyrofg1maxt3`, `gyrofg2mint1`, `gyrofg2mint2`, `gyrofg2mint3`, `gyrofg2maxt1`, `gyrofg2maxt2`, `gyrofg2maxt3`, `gyrofg3mint1`, `gyrofg3mint2`, `gyrofg3mint3`, `gyrofg3maxt1`, `gyrofg3maxt2`, `gyrofg3maxt3`, `gyrofg4mint1`, `gyrofg4mint2`, `gyrofg4mint3`, `gyrofg4maxt1`, `gyrofg4maxt2`, `gyrofg4maxt3`, `gyrofoanalogmint1`, `gyrofoanalogmint2`, `gyrofoanalogmint3`, `gyrofoanalogmaxt1`, `gyrofoanalogmaxt2`, `gyrofoanalogmaxt3`, `gyrofodigitalmint1`, `gyrofodigitalmint2`, `gyrofodigitalmint3`, `gyrofodigitalmaxt1`, `gyrofodigitalmaxt2`, `gyrofodigitalmaxt3`, `gyrotcglowt1`, `gyrotcglowt2`, `gyrotcglowt3`, `gyrotcghight1`, `gyrotcghight2`, `gyrotcghight3`, `gyrotcgmint1`, `gyrotcgmint2`, `gyrotcgmint3`, `gyrotcgmaxt1`, `gyrotcgmaxt2`, `gyrotcgmaxt3`, `gyrotcolowt1`, `gyrotcolowt2`, `gyrotcolowt3`, `gyrotcohight1`, `gyrotcohight2`, `gyrotcohight3`, `gyrotcomint1`, `gyrotcomint2`, `gyrotcomint3`, `gyrotcomaxt1`, `gyrotcomaxt2`, `gyrotcomaxt3`, `gyrordmscalemin`, `gyrordmscalemax`, `gyrordmrefmin`, `gyrordmrefmax`, `gyrordmdelaymin`, `gyrordmdelaymax`, `gyrotsmdelaymin`, `gyrotsmdelaymax`, `gyrofreqseparationmin`, `gyrofreqseparationtarget`, `gyrofreqseparationmax` # TableParser:3316 11720 Storage engine: InnoDB # TableParser:3332 11720 Parsed key: PRIMARY KEY (`specindex`) # TableParser:3352 11720 PRIMARY key cols: `specindex` # TableParser:3374 11720 This key is the clustered key # NibbleIterator:5598 11720 EXPLAIN SELECT * FROM `ATDB`.`AccelGyroTestSpec` WHERE 1=1 # NibbleIterator:5600 11720 $VAR1 = { # extra => undef, # id => '1', # key => undef, # key_len => undef, # possible_keys => undef, # ref => undef, # rows => '42', # select_type => 'SIMPLE', # table => 'AccelGyroTestSpec', # type => 'ALL' # }; # # NibbleIterator:5475 11720 One nibble: yes # NibbleIterator:5530 11720 Auto-selecting best index # TableParser:3231 11720 Indexes sorted best-first: PRIMARY # NibbleIterator:5563 11720 Best index: PRIMARY Operation, tries, wait: copy_rows, 10, 0.25 create_triggers, 10, 1 drop_triggers, 10, 1 swap_tables, 10, 1 update_foreign_keys, 10, 1 # pt_online_schema_change:10056 11720 Finding child tables # pt_online_schema_change:10062 11720 SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE referenced_table_schema='ATDB' AND referenced_table_name='AccelGyroTestSpec' # pt_online_schema_change:10065 11720 No child tables found Starting a dry run. `ATDB`.`AccelGyroTestSpec` will not be altered. Specify --execute instead of --dry-run to alter the table. # CleanupTask:6170 11720 Created cleanup task CODE(0x301bee8) # pt_online_schema_change:9739 11720 Renamed columns (old => new): $VAR1 = {}; # # Percona::XtraDB::Cluster:7621 11720 ChiefDB1 SHOW VARIABLES LIKE 'wsrep_on' # Percona::XtraDB::Cluster:7623 11720 $VAR1 = undef; # # TableParser:3119 11720 /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */ # TableParser:3124 11720 DBI::db=HASH(0x3457c50) USE `ATDB` # TableParser:3128 11720 SHOW CREATE TABLE `ATDB`.`AccelGyroTestSpec` # TableParser:3138 11720 /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */ Creating new table... # pt_online_schema_change:9868 11720 CREATE TABLE `ATDB`.`_AccelGyroTestSpec_new` ( # `SpecIndex` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', # `Part_No` varchar(50) DEFAULT NULL COMMENT 'Name of Product', # `ASIC` varchar(10) DEFAULT NULL COMMENT 'Which ASIC is in product', # `AccelSenseElement` varchar(15) DEFAULT NULL COMMENT 'MEMS Accelerometer Sense Element', # `GyroSenseElement` varchar(15) DEFAULT NULL COMMENT 'MEMS Gyro Sense Element', # `SpecType` enum('engineering','production','samples') DEFAULT 'production' COMMENT 'Type of Spec', # `Approved` enum('pending','approved','obsolete','rejected') DEFAULT NULL COMMENT 'Approval Status of Spec', # `ApprovedBy` varchar(3) DEFAULT NULL COMMENT 'Approver of Spec', # `CreatedBy` varchar(5) DEFAULT NULL COMMENT 'Creation Date of Spec', # `DateApproved` date DEFAULT NULL COMMENT 'Approval Date of Spec', # `DateObsolete` date DEFAULT NULL COMMENT 'Date Spec Obsoleted', # `BasedOn` int(10) unsigned DEFAULT NULL COMMENT 'SpecIndex of Prior Spec', # `Comments` varchar(200) DEFAULT NULL, # `ReelSize` int(5) DEFAULT NULL COMMENT 'Default number of parts on a reel', # `AuditParts` int(5) DEFAULT NULL COMMENT 'Number of Audit Parts on each Reel', # `TpgmPath` varchar(260) DEFAULT NULL COMMENT 'SPEA Test Program Path', # `DeviceName` varchar(150) DEFAULT NULL COMMENT 'SPEA Device Name', # `HumidityScrn` enum('None','Initial','Verify') DEFAULT NULL, # `TemperatureSetpts` varchar(50) DEFAULT NULL COMMENT 'Comma separated list of temperatures. First Temp is considered Room Temp. These are the temperatures for temperature compensation is performed and thermal performance is measured at', # `PROMMask` varchar(256) DEFAULT NULL, # `PROMImage` varchar(256) DEFAULT NULL, # `DefaultRAMImage` varchar(256) DEFAULT NULL, # `RegisterMask` varchar(256) DEFAULT NULL COMMENT 'Mask defining which register bits to test', # `I2C_Address` char(7) DEFAULT NULL COMMENT 'String of seven ones and zeros representing I2C Address (MSB first). An 8th (LSB) is added when communicating with the device to signify Read (1) vs Write (0)', # `Vdd` float DEFAULT NULL COMMENT 'Units: V', # `VddIO` float DEFAULT NULL COMMENT 'Units: V', # `VddRatioHigh` float DEFAULT NULL, # `VddRatioLow` float DEFAULT NULL, # `RegulatorTarget` float DEFAULT NULL COMMENT 'Target (V) for Regulator Trim', # `RegulatorTol` float DEFAULT NULL COMMENT 'Tolerance (% of Target) for Regulator Trim', # `OSCTarget` float DEFAULT NULL COMMENT 'Oscillator (OSC) Target (Hz)', # `OSCTol` float DEFAULT NULL COMMENT 'Oscillator (OSC) Tolerance (Hz)', # `VCOTarget` float DEFAULT NULL COMMENT 'VCO Target (Hz)', # `VCOTol` float DEFAULT NULL COMMENT 'VCO Tolerance (Hz)', # `WDTTarget` float DEFAULT NULL COMMENT 'WatchDogTimer (WDT) Target (Hz)', # `WDTTol` float DEFAULT NULL COMMENT 'WatchDogTimer (WDT) Tolerance (Hz)', # `CurrentMin` float DEFAULT NULL COMMENT 'Minimum Operating Current (mA)', # `CurrentMax` float DEFAULT NULL COMMENT 'Maximum Operating Current (mA)', # `AltCurrent1Min` float DEFAULT NULL COMMENT 'Max for Alternate Current 1 Measurement', # `AltCurrent1Max` float DEFAULT NULL COMMENT 'Max for Alternate Current 1 Measurement', # `AltCurrent2Min` float DEFAULT NULL COMMENT 'Max for Alternate Current 2 Measurement', # `AltCurrent2Max` float DEFAULT NULL COMMENT 'Max for Alternate Current 2 Measurement', # `DisabledCurrentMin` float DEFAULT NULL COMMENT 'Min for Disabled Current Measurement', # `DisabledCurrentMax` float DEFAULT NULL COMMENT 'Maximum Sleep (Disabled) Current (mA)', # `TempSensorOutputTol` int(5) DEFAULT NULL COMMENT 'Tolerance (in degrees) to trim Temperature Output from DUT Internal Temperature Sensor', # `TempSensorFgMin` int(11) DEFAULT NULL COMMENT 'Minimum value of Gain Trim Code for Temperature Output from DUT Internal Temperature Sensor', # `TempSensorFgMax` int(11) DEFAULT NULL COMMENT 'Maximum value of Gain Trim Code for Temperature Output from DUT Internal Temperature Sensor', # `TempSensorFoMin` int(11) DEFAULT NULL COMMENT 'Minimum value of Offset Trim Code for Temperature Output from DUT Internal Temperature Sensor', # `TempSensorFoMax` int(11) DEFAULT NULL COMMENT 'Maximum value of Offset Trim Code for Temperature Output from DUT Internal Temperature Sensor', # `AccelBitResolution` int(11) DEFAULT NULL COMMENT 'Standard Bit Resolution of Part', # `AccelRangeHighMin` float DEFAULT NULL, # `AccelRangeLowMax` float DEFAULT NULL, # `AccelStabilityTol` float DEFAULT NULL COMMENT 'Maximum Value for Stability Measurement. Typically Std (volts or counts) of filtered measurements', # `AccelSenseX` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `AccelSenseY` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `AccelSenseZ` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `AccelSenseTolX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolXY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolXZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolYX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolYZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolZX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseTolZY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `AccelSenseThermalSlopeTolX` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `AccelSenseThermalSlopeTolY` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `AccelSenseThermalSlopeTolZ` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `AccelSenseRatiometricErrorTolX` float DEFAULT NULL, # `AccelSenseRatiometricErrorTolY` float DEFAULT NULL, # `AccelSenseRatiometricErrorTolZ` float DEFAULT NULL, # `AccelOffX` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `AccelOffY` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `AccelOffZ` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `AccelOffTolX` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `AccelOffTolY` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `AccelOffTolZ` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `AccelScreenTolSingleAxis` float DEFAULT NULL COMMENT 'Max shift of 1Gz Offset on any axis (% of Offset Target)', # `AccelScreenTolAllAxes` float DEFAULT NULL COMMENT 'Max shift of 1Gz Offset on all axes (% of Offset Target)', # `AccelOffThermalSlopeTolX` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (mg/deg C)', # `AccelOffThermalSlopeTolY` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (mg/deg C)', # `AccelOffThermalSlopeTolZ` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (mg/deg C)', # `AccelOffRatiometricErrorTolX` float DEFAULT NULL, # `AccelOffRatiometricErrorTolY` float DEFAULT NULL, # `AccelOffRatiometricErrorTolZ` float DEFAULT NULL, # `AccelSelfTestTargetX` float DEFAULT NULL COMMENT 'Target (in g) for SelfTest Output', # `AccelSelfTestTargetY` float DEFAULT NULL COMMENT 'Target (in g) for SelfTest Output', # `AccelSelfTestTargetZ` float DEFAULT NULL COMMENT 'Target (in g) for SelfTest Output', # `AccelSelfTestTrimTolX` float DEFAULT NULL COMMENT 'Tolerance (in g) for SelfTest Output', # `AccelSelfTestTrimTolY` float DEFAULT NULL COMMENT 'Tolerance (in g) for SelfTest Output', # `AccelSelfTestTrimTolZ` float DEFAULT NULL COMMENT 'Tolerance (in g) for SelfTest Output', # `AccelPosSelfTestMinX` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelPosSelfTestMinY` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelPosSelfTestMinZ` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelPosSelfTestMaxX` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelPosSelfTestMaxY` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelPosSelfTestMaxZ` float DEFAULT NULL COMMENT 'Positive SelfTest Limit (in g)', # `AccelNegSelfTestMinX` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelNegSelfTestMinY` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelNegSelfTestMinZ` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelNegSelfTestMaxX` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelNegSelfTestMaxY` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelNegSelfTestMaxZ` float DEFAULT NULL COMMENT 'Negative SelfTest Limit (in g)', # `AccelLinearityErrorTolX` float DEFAULT NULL COMMENT '%', # `AccelLinearityErrorTolY` float DEFAULT NULL COMMENT '%', # `AccelLinearityErrorTolZ` float DEFAULT NULL COMMENT '%', # `AccelCgMinX` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelCgMinY` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelCgMinZ` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelCgMaxX` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelCgMaxY` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelCgMaxZ` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelFgMinX` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelFgMinY` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelFgMinZ` int(11) DEFAULT NULL COMMENT 'Minimum Gain Trim Code', # `AccelFgMaxX` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelFgMaxY` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelFgMaxZ` int(11) DEFAULT NULL COMMENT 'Maximum Gain Trim Code', # `AccelFoMinX` int(11) DEFAULT NULL COMMENT 'Minimum Offset Trim Code', # `AccelFoMinY` int(11) DEFAULT NULL COMMENT 'Minimum Offset Trim Code', # `AccelFoMinZ` int(11) DEFAULT NULL COMMENT 'Minimum Offset Trim Code', # `AccelFoMaxX` int(11) DEFAULT NULL COMMENT 'Maximum Offset Trim Code', # `AccelFoMaxY` int(11) DEFAULT NULL COMMENT 'Maximum Offset Trim Code', # `AccelFoMaxZ` int(11) DEFAULT NULL COMMENT 'Maximum Offset Trim Code', # `AccelTCLowX` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `AccelTCLowY` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `AccelTCLowZ` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `AccelTCHighX` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `AccelTCHighY` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `AccelTCHighZ` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `AccelTCMinX` int(11) DEFAULT NULL COMMENT 'Maximum trim code allowed for Temperature Compensation', # `AccelTCMinY` int(11) DEFAULT NULL COMMENT 'Maximum trim code allowed for Temperature Compensation', # `AccelTCMinZ` int(11) DEFAULT NULL COMMENT 'Maximum trim code allowed for Temperature Compensation', # `AccelTCMaxX` int(11) DEFAULT NULL COMMENT 'Minimum trim code allowed for Temperature Compensation', # `AccelTCMaxY` int(11) DEFAULT NULL COMMENT 'Minimum trim code allowed for Temperature Compensation', # `AccelTCMaxZ` int(11) DEFAULT NULL COMMENT 'Minimum trim code allowed for Temperature Compensation', # `GyroBitResolution` int(11) DEFAULT NULL COMMENT 'Standard Bit Resolution of Part', # `GyroRangeHighMin` float DEFAULT NULL, # `GyroRangeLowMax` float DEFAULT NULL, # `GyroStabilityTol` float DEFAULT NULL COMMENT 'Maximum Value for Stability Measurement. Typically Std (volts or counts) of filtered measurements', # `GyroSenseX` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `GyroSenseY` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `GyroSenseZ` float DEFAULT NULL COMMENT 'Sensitivity Target (Units: See SensUnit)', # `GyroSenseTolX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolXY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolXZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolYX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolYZ` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolZX` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseTolZY` float DEFAULT NULL COMMENT 'Sensitivity Tolerance (% of Sensitivity Target)', # `GyroSenseThermalSlopeTolX` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `GyroSenseThermalSlopeTolY` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `GyroSenseThermalSlopeTolZ` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (%/deg C)', # `GyroOffX` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `GyroOffY` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `GyroOffZ` float DEFAULT NULL COMMENT 'Offset Target (Units: see OffUnit)', # `GyroOffTolX` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `GyroOffTolY` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `GyroOffTolZ` float DEFAULT NULL COMMENT 'Offset Tolerance (% of Offset Target)', # `GyroScreenTolAllAxes` float DEFAULT NULL COMMENT 'Max shift of 1Gz Offset on all axes (% of Offset Target)', # `GyroScreenTolSingleAxis` float DEFAULT NULL COMMENT 'Max shift of 1Gz Offset on any axis (% of Offset Target)', # `GyroOffThermalSlopeTolX` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (dps/deg C)', # `GyroOffThermalSlopeTolY` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (dps/deg C)', # `GyroOffThermalSlopeTolZ` float DEFAULT NULL COMMENT 'Thermal Slope Threshold (dps/deg C)', # `GyroOffRatiometricErrorTolX` float DEFAULT NULL, # `GyroOffRatiometricErrorTolY` float DEFAULT NULL, # `GyroOffRatiometricErrorTolZ` float DEFAULT NULL, # `GyroFg1MinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg1MinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg1MinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg1MaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg1MaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg1MaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg2MinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg2MinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg2MinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg2MaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg2MaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg2MaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg3MinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg3MinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg3MinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg3MaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg3MaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg3MaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg4MinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg4MinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg4MinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFg4MaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg4MaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFg4MaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoAnalogMinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoAnalogMinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoAnalogMinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoAnalogMaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoAnalogMaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoAnalogMaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoDigitalMinT1` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoDigitalMinT2` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoDigitalMinT3` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroFoDigitalMaxT1` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoDigitalMaxT2` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFoDigitalMaxT3` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroTCgLowT1` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCgLowT2` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCgLowT3` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCgHighT1` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCgHighT2` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCgHighT3` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCgMinT1` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCgMinT2` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCgMinT3` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCgMaxT1` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroTCgMaxT2` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroTCgMaxT3` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroTCoLowT1` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCoLowT2` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCoLowT3` int(11) DEFAULT NULL COMMENT 'Low code used for determining optimum Temperature Compensation Code', # `GyroTCoHighT1` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCoHighT2` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCoHighT3` int(11) DEFAULT NULL COMMENT 'High code used for determining optimum Temperature Compensation Code', # `GyroTCoMinT1` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCoMinT2` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCoMinT3` int(11) DEFAULT NULL COMMENT 'Min code used for determining optimum Temperature Compensation Code', # `GyroTCoMaxT1` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroTCoMaxT2` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroTCoMaxT3` int(11) DEFAULT NULL COMMENT 'Max code used for determining optimum Temperature Compensation Code', # `GyroRDMScaleMin` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroRDMScaleMax` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroRDMRefMin` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroRDMRefMax` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroRDMDelayMin` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroRDMDelayMax` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroTSMDelayMin` int(11) DEFAULT NULL COMMENT 'Minimum Trim Code', # `GyroTSMDelayMax` int(11) DEFAULT NULL COMMENT 'Maximum Trim Code', # `GyroFreqSeparationMin` int(5) DEFAULT NULL COMMENT 'Minimum Frequency Separation between TSM and RDM (Hz)', # `GyroFreqSeparationTarget` int(5) DEFAULT NULL COMMENT 'Preferred (Target) Frequency Separation between TSM and RDM (Hz)', # `GyroFreqSeparationMax` int(5) DEFAULT NULL COMMENT 'Maximum Frequency Separation between TSM and RDM (Hz)', # PRIMARY KEY (`SpecIndex`) # ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 Created new table ATDB._AccelGyroTestSpec_new OK. Altering new table... # pt_online_schema_change:8821 11720 ALTER TABLE `ATDB`.`_AccelGyroTestSpec_new` ADD GyroStupMin float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values', ADD GyroStupMax float DEFAULT NULL AFTER GyroStabilityTol COMMENT 'Gyro Startup time in ms defined as the time for the Gyro outputs to reach 90% of steady state values'; # CleanupTask:6178 11720 Calling cleanup task CODE(0x301bee8)