Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 37

Displaying posts with tag: cacti (reset)

Agent vs agent-less monitoring
Employee +0 Vote Up -0Vote Down

Baron posted something interesting about agent vs agent-less monitoring in response to Rob.

While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.

I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?

Trivially, you need some piece of software to collect data. With …

  [Read more...]
MySQL Cacti templates 1.0.0 released
+0 Vote Up -0Vote Down

I just uploaded the 1.0.0 release of my MySQL templates for Cacti. Now there’s an actual download under the Downloads tab. I solved a number of issues in this release. The changelog:

2008-06-01: version 1.0.0

        * Fixed when SHOW MASTER LOGS has no File_size column.
        * Fixed Cacti-version-specific problems with include files.
        * Fixed when binary log is not enabled.
        * Fixed some caching issues.
        * Fixed issues when downloaded from SVN.
        * Replication graph shows only slave_lag instead of Seconds_behind_master
        * …
  [Read more...]
Screenshots of improved MySQL Cacti templates
+0 Vote Up -0Vote Down

I finally have some images to show you what my improved Cacti templates look like.

These aren’t a perfect demo, since for example this server doesn’t have the query cache enabled, but it should show you what I’ve done. Note, for example, that each graph is labeled with the actual values of the images drawn on it. You don’t have to guess what the values are by squinting at the graphs.

You can click on any image to go to a larger version. Enjoy:

  [Read more...]
Improved Cacti monitoring templates for MySQL
+0 Vote Up -0Vote Down

Download MySQL Cacti templates

As promised, I’ve created some improved software for monitoring MySQL via Cacti. I began using the de facto MySQL Cacti templates a while ago, but found some things I needed to improve about them. As time passed, I rewrote everything from scratch. The resulting templates are much improved.

You can grab the templates by browsing the source repository on the project’s homepage.

  [Read more...]
MySQL Conference Liveblogging: Monitoring Tools (Wednesday 5:15PM)
+0 Vote Up -0Vote Down
  • Tom Hanlon of MySQL presents
  • monitoring tool basics
  • basic tools
    • mysqladmin is provided with the server
      • mysqladmin -i 10 extended status: will repeat the same command every 10 seconds. Pipe through grep "and smoke it" (bad pun, hah hah)
      • -r: show only changed values
    • MySQL Administrator
  • cacti …
  [Read more...]
What?s the best way to choose graph colors?
+0 Vote Up -0Vote Down

I have an issue I hope someone can help me with. I am generating RRDtool graphs (for Cacti monitoring templates for MySQL, which I’ll release soon) that have up to 11 different metrics on them. With that many lines or areas on a graph, it becomes very hard to pick colors that are easy to see and easy to distinguish from each other. What’s a good way to choose such colors? Is there a way to do it automatically — is there a formal method that will produce good results?

I know some color theory and I have read about how you can …

  [Read more...]
Useful Cacti Templates to Monitor Your Servers
+0 Vote Up -0Vote Down

Recently I had one customer for consulting and aside from mysql optimization, etc they asked me for cacti installation/setup to monitor their pretty generic LAMP application. I’ve started setting up all this stuff and I’ve never thought it could be so painful… lots of different templates for the same tasks, all of them are incompatible with recent cacti releases, etc, etc… So, this post is generally a list of used templates …

  [Read more...]
10 Newer Entries Showing entries 31 to 37

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.