Tag1 Consulting

Performance and Scalability Experts

Cacti Monitoring


Tag1 Consulting Cacti monitoring offers a trouble free, hosted solution to database performance graphing. Our monitoring solution allows you to view historical graphs of many standard and not so standard MySQL performance statistics. This goes beyond just running a tool such as mysqlreport once week. These graphs offer per minute MySQL statistics and allow you to view trends over a week, month or even years.

We are always looking for new monitoring technologies to better assist our clients solve and prevent performance issues. Our consultants have used monitoring such as Cacti for years and view it as an indispensable tool, not just in solving problems after the fact but in preventing them. This type of monitoring is a preventative measure, it allows you solve problems while they are just spikes in the graph and not user impacting service failures.

Authentication

We are always improving our monitoring services. We have developed an in-house solution to integrate the Cacti and Nagios authentication systems with our secure Drupal-powered management console. This means that you can safely maintain a single password with a simple and familiar interface, confident that it is never being sent un-encrypted.

Security

Our monitoring server is consistently updated to the latest security releases, fully firewalled, running RootKit Hunter and Tripwire. It runs only the services needed for Cacti, Nagios and our authentication system. We do not give shell access to anyone but our consultants and we have a strict ssh key only policy for those consultants. Our login pages are SSL protected, to ensure the security of your password.

Cacti Details

Our Cacti instance can graph many MySQL statistics and provide detailed reports. We have the following graphs available:

  • InnoDB Buffer Pool Activity
  • InnoDB Buffer Pool Fill
  • InnoDB IO
  • InnoDB IO Pending
  • InnoDB Insert Buffer
  • InnoDB Log Usage
  • InnoDB Row Operations
  • InnoDB Semaphores
  • InnoDB Transactions
  • MyISAM Indexes
  • Binary/Relay Log Usage
  • Command Counters (SELECTSvsUPDATESvsDELETES)
  • Connections
  • Files and Tables
  • Network Traffic
  • MySQL Processlist
  • Query Cache
  • Query Cache Usage
  • Replication
  • Select Types
  • Sorts
  • Table Locks
  • Temp Tables
  • Threads

See It In Action

Cacti Screencacti-pic.png

InnoDB Buffer Activitycacti-bpool.png

Processlistcacti-procslist.png

Detailed Processslistcacti-proclist2.png

Temporary Tablescacti-temptbls.png

Buffer Pool Activityboolactivity.png

InnoDB Buffer Poolbufferpool.png

Commands Breakdowncommands.png

Connectionsconnections.png

MyISAM Index Usageindexes.png

InnoDB IOinnodbio.png

InnoDB Logsinnodblogs.png

InnoDB Insert Bufferinsbuf.png

InnoDB IO Pendingiopending.png

Query Cache Usagequerycache.png

Row Operationsrows.png

InnoDB Semaphoressemaphores.png

Sortssorts.png

Go Back To MySQL Support