[Phpmyadmin-devel] GSoC - Server Stats

[Philip Frank]

2010/4/1 Marc Delisle <marc at infomarc.info>:
> Philip Frank a écrit :
>> Hello everyone,
>>
>> I'm a student from Munich, Germany and stumbled across the GSoC Idea
>> of collecting the data that is shown on the server status page and
>> rendering them as graphs over time. I will apply in the next days,
>> here is what I thought of implementing when I'm accepted:
>>
>> Data collection: In the past, I used rrdtool to collect stats on a
>> server. Its datastore has a limited size - over time old entries get
>> merged together and the data gets thinner, but is never completely
>> deleted. Unfortunately, it is not very portable. Therefor, I would
>> implement a similarily behaving datastore ontop of a mysql table. I
>> think of storing each set of measures as a row and limit the number of
>> total rows, making room for new entries by combining one pair of
>> neighbouring old entries together.
>
> Hi Philip,
> so you plan that an external process will collect data? Please have a
> look on this list archives, this was discussed a few days ago.
>

Hi Marc,
i thought the process could be triggered by a cron, but if that is not
an option, historic data can not be collected, i guess. How about a
live monitoring tool? I could create a visualisation of the ratios of
the different query types. Constantly updating that with ajax would be
nice, and maybe even collecting the data in the browser and plotting
graphes.

Philip

>>
>> Plotting: On the ideas page GD is suggeted, but I would prefer to use
>> processing.js, which is a javascript library that draws on a canvas
>> element with a similar usage.
>> To connect to the datastore I would build a json interface for the
>> collected data.
>>
>> Let me know, what you think of it!
>>
>> Best regards,
>> Philip
>
>
>
> --
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>