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

<b>Cacti Screen<b>cacti-pic.png

<b>InnoDB Buffer Activity<b>cacti-bpool.png

<b>Processlist<b>cacti-procslist.png

<b>Detailed Processslist<b>cacti-proclist2.png

<b>Temporary Tables<b>cacti-temptbls.png

<b>Buffer Pool Activity<b>boolactivity.png

<b>InnoDB Buffer Pool<b>bufferpool.png

<b>Commands Breakdown<b>commands.png

<b>Connections<b>connections.png

<b>MyISAM Index Usage<b>indexes.png

<b>InnoDB IO<b>innodbio.png

<b>InnoDB Logs<b>innodblogs.png

<b>InnoDB Insert Buffer<b>insbuf.png

<b>InnoDB IO Pending<b>iopending.png

<b>Query Cache Usage<b>querycache.png

<b>Row Operations<b>rows.png

<b>InnoDB Semaphores<b>semaphores.png

<b>Sorts<b>sorts.png

<b>Go Back To MySQL Support<b>