Thanks for checking this out. However, with InnoDB tables you only get the .frm files under a database directory and these are only modified when you change the definition of a table. The data itself is kept in a big binary file(s) one directory up, whose modification time cannot be used to deduce that a particular database has changed since it must be shared by all databases that have InnoDB table in... unless you only have 1 database with InnoDB tables in! Cheers, Phil
On Sat, 2004-02-07 at 17:41, Brian Reichert wrote: > On Fri, Feb 06, 2004 at 08:18:10PM +0000, Phil wrote: > > Doesn't seem to change the mtime on table files. It appears that for > > InnoDB tables these files are only updated when the definition of a > > table is changed. The content of the all InnoDB tables is kept in one or > > two massive files directly under the 'data' directory! > > At _some_ point your data has to end up on disk. I haven't read > up on the caching that MySQL does. I know you can manually FLUSH > TABLES, but that's of no use to you: you want to passively detect > when the file's changed. > > I just did a one-record update to a test database: > > Before: > > # ls -ld user.* > -rw-rw---- 1 mysql mysql 18168 Dec 22 16:58 user.MYD > -rw-rw---- 1 mysql mysql 20480 Dec 26 18:00 user.MYI > -rw-rw---- 1 mysql mysql 8794 Dec 11 14:20 user.frm > > After: > > # ls -ld user.* > -rw-rw---- 1 mysql mysql 18168 Feb 7 12:33 user.MYD > -rw-rw---- 1 mysql mysql 20480 Feb 7 12:33 user.MYI > -rw-rw---- 1 mysql mysql 8794 Dec 11 14:20 user.frm > > I updated that same record again: > > # ls -ld user.* > -rw-rw---- 1 mysql mysql 18168 Feb 7 12:34 user.MYD > -rw-rw---- 1 mysql mysql 20480 Feb 7 12:34 user.MYI > -rw-rw---- 1 mysql mysql 8794 Dec 11 14:20 user.frm > > This is with MySQL 3.23.58 and MyISAM tables. > > So, in my (very) limited testing; changing a table's content does > promptly correspond to an updated mtime of the data and index > columns. > > I do see that you're using InnoDB tables; I'll try to set another > test environment. > > Good luck, anyway... > > -- > Brian Reichert <[EMAIL PROTECTED]> > 37 Crystal Ave. #303 Daytime number: (603) 434-6842 > Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
