Hello Everyone,
I have been using phpMyAdmin a lot for my development work on PHP/ MySQL and it really fascinates. It creates such a simple interface for regular people to manage their database.
I very much liked the idea of server status page for PMA.
Using GD2 library (PHP) would be the most convenient option.
We can build graphs for volumes, errors, traffic inflows, server downtime due to high volume, highlight server alerts, breakdown, etc
Anybody here to discuss the idea?
------ Regards, Neeraj Agarwal
Neeraj Agarwal a écrit :
Hello Everyone,
I have been using phpMyAdmin a lot for my development work on PHP/ MySQL and it really fascinates. It creates such a simple interface for regular people to manage their database.
I very much liked the idea of server status page for PMA.
Using GD2 library (PHP) would be the most convenient option.
We can build graphs for volumes, errors, traffic inflows, server downtime due to high volume, highlight server alerts, breakdown, etc
Anybody here to discuss the idea?
Regards, Neeraj Agarwal
Hi, do you plan to display graphs for only the current server status or for historic data?
Hi,
We should have both the current status and historic data upto a user defined date.
------ Regards, Neeraj Agarwal
On Sat, Mar 27, 2010 at 11:24 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Hello Everyone,
I have been using phpMyAdmin a lot for my development work on PHP/ MySQL
and
it really fascinates. It creates such a simple interface for regular
people
to manage their database.
I very much liked the idea of server status page for PMA.
Using GD2 library (PHP) would be the most convenient option.
We can build graphs for volumes, errors, traffic inflows, server downtime due to high volume, highlight server alerts, breakdown, etc
Anybody here to discuss the idea?
Regards, Neeraj Agarwal
Hi, do you plan to display graphs for only the current server status or for historic data?
-- 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
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user defined date.
Regards, Neeraj Agarwal
Please ... I'm allergic to top-posting ...
How do you plan to collect this historic data?
On Sat, Mar 27, 2010 at 11:24 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Hello Everyone,
I have been using phpMyAdmin a lot for my development work on PHP/ MySQL
and
it really fascinates. It creates such a simple interface for regular
people
to manage their database.
I very much liked the idea of server status page for PMA.
Using GD2 library (PHP) would be the most convenient option.
We can build graphs for volumes, errors, traffic inflows, server downtime due to high volume, highlight server alerts, breakdown, etc
Anybody here to discuss the idea?
Regards, Neeraj Agarwal
Hi, do you plan to display graphs for only the current server status or for historic data?
-- 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
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
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined
date.
Regards, Neeraj Agarwal
Please ... I'm allergic to top-posting ...
How do you plan to collect this historic data?
On Sat, Mar 27, 2010 at 11:24 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Hello Everyone,
I have been using phpMyAdmin a lot for my development work on PHP/
MySQL
and
it really fascinates. It creates such a simple interface for regular
people
to manage their database.
I very much liked the idea of server status page for PMA.
Using GD2 library (PHP) would be the most convenient option.
We can build graphs for volumes, errors, traffic inflows, server
downtime
due to high volume, highlight server alerts, breakdown, etc
Anybody here to discuss the idea?
Regards, Neeraj Agarwal
Hi, do you plan to display graphs for only the current server status or for historic data?
-- 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
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
-- 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
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and then provide analytics on historical data.
------ Regards, Neeraj Agarwal
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined
How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and then provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined
How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and then provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
-- 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
Hi,
We can access the MySQL log?
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and then provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
-- Marc Delisle http://infomarc.info
Hi,
We can access the MySQL log?
You mean the binary log? http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log
If you find a way to do that via a command sent from mysqli_query() or mysql_query(), tell me.
On Sun, Mar 28, 2010 at 12:59 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Hi,
We should have both the current status and historic data upto a user
defined How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and
then
provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
-- Marc Delisle http://infomarc.info
Hi,
We can access the MySQL log?
You mean the binary log? http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log
If you find a way to do that via a command sent from mysqli_query() or mysql_query(), tell me.
-- 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
Hi,
We can use one of the many logs available here: http://dev.mysql.com/doc/refman/4.1/en/server-logs.html
Can use fopen() to read through the logs and generate data.
Or I think the way of creating a separate PHP library which can capture all data upto a certain extent would do it too. We will anyway have to maintain the data to build the graphs.
And the user might turn it off or on as per his wish as and whenever needed for diagnose basis.
Thanks
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:59 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit : > Hi, > > We should have both the current status and historic data upto a user defined How do you plan to collect this historic data?
Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and
then
provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit of generating historic data. Not mentionning the huge overhead.
-- Marc Delisle http://infomarc.info
Hi,
We can access the MySQL log?
You mean the binary log? http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log
If you find a way to do that via a command sent from mysqli_query() or mysql_query(), tell me.
Hi,
We can use one of the many logs available here: http://dev.mysql.com/doc/refman/4.1/en/server-logs.html
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
Or I think the way of creating a separate PHP library which can capture all data upto a certain extent would do it too. We will anyway have to maintain the data to build the graphs.
I don't get your point. What would be calling this PHP library in order to capture this data? You mean all data passing through phpMyAdmin? This does not reflect the complete server activity.
And the user might turn it off or on as per his wish as and whenever needed for diagnose basis.
Thanks
On Sun, Mar 28, 2010 at 1:30 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:59 AM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 12:38 AM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
On Sat, Mar 27, 2010 at 11:41 PM, Marc Delisle marc@infomarc.info
wrote:
> Neeraj Agarwal a écrit : >> Hi, >> >> We should have both the current status and historic data upto a
user
> defined > How do you plan to collect this historic data? Hi
We can create triggers for each query which can make up our database.
Or can create a library which the user can add to their scripts and
then
provide analytics on historical data.
Both suggestions are IMO difficult to implement, just for the benefit
of
generating historic data. Not mentionning the huge overhead.
-- Marc Delisle http://infomarc.info
Hi,
We can access the MySQL log?
You mean the binary log? http://forge.mysql.com/wiki/MySQL_Internals_Binary_Log
If you find a way to do that via a command sent from mysqli_query() or mysql_query(), tell me.
Hi,
We can use one of the many logs available here: http://dev.mysql.com/doc/refman/4.1/en/server-logs.html
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
No, not an external project. In the PMA package itself, we can read and
scan the MySQL logs and get our data.
Or I think the way of creating a separate PHP library which can capture
all
data upto a certain extent would do it too. We will anyway have to
maintain
the data to build the graphs.
I don't get your point. What would be calling this PHP library in order to capture this data? You mean all data passing through phpMyAdmin? This does not reflect the complete server activity.
All the user's code would be calling this PHP library in order for us to
capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.
And the user might turn it off or on as per his wish as and whenever
needed
for diagnose basis.
Thanks
-- 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
Neeraj Agarwal a écrit :
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
No, not an external project. In the PMA package itself, we can read and scan the MySQL logs and get our data.
How? you only have access to data that the web server itself has access. Also, the web server can be on a different machine than the MySQL server, how do you fopen() that?
Or I think the way of creating a separate PHP library which can capture
all
data upto a certain extent would do it too. We will anyway have to
maintain
the data to build the graphs.
I don't get your point. What would be calling this PHP library in order to capture this data? You mean all data passing through phpMyAdmin? This does not reflect the complete server activity.
All the user's code would be calling this PHP library in order for us to capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.
You cannot ask developers of all apps running on a server to modify their apps in order to capture and store statistical data! This is just not practical and would work in a limited number of situations.
On Sun, Mar 28, 2010 at 1:53 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
No, not an external project. In the PMA package itself, we can read and scan the MySQL logs and get our data.
How? you only have access to data that the web server itself has access. Also, the web server can be on a different machine than the MySQL server, how do you fopen() that?
Or I think the way of creating a separate PHP library which can capture
all
data upto a certain extent would do it too. We will anyway have to
maintain
the data to build the graphs.
I don't get your point. What would be calling this PHP library in order to capture this data? You mean all data passing through phpMyAdmin? This does not reflect the complete server activity.
All the user's code would be calling this PHP library in order for us to capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.
You cannot ask developers of all apps running on a server to modify their apps in order to capture and store statistical data! This is just not practical and would work in a limited number of situations.
-- 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
I understand. What alternative would you suggest?
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 1:53 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
No, not an external project. In the PMA package itself, we can read and scan the MySQL logs and get our data.
How? you only have access to data that the web server itself has access. Also, the web server can be on a different machine than the MySQL server, how do you fopen() that?
Or I think the way of creating a separate PHP library which can capture
all
data upto a certain extent would do it too. We will anyway have to
maintain
the data to build the graphs.
I don't get your point. What would be calling this PHP library in order to capture this data? You mean all data passing through phpMyAdmin? This does not reflect the complete server activity.
All the user's code would be calling this PHP library in order for us to capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.
You cannot ask developers of all apps running on a server to modify their apps in order to capture and store statistical data! This is just not practical and would work in a limited number of situations.
-- Marc Delisle http://infomarc.info
I understand. What alternative would you suggest?
I don't see any way we can show historic data (except limited historic data that would be captured and stored only via phpMyAdmin but I doubt this is useful).
Anyway, other tools like Cacti exist just for this purpose. See Baron's templates at http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for...
So, we are now oriented to generate graphs only for current status, aren't we?
On Sun, Mar 28, 2010 at 2:04 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
On Sun, Mar 28, 2010 at 1:53 AM, Marc Delisle marc@infomarc.info
wrote:
Neeraj Agarwal a écrit :
Can use fopen() to read through the logs and generate data.
You are thinking about a process external to phpMyAdmin here, I guess. This is not in the scope of the GSoC projects for phpMyAdmin.
No, not an external project. In the PMA package itself, we can read and scan the MySQL logs and get our data.
How? you only have access to data that the web server itself has access. Also, the web server can be on a different machine than the MySQL server, how do you fopen() that?
Or I think the way of creating a separate PHP library which can
capture
all
data upto a certain extent would do it too. We will anyway have to
maintain
the data to build the graphs.
I don't get your point. What would be calling this PHP library in
order
to capture this data? You mean all data passing through phpMyAdmin?
This
does not reflect the complete server activity.
All the user's code would be calling this PHP library in order for us
to
capture the data. As its done with many different CMS which reports SQL stats to administrator for diagnosis basis.
You cannot ask developers of all apps running on a server to modify their apps in order to capture and store statistical data! This is just not practical and would work in a limited number of situations.
-- Marc Delisle http://infomarc.info
I understand. What alternative would you suggest?
I don't see any way we can show historic data (except limited historic data that would be captured and stored only via phpMyAdmin but I doubt this is useful).
Anyway, other tools like Cacti exist just for this purpose. See Baron's templates at
http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for...
Many people uses phpMyAdmin so if we build the functionality into this then it would be great.
So, we are now oriented to generate graphs only for current status, aren't we?
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.
-- 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
Neeraj Agarwal wrote:
On Sun, Mar 28, 2010 at 2:04 AM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Neeraj Agarwal a écrit : > On Sun, Mar 28, 2010 at 1:53 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote: > >> Neeraj Agarwal a écrit : >> >>>>> Can use fopen() to read through the logs and generate data. >>>> You are thinking about a process external to phpMyAdmin here, I guess. >>>> This is not in the scope of the GSoC projects for phpMyAdmin. >>>> >>> No, not an external project. In the PMA package itself, we can read and >>> scan the MySQL logs and get our data. >> How? you only have access to data that the web server itself has access. >> Also, the web server can be on a different machine than the MySQL >> server, how do you fopen() that? >> >>> >>>> > >>>>> Or I think the way of creating a separate PHP library which can capture >>>> all >>>>> data upto a certain extent would do it too. We will anyway have to >>>> maintain >>>>> the data to build the graphs. >>>> I don't get your point. What would be calling this PHP library in order >>>> to capture this data? You mean all data passing through phpMyAdmin? This >>>> does not reflect the complete server activity. >>>> >>> All the user's code would be calling this PHP library in order for us to >>> capture the data. As its done with many different CMS which reports SQL >>> stats to administrator for diagnosis basis. >> You cannot ask developers of all apps running on a server to modify >> their apps in order to capture and store statistical data! This is just >> not practical and would work in a limited number of situations. >> >> >> -- >> Marc Delisle >> http://infomarc.info > > I understand. What alternative would you suggest? I don't see any way we can show historic data (except limited historic data that would be captured and stored only via phpMyAdmin but I doubt this is useful). Anyway, other tools like Cacti exist just for this purpose. See Baron's templates at http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for-mysql/Many people uses phpMyAdmin so if we build the functionality into this then it would be great.
So, we are now oriented to generate graphs only for current status, aren't we?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.
Having read the discussion I fully agree with Marc that graphing historic data poses a serious problem. Making pma keep track of ongoing activity would duplicate way too much from tools like cacti and nagios.
The next best thing might be something like the mytop utility. It would keep polling the database to store its data in session or javascript variables.
Something Martynas suggested is to present charts for query results. The definition of such a graph could be stored in the pmadb.
-
Herman van Rink -
Marc Delisle -
Neeraj Agarwal