MySQL對所有表收集統計資訊(Python 2指令碼)

feelpurple發表於2018-04-11
MySqlPython指令碼


  1. [root@MySQL01 script]# vim analyze.py
  2. #!/usr/bin/env python
  3. # -*-encoding:utf8-*-
  4. #

  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()

  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)

  21. time.sleep(0.5)

  23. conn.close()
  24. db.close()

  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章