python
MySQL check & repair script
Submitted by vladimir on Sat, 08/01/2009 - 11:17Recommended to run after every forced shutdown and periodically. Especially useful for large number of databases with MyISAM tables.
Requires: Python 2.x and MySQLdb (mysql python module)
#!/usr/bin/env python ######################################### # Check all tables in all mysql databases # # Written by Vladimir Rusinov <vladimir@greenmice.info>, http://greenmice.info/ # # Reqirements: # Python 2.x (tested with 2.4) # MySQLdb ######################################### # Settings: host="localhost" username="root" password=""
РусскийFortune #003
Submitted by vladimir on Sat, 04/18/2009 - 23:00One of my favorite quotes:
If the implementation is hard to explain, it's a bad idea.
If the implementation is easy to explain, it may be a good idea.
/Tim Peters, "The Zen of Python"/
CAFS
Submitted by vladimir on Tue, 12/23/2008 - 12:36CAFS is a read-only fuse filesystem, which works as a caching middleware above any other (local or remote) filesystem (e.g. sftp, samba, webdav). CAFS can also work in offline mode, when source fs is not accessible.
News
12 Feb 2008
CAFS trac is now available.
20 Dec 2008
Version 0.0.6: minor additions, setup.py fix
English