System administrators familiar with the Linux operating system
use the tools in the 'procps' toolset all the time. Tools which
read from /proc include top, iostat, vmstat, sar and others. The
files in /proc contain useful information about the performance
of the system. Most of the files are documented in the Linux kernel documentation. You can also check
man 5 proc.
Most performance monitoring tools invoke other tools like iostat
to collect performance information instead of reading from the
/proc filesytem itself. This begs the question, what can you do
if you don't have access to those tools? Perhaps you are using a
hosted Linux database and have no access to the underlying shell
to execute tools like iostat or top? How could you gather
information about the performance of the actual system without
being allowed to run the tools?
…
Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are two new scripts included as well as some good updates to the my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads kt-mysql-systemcheck – generates a report for point-in-time system status that is useful for troubleshooting MySQL [...]
Looking around on Google for a webpage test script returns a lot of results. Some of them are useful, some are not. In particular, for Python, the scripts on the first page of results are minimal and lacking a useful copy and paste / ready to go script that will answer the question “is my webpage available?”. So I decided to write a quick one that will give you the return code and email you as an alert if the page does not return with a 200 code (successful). You can find the script here. Update: the webserver was trying to execute the script as a .py file so I just changed it to .txt – for it to work you will want to change the .txt extension to a .py extension after you download it.
If you are familiar with Python scripting, this script could easily be modified to post to a form so that you can test a MySQL transaction (or other transactional DB) …
[Read more]I’ve recently become supremely disappointed in the availability of Nagios checks for RAID cards. Too often, I see administrators rely on chance (or their hosting provider) to discover failed drives, a dying BBU, or a degrading capacity on their RAID cards. So I began work on check_raid (part of check_mysql_all) to provide a suite of [...]
The time has come for major performance improvements to the reporter, stats-gather, alerter, and client scripts. This means that I will be rewriting the scripts in Python. A couple of reasons for this; to cut down on the number of modules that are required for the installation process (which also makes distributing the client script [...]
I’ve been looking over the documentation lately and trying to find ways to improve the installation experience for new users. That said, I’ve written a short but useful description of the easiest way to install all of the Perl and PHP requirements for Kontrollbase. You can find it here: http://kontrollsoft.com/kontrollbase/userguide/installation-install_overview.php#simple – or in the Installation [...]
A new version of Kontrollbase – the enterprise monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases – is available for download. See the downloads page or run “svn update” to get your new version today. http://kontrollsoft.com/software-downloads
CMON -
the Cluster Monitor has recently been released and here is a
little how to about how to install from binary and source (at the
end), deployment etc.
1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and
32-bit (statically linked) and works for MySQL Cluster 7.0.9 and
later.
In this case the monitoring host will be on 'ndb05' (IP address
10.0.1.5) - see 9. Suggested Deployment for a picture describing
the setup.
The Monitoring machine should have installed:
- a mysql server up and running that will store the cmon database (if you build from source you need to have the mysql cluster libraries and include files)
- apache (if you want to have the web interface) + php_mysql
- rrdtool (if you want to have graphs in web interface) …
Good news for everyone that has wanted the performance tuning abilities of Kontrollbase – the opensource enterprise monitor for MySQL – but didn’t want to install a centralized monitoring application for their MySQL database servers. Now the same performance tuning reports are available in a single script that can be run from the command line [...]
I’m really proud to announce the release of the version 1.0 of mysql-snmp.
What is mysql-snmp?
mysql-snmp is a mix between the excellent MySQL Cacti Templates and a Net-SNMP agent. The idea is that combining the power of the MySQL Cacti Templates and any SNMP based monitoring would unleash a powerful mysql monitoring system. Of course this project favorite monitoring system is OpenNMS.
mysql-snmp is shipped with the necessary OpenNMS configuration files, but any other SNMP monitoring software can …
[Read more]