Show partition size in megabytes per history tables

Authorize:

mysql -u$(grep "^DBUser" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//") -p$(grep "^DBPassword" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//")

Select database:

use zabbix;

history:

SELECT PARTITION_NAME,PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD,round((DATA_LENGTH + index_length) / 1024 / 1024) "DB Size in MB" FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = 'zabbix' AND TABLE_NAME = 'history';

history_uint:

SELECT PARTITION_NAME,PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD,round((DATA_LENGTH + index_length) / 1024 / 1024) "DB Size in MB" FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = 'zabbix' AND TABLE_NAME = 'history_uint';

history_text:

SELECT PARTITION_NAME,PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD,round((DATA_LENGTH + index_length) / 1024 / 1024) "DB Size in MB" FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = 'zabbix' AND TABLE_NAME = 'history_text';

history_str:

SELECT PARTITION_NAME,PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD,round((DATA_LENGTH + index_length) / 1024 / 1024) "DB Size in MB" FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = 'zabbix' AND TABLE_NAME = 'history_str';

history_log:

SELECT PARTITION_NAME,PARTITION_ORDINAL_POSITION, TABLE_ROWS, PARTITION_METHOD,round((DATA_LENGTH + index_length) / 1024 / 1024) "DB Size in MB" FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = 'zabbix' AND TABLE_NAME = 'history_log';