Re: Is Database active or inactive in mysql
If "active" means "queries within a given period", you could enable the general log (http://dev.mysql.com/doc/refman/5.6/en/query-log.html). It will have a small effect on performance. Though that page fails to say so, you can use the GLOBAL log_output variable to set general log output to TABLE, making the general log accessible to ordinary queries.
Edited 1 time(s). Last edit at 04/08/2013 11:07AM by Peter Brawley.
Subject
Written By
Posted
Re: Is Database active or inactive in mysql
April 08, 2013 10:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.