SQL (Structured Query Language) analysis platform system and method for MySQL database

The invention relates to an SQL (Structured Query Language) analysis platform system and method for a MySQL database, the system comprises a kafka cluster, a log segmentation unit, a click cluster and an SQL analysis unit which are connected in sequence, and the method comprises the following steps: storing logs extracted from a database cluster to the kafka cluster; using the log segmentation unit to consume the logs in the kafka cluster, then performing collection and fingerprinting, and then storing the logs in a click home cluster; and the SQL analysis unit is used for aggregating the logs in the click home cluster, carrying out corresponding optimization or auditing processing, and outputting to obtain an SQL analysis report. Compared with the prior art, all database logs can be collected, database execution records can be displayed in a platform mode, an aggregation analysis report can be formed, and second-level and millisecond-level sql performance analysis can be carried out. 本发明涉及一种用于MySQL数据库的SQL分析平