How can i get MySQL config variable value in PMM?

[Asuwini_P]

Hi Guys,

In PMM, I was able to see the MySQL Global variable in PMM dashboard. With the help of Mysqld exporter, the variable values are taken. However, I am curious to know about the MySQL config variable value which is place in my.cnf file. How can I list the MySQL config variable in PMM dashboard? Is it possible to achieve this?

[Vadim_Yalovets]

Hi @Asuwini_P,

“SHOW GLOBAL VARIABLES” request is used by exporter to generate metrics with variable values.

[Abhinav_Gupta]

Hi @Asuwini_P ,

You can find my.cnf config details under the “MySQL → MySQL Instance Summary → Service Summary” dashboard which contains the pt-mysql-summary output and it prints my.cnf contents as well under “Configuration File” section.