MySQL - determine last date of shutdown and analyze

------=_NextPart_000_00B7_01CA561E.F3454050
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all





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.



Can someone please assist in this and let me know if this is
possible.



Your assistance is appreciated.





Regards

Machiel


------=_NextPart_000_00B7_01CA561E.F3454050--

Re: MySQL - determine last date of shutdown and analyze

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@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org