mirror of https://github.com/apache/cloudstack.git
5750e56be5
In this example commit, we look at: - Adding missing indexes to speed up queries - Reduce table scans by optimising sql query and using indexes - Optimising sql queries to remove duplicate rows (use of distinct) - Reduce CPU and DB load by using jprofiler to optimise both sql query and CPU hotspots server: reduce CPU and DB load caused by systemvm ::isZoneReady() For this case, the sql query was fetching large number of table scans only to determine if zone has any available pool+host to launch systemvms. Accodingly the code and sql queries along with indexes optimisations were used to lower both DB scans and mgmt server CPU load. Signed-off-by: Rohit Yadav <rohit.yadav@shapeblue.com> |
||
|---|---|---|
| .. | ||
| 22beta4to22GA.sql | ||
| 221to222upgrade.sh | ||
| create-database-premium.sql | ||
| create-database-simulator.sql | ||
| create-database.sql | ||
| create-schema-premium.sql | ||
| create-schema-simulator.sql | ||
| create-schema.sql | ||
| data-20to21.sql | ||
| data-22beta1to22beta2.sql | ||
| deploy-db-clouddev.sh | ||
| deploy-db-dev.sh | ||
| deploy-db-simulator.sh | ||
| hypervisor_capabilities.simulator.sql | ||
| index-20to21.sql | ||
| index-212to213.sql | ||
| postprocess-20to21.sql | ||
| server-setup.sql | ||
| server-setup.xml | ||
| templates.simulator.sql | ||
| templates.sql | ||