diff options
| author | Cecil Hugh Watson <knoppmyth@gmail.com> | 2009-09-26 01:57:08 (GMT) |
|---|---|---|
| committer | Cecil Hugh Watson <knoppmyth@gmail.com> | 2009-09-26 01:57:08 (GMT) |
| commit | 7b29169fff9e7c624890c5edffe85def8a293136 (patch) | |
| tree | 47753889faa3a2063b66d1c7e7681e703eb1b39a /abs/core/LinHES-system/optimize_mythdb.py | |
| parent | c491dea779dac29afff3578bf8245943817c2339 (diff) | |
| download | linhes_pkgbuild-7b29169fff9e7c624890c5edffe85def8a293136.zip linhes_pkgbuild-7b29169fff9e7c624890c5edffe85def8a293136.tar.gz linhes_pkgbuild-7b29169fff9e7c624890c5edffe85def8a293136.tar.bz2 | |
LinHES 6.01.00
Diffstat (limited to 'abs/core/LinHES-system/optimize_mythdb.py')
| -rwxr-xr-x | abs/core/LinHES-system/optimize_mythdb.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/abs/core/LinHES-system/optimize_mythdb.py b/abs/core/LinHES-system/optimize_mythdb.py new file mode 100755 index 0000000..e7b35ed --- /dev/null +++ b/abs/core/LinHES-system/optimize_mythdb.py @@ -0,0 +1,16 @@ +#!/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) |