diff options
| author | Britney Fransen <brfransen@gmail.com> | 2022-11-30 23:10:41 (GMT) |
|---|---|---|
| committer | Britney Fransen <brfransen@gmail.com> | 2022-11-30 23:10:41 (GMT) |
| commit | 09c491757cc31cc4b44967f4df50b56a06b218c3 (patch) | |
| tree | c4402c13e403c4c232dedaf4db576f004495a736 /linhes/linhes-system/optimize_mythdb.py | |
| parent | 0e927ab4c2948429c71c22200da0e760b766102f (diff) | |
| download | linhes_pkgbuild-09c491757cc31cc4b44967f4df50b56a06b218c3.zip linhes_pkgbuild-09c491757cc31cc4b44967f4df50b56a06b218c3.tar.gz linhes_pkgbuild-09c491757cc31cc4b44967f4df50b56a06b218c3.tar.bz2 | |
linhes-dev: mp.py: use updpkgsums to replace sums
Diffstat (limited to 'linhes/linhes-system/optimize_mythdb.py')
| -rwxr-xr-x | linhes/linhes-system/optimize_mythdb.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/linhes/linhes-system/optimize_mythdb.py b/linhes/linhes-system/optimize_mythdb.py new file mode 100755 index 0000000..7d60e89 --- /dev/null +++ b/linhes/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) |