MySQL对所有表收集统计信息(Python 2脚本)

1. [root@MySQL01 script]# vim analyze.py
   
2. #!/usr/bin/env python
   
3. # -*-encoding:utf8-*-
   
4. #
   
5. 
   
6. import MySQLdb
   
7. import time
   
8. step = 0
   
9. db = MySQLdb.connect(host = '192.168.56.101',port = 3306,user = 'neo', passwd = 'neo' , db = 'information_schema')
   
10. conn = db.cursor()
    
11. 
    
12. sql = '''select TABLE_SCHEMA, table_name from information_schema.tables where table_schema not in ('information_schema', 'performance_schema', 'mysql') '''
    
13. # print sql
    
14. conn.execute(sql)
    
15. if conn.rowcount > 0:
    
16.         for item in conn.fetchall():
    
17.                 sql = '''analyze table %s.%s''' % (item[0], item[1])
    
18.                 print sql + ' operation executes successfully!'
    
19.                 conn.execute(sql)
    
20. 
    
21. time.sleep(0.5)
    
22. 
    
23. conn.close()
    
24. db.close()
    
25. 
    
26. # 执行脚本
    
27. [root@MySQL01 script]# python2.6 analyze.py
    
28. analyze table test.area operation executes
    
29. analyze table test.class operation executes

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2152815/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2152815/