MySQL Monitoring solutions

Basic solutions (CLI)

Those solutions are run from the command line (CLI):

top (man)
vmstat (man)
iostat (man), mpstat (man), pidstat in package sysstat
mytop, a Mytop Introduction
dstat
free (man)
procinfo (man)
mpstat (man)
mTop
InnoTop

Advanced solutions

More advanced MySQL database and host monitoring solutions with graphs and/or history and/or hints are:

MySQL Performance Monitor	The FromDual Performance Monitor for MySQL/MariaDB is a monitoring solution based on Zabbix. It is freely available. More information about it you can find here.
MySQL Enterprise Monitor	The MySQL Enterprise Monitor (aka Merlin or MEM) serves as an automated assistant for MySQL database administrators. For MySQL customers only!
cmon	CMON - the Cluster Monitor for MySQL Cluster. CMON is the most comprehensive monitor for MySQL Cluster and collect all information that is possible to collect from the data nodes and management servers.
MySQL Activity Report	The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.
MySQL Administrator	Exterminated! Is replaced by the MySQL Workbench.
Kontrollbase	Kontrollbase is a monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases. You can download it from here.
Zabbix	Zabbix offers advanced monitoring, alerting and visualisation features.
Nagios	Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes. FromDual provides the following Nagios plugins for MySQL/MariaDB: check_db check_errorlog check_repl_cnt_slave_hosts check_repl_heartbeat check_repl_io_thread check_repl_sql_thread check_repl_read_exec_pos check_repl_seconds_behind_master check_repl_readonly perf They can be downloaded from here. It is planned to make some more plugins for Nagios. Please make suggestions what you need next! PerfParse Add On for Nagios
Icinga	Icinga (Nagios fork) is an enterprise grade open source monitoring system which keeps watch over a network and any conceivable network resource, notifies the user of errors and recoveries, and generates performance data for reporting.
Cacti	Cacti is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. MySQL monitoring with Cacti
MRTG	MRTG will monitor SNMP network devices and draw pretty pictures showing how much traffic has passed through each interface. MRTG is being used to graph all sorts of network devices as well as everything else from weather data to vending machines.
RRD	RRDtool is the OpenSource industry standard, high performance data logging and graphing system for time series data. Example RRD World Welcome to the mrtg-rrd Home Page How do I get MySQL statistics into RRDUtil?
Munin	Munin is a networked resource monitoring tool that can help analyse resource trends and "what just happened to kill our performance?" problems.
Moodds	moodss is a graphical monitoring application. Seems to be stalled since 2006. MySQL modules
Hobbit Monitor	Hobbit is a system for monitoring servers and networks. It takes its inspiration from the Big Brother monitoring system. Hobbit is the successor to the bbgen toolkit, which has been available as an add-on to Big Brother since late 2002.
Big Sister	Big Sister originally was the Big Sister network monitor. Now, multiple projects in the realm of system management and monitoring are run under the label Big Sister.
Monit	Monit is a free open source utility for managing and monitoring, processes, files, directories and file systems on a UNIX system. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations.
SmokePing	SmokePing keeps track of your network latency.
ksysguard	KDE System Guard allows you to monitor various statistics about your computer.
GKrellM	GKrellM is a single process stack of system monitors which supports applying themes to match its appearance to your window manager, Gtk, or any other theme.
Ganglia	Ganglia is a scalable distributed monitoring system for high-performance computing systems such as clusters and Grids.
Hyperic	Hyperic monitors the health and well-being of operating systems, VMs, app servers, web servers, databases, messaging servers, authentication systems, and more.
Uptime Software	A single tool for simplifying the management of Virtual, Physical and Cloud environments. Monitor services, monitor applications, monitor servers, and monitor platforms from a unified dashboard, even across multiple datacenters.
Zenoss	Zenoss assures IT service delivery to applications, business services and real-time physical, virtual, and cloud-based infrastructures.
openNMS	OpenNMS is the world’s first enterprise grade network management application platform developed under the open source model.
GroundWork Monitor	GroundWork Monitor Enterprise Edition is the most scalable open source system and network management software for companies with heterogeneous operating systems, application and hardware environments.
Tivoli Monitoring	Monitoring software to help improve the effectiveness and efficiency of your IT department.
HP OpenView
CA Unicenter	Proactively manage the performance and availability of your infrastructure including physical and virtual systems, networks, databases and applications.
Big Brother	Big Brother Professional Edition (BBPE) is a simple way to measure the health of your heterogeneous IT environment at-a-glance.
Shinken
MONyog	MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box" that helps MySQL DBAs manage more MySQL servers, tune their MySQL servers and fix problems with MySQL database applications.

MySQL quick poll for monitoring solutions

What monitoring software do you use? [Lit.]

Solution	Votes	%
none	365	40.2
Nagios	211	23.3
home grown solution	85	9.4
other	78	8.6
Big Brother	38	4.2
IBM Tivoli	37	4.1
HP OpenView	31	3.4
Mytop	23	2.5
CA-Unicenter	15	1.7
Ganglia	14	1.5
Moodss	5	0.6
Hyperic	5	0.6

A total of 907 votes have been cast in this poll so far. Poll opened January 24, 2005.

Linux Journal survey about Linux monitoring

What is your favourite Linux monitoring application?

Solution	Votes	%
Zabbix	394	33.2
Nagios	373	31.4
Uptime Software	91	7.7
other	77	6.5
Cacti	62	5.2
Hyperic	52	4.4
Zenoss	51	4.3
Ganglia	41	3.5
OpenNMS	34	2.9
Groundwork	12	1.0

A total of 1187 votes have been cast in this poll until April 21, 2010.