Re^2: Get timestamp of last modify of MySQL table

Thank you. This brought me to the solution:

my $sql = "SELECT UPDATE_TIME FROM information_schema.tables WHERE TAB
+LE_NAME = 'name_of_table'";
[download]

Comment on Re^2: Get timestamp of last modify of MySQL table Download Code

Replies are listed 'Best First'.
Re^3: Get timestamp of last modify of MySQL table by perlfan (Parson) on Mar 10, 2022 at 15:40 UTC
Beware, > Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache. And given that file time stamps (on the system) are unreliable and fragile, I suggest if there is a "time" you want to track reliably/correctly and precision is not a priority, using time stamp fields in your tables is going to give you the best and most reliable result.	[reply]

Replies are listed 'Best First'.

Re^3: Get timestamp of last modify of MySQL table
by perlfan (Parson) on Mar 10, 2022 at 15:40 UTC

> Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache.

And given that file time stamps (on the system) are unreliable and fragile, I suggest if there is a "time" you want to track reliably/correctly and precision is not a priority, using time stamp fields in your tables is going to give you the best and most reliable result.

[reply]