Hello.
I am looking at the MySQL documentation and the column definitions for the
FILES table in the Information Schema. Can you please provide a more
detailed description of what a new storage engine is to provide for the
following columns?
UPDATE_COUNT - This is the total count of all update operations performed
on the file....correct?
CREATION_TIME - This is the date and time that the file was created. What
is the difference between this field and the CREATE_TIME field? What is
the description of the CREATE_TIME field?
LAST_UPDATE_TIME - This is the date and time when the file was last
modified. What is the difference between this field and the UPDATE_TIME
field? What is the description of the UPDATE_TIME field?
RECOVER_TIME - What is the description of this field?
TRANSACTION_COUNTER - What is the description of this field? What
operations should be included in the count?
INDEX_LENGTH - What is expected for this field? A file may have more than
one index.
CHECK_TIME - Is this the last time that the file was checked for damage
and/or repairs, or what is the description of this field?
Thank you!
Kathy Steinbrink
Dept 45X - DB2 for i5/OS
IBM Rochester: 015-3 B201
507-253-5545
