Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and then provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
-- Marc Delisle http://infomarc.info
Hi,
We can access the MySQL log?
You mean the binary log? http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log
If you find a way to do that via a command sent from mysqli_query() or mysql_query(), tell me.