I have been offering free hosting of MySQL databases at freesql.org for the
last few weeks. As a result I now have several hundred databases (which I
think is great!), with a subset (perhaps 50) that are in active use. I
would like to implement a policy where I can cull dormant or otherwise
abandoned databases. Empty ones are easy, I can check the file dates in
~/mysql/data/whatever, and delete if there are no tables after 30 days or
so. Databases with empty tables are similarly easy too.
My problem is the case where a user creates a database, creates a table and
adds data. I did not realise that the file date reported by ls -l is not
updated unless the user inserts or updates. If the user has relatively
static data and is only using selects, then that date will remain "old" and
thus I cannot trust it to identify unused databases.
What is the best (or a better) way to identify these abandoned databases?
Each database has exactly one authorized user so I was considering starting
mysqld with --log, and then writing a script to parse the logfile, but that
seems inelegant. Is there an easier way to identify the last time a user
connected to a database?
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
