pt-mysql-summary schema dump prompt can't be disabled
Bug #1214685 reported by
Muhammad Irfan
This bug affects 4 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Daniel Nichter | ||
Bug Description
There is no parameter i can find which avoids the question in pt-mysql-summary
Would you like to mysqldump -d the schema and analyze it? y/n
In order to avoid dump and analyze of database the workaround is to use --databases option with dummy database name or provide " " to --databases option. There should be an option which can ignore dump and analyze of database.
version: pt-mysql-summary 2.2.2
commandline: pt-mysql-summary --databases dummy
Related branches
lp:~percona-toolkit-dev/percona-toolkit/disable-pt-mysql-summary-schema-dump-prompt-bug-1214685
- Daniel Nichter: Approve
-
Diff: 275 lines (+47/-97)7 files modifiedbin/pt-mysql-summary (+24/-50)
lib/bash/collect_mysql_info.sh (+6/-5)
lib/bash/report_mysql_info.sh (+12/-38)
t/lib/bash/report_mysql_info.sh (+1/-0)
t/pt-mysql-summary/pt-mysql-summary.t (+2/-2)
t/pt-mysql-summary/samples/expected_output_temp003.txt (+1/-1)
t/pt-mysql-summary/samples/expected_output_temp004.txt (+1/-1)
Revision history for this message
| Miguel Angel Nieto (miguelangelnieto) wrote | #1 |
Revision history for this message
| Fernando Ipar (fipar) wrote | #2 |
| Changed in percona-toolkit: | |
| status: | New → Confirmed |
Revision history for this message
| Miguel Angel Nieto (miguelangelnieto) wrote | #3 |
| Changed in percona-toolkit: | |
| milestone: | none → 2.2.6 |
| importance: | Undecided → Medium |
| summary: |
- Parameter to avoid question during execution of pt-mysql-summary script - about to dump the schema and analyze it + pt-mysql-summary schema dump prompt can't be disabled |
| tags: | added: pt-mysql-summary |
| Changed in percona-toolkit: | |
| importance: | Medium → High |
| Changed in percona-toolkit: | |
| assignee: | nobody → Daniel Nichter (daniel-nichter) |
| Changed in percona-toolkit: | |
| status: | Confirmed → In Progress |
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #4 |
| Changed in percona-toolkit: | |
| status: | In Progress → Fix Committed |
| Changed in percona-toolkit: | |
| status: | Fix Committed → Fix Released |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #5 |
To post a comment you must log in.
There should be a parameter if you want to analyze the schema, like --analyze or something similar that is disabled by default. Most of the customers (and myself) don't like to see the mysqldump question and they usually control+c the tool. pt-mysql-schema should be a tool that by default it just run without asking questions.