| We want to collect a list of commonly issued queries against PDB to provide a list for a performance testing baseline and to help identify which queries we may be able to help optimize. For this ticket you'll need to get a PE install running using Frankenbuilder. Note that setting up a Platform 9 instance and running Frankenbuilder there will greatly reduce the time it takes to spin up a PE install due to the PE tarball needing to be copied back and forth from Portland and your local machine. We can help troubleshoot this setup in the pdb-sync room if there are any issues. Below is an example of a Frankenbuilder command I've used in the past for reference:
./frankenbuilder master --workdir=/Users/zachary.kent/frankenbuilder/franken-workdir --vmpooler --install --preserve-hosts=always --keyfile=~/.ssh/id_rsa-acceptance
|
Once you have a running PE instance you'll need to enable log-queries in the PuppetDB config and restart the service. Once the logging is enabled clicking through the PE console should start logging the AST PDB is generating in the logs. The list of queries we generate doesn't have to be exhaustive for the first pass. Clicking through the main pages and the side navs of the console should generate a reasonable list. We should capture this list in a gist and link it to this ticket. |
