What kind of Python script does MySQL to collect statistics on all tables

Use the Python script to MySQL all tables to collect statistical information. In view of this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

[root@MySQL01 script] # vim analyze.py

#! / usr/bin/env python

#-*-encoding:utf8-*-

#

Import MySQLdb

Import time

Step = 0

Db = MySQLdb.connect (host = '192.168.56.101) neo', passwd =' neo', db = 'information_schema')

Conn = db.cursor ()

Sql =''select TABLE_SCHEMA, table_name from information_schema.tables where table_schema not in (' information_schema', 'performance_schema',' mysql')''

# print sql

Conn.execute (sql)

If conn.rowcount > 0:

For item in conn.fetchall ():

Sql =''analyze table% s.% slots'% (item [0], item [1])

Print sql + 'operation executes perfect fullness'

Conn.execute (sql)

Time.sleep (0.5)

Conn.close ()

Db.close ()

# execute script

[root@MySQL01 script] # python2.6 analyze.py

Analyze table test.area operation executes

Analyze table test.class operation executes

This is the answer to the question about using Python script for MySQL to collect statistics on all tables. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.