List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 26 2009 2:50pm
Subject:Re: MySQL - determine last date of shutdown and analyze
View as plain text  
In the last episode (Oct 26), machiel.richards said:
>    I hope someone can help me out here as I am still new with MySQL.
> 
>     I am trying to determine when last a MySQL database was shut down and
> when last the tables were analyzed.

The server logs startups and shutdowns in the mysqld error logfile (in your
data directory, it's the only file ending in .err).  I don't think any of
the storage engines keep track of when the last analyze was done, though.

-- 
	Dan Nelson
	dnelson@stripped
Thread
MySQL - determine last date of shutdown and analyzemachiel.richards26 Oct
  • Re: MySQL - determine last date of shutdown and analyzeDan Nelson26 Oct