puppetlabs-mysql icon indicating copy to clipboard operation
puppetlabs-mysql copied to clipboard

select instances aka databases with one query

Open dgf-hogrefe opened this issue 11 months ago • 1 comments
trafficstars

In a server environment with thousands of databases, the original iterative retrieval of database information is extremely slow and results in a Puppet run taking minutes to complete. This change replaces these queries with a single one by querying all relevant attributes from the information schema.

dgf-hogrefe avatar Dec 02 '24 15:12 dgf-hogrefe

CLA assistant check
Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
You have signed the CLA already but the status is still pending? Let us recheck it.

CLAassistant avatar Dec 02 '24 15:12 CLAassistant