Database system optimization method, system, electronic apparatus, and storage medium

摘要

The disclosure relates to a method and system of optimizing a database system, an electronic device and a computer readable storage medium. The method of optimizing the database system includes: snapshotting performance data of each Structured Query Language (SQL) sentence of the database system every preset first time, and arranging and storing snapshots according to a time sequence, wherein the performance data include the number of times of executions and a buffer gets data volume; correspondingly carrying out variance calculation on the performance data of the current snapshot and the performance data of the former snapshot respectively to calculate a total buffer gets data volume and a single-execution buffer gets data average volume which correspond to each SQL sentence within the preset first time; obtaining a value sum of the total buffer gets data volume and the single-execution buffer gets data average volume of each SQL sentence, and selecting an SQL sentence to be optimized on the basis of the value sum. The disclosure can accurately position the SQL sentence to be optimized, and improve the optimization efficiency.