Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #889742: Should use SHOW GLOBAL VARIABLES

Description

**Reported in Launchpad by Simon J Mudd last update 11-06-2012 16:02:57

pt-config-diff does SHOW VARIABLES to collect the configuration settings. This is wrong and it should use SHOW GLOBAL VARIABLES which ensures that global settings are used. SHOW VARIABLES shows session settings which may vary from the global values, and using SHOW GLOBAL VARIABLES makes it clear you are trying to collect global settings. Perhaps the impact is not large but it seems more correct to do this.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:05 PM

**Comment from Launchpad by: Brian Fraser on: 11-06-2012 16:02:56

Marking this as invalid, since pt-config-diff appears to already use SHOW GLOBAL VARIABLES.

lpjirasync January 24, 2018 at 6:05 PM

**Comment from Launchpad by: Daniel Nichter on: 21-02-2012 18:11:28

Which version of pt-config-diff? In the latest I see my $sql = "SHOW /!40103 GLOBAL/ VARIABLES";

Not a Bug

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 6:05 PM
Updated February 4, 2018 at 12:09 AM
Resolved January 24, 2018 at 6:05 PM