> What kind of values do you want charted? Have you looked at the binlogs to
> see what is available? What you want to chart may not be part of the
> actual data so you may want to expand your search to the general log file
> as well. If you want database statistics, those are available through the
> SHOW VARIABLES command. A performance monitoring app would need to poll
> the server at specified periods to check on the progress of certain
> variables in order to build a graph of running performance based on the
> values presented by SHOW VARIABLES.
>
> What I am getting at: you didn't say what you want charted so we have no
> idea what can provide you with the charts you want. There may be some
> existing performance monitoring tools for MySQL but we can't know if they
> might meet your needs or not.
thanks for the fast answer.
i think i use cacti for now.
i found some templates for MySQL:
- memory usage
- command stats (interesting)
- connections
- handler stats: read rnd/next/first/key/prev, delete, update and
write (neat :) )
- querycache stats
- questions
- thread stats
- traffic
the only thing missing is avg exec time per sql command as far as i
see. i think you can only get it via the binary logfile.
f.e.: you parse the logfile for SELECTs and calc the avg exec time.
i don't think cacti can do this in realtime, maybe it will work for
old logfiles. i'll have a look at the cacti mysql scripts.
well you could expand this and show what query on what table took
how many seconds andsoon andsoon.
well the problem that brought me to this stats-thing is:
i have a lot of "read rnd"s and "read rnd next"s since thuesday...
which means im doing a lot of table scans and sorting without keys.
and i've NO IDEA why this happens now
best regards chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
