MySQL Forums
Forum List  »  InnoDB

create_time value is incorrect from information_schema.tables
Posted by: D BA
Date: August 28, 2019 02:19AM

Hello,

We have a 5 MySQL databases (5.7.26-0ubuntu0.18.04.1-log) on Production for our Drupal websites.
We have 1 MySQL Master and 4 MySQL Slaves.

When I check the table creation time from information_schema.tables, I have strange value.
For example, I created a database db1 yesterday (2019-08-27) at 15:00 on Master with the Drupal schema (including the table webform_submission_log in InnoDB).
Database was created on slaves automatically.

Today, when I checked information_schema.tables the create_time of db1.webform_submission_log, It's now 2019-08-28 01:00:53.

From MySQL documentation, create_time column is describe as "When the table was created."
https://dev.mysql.com/doc/refman/5.7/en/tables-table.html

I still have table create_time to yesterday date on table of other databases(create 1 month ago...). I suppose I can exclude mysqldump operation.
Drupal users don't have privilege on the db1 database.

Someone know about this problem ? is-it a bug ?

regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
create_time value is incorrect from information_schema.tables
65
August 28, 2019 02:19AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.