-
Problem report
-
Resolution: Duplicate
-
Trivial
-
None
-
4.4.1
-
MySQL
-
Sprint 65 (Jun 2020)
Steps to reproduce:
- Use standart template https://github.com/zabbix/zabbix/tree/master/templates/db/mysql
- mysql -e "create database test1;"
- mysql -e "SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test1'"
- Return NULL
- See latest data in web-frontend, item "Size of database test1" is not value
Fix:
Change in template_db_mysql.conf on:
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT IFNULL(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
- duplicates
-
ZBX-17409 The item mysql.dbsize returns NULL
- Closed