On Sun, Mar 28, 2010 at 4:13 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 4:04 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On the "Runtime Information" page, we have records of the number of
queries
processed like "select", "update", etc so we can store this information somewhere and generate graphs based on this data?
This page sends SHOW GLOBAL STATUS and the server returns the exact number of each command it has received at this point, for example
Com_select 15897667
But SHOW GLOBAL STATUS is sent from phpMyAdmin when someone looks at this page. It's a web page, triggered by a human so we cannot predict at which point in time phpMyAdmin would be invoked, to generate/store the current stats.
We can have a cron job installed.
I know, but isn't this outside the scope of phpMyAdmin? I mean, not everyone has this level of access to his server, and not all servers support cron anyway (might be a non-Linux server).
Most of the hosting providers provide cron support and we can ask the user to set it up for us if he wants to enjoy this feature and I guess he will do that for the extra benefits he get! After all everybody needs diagnostics.
I cannot forbid you to put this in your proposal, though :)
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel