Re: InnoDB Partition Statistics

[David Ishmael]

I have a large table of records partitioned by a date field, specifically by the month the record is created. However, the records could be updated throughout the year. Right now, I use a script to parse each partition to see the last date a record was updated on each partition.

[pseudocode]
for Partition p in Partitions do
date = select max(lastoccurrence) from records partitions (p)
if date >= last check then
run additional statistics against p
done
done

This is a non-issue with the MyISAM database engine since it updates the updated field in the information_schema table. Unfortunately the InnoDB engine does not seem to update that field. This leaves me wondering how others are acquiring partition statistics, specifically the last time a partition was updated.