Keith,
The definitive way is to turn on the query log and watch it for a few days
or weeks.
In your my.cnf under [mysqld] add the line:
log=mysql-query
Then restart your server.
In your server's data directory (e.g. /usr/local/mysql/data/), there will
now be a log file called mysql-query.log.
Just speaking as a newbie who has no idea what he is talking about ...
If nobody suggests anything better ...
I've noticed that there is a clear correspondence between table names and
the files that MySQL keeps, i.e.
[EMAIL PROTECTED] dashley]# ls -al /var/lib/mysql/fboprimedevel/
total 7832
dr
I have inherited database servers from a group whose main job was not working
on mysql. I am not certain if all the tables on the databases are being used.
Is there some efficient way of determining if a table is being accessed or when
the last time it was accessed?
Thanks,
Keith
--
Keith
