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 drwx------ 2 mysql mysql 4096 Nov 5 2006 . drwxr-xr-x 13 mysql mysql 4096 Jun 11 01:07 .. -rw-rw---- 1 mysql mysql 65 Mar 4 2006 db.opt -rw-rw---- 1 mysql mysql 8940 Nov 5 2006 loge.frm -rw-rw---- 1 mysql mysql 2359444 Jun 11 11:47 loge.MYD -rw-rw---- 1 mysql mysql 105472 Jun 11 11:47 loge.MYI -rw-rw---- 1 mysql mysql 9322 Nov 5 2006 resv.frm -rw-rw---- 1 mysql mysql 5146108 Nov 5 2006 resv.MYD -rw-rw---- 1 mysql mysql 160768 Nov 6 2006 resv.MYI -rw-rw---- 1 mysql mysql 8948 Nov 5 2006 rscs.frm -rw-rw---- 1 mysql mysql 1944 Nov 20 2006 rscs.MYD -rw-rw---- 1 mysql mysql 2048 Nov 21 2006 rscs.MYI -rw-rw---- 1 mysql mysql 9178 Nov 5 2006 sess.frm -rw-rw---- 1 mysql mysql 904 Jun 8 01:01 sess.MYD -rw-rw---- 1 mysql mysql 2048 Jun 8 01:04 sess.MYI -rw-rw---- 1 mysql mysql 9930 Nov 5 2006 usrs.frm -rw-rw---- 1 mysql mysql 109464 Jun 5 15:58 usrs.MYD -rw-rw---- 1 mysql mysql 8192 Jun 5 20:02 usrs.MYI The atimes or mtimes of the files may give you some information. Dave. 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