[Phpmyadmin-devel] GSoC 2010 : Charts in server status page

[Marc Delisle]

Neeraj Agarwal a écrit :
> On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle <marc at infomarc.info> wrote:
> 
>> Neeraj Agarwal a écrit :
>>> On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle <marc at 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.

-- 
Marc Delisle
http://infomarc.info