diff options
author | James Meyer <james.meyer@operamail.com> | 2008-11-09 03:14:58 (GMT) |
---|---|---|
committer | James Meyer <james.meyer@operamail.com> | 2008-11-09 03:14:58 (GMT) |
commit | 5445907db788ab2c7c73ea19fc47d59c862fc6a3 (patch) | |
tree | 1b0a868eb5b9d6aa8e7835cbc49c05947b7c75fe /abs/mv-core/MythVantage-system/optimize_mythdb.py | |
parent | abc83d46637ebc63479ec745f05ae392f404f04e (diff) | |
download | linhes_pkgbuild-5445907db788ab2c7c73ea19fc47d59c862fc6a3.zip linhes_pkgbuild-5445907db788ab2c7c73ea19fc47d59c862fc6a3.tar.gz linhes_pkgbuild-5445907db788ab2c7c73ea19fc47d59c862fc6a3.tar.bz2 |
MythVantage-config (replaces live-installer) for MythVantage
MythVanate-system (replaces STB-system)
Diffstat (limited to 'abs/mv-core/MythVantage-system/optimize_mythdb.py')
-rwxr-xr-x | abs/mv-core/MythVantage-system/optimize_mythdb.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/abs/mv-core/MythVantage-system/optimize_mythdb.py b/abs/mv-core/MythVantage-system/optimize_mythdb.py new file mode 100755 index 0000000..e7b35ed --- /dev/null +++ b/abs/mv-core/MythVantage-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) |