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&#174; 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