Re: MySQL last table alteration time

[Steve Alligood]

Please be aware that most of the versions of mysql 5 have a bug with the information_schema view that causes major performance degradation when you use it with a "large amounts of data" or "a lot of tables". This could be a couple hundred tables or even a couple hundred MB of data

http://bugs.mysql.com/bug.php?id=19588

small databases are probably fine.

-Steve

Ryan Simpkins wrote:

On Tue, March 27, 2007 16:12, Dave Smith wrote:

Does MySQL provide a way to query the last time a table's data was
changed (i.e., insert, delete, or update)? Preferably, I'd like to
execute an SQL statement to get the information. I realize I could go
look at the .frm files on disk, but I may not have local access to the
MySQL server.

You might take a look at this:

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

If you are using v5 you can also likely use the information_schema view.

-Ryan

/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/

smime.p7s
Description: S/MIME Cryptographic Signature

/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/