<br><div class="gmail_quote">On Sun, Mar 28, 2010 at 2:04 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;">
Neeraj Agarwal a écrit :<br>
<div><div></div><div class="h5">> On Sun, Mar 28, 2010 at 1:53 AM, Marc Delisle <<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>> wrote:<br>
><br>
>> Neeraj Agarwal a écrit :<br>
>><br>
>>>>> Can use fopen() to read through the logs and generate data.<br>
>>>> 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>
>>>><br>
>>> No, not an external project. In the PMA package itself, we can read and<br>
>>> scan the MySQL logs and get our data.<br>
>> How? you only have access to data that the web server itself has access.<br>
>> Also, the web server can be on a different machine than the MySQL<br>
>> server, how do you fopen() that?<br>
>><br>
>>><br>
>>>> ><br>
>>>>> Or I think the way of creating a separate PHP library which can capture<br>
>>>> all<br>
>>>>> data upto a certain extent would do it too. We will anyway have to<br>
>>>> maintain<br>
>>>>> the data to build the graphs.<br>
>>>> 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>
>>>><br>
>>> All the user's code would be calling this PHP library in order for us to<br>
>>> capture the data. As its done with many different CMS which reports SQL<br>
>>> stats to administrator for diagnosis basis.<br>
>> You cannot ask developers of all apps running on a server to modify<br>
>> their apps in order to capture and store statistical data! This is just<br>
>> not practical and would work in a limited number of situations.<br>
>><br>
>><br>
>> --<br>
>> Marc Delisle<br>
>> <a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
><br>
</div></div><div class="im">> I understand. What alternative would you suggest?<br>
<br>
</div>I don't see any way we can show historic data (except limited historic<br>
data that would be captured and stored only via phpMyAdmin but I doubt<br>
this is useful). </blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Anyway, other tools like Cacti exist just for this purpose. See Baron's<br>
templates at<br>
<a href="http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for-mysql/" target="_blank">http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for-mysql/</a><br></blockquote><div>Many people uses phpMyAdmin so if we build the functionality into this then it would be great. <br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
So, we are now oriented to generate graphs only for current status,<br>
aren't we?<br></blockquote><div>I will try to think of something more and let you know until that we are left with current system status. We can generate excellent graphs using GD2 library as well as using JS to make it more rich.<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<font color="#888888"><br>
--<br>
</font><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>