Missing create table mysql_statistics in schema.h

[fortxun]

The following table definition is missing from schema.h in the 0.13 version

CREATE TABLE IF NOT EXISTS `mysql_statistics` (
mysqlid integer not null,
ABORTED_CLIENTS VARCHAR(255) NOT NULL DEFAULT '0',
ABORTED_CONNECTS VARCHAR(255) NOT NULL DEFAULT '0',
BINLOG_CACHE_DISK_USE VARCHAR(255) NOT NULL DEFAULT '0',
BINLOG_CACHE_USE VARCHAR(255) NOT NULL DEFAULT '0',
BYTES_RECEIVED VARCHAR(255) NOT NULL DEFAULT '0',
BYTES_SENT VARCHAR(255) NOT NULL DEFAULT '0',
COMPRESSION VARCHAR(255) NOT NULL DEFAULT '0',
COM_ADMIN_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_DB_UPGRADE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_TABLESPACE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ANALYZE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ASSIGN_TO_KEYCACHE VARCHAR(255) NOT NULL DEFAULT '0',
COM_BACKUP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_BEGIN VARCHAR(255) NOT NULL DEFAULT '0',
COM_BINLOG VARCHAR(255) NOT NULL DEFAULT '0',
COM_CALL_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHANGE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHANGE_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHECKSUM VARCHAR(255) NOT NULL DEFAULT '0',
COM_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_UDF VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_VIEW VARCHAR(255) NOT NULL DEFAULT '0',
COM_DEALLOC_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_DELETE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DELETE_MULTI VARCHAR(255) NOT NULL DEFAULT '0',
COM_DO VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_VIEW VARCHAR(255) NOT NULL DEFAULT '0',
COM_EMPTY_QUERY VARCHAR(255) NOT NULL DEFAULT '0',
COM_EXECUTE_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_FLUSH VARCHAR(255) NOT NULL DEFAULT '0',
COM_GRANT VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_CLOSE VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_OPEN VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_READ VARCHAR(255) NOT NULL DEFAULT '0',
COM_HELP VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSERT VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSERT_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSTALL_PLUGIN VARCHAR(255) NOT NULL DEFAULT '0',
COM_KILL VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOAD VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOAD_MASTER_DATA VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOAD_MASTER_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOCK_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_OPTIMIZE VARCHAR(255) NOT NULL DEFAULT '0',
COM_PRELOAD_KEYS VARCHAR(255) NOT NULL DEFAULT '0',
COM_PREPARE_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_PURGE VARCHAR(255) NOT NULL DEFAULT '0',
COM_PURGE_BEFORE_DATE VARCHAR(255) NOT NULL DEFAULT '0',
COM_RELEASE_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
COM_RENAME_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_RENAME_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPAIR VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPLACE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPLACE_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_RESET VARCHAR(255) NOT NULL DEFAULT '0',
COM_RESTORE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REVOKE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REVOKE_ALL VARCHAR(255) NOT NULL DEFAULT '0',
COM_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
COM_ROLLBACK_TO_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SET_OPTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_AUTHORS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_BINLOGS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_BINLOG_EVENTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CHARSETS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_COLLATIONS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_COLUMN_TYPES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CONTRIBUTORS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_FUNC VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_PROC VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_CREATE_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_DATABASES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_ENGINE_LOGS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_ENGINE_MUTEX VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_ENGINE_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_ERRORS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_EVENTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_FIELDS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_FUNCTION_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_GRANTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_KEYS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_MASTER_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_NEW_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_OPEN_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PLUGINS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PRIVILEGES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PROCEDURE_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PROCESSLIST VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PROFILE VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PROFILES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_SLAVE_HOSTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_SLAVE_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_STORAGE_ENGINES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_TABLE_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_TRIGGERS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_VARIABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_WARNINGS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SLAVE_START VARCHAR(255) NOT NULL DEFAULT '0',
COM_SLAVE_STOP VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_CLOSE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_EXECUTE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_FETCH VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_RESET VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_SEND_LONG_DATA VARCHAR(255) NOT NULL DEFAULT '0',
COM_TRUNCATE VARCHAR(255) NOT NULL DEFAULT '0',
COM_UNINSTALL_PLUGIN VARCHAR(255) NOT NULL DEFAULT '0',
COM_UNLOCK_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_UPDATE VARCHAR(255) NOT NULL DEFAULT '0',
COM_UPDATE_MULTI VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_END VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_RECOVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_START VARCHAR(255) NOT NULL DEFAULT '0',
CONNECTIONS VARCHAR(255) NOT NULL DEFAULT '0',
CREATED_TMP_DISK_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
CREATED_TMP_FILES VARCHAR(255) NOT NULL DEFAULT '0',
CREATED_TMP_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
DELAYED_ERRORS VARCHAR(255) NOT NULL DEFAULT '0',
DELAYED_INSERT_THREADS VARCHAR(255) NOT NULL DEFAULT '0',
DELAYED_WRITES VARCHAR(255) NOT NULL DEFAULT '0',
FLUSH_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_DELETE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_DISCOVER VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_FIRST VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_KEY VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_NEXT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_PREV VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_RND VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_RND_NEXT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_SAVEPOINT_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_UPDATE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_WRITE VARCHAR(255) NOT NULL DEFAULT '0',
KEY_BLOCKS_NOT_FLUSHED VARCHAR(255) NOT NULL DEFAULT '0',
KEY_BLOCKS_UNUSED VARCHAR(255) NOT NULL DEFAULT '0',
KEY_BLOCKS_USED VARCHAR(255) NOT NULL DEFAULT '0',
KEY_READS VARCHAR(255) NOT NULL DEFAULT '0',
KEY_READ_REQUESTS VARCHAR(255) NOT NULL DEFAULT '0',
KEY_WRITES VARCHAR(255) NOT NULL DEFAULT '0',
KEY_WRITE_REQUESTS VARCHAR(255) NOT NULL DEFAULT '0',
LAST_QUERY_COST VARCHAR(255) NOT NULL DEFAULT '0',
MAX_USED_CONNECTIONS VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CLUSTER_CONNECTION_POOL VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CLUSTER_NODE_ID VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFIG_FROM_HOST VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFIG_FROM_PORT VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFLICT_FN_MAX VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFLICT_FN_OLD VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONNECT_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
NDB_EXECUTE_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
NDB_NUMBER_OF_DATA_NODES VARCHAR(255) NOT NULL DEFAULT '0',
NDB_NUMBER_OF_READY_DATA_NODES VARCHAR(255) NOT NULL DEFAULT '0',
NOT_FLUSHED_DELAYED_ROWS VARCHAR(255) NOT NULL DEFAULT '0',
OPENED_FILES VARCHAR(255) NOT NULL DEFAULT '0',
OPENED_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
OPENED_TABLE_DEFINITIONS VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_FILES VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_STREAMS VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_TABLE_DEFINITIONS VARCHAR(255) NOT NULL DEFAULT '0',
PREPARED_STMT_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_FREE_BLOCKS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_FREE_MEMORY VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_HITS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_INSERTS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_LOWMEM_PRUNES VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_NOT_CACHED VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_QUERIES_IN_CACHE VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_TOTAL_BLOCKS VARCHAR(255) NOT NULL DEFAULT '0',
QUESTIONS VARCHAR(255) NOT NULL DEFAULT '0',
RPL_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_FULL_JOIN VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_FULL_RANGE_JOIN VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_RANGE VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_RANGE_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_SCAN VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_HEARTBEAT_PERIOD VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_OPEN_TEMP_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_RECEIVED_HEARTBEATS VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_RETRIED_TRANSACTIONS VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_RUNNING VARCHAR(255) NOT NULL DEFAULT '0',
SLOW_LAUNCH_THREADS VARCHAR(255) NOT NULL DEFAULT '0',
SLOW_QUERIES VARCHAR(255) NOT NULL DEFAULT '0',
SORT_MERGE_PASSES VARCHAR(255) NOT NULL DEFAULT '0',
SORT_RANGE VARCHAR(255) NOT NULL DEFAULT '0',
SORT_ROWS VARCHAR(255) NOT NULL DEFAULT '0',
SORT_SCAN VARCHAR(255) NOT NULL DEFAULT '0',
TABLE_LOCKS_IMMEDIATE VARCHAR(255) NOT NULL DEFAULT '0',
TABLE_LOCKS_WAITED VARCHAR(255) NOT NULL DEFAULT '0',
TC_LOG_MAX_PAGES_USED VARCHAR(255) NOT NULL DEFAULT '0',
TC_LOG_PAGE_SIZE VARCHAR(255) NOT NULL DEFAULT '0',
TC_LOG_PAGE_WAITS VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CACHED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CONNECTED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CREATED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_RUNNING VARCHAR(255) NOT NULL DEFAULT '0',
UPTIME VARCHAR(255) NOT NULL DEFAULT '0',
report_ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
KEY(mysqlid),
KEY(report_ts)
) engine=myisam

