in reply to Get timestamp of last modify of MySQL table

maybe have a look at https://mariadb.com/kb/en/myisam-log/ ?

edit

I remember seeing meta-tables with extensive schema information. You should have a look there.

Like UPDATE_TIME in https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html

No guaranty, sorry.

This is not really a Perl question ...

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery

Replies are listed 'Best First'.
Re^2: Get timestamp of last modify of MySQL table
by Anonymous Monk on Mar 05, 2022 at 21:59 UTC

    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]
[reply]
[d/l]
      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]

In Section Seekers of Perl Wisdom