<br><br><div class="gmail_quote">On Sun, Mar 28, 2010 at 1:30 AM, Marc Delisle <span dir="ltr"><<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5">Neeraj Agarwal a écrit :<br>
> On Sun, Mar 28, 2010 at 12:59 AM, Marc Delisle <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>> wrote:<br>
><br>
>> Neeraj Agarwal a écrit :<br>
>>> On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>><br>
>> wrote:<br>
>>>> Neeraj Agarwal a écrit :<br>
>>>>> On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>><br>
>>>> wrote:<br>
>>>>>> Neeraj Agarwal a écrit :<br>
>>>>>>> Hi,<br>
>>>>>>><br>
>>>>>>> We should have both the current status and historic data upto a user<br>
>>>>>> defined<br>
>>>>>> How do you plan to collect this historic data?<br>
>>>>> Hi<br>
>>>>><br>
>>>>> We can create triggers for each query which can make up our database.<br>
>>>>><br>
>>>>> Or can create a library which the user can add to their scripts and<br>
>> then<br>
>>>>> provide analytics on historical data.<br>
>>>> Both suggestions are IMO difficult to implement, just for the benefit of<br>
>>>> generating historic data. Not mentionning the huge overhead.<br>
>>>><br>
>>>> --<br>
>>>> Marc Delisle<br>
>>>> <a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
>>>><br>
>>> Hi,<br>
>>><br>
>>> We can access the MySQL log?<br>
>> You mean the binary log?<br>
>> <a href="http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log" target="_blank">http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log</a><br>
>><br>
>> If you find a way to do that via a command sent from mysqli_query() or<br>
>> mysql_query(), tell me.<br>
<br>
><br>
</div></div><div class="im">> Hi,<br>
><br>
> We can use one of the many logs available here:<br>
> <a href="http://dev.mysql.com/doc/refman/4.1/en/server-logs.html" target="_blank">http://dev.mysql.com/doc/refman/4.1/en/server-logs.html</a><br>
><br>
> Can use fopen() to read through the logs and generate data.<br>
<br>
</div>You are thinking about a process external to phpMyAdmin here, I guess.<br>
This is not in the scope of the GSoC projects for phpMyAdmin.<br>
<div class="im"><br></div></blockquote><div>No, not an external project. In the PMA package itself, we can read and scan the MySQL logs and get our data.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">
><br>
> Or I think the way of creating a separate PHP library which can capture all<br>
> data upto a certain extent would do it too. We will anyway have to maintain<br>
> the data to build the graphs.<br>
<br>
</div>I don't get your point. What would be calling this PHP library in order<br>
to capture this data? You mean all data passing through phpMyAdmin? This<br>
does not reflect the complete server activity.<br>
<div class="im"><br></div></blockquote><div>All the user's code would be calling this PHP library in order for us to capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
><br>
> And the user might turn it off or on as per his wish as and whenever needed<br>
> for diagnose basis.<br>
><br>
> Thanks<br>
<br>
<br>
</div>--<br>
<div><div></div><div class="h5">Marc Delisle<br>
<a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
<br>
------------------------------------------------------------------------------<br>
Download Intel® Parallel Studio Eval<br>
Try the new software tools for yourself. Speed compiling, find bugs<br>
proactively, and fine-tune applications for parallel performance.<br>
See why Intel Parallel Studio got high marks during beta.<br>
<a href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</div></div></blockquote></div><br>