"Plugins" Posts


Rails 3 Support

By Derek Bullet_white Posted in Plugins Bullet_white Comments Comments

Upgraded to Rails 3? No problem, Scout can monitor that!

Just follow these 3 steps to monitor a Rails 3 application in Scout.

 

MySQL Tuning Tips with Scout

By Andre Bullet_white Posted in Plugins Bullet_white Comments Comments

If you’ve used Major Hayden’s MySQLTuner before, you know it’s a great source of MySQL optimization tips.

Now you can get MySQLTuner reports automatically delivered through Scout. All you need to do is install the MySQL Stats w/MySQLTuner plugin, or update the plugin if you already have it installed. You will be informed if:

  • the amount of memory you have allocated to MySQL needs adjusting
  • tables are fragmented and need to be optimized
  • query cache sizes, max heap sizes, or buffer pool sizes need adjusting
  • queries are requiring an excessive number of temp tables

Weekly Reports

You’ll get your first report right away after installing the plugin. After that, you’ll automatically get a weekly follow-up report, so your database stays nice and optimized. You can change the frequency of the tuner reports to suit your needs.

Here’s an example report of a MySQLTuner report.

In case you’re wondering—you don’t need to install the MySQLTuner script on your server. All you need to do is select the Scout plugin from the plugin directory.

Real-time Query Activity

In addition to the MySQLTuner reports, you’ll get real-time statistics on MySQL query activity:

Like all Scout metrics, these can be charted and compared, you can get alerts on thresholds and trends, etc!

Where Credit’s Due

A huge thank-you to Major Hayden AKA Racker Hacker for the MySQLTuner Script. Also thanks to Eric Lindvall for creating the original MySQL Statistics plugin.

Get Started!

Sound interesting? Install the MySQL Stats w/MySQLTuner Plugin and start getting MySQLTuner reports automatically.

 

Monitoring MongoDB

By Derek Bullet_white Posted in Plugins Bullet_white Comments Comments

Updated 3/21/2013The MongoDB Overview plugin discussed below has been split into 2 separate plugins: MongoDB Server Status and MongoDB Database Stats. The server status plugin reports global MongoDB metrics and the database stats plugin reports metrics specific to a particular database.

John Nunemaker of Ordered List knows his way around MongoDB, the high-performance open-source, document-orientated database. We were obviously excited to see that John created a MongoDB Monitoring plugin.

Like all Scout plugins, installing it is a button click away.

Mongo Monitoring Walkthru

John’s MongoDB Monitoring plugin gives both an overview of key Mongo performance metrics and a detailed display when you need to dig deeper.

The overview:

The details:

View a chart of each metric:

Mongo Q&A with John

At Scout HQ, I brought out some hot cocoa, lit a fire, and demanded that John reflect on MongoDB. You wouldn’t know it from his appearance, but John had some rather enlightening things to say.

Read More →

 

New CPU Usage Plugin

By Andre Bullet_white Posted in Plugins Bullet_white Comments Comments

Eric Lindvall of Cloudvox has created a CPU Usage plugin for the Scout directory.

The plugin uses the same underlying data that vmstat uses in /proc to give you the CPU usage for the full duration between scout runs.

This means the sampling interval for the plugin is equal to your Scout execution interval -- three minutes for an Ultimate account, etc.

Understanding CPU Usage Metrics

The CPU Usage plugin provides the following:

  • % System: percentage of time spent in the kernel
  • % User: percentage of time in "userland" (your code, apache, mysql, etc)
  • % IO Wait: percentage of time waiting for the disk to return data
  • number of running processes: processes that are being processed by the CPUs
  • number of blocked processes: processes that are waiting for IO (or possibly other things).
  • number of interrupts per second

Eric elaborated on the interrupts metric:

The interrupts per second metric is very interesting because it gives you insight into part of what the kernel is doing in the "System" time. Also, many times a high interrupt rate can be an indication of mis-configured hardware like a NIC.

There isn't a single "good value" for number of interrupts/second, Eric explains:

A lot of it depends on the connected devices, their configurations, and the amount of throughput the device is doing.

... however, you can should watch the int interrupts /sec metric after OS changes:

One nice thing this will show you is if your interrupts/sec spikes after a kernel upgrade, one of the upgraded drivers may be doing something bad that it wasn't doing before.

Different from Server Load

Note that this plugin is distinct from the Server Load plugin. For information on load averages, see our understanding load averages post from last year.

Thanks again to Eric Lindvall of Cloudvox. As always, drop us a note at support@scoutapp.com if you have questions.

 

PostgreSQL Monitoring Plugin

By Derek Bullet_white Posted in Plugins Bullet_white Comments Comments

Robert Coup of Koordinates has added a PostgreSQL monitoring plugin to the Scout Plugin Directory. It’s about time PostgreSQL got some love from the Scout community!

The PostgreSQL monitoring plugin tracks the basics you really need to know about your PostgreSQL setup (query rates, buffer cache hits, etc).

Don’t forget that you can get alerts when these metrics change dramatically using Scout’s triggers. For example, you could create a trend trigger to alert you of a dramatic drop in the Buffer cache hit rate.

You can view more details about the plugin in our directory.

Like all Scout plugins, using the PostgreSQL plugin is just a button click away – no scripts to install or configure.

If you run into an issue with the plugin, shoot us an email at support@scoutapp.com. We maintain a test suite for the plugin, so we’d love to document and fix your issue.

 

Oink + Request Log Analyzer = Rails Monitoring in one report

By Derek Bullet_white Posted in Plugins Bullet_white Comments Comments

If you’ve ever had to track down a memory leak in a Rails application (and who hasn’t forgotten to use will_paginate occasionally), you’re probably already familiar with the excellent Oink plugin by Noah Davis. Oink spits out the actions that are leaking the most.

Oink is a huge help when tracking down a memory leak. However, it doesn’t overcome my laziness. Tracking memory usage is extremely important – talk to any dedicated Rails host and they’ll tell you memory leaks are behind many crashed servers. To make monitoring memory usage less involoved, I needed 3 additions to Oink.

Read More →

 

Older posts: 1 2 3 4 5 ... 7