Execution time 60s+ with 4000 databases

[deubert-it]

Use Case

I'm not managing databases with puppet, however this module will always loop all databases and do a "show variables" on them. This currently takes ~60 seconds for ~4.000 database.

Debug: Executing: '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe show variables like '%_database' db_982'

Describe the Solution You Would Like

If I'm not managing databases via the module at all, maybe this information is not required for everything else to function, and the module could detect itself if it isn't managing databases.

Describe Alternatives You've Considered

An alternative could be a new parameter to just disable this behaviour on demand.