When starting cmon the following occurs.

Jan 26 02:00:52 api1 cmon[18427]: Starting cmon version 0.12 with the following parameters: --mysqldatabase=cmon --mysqluser=root --mysqlpasswd=blah --mysqlhost=localhost --mysqlport=3306 --mysqlsocket=/tmp/mysql.sock --ndb-connectstring=localhost --savetime-clusterlog=24 (hours) --savetime-statistics=24 (hours)
Jan 26 02:00:52 api1 cmon[18427]: If that doesn't look correct, kill cmon and restart with -? for help on the parameters, or change the params in /etc/init.d/cmon
Jan 26 02:00:52 api1 cmon[18427]: connected to mysqld
Jan 26 02:00:52 api1 cmon[18427]: Table 'backup' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'backup_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'restore' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'restore_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_state' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'node_state' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'node_statistics' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_statistics' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'memory_usage' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'mysql_server' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'mysql_statistics' did not exist. Schema incomplete. Going to recreate missing tables.
Jan 26 02:00:52 api1 cmon[18427]: Recreating missing tables

schema.h does not appear to have this table defined and the process fails.

[johan (johan-severalnines)]

Hello,
Thank you for your bug report and sorry for the inconvenience.
This bug is fixed in cmon-0.13

BR
johan

fortxun wrote:
> ** Description changed:
>
> The following table definition is missing from schema.h in the 0.13
> version
>
> CREATE TABLE IF NOT EXISTS `mysql_statistics` (
> - `mysqlid` int(11),
> - `variable_name` varchar(255) NOT NULL,
> - `variable_value` varchar(255),
> - `report_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> - PRIMARY KEY (`mysqlid`,`variable_name`),
> - KEY `report_ts` (`report_ts`)
> - ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
> + mysqlid integer not null,
> + ABORTED_CLIENTS VARCHAR(255) NOT NULL DEFAULT '0',
> + ABORTED_CONNECTS VARCHAR(255) NOT NULL DEFAULT '0',
> + BINLOG_CACHE_DISK_USE VARCHAR(255) NOT NULL DEFAULT '0',
> + BINLOG_CACHE_USE VARCHAR(255) NOT NULL DEFAULT '0',
> + BYTES_RECEIVED VARCHAR(255) NOT NULL DEFAULT '0',
> + BYTES_SENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COMPRESSION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ADMIN_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_DB_UPGRADE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_TABLESPACE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ANALYZE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ASSIGN_TO_KEYCACHE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_BACKUP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_BEGIN VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_BINLOG VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CALL_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHANGE_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHANGE_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHECKSUM VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_UDF VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_USER VARCHAR(255) NOT NULL DEFAULT '0',
>...

[johan (johan-severalnines)]

A new better fix for this will be released in cmon 0.15.