Monitoring MySQL Product Options

I’ve had plenty of comments on specific products to Monitoring MySQL Options before providing the completed list. Here are the results from my survey to give everybody a more complete list.

<td>
  25
</td>

<td>
  xxxxxxxxxxxxxxxxxxxxxxxxx
</td>
<td>
  8
</td>

<td>
  xxxxxxxx
</td>
<td>
  4
</td>

<td>
  xxxx
</td>
<td>
  3
</td>

<td>
  xxx
</td>
<td>
  3
</td>

<td>
  xxx
</td>
<td>
  2
</td>

<td>
  xx
</td>
<td>
  2
</td>

<td>
  xx
</td>
<td>
  2
</td>

<td>
  xx
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
<td>
  1
</td>

<td>
  x
</td>
Nagios
MONyog
Cacti
Munin
MySQL Enterprise Monitor/Merlin
Hyperic
KontrolBase
Zabbix
Big Brother
iGlass
MyDBA
MySQL AR
pacemaker
Panopta
Opsview
Monit
Tivoli

NOTE: Some answers included multiple products, these are all counted separately in the above figures.

There are a few products that are not listed at Monitoring MySQL in this list.

If you want to list what you use, please continue to use the MySQL Alert Monitoring Survey . Thanks to all those that replied.

Tagged with: Databases MySQL Uncategorized

Monitoring MySQL options

My recent poll What alert monitoring do you use? showed 25% of the 58 respondents to bravely state they had no MySQL monitoring. I see 1 in 3, ~33% in my consulting so this is consistent.

What do you monitor in MySQL?

If you are unfamiliar with what to monitor in MySQL, starting with looking at what popular Monitoring products monitor. For example, the following is the list of MySQL Cacti Plugin measurements.

Producing Chi-Squared statistics with SQL

The Chi-Squared test is one of the most widely used statistical tests for categorical data. It comes in two flavors: the goodness-of-fit test asks whether an observed frequency distribution matches an expected one, while the test of independence asks whether two categorical variables are associated with each other.