RE: UPDATE_TIME for InnoDB in MySQL 5.7

2013-06-25 Thread Rick James
Yeah, why not flush them to disk on a clean shutdown, and periodically before that? > -Original Message- > From: Dotan Cohen [mailto:dotanco...@gmail.com] > Sent: Sunday, June 23, 2013 10:39 AM > To: mysql. > Subject: UPDATE_TIME for InnoDB in MySQL 5.7 > > Th

UPDATE_TIME for InnoDB in MySQL 5.7

2013-06-23 Thread Dotan Cohen
The MySQL 5.7 changelog mentions: "Beginning with MySQL 5.7.2, UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or DELETE performed on InnoDB tables. Previously, UPDATE_TIME displayed a NULL value for InnoDB tables. For MVCC, the timestamp value reflects the COMMIT time, which is