Optimization design of Vertica DBD analysis

The DBD = Database Designer is the primary native tool in the optimization of Vertica databases.

First run the AdminTools tool and follow the steps below:

1. Select "6 Configuration Menu"
2. Select "2 Run Database Designer"
3. "Select a database for design"Select the database you want to analyze
4. "Enter directory for Database Designer output:"Enter the output directory of the DBD
5. "Designer Name:"Enter the name of the DBD and feel free to start
6. "Design type[comprehensive| Query-specific]"Choose the design type of DBD with two single options and choose according to actual requirements
7. "Select Schema (s) for design"Select the Shema (s) to be designed
8. "Design options[optimize with queries| Update statistics| Deploy Design]"There are three complex options, it is recommended that you remove the deploy design and then manually apply the DBD recommendations
9. "Enter the full path for queries file"Input SQL query statements commonly used by the business to make the analysis of dbd more targeted
10. "proposed k-safety value:1"This is the default
11. "Select Storage footprint preference[balanced Query/load performance| Query performance (larger footprint) | Load performance (smaller footprint)]"There are three single options, depending on the actual needs of the choice, generally choose the first item, balanced query and load performance
12. "ProceedThe Execute DBD
13. "Database Designer started."The DBD has started and there will be output similar to the following until the DBD is completed

Database Designer started. For large databases a design session could take aLong  Time; allow it to complete uninterrupted. Use Ctrl+cifYou must cancel the session. Setting Up Design Session ... Examining table Data ... Loading queries from'/home/dbadmin/sqltune.sql'. Processed ASQL statement (s), all accepted and consideredinchThe design. No existing projections found. Creating design ... [ -%] Designinchprogress ... Completed of. [ -%] Analyzing data statistics ... Completed of. [ -%] Designinchprogress ... Completed of. [ -%] Optimizing query performance ... Completed of. [ -%] Designinchprogress ... Completed of. [ -%] Optimizing storage footprint ... Completed of. [ -%] Internal warning during design ... Completed of. Query Optimization Results ... Query1Optimization ratio or status is1Query2Optimization ratio or status is1Query3Optimization ratio or status is1Query4Optimization ratio or status is1Query5Optimization ratio or status is1Query6Optimization ratio or status is1Query7Optimization ratio or status is1Query8Optimization ratio or status is1Query9Optimization ratio or status is1QueryTenOptimization ratio or status is1Query OneOptimization ratio or status is1Query AOptimization ratio or status is1Query -Optimization ratio or status is1Query -Optimization ratio or status is1Query theOptimization ratio or status is1Query -Optimization ratio or status is1Query -Optimization ratio or status is1Query -Optimization ratio or status is1Query +Optimization ratio or status is1Query -Optimization ratio or status is1Query +Optimization ratio or status is1Query AOptimization ratio or status is1Generating deployment script ... Could not generate default deployment script. The deployment error is deployment do not complete successfully. ERROR-Insufficient resources to the Execute plan on pool dbd [timedout waiting forResource request:waiting forReservation Spot] Design script is locatedinch/home/dbadmin/designer1_design.sqldeployment script is locatedinch/home/dbadmin/designer1_deploy.sqlthe design won't be deployed. The new design is not automatically deployed. For manual deployment Procedures consult Vertica Administrator'S GuideDatabase Designer finished. Press<Enter>To return to the administration Tools menu. Vertica Analytic Database6.1.3-7Administration Tools

Optimization design of Vertica DBD analysis