<br><br><div class="gmail_quote">On Sun, Mar 28, 2010 at 1:53 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 class="im"><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>
<br>
</div>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>
<div class="im"><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>
<br>
</div>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>
<font color="#888888"><br>
<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>I understand. What alternative would you suggest?<br>