1. Home
2. theyosh.nl
3. theyosh.theyosh.nl
4. mysql size ondisk

Graph information

mysql_size_ondisk - Munin plugin that reports the size of the files and
directories in /var/lib/mysql, biggest to smallest.
To correctly count InnoDB tables you should have innodb_file_per_table enabled
in MySQL (good practise anyway), otherwise all InnoDB tables will be counted into
ibdataX.
This plugin must be run as the user mysql, to do that append the following
to your /etc/munin/plugins/plugin-conf.d/munin-node:

[mysql_size_ondisk]
user mysql

This plugin gives you similar information as mysql_size_all. A difference
is that mysql_size_ondisk is much faster (0.4 seconds vs 14 seconds, on a server
with 170 databases, 26 GB total). Also note that mysql_size_all gives you the net
data size, mysql_size_ondisk gives you the gross storage space used, which may be
much more than your actual data.

Field	Internal name	Type	Warning	Critical	Info
piwik	piwik	gauge
theyosh_nl	theyosh_nl	gauge
temperatures	temperatures	gauge
nextcloud	nextcloud	gauge
undo_001	undo_001	gauge
undo_002	undo_002	gauge
_innodb_redo	_innodb_redo	gauge
binlog_000002	binlog_000002	gauge
ibdata1	ibdata1	gauge
postfixadmin	postfixadmin	gauge
mysql_ibd	mysql_ibd	gauge
ibtmp1	ibtmp1	gauge
_ib_16384_1_dblwr	_ib_16384_1_dblwr	gauge
roundcubemail	roundcubemail	gauge
phpmyadmin	phpmyadmin	gauge
performance_schema	performance_schema	gauge
opendmarc	opendmarc	gauge
_innodb_temp	_innodb_temp	gauge
_ib_16384_0_dblwr	_ib_16384_0_dblwr	gauge
sys	sys	gauge
mysql	mysql	gauge
ib_buffer_pool	ib_buffer_pool	gauge
cert_pem	cert_pem	gauge
chain_pem	chain_pem	gauge
theyosh_relay_bin_index	theyosh_relay_bin_index	gauge
privkey_pem	privkey_pem	gauge
server_key_pem	server_key_pem	gauge
private_key_pem	private_key_pem	gauge
client_key_pem	client_key_pem	gauge
ca_key_pem	ca_key_pem	gauge
server_cert_pem	server_cert_pem	gauge
client_cert_pem	client_cert_pem	gauge
ca_pem	ca_pem	gauge
binlog_000001	binlog_000001	gauge
public_key_pem	public_key_pem	gauge
theyosh_relay_bin_000044	theyosh_relay_bin_000044	gauge
theyosh_relay_bin_000036	theyosh_relay_bin_000036	gauge
theyosh_relay_bin_000035	theyosh_relay_bin_000035	gauge
theyosh_relay_bin_000063	theyosh_relay_bin_000063	gauge
theyosh_relay_bin_000062	theyosh_relay_bin_000062	gauge
theyosh_relay_bin_000061	theyosh_relay_bin_000061	gauge
theyosh_relay_bin_000060	theyosh_relay_bin_000060	gauge
theyosh_relay_bin_000059	theyosh_relay_bin_000059	gauge
theyosh_relay_bin_000058	theyosh_relay_bin_000058	gauge
theyosh_relay_bin_000057	theyosh_relay_bin_000057	gauge
theyosh_relay_bin_000056	theyosh_relay_bin_000056	gauge
theyosh_relay_bin_000055	theyosh_relay_bin_000055	gauge
theyosh_relay_bin_000054	theyosh_relay_bin_000054	gauge
theyosh_relay_bin_000053	theyosh_relay_bin_000053	gauge
theyosh_relay_bin_000052	theyosh_relay_bin_000052	gauge
theyosh_relay_bin_000051	theyosh_relay_bin_000051	gauge
theyosh_relay_bin_000050	theyosh_relay_bin_000050	gauge
theyosh_relay_bin_000049	theyosh_relay_bin_000049	gauge
theyosh_relay_bin_000048	theyosh_relay_bin_000048	gauge
theyosh_relay_bin_000047	theyosh_relay_bin_000047	gauge
theyosh_relay_bin_000046	theyosh_relay_bin_000046	gauge
theyosh_relay_bin_000045	theyosh_relay_bin_000045	gauge
theyosh_relay_bin_000042	theyosh_relay_bin_000042	gauge
theyosh_relay_bin_000041	theyosh_relay_bin_000041	gauge
theyosh_relay_bin_000040	theyosh_relay_bin_000040	gauge
theyosh_relay_bin_000039	theyosh_relay_bin_000039	gauge
theyosh_relay_bin_000038	theyosh_relay_bin_000038	gauge
theyosh_relay_bin_000037	theyosh_relay_bin_000037	gauge
theyosh_relay_bin_000034	theyosh_relay_bin_000034	gauge
theyosh_relay_bin_000033	theyosh_relay_bin_000033	gauge
theyosh_relay_bin_000031	theyosh_relay_bin_000031	gauge
theyosh_relay_bin_000030	theyosh_relay_bin_000030	gauge
theyosh_relay_bin_000029	theyosh_relay_bin_000029	gauge
theyosh_relay_bin_000028	theyosh_relay_bin_000028	gauge
theyosh_relay_bin_000026	theyosh_relay_bin_000026	gauge
theyosh_relay_bin_000025	theyosh_relay_bin_000025	gauge
theyosh_relay_bin_000024	theyosh_relay_bin_000024	gauge
theyosh_relay_bin_000023	theyosh_relay_bin_000023	gauge
theyosh_relay_bin_000022	theyosh_relay_bin_000022	gauge
theyosh_relay_bin_000021	theyosh_relay_bin_000021	gauge
theyosh_relay_bin_000020	theyosh_relay_bin_000020	gauge
theyosh_relay_bin_000019	theyosh_relay_bin_000019	gauge
theyosh_relay_bin_000018	theyosh_relay_bin_000018	gauge
theyosh_relay_bin_000014	theyosh_relay_bin_000014	gauge
theyosh_relay_bin_000012	theyosh_relay_bin_000012	gauge
theyosh_relay_bin_000009	theyosh_relay_bin_000009	gauge
theyosh_relay_bin_000008	theyosh_relay_bin_000008	gauge
theyosh_relay_bin_000007	theyosh_relay_bin_000007	gauge
theyosh_relay_bin_000006	theyosh_relay_bin_000006	gauge
theyosh_relay_bin_000005	theyosh_relay_bin_000005	gauge
theyosh_relay_bin_000004	theyosh_relay_bin_000004	gauge
theyosh_relay_bin_000003	theyosh_relay_bin_000003	gauge
theyosh_relay_bin_000002	theyosh_relay_bin_000002	gauge
theyosh_relay_bin_000001	theyosh_relay_bin_000001	gauge
mysql_bin_000090	mysql_bin_000090	gauge
mysql_bin_000089	mysql_bin_000089	gauge
mysql_bin_000088	mysql_bin_000088	gauge
theyosh_relay_bin_000064	theyosh_relay_bin_000064	gauge
theyosh_relay_bin_000043	theyosh_relay_bin_000043	gauge
theyosh_relay_bin_000032	theyosh_relay_bin_000032	gauge
theyosh_relay_bin_000027	theyosh_relay_bin_000027	gauge
theyosh_relay_bin_000017	theyosh_relay_bin_000017	gauge
theyosh_relay_bin_000016	theyosh_relay_bin_000016	gauge
theyosh_relay_bin_000015	theyosh_relay_bin_000015	gauge
theyosh_relay_bin_000013	theyosh_relay_bin_000013	gauge
theyosh_relay_bin_000011	theyosh_relay_bin_000011	gauge
theyosh_relay_bin_000010	theyosh_relay_bin_000010	gauge
mysql_bin_000091	mysql_bin_000091	gauge
mysql_bin_index	mysql_bin_index	gauge
auto_cnf	auto_cnf	gauge
binlog_index	binlog_index	gauge
mysql_upgrade_info	mysql_upgrade_info	gauge