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

Reply via email to