pt-mysql-summary schema dump prompt can't be disabled

Bug #1214685 reported by Muhammad Irfan on 2013-08-21
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Fix Released
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

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.

Fernando Ipar (fipar) wrote :

I agree. Additionally, the way it is set up makes it impossible or at least difficult to get the schema analysis when this is run from a script.

Changed in percona-toolkit:
status: New → Confirmed

s/pt-mysql-schema/pt-mysql-symmary/g :)

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
Daniel Nichter (daniel-nichter) wrote :

The prompt has been removed. You only get a Schema summary if you specify --databases or --all-databases (this latter is a new option), or if you specify --read-samples DIR and DIR/mysqldump exists.

Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers