diff options
Diffstat (limited to 'abs/core-testing/LinHES-system/optimize_mythdb.py')
-rwxr-xr-x | abs/core-testing/LinHES-system/optimize_mythdb.py | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/abs/core-testing/LinHES-system/optimize_mythdb.py b/abs/core-testing/LinHES-system/optimize_mythdb.py deleted file mode 100755 index e7b35ed..0000000 --- a/abs/core-testing/LinHES-system/optimize_mythdb.py +++ /dev/null @@ -1,16 +0,0 @@ -#!/usr/bin/python -# import MySQL module -import MySQLdb -import socket -import sys -db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="mythconverg") -cursor = db.cursor() -cursor.execute("SHOW tables") -result = cursor.fetchall() -ops=["REPAIR","OPTIMIZE","ANALYZE"] -for row in result: - ctable=row[0] - for op in ops: - print op,ctable - cmd= "%s table %s" %(op,ctable) - cursor.execute(cmd) |