Puppet agent very slow due to MySQL module ...

asked 2017-02-01 06:41:37 -0500

We're using the puppetforge MySQL module - the agent is taking a long time to complete its run. A "--debug" trace reveals that Puppet is running a mysql query for every user in the mysql.user table. E.g.: Debug: Executing: '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT MAXUSERCONNECTIONS, MAXCONNECTIONS, MAXQUESTIONS, MAX_UPDATES, PASSWORD /*!50508 , PLUGIN */ FROM mysql.user WHERE CONCAT(user, '@', host) = 'xxxxx'@localhost''

We have a lot of MySQL users, hence the slowness. Is this just the way it is, or is there a way to turn off all these queries and so speed up the run of the agent? Many thanks Stephen Kenny

edit retag flag offensive close merge delete