Not the answer you need?
Register and ask your own question!

diff

dvandvan EntrantCurrent User Role Beginner
I cannot get the following to work:

pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha

(the databases are correct, and available to user as specified in mypercdvd.cnf)

I cannot figure out how to get a 'verbose' thingy going on this command, but stdout is:

me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha
DBI connect('metasearch;mysql_read_default_file=/mampstack/mypercdvd.cnf;mysql_read_default_group=client','',...) failed: Access denied for user 'me'@'localhost' (using password: NO) at /usr/local/bin/pt-config-diff line 2055.

I correct the username, and get no output:
me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch,u=dvd,p=XXX D=metasrcha,u=dvd,p=XXX


I compare entirely different databases, and get no output:
me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch,u=dvd,p=XXX D=topic3d,u=dvd,p=XXX

I set the username and password in a cnf file, in sections [mysql] and [client] (duplicated values) and get no output:
me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=topic3d

me:~ me$ pt-config-diff --defaults-file=/mampstack/mypercdvd.cnf D=metasearch D=metasrcha






The following command works very nearly perfectly:

pt-mysql-summary --config=/usr/local/mysql/my.cnf --defaults-file=/mampstack/mypercdvd.cnf --all-databases


Please tell me how to obtain a verbose log on pt-config-diff, and how to perfect my pt-config-diff commands above.
Thx

(btw, I think this is a great toolkit!)

D

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    What is it you are actually attempting to do? The command you are running is logically trying to diff the config of the same MySQL instance with itself (you're just giving it two database names, not two hosts). pt-config-diff is used to compare the configs of two different hosts, or option files.

    Take a look at the three examples in the manual; they are pretty straight forward as far as comparing two hosts, two option files, or a host and an option file:

    http://www.percona.com/doc/percona-toolkit/2.1/pt-config-diff.html
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.