The invention relates to the technical field of
database operation and maintenance, in particular to a
database operation and maintenance decision-making method and device based on a large
language model.The method comprises the steps that real-time operation indexes and historical
log data of a
database are collected, and multi-dimensional
time sequence features are extracted; and analyzing the characteristics by using a large
language model, judging whether a performance
bottleneck or an abnormal risk exists or not, and determining the relevance between the performance
bottleneck or the abnormal risk and a database performance problem. If the risk exists, acquiring a
system load sudden change trend and a resource request rate, quantifying a
system pressure degree, and inputting a performance optimization model to generate an adaptive tuning strategy; calculating statement complexity through an
SQL audit log, and selecting an index adjustment strategy in combination with an index optimization model; evaluating the influence of the tuning strategy and the index strategy on the
throughput, the
response delay and the
resource utilization rate, and determining a target high-performance strategy; according to the scheme, accurate optimization and efficient operation and maintenance of database performance are realized through intelligent analysis and dynamic adjustment and optimization.