smtc0097 / mysql-cacti-templates

Automatically exported from code.google.com/p/mysql-cacti-templates
GNU General Public License v2.0
0 stars 0 forks source link

Graph Mysql user wise resource usage stats available from googles user statistics patch #117

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
References : 

1. http://ourdelta.org/docs/userstats
2.
http://www.mysqlperformanceblog.com/2008/08/04/userstats-patches-with-informatio
n-schema/

Might be challenging if the Mysql database has 1000's of users 

Original issue reported on code.google.com by dushya...@gmail.com on 5 Jan 2010 at 12:07

GoogleCodeExporter commented 8 years ago
* request type is enhancement - chose defect by mistake ;)

Original comment by dushya...@gmail.com on 5 Jan 2010 at 12:09

GoogleCodeExporter commented 8 years ago
Please define how you'd like the graphs to be.  Which statistics do you want to
graph, and how do you want to display them?

As a note, I think this will be nearly impossible to do with Cacti, which 
requires
fixed definitions up-front.  For example, if you have 5 different users on your
system, then you have to create a set of graphs for each user.  There is 
something
called a data query, but that is an unworkable mess, which is why you don't see 
many
templates that use it.  I've looked at it and I have no desire to try to 
program for it.

Original comment by baron.schwartz on 21 Mar 2010 at 3:49

GoogleCodeExporter commented 8 years ago
Thanks for the response. We realized that its not possible with cacti and made 
our
own polling daemon to update RRDs per user and create graphs out of it. 

Original comment by dushya...@gmail.com on 23 Mar 2010 at 8:59

GoogleCodeExporter commented 8 years ago

Original comment by baron.schwartz on 23 Mar 2010 at 10:18