Mysql Server 5.6 : Script to collect Mysql server setting

Guys,
I would need a script on Mysql database that can be use to collect all global setting and also database setting, the users etc. If anyone here expert with Mysql  system administration nad have those scripts, please I appreciate eif this could be share with me.
motioneyeAsked:
Who is Participating?
 
theGhost_k8Connect With a Mentor Database ConsultantCommented:
Hello again :)

So as you write grabbing settings is not for monitoring I'd recommend these two awesome scripts:

https://www.percona.com/doc/percona-toolkit/LATEST/pt-summary.html
https://www.percona.com/doc/percona-toolkit/LATEST/pt-mysql-summary.html

Downloading them is as easy as:
wget percona.com/get/pt-summary
wget percona.com/get/pt-mysql-summary
(I guess you're on windows, then you can download those files directly copying the link to browser)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.