Statistical analysis method for analyzing invalid update statements based on binlog

The invention discloses a statistical analysis method for analyzing invalid update statements based on binlog, which is characterized by comprising the following steps of: S1, reading the binlog in a system database, analyzing the binlog into an SQL (Structured Query Language) file F of a plain text, and the like. The method comprises the following steps: analyzing a binlog file of a database, segmenting the binlog into a plurality of small files according to an SQL (Structured Query Language) statement, collecting an update statement character string of each small file, and judging and counting whether the individual and combination of the updated fields of the update statement character strings are valid or invalid update statements or not, so as to obtain the update statement character string of each small file. According to the method, the problem that judgment and statistics cannot be carried out on the invalid update statements in an existing statistical analysis method of the invalid update statements