API tools faq
paste
Guest User

Untitled

a guest
Aug 26th, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.32 KB | None | 0 0
raw download clone embed print report
  1. PTDEBUG=1 pt-slave-find --defaults-file=master/my.sandbox.cnf --user=root
  2. # /usr/bin/perl 5.010001
  3. # Linux perconatest 2.6.32-220.4.2.el6.x86_64 #1 SMP Tue Feb 14 04:00:16 GMT 2012 x86_64 x86_64 x86_64 GNU/Linux
  4. # Arguments: _[--defaults-file=master/my.sandbox.cnf]_ _[--user=root]_
  5. # OptionParser:190 6362 Option rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details.
  6. # OptionParser:199 6362 =item --ask-pass
  7. # OptionParser:218 6362 Option has no attributes
  8. # OptionParser:226 6362 Short help: Prompt for a password when connecting to MySQL
  9. # OptionParser:199 6362 =item --charset
  10. # OptionParser:226 6362 Short help: Default character set
  11. # OptionParser:199 6362 =item --config
  12. # OptionParser:226 6362 Short help: Read this comma-separated list of config files; if specified, this must be the first option on the command line
  13. # OptionParser:199 6362 =item --database
  14. # OptionParser:226 6362 Short help: Database to use
  15. # OptionParser:199 6362 =item --defaults-file
  16. # OptionParser:226 6362 Short help: Only read mysql options from the given file
  17. # OptionParser:199 6362 =item --help
  18. # OptionParser:218 6362 Option has no attributes
  19. # OptionParser:226 6362 Short help: Show help and exit
  20. # OptionParser:199 6362 =item --host
  21. # OptionParser:226 6362 Short help: Connect to host
  22. # OptionParser:199 6362 =item --password
  23. # OptionParser:226 6362 Short help: Password to use when connecting
  24. # OptionParser:199 6362 =item --pid
  25. # OptionParser:226 6362 Short help: Create the given PID file
  26. # OptionParser:199 6362 =item --port
  27. # OptionParser:226 6362 Short help: Port number to use for connection
  28. # OptionParser:199 6362 =item --recurse
  29. # OptionParser:226 6362 Short help: Number of levels to recurse in the hierarchy
  30. # OptionParser:199 6362 =item --recursion-method
  31. # OptionParser:226 6362 Short help: Preferred recursion method used to find slaves
  32. # OptionParser:199 6362 =item --report-format
  33. # OptionParser:226 6362 Short help: Set what information about the slaves is printed
  34. # OptionParser:199 6362 =item --set-vars
  35. # OptionParser:226 6362 Short help: Set these MySQL variables
  36. # OptionParser:199 6362 =item --socket
  37. # OptionParser:226 6362 Short help: Socket file to use for connection
  38. # OptionParser:199 6362 =item --user
  39. # OptionParser:226 6362 Short help: User for login if not current user
  40. # OptionParser:199 6362 =item --version
  41. # OptionParser:218 6362 Option has no attributes
  42. # OptionParser:226 6362 Short help: Show version and exit
  43. # OptionParser:265 6362 Parsing opt spec: group => default spec => ask-pass desc => Prompt for a password when connecting to MySQL
  44. # OptionParser:303 6362 ask-pass type: undef
  45. # OptionParser:265 6362 Parsing opt spec: group => default spec => charset|A=s desc => Default character set
  46. # OptionParser:303 6362 charset type: s
  47. # OptionParser:265 6362 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
  48. # OptionParser:303 6362 config type: A
  49. # OptionParser:265 6362 Parsing opt spec: group => default spec => database|D=s desc => Database to use
  50. # OptionParser:303 6362 database type: s
  51. # OptionParser:265 6362 Parsing opt spec: group => default spec => defaults-file|F=s desc => Only read mysql options from the given file
  52. # OptionParser:303 6362 defaults-file type: s
  53. # OptionParser:265 6362 Parsing opt spec: group => default spec => help desc => Show help and exit
  54. # OptionParser:303 6362 help type: undef
  55. # OptionParser:265 6362 Parsing opt spec: group => default spec => host|h=s desc => Connect to host
  56. # OptionParser:303 6362 host type: s
  57. # OptionParser:265 6362 Parsing opt spec: group => default spec => password|p=s desc => Password to use when connecting
  58. # OptionParser:303 6362 password type: s
  59. # OptionParser:265 6362 Parsing opt spec: group => default spec => pid=s desc => Create the given PID file
  60. # OptionParser:303 6362 pid type: s
  61. # OptionParser:265 6362 Parsing opt spec: group => default spec => port|P=i desc => Port number to use for connection
  62. # OptionParser:303 6362 port type: i
  63. # OptionParser:265 6362 Parsing opt spec: group => default spec => recurse=i desc => Number of levels to recurse in the hierarchy
  64. # OptionParser:303 6362 recurse type: i
  65. # OptionParser:265 6362 Parsing opt spec: group => default spec => recursion-method=s desc => Preferred recursion method used to find slaves
  66. # OptionParser:303 6362 recursion-method type: s
  67. # OptionParser:265 6362 Parsing opt spec: group => default spec => report-format=s desc => Set what information about the slaves is printed (default summary)
  68. # OptionParser:303 6362 report-format type: s
  69. # OptionParser:310 6362 report-format default: summary
  70. # OptionParser:265 6362 Parsing opt spec: group => default spec => set-vars=s desc => Set these MySQL variables (default wait_timeout=10000)
  71. # OptionParser:303 6362 set-vars type: s
  72. # OptionParser:310 6362 set-vars default: wait_timeout=10000
  73. # OptionParser:265 6362 Parsing opt spec: group => default spec => socket|S=s desc => Socket file to use for connection
  74. # OptionParser:303 6362 socket type: s
  75. # OptionParser:265 6362 Parsing opt spec: group => default spec => user|u=s desc => User for login if not current user
  76. # OptionParser:303 6362 user type: s
  77. # OptionParser:265 6362 Parsing opt spec: group => default spec => version desc => Show version and exit
  78. # OptionParser:303 6362 version type: undef
  79. # OptionParser:325 6362 Parsing rule: This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details.
  80. # OptionParser:381 6362 Participants for This tool accepts additional command-line arguments. Refer to the SYNOPSIS and usage information for details. :
  81. # OptionParser:357 6362 Strict mode disabled by rule
  82. # OptionParser:109 6362 Parsing DSN OPTIONS
  83. # OptionParser:199 6362 =item * A
  84. # OptionParser:226 6362 Short help: Default character set
  85. # OptionParser:199 6362 =item * D
  86. # OptionParser:226 6362 Short help: Default database
  87. # OptionParser:199 6362 =item * F
  88. # OptionParser:226 6362 Short help: Only read default options from the given file
  89. # OptionParser:199 6362 =item * h
  90. # OptionParser:226 6362 Short help: Connect to host
  91. # OptionParser:199 6362 =item * p
  92. # OptionParser:226 6362 Short help: Password to use when connecting
  93. # OptionParser:199 6362 =item * P
  94. # OptionParser:226 6362 Short help: Port number to use for connection
  95. # OptionParser:199 6362 =item * S
  96. # OptionParser:226 6362 Short help: Socket file to use for connection
  97. # OptionParser:199 6362 =item * u
  98. # OptionParser:226 6362 Short help: User for login if not current user
  99. # DSNParser:1075 6362 DSN option: copy=1, dsn=charset, desc=Default character set, key=A
  100. # DSNParser:1075 6362 DSN option: copy=1, dsn=database, desc=Default database, key=D
  101. # DSNParser:1075 6362 DSN option: copy=1, dsn=mysql_read_default_file, desc=Only read default options from the given file, key=F
  102. # DSNParser:1075 6362 DSN option: copy=1, dsn=host, desc=Connect to host, key=h
  103. # DSNParser:1075 6362 DSN option: copy=1, dsn=password, desc=Password to use when connecting, key=p
  104. # DSNParser:1075 6362 DSN option: copy=1, dsn=port, desc=Port number to use for connection, key=P
  105. # DSNParser:1075 6362 DSN option: copy=1, dsn=mysql_socket, desc=Socket file to use for connection, key=S
  106. # DSNParser:1075 6362 DSN option: copy=1, dsn=user, desc=User for login if not current user, key=u
  107. # OptionParser:153 6362 pt-slave-find 2.0.3
  108. # OptionParser:465 6362 Cannot open /etc/percona-toolkit/percona-toolkit.conf: No such file or directory
  109. #
  110. # OptionParser:465 6362 Cannot open /etc/percona-toolkit/pt-slave-find.conf: No such file or directory
  111. #
  112. # OptionParser:465 6362 Cannot open /home/martin/.percona-toolkit.conf: No such file or directory
  113. #
  114. # OptionParser:465 6362 Cannot open /home/martin/.pt-slave-find.conf: No such file or directory
  115. #
  116. # OptionParser:433 6362 Got option defaults-file = master/my.sandbox.cnf
  117. # OptionParser:433 6362 Got option user = root
  118. # OptionParser:653 6362 Nothing to validate for option report-format type s value summary
  119. # OptionParser:653 6362 Nothing to validate for option recursion-method type s value undef
  120. # OptionParser:653 6362 Nothing to validate for option password type s value undef
  121. # OptionParser:653 6362 Nothing to validate for option pid type s value undef
  122. # OptionParser:653 6362 Nothing to validate for option user type s value root
  123. # OptionParser:653 6362 Nothing to validate for option charset type s value undef
  124. # OptionParser:653 6362 Nothing to validate for option port type i value undef
  125. # OptionParser:653 6362 Nothing to validate for option set-vars type s value wait_timeout=10000
  126. # OptionParser:653 6362 Nothing to validate for option defaults-file type s value master/my.sandbox.cnf
  127. # OptionParser:653 6362 Nothing to validate for option host type s value undef
  128. # OptionParser:653 6362 Nothing to validate for option socket type s value undef
  129. # OptionParser:653 6362 Nothing to validate for option database type s value undef
  130. # OptionParser:653 6362 Nothing to validate for option recurse type i value undef
  131. # DSNParser:1091 6362 Setting set-vars property
  132. # DSNParser:1162 6362 DSN string made from options: F=master/my.sandbox.cnf,u=root
  133. # DSNParser:1103 6362 Parsing F=master/my.sandbox.cnf,u=root
  134. # DSNParser:1121 6362 Finding value for S
  135. # DSNParser:1131 6362 Copying value for S from defaults
  136. # DSNParser:1121 6362 Finding value for F
  137. # DSNParser:1121 6362 Finding value for A
  138. # DSNParser:1131 6362 Copying value for A from defaults
  139. # DSNParser:1121 6362 Finding value for P
  140. # DSNParser:1131 6362 Copying value for P from defaults
  141. # DSNParser:1121 6362 Finding value for p
  142. # DSNParser:1131 6362 Copying value for p from defaults
  143. # DSNParser:1121 6362 Finding value for u
  144. # DSNParser:1121 6362 Finding value for h
  145. # DSNParser:1131 6362 Copying value for h from defaults
  146. # DSNParser:1121 6362 Finding value for D
  147. # DSNParser:1131 6362 Copying value for D from defaults
  148. # OptionParser:727 6362 Getting description and usage from SYNOPSIS in /usr/bin/pt-slave-find
  149. # OptionParser:980 6362 Parsing SYNOPSIS in /usr/bin/pt-slave-find
  150. # OptionParser:993 6362 Raw SYNOPSIS text: Usage: pt-slave-find [OPTION...] MASTER-HOST
  151. #
  152. # pt-slave-find finds and prints a hierarchy tree of MySQL slaves.
  153. #
  154. #
  155. # OptionParser:731 6362 Description: pt-slave-find finds and prints a hierarchy tree of MySQL slaves.
  156. # Usage: pt-slave-find [OPTION...] MASTER-HOST
  157. # DSNParser:1212 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;mysql_read_default_group=client
  158. # DSNParser:1258 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;mysql_read_default_group=client root undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0
  159. # DSNParser:1267 6362 DBI::db=HASH(0x18f2568) SELECT @@SQL_MODE
  160. # DSNParser:1274 6362 DBI::db=HASH(0x18f2568) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
  161. # DSNParser:1293 6362 DBI::db=HASH(0x18f2568) : SET wait_timeout=10000
  162. # DSNParser:1319 6362 DBH info: DBI::db=HASH(0x18f2568) $VAR1 = {'@@hostname' => 'perconatest','VERSION()' => '5.1.61-log','DATABASE()' => undef,'CONNECTION_ID()' => '70416'}; 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 => '/home/martin/opt/mysql/5.1.61/share/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609
  163. # MasterSlave:1475 6362 Connected to F=master/my.sandbox.cnf,u=root
  164. # MasterSlave:1484 6362 SELECT @@SERVER_ID
  165. # MasterSlave:1486 6362 Working on server ID 1
  166. # MasterSlave:1530 6362 Looking for slaves on F=master/my.sandbox.cnf,u=root using methods processlist hosts
  167. # MasterSlave:1537 6362 Finding slaves with _find_slaves_by_processlist
  168. # VersionParser:2302 6362 5.1.61-log parses to 005001061
  169. # VersionParser:2302 6362 4.1.2 parses to 004001002
  170. # VersionParser:2313 6362 005001061 ge 4.1.2 : 1
  171. # MasterSlave:1604 6362 DBI::db=HASH(0x18f2568) SHOW GRANTS FOR CURRENT_USER()
  172. # MasterSlave:1634 6362 DBI::db=HASH(0x18f2568) SHOW PROCESSLIST
  173. # DSNParser:1103 6362 Parsing h=127.0.0.1
  174. # DSNParser:1121 6362 Finding value for S
  175. # DSNParser:1131 6362 Copying value for S from defaults
  176. # DSNParser:1121 6362 Finding value for F
  177. # DSNParser:1127 6362 Copying value for F from previous DSN
  178. # DSNParser:1121 6362 Finding value for A
  179. # DSNParser:1131 6362 Copying value for A from defaults
  180. # DSNParser:1121 6362 Finding value for P
  181. # DSNParser:1131 6362 Copying value for P from defaults
  182. # DSNParser:1121 6362 Finding value for p
  183. # DSNParser:1131 6362 Copying value for p from defaults
  184. # DSNParser:1121 6362 Finding value for u
  185. # DSNParser:1127 6362 Copying value for u from previous DSN
  186. # DSNParser:1121 6362 Finding value for h
  187. # DSNParser:1121 6362 Finding value for D
  188. # DSNParser:1131 6362 Copying value for D from defaults
  189. # DSNParser:1103 6362 Parsing h=127.0.0.1
  190. # DSNParser:1121 6362 Finding value for S
  191. # DSNParser:1131 6362 Copying value for S from defaults
  192. # DSNParser:1121 6362 Finding value for F
  193. # DSNParser:1127 6362 Copying value for F from previous DSN
  194. # DSNParser:1121 6362 Finding value for A
  195. # DSNParser:1131 6362 Copying value for A from defaults
  196. # DSNParser:1121 6362 Finding value for P
  197. # DSNParser:1131 6362 Copying value for P from defaults
  198. # DSNParser:1121 6362 Finding value for p
  199. # DSNParser:1131 6362 Copying value for p from defaults
  200. # DSNParser:1121 6362 Finding value for u
  201. # DSNParser:1127 6362 Copying value for u from previous DSN
  202. # DSNParser:1121 6362 Finding value for h
  203. # DSNParser:1121 6362 Finding value for D
  204. # DSNParser:1131 6362 Copying value for D from defaults
  205. # MasterSlave:1542 6362 Found 2 slaves
  206. # MasterSlave:1508 6362 Recursing from F=master/my.sandbox.cnf,u=root to F=master/my.sandbox.cnf,h=127.0.0.1,u=root
  207. # DSNParser:1212 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;host=127.0.0.1;mysql_read_default_group=client
  208. # DSNParser:1258 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;host=127.0.0.1;mysql_read_default_group=client root undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0
  209. # DSNParser:1267 6362 DBI::db=HASH(0x18ecbc8) SELECT @@SQL_MODE
  210. # DSNParser:1274 6362 DBI::db=HASH(0x18ecbc8) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
  211. # DSNParser:1293 6362 DBI::db=HASH(0x18ecbc8) : SET wait_timeout=10000
  212. # DSNParser:1319 6362 DBH info: DBI::db=HASH(0x18ecbc8) $VAR1 = {'@@hostname' => 'perconatest','VERSION()' => '5.1.61-log','DATABASE()' => undef,'CONNECTION_ID()' => '70417'}; Connection info: 127.0.0.1 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 => '/home/martin/opt/mysql/5.1.61/share/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609
  213. # MasterSlave:1475 6362 Connected to F=master/my.sandbox.cnf,h=127.0.0.1,u=root
  214. # MasterSlave:1484 6362 SELECT @@SERVER_ID
  215. # MasterSlave:1486 6362 Working on server ID 1
  216. # MasterSlave:1492 6362 Server ID seen, or not what master said
  217. # MasterSlave:1508 6362 Recursing from F=master/my.sandbox.cnf,u=root to F=master/my.sandbox.cnf,h=127.0.0.1,u=root
  218. # DSNParser:1212 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;host=127.0.0.1;mysql_read_default_group=client
  219. # DSNParser:1258 6362 DBI:mysql:;mysql_read_default_file=master/my.sandbox.cnf;host=127.0.0.1;mysql_read_default_group=client root undef mysql_enable_utf8=>0, ShowErrorStatement=>1, AutoCommit=>1, RaiseError=>1, PrintError=>0
  220. # DSNParser:1267 6362 DBI::db=HASH(0x18d2560) SELECT @@SQL_MODE
  221. # DSNParser:1274 6362 DBI::db=HASH(0x18d2560) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/
  222. # DSNParser:1293 6362 DBI::db=HASH(0x18d2560) : SET wait_timeout=10000
  223. # DSNParser:1319 6362 DBH info: DBI::db=HASH(0x18d2560) $VAR1 = {'@@hostname' => 'perconatest','VERSION()' => '5.1.61-log','DATABASE()' => undef,'CONNECTION_ID()' => '70418'}; Connection info: 127.0.0.1 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 => '/home/martin/opt/mysql/5.1.61/share/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.013 $DBI::VERSION: 1.609
  224. # MasterSlave:1475 6362 Connected to F=master/my.sandbox.cnf,h=127.0.0.1,u=root
  225. # MasterSlave:1484 6362 SELECT @@SERVER_ID
  226. # MasterSlave:1486 6362 Working on server ID 1
  227. # MasterSlave:1492 6362 Server ID seen, or not what master said
  228. # pt_slave_find:2748 6362 Printing slaves, starting level 0
  229. # pt_slave_find:2793 6362 level 0 host Localhost
  230. Localhost
  231. # MasterSlave:1718 6362 DBI::db=HASH(0x18f2568) SHOW MASTER STATUS
  232. # MasterSlave:1722 6362 binlog_do_db= position=10364419 file=mysql-bin.000001 binlog_ignore_db=
  233. # MasterSlave:1694 6362 DBI::db=HASH(0x18f2568) SHOW SLAVE STATUS
  234. # MasterSlave:1703 6362 This server returns nothing for SHOW SLAVE STATUS
  235. # VersionParser:2331 6362 InnoDB support: YES
  236. # VersionParser:2343 6362 InnoDB version: BUILTIN
  237. Version 5.1.61-log
  238. Server ID 1
  239. Uptime 1+20:36:47 (started 2012-06-06T08:40:47)
  240. Replication Is not a slave, has 2 slaves connected, is not read_only
  241. Filters
  242. Binary logging STATEMENT
  243. Slave status
  244. Slave mode STRICT
  245. Auto-increment increment 1, offset 1
  246. InnoDB version BUILTIN
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!