Database optimization method, device, electronic device and storage medium

Abstract

The present invention provides a database optimization method, including: obtaining a pending SQL statement; when it is detected that the pending SQL statement is executed by the database, recording the execution time, and when it is determined that the execution time is greater than a preset time, searching for the entity table corresponding to the pending SQL statement in the database; performing sampling analysis and / or histogram analysis on the entity table, and sending the obtained sampling analysis results and / or data histogram to the database, so that the database optimizes the execution plan according to the sampling analysis and / or data histogram; the situation that the database executes the pending SQL statement can be automatically detected, and when an abnormal situation is found, the entity table corresponding to the abnormal SQL statement can be automatically analyzed, without manual operation, and the problems of low optimization efficiency and poor optimization quality caused by manual operation can be avoided, thereby improving the database optimization effect. The present invention also provides a database optimization device, an electronic device and a storage medium, which have the above-mentioned beneficial effects.

Images