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. After some time there may be one for each day, week or size interval. This file, 'mysql-query.log' shows all queries and can be opened, cat'd, tailed, etc. Using the query log impacts performance, comment out the line and restart mysql when you're done. Link to the mysql doc: http://dev.mysql.com/doc/refman/5.0/en/query-log.html -sean On 6/11/07, Keith Murphy <[EMAIL PROTECTED]> wrote:
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 Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877
