in sql/sql_stats.cc [1732:1924]
static std::string sql_cmd_type(enum_sql_command sql_command)
{
switch (sql_command) {
case SQLCOM_ALTER_TABLE:
case SQLCOM_ALTER_DB:
case SQLCOM_ALTER_PROCEDURE:
case SQLCOM_ALTER_FUNCTION:
case SQLCOM_ALTER_TABLESPACE:
case SQLCOM_ALTER_SERVER:
case SQLCOM_ALTER_EVENT:
case SQLCOM_ALTER_DB_UPGRADE:
case SQLCOM_ALTER_USER:
case SQLCOM_RENAME_TABLE:
case SQLCOM_RENAME_USER:
return "ALTER";
case SQLCOM_BEGIN:
case SQLCOM_XA_START:
return "BEGIN";
case SQLCOM_COMMIT:
case SQLCOM_XA_COMMIT:
return "COMMIT";
case SQLCOM_CREATE_TABLE:
case SQLCOM_CREATE_INDEX:
case SQLCOM_CREATE_DB:
case SQLCOM_CREATE_FUNCTION:
case SQLCOM_CREATE_USER:
case SQLCOM_CREATE_PROCEDURE:
case SQLCOM_CREATE_SPFUNCTION:
case SQLCOM_CREATE_VIEW:
case SQLCOM_CREATE_TRIGGER:
case SQLCOM_CREATE_SERVER:
case SQLCOM_CREATE_EVENT:
case SQLCOM_CREATE_NPROCEDURE:
case SQLCOM_CREATE_EXPLICIT_SNAPSHOT:
return "CREATE";
case SQLCOM_DELETE:
case SQLCOM_DELETE_MULTI:
case SQLCOM_RELEASE_EXPLICIT_SNAPSHOT:
return "DELETE";
case SQLCOM_DROP_TABLE:
case SQLCOM_DROP_INDEX:
case SQLCOM_DROP_DB:
case SQLCOM_DROP_FUNCTION:
case SQLCOM_DROP_USER:
case SQLCOM_DROP_PROCEDURE:
case SQLCOM_DROP_VIEW:
case SQLCOM_DROP_TRIGGER:
case SQLCOM_DROP_SERVER:
case SQLCOM_DROP_EVENT:
case SQLCOM_DROP_NPROCEDURE:
return "DROP";
case SQLCOM_INSERT:
case SQLCOM_INSERT_SELECT:
return "INSERT";
case SQLCOM_LOAD:
return "LOAD";
case SQLCOM_SELECT:
return "SELECT";
case SQLCOM_SET_OPTION:
return "SET";
case SQLCOM_REPLACE:
case SQLCOM_REPLACE_SELECT:
return "REPLACE";
case SQLCOM_ROLLBACK:
case SQLCOM_ROLLBACK_TO_SAVEPOINT:
case SQLCOM_XA_ROLLBACK:
return "ROLLBACK";
case SQLCOM_TRUNCATE:
return "TRUNCATE";
case SQLCOM_UPDATE:
case SQLCOM_UPDATE_MULTI:
return "UPDATE";
case SQLCOM_SHOW_DATABASES:
case SQLCOM_SHOW_TABLES:
case SQLCOM_SHOW_FIELDS:
case SQLCOM_SHOW_KEYS:
case SQLCOM_SHOW_VARIABLES:
case SQLCOM_SHOW_STATUS:
case SQLCOM_SHOW_ENGINE_LOGS:
case SQLCOM_SHOW_ENGINE_STATUS:
case SQLCOM_SHOW_ENGINE_MUTEX:
case SQLCOM_SHOW_PROCESSLIST:
case SQLCOM_SHOW_TRANSACTION_LIST:
case SQLCOM_SHOW_CONNECTION_ATTRIBUTES:
case SQLCOM_SHOW_SRV_SESSIONS:
case SQLCOM_SHOW_MASTER_STAT:
case SQLCOM_SHOW_SLAVE_STAT:
case SQLCOM_SHOW_GRANTS:
case SQLCOM_SHOW_CREATE:
case SQLCOM_SHOW_CHARSETS:
case SQLCOM_SHOW_COLLATIONS:
case SQLCOM_SHOW_CREATE_DB:
case SQLCOM_SHOW_TABLE_STATUS:
case SQLCOM_SHOW_TRIGGERS:
case SQLCOM_SHOW_RESOURCE_COUNTERS:
case SQLCOM_SHOW_BINLOGS:
case SQLCOM_SHOW_OPEN_TABLES:
case SQLCOM_SHOW_SLAVE_HOSTS:
case SQLCOM_SHOW_BINLOG_EVENTS:
case SQLCOM_SHOW_BINLOG_CACHE:
case SQLCOM_SHOW_WARNS:
case SQLCOM_SHOW_ERRORS:
case SQLCOM_SHOW_STORAGE_ENGINES:
case SQLCOM_SHOW_PRIVILEGES:
case SQLCOM_SHOW_CREATE_PROC:
case SQLCOM_SHOW_CREATE_FUNC:
case SQLCOM_SHOW_STATUS_PROC:
case SQLCOM_SHOW_STATUS_FUNC:
case SQLCOM_SHOW_PROC_CODE:
case SQLCOM_SHOW_FUNC_CODE:
case SQLCOM_SHOW_PLUGINS:
case SQLCOM_SHOW_CREATE_EVENT:
case SQLCOM_SHOW_EVENTS:
case SQLCOM_SHOW_CREATE_TRIGGER:
case SQLCOM_SHOW_PROFILE:
case SQLCOM_SHOW_PROFILES:
case SQLCOM_SHOW_RELAYLOG_EVENTS:
case SQLCOM_SHOW_ENGINE_TRX:
case SQLCOM_SHOW_MEMORY_STATUS:
case SQLCOM_SHOW_RAFT_LOGS:
case SQLCOM_SHOW_RAFT_STATUS:
return "SHOW";
case SQLCOM_CHANGE_DB:
return "USE";
case SQLCOM_LOCK_TABLES:
case SQLCOM_UNLOCK_TABLES:
case SQLCOM_GRANT:
case SQLCOM_REPAIR:
case SQLCOM_REVOKE:
case SQLCOM_OPTIMIZE:
case SQLCOM_CHECK:
case SQLCOM_ASSIGN_TO_KEYCACHE:
case SQLCOM_PRELOAD_KEYS:
case SQLCOM_FLUSH:
case SQLCOM_KILL:
case SQLCOM_ANALYZE:
case SQLCOM_SAVEPOINT:
case SQLCOM_RELEASE_SAVEPOINT:
case SQLCOM_SLAVE_START:
case SQLCOM_SLAVE_STOP:
case SQLCOM_CHANGE_MASTER:
case SQLCOM_RESET:
case SQLCOM_PURGE:
case SQLCOM_PURGE_BEFORE:
case SQLCOM_PURGE_UUID:
case SQLCOM_PURGE_RAFT_LOG:
case SQLCOM_PURGE_RAFT_LOG_BEFORE:
case SQLCOM_HA_OPEN:
case SQLCOM_HA_CLOSE:
case SQLCOM_HA_READ:
case SQLCOM_DO:
case SQLCOM_EMPTY_QUERY:
case SQLCOM_HELP:
case SQLCOM_REVOKE_ALL:
case SQLCOM_CHECKSUM:
case SQLCOM_CALL:
case SQLCOM_PREPARE:
case SQLCOM_EXECUTE:
case SQLCOM_DEALLOCATE_PREPARE:
case SQLCOM_XA_END:
case SQLCOM_XA_PREPARE:
case SQLCOM_XA_RECOVER:
case SQLCOM_INSTALL_PLUGIN:
case SQLCOM_UNINSTALL_PLUGIN:
case SQLCOM_BINLOG_BASE64_EVENT:
case SQLCOM_SIGNAL:
case SQLCOM_RESIGNAL:
case SQLCOM_GET_DIAGNOSTICS:
case SQLCOM_FIND_GTID_POSITION:
case SQLCOM_GTID_EXECUTED:
case SQLCOM_RBR_COLUMN_NAMES:
case SQLCOM_ATTACH_EXPLICIT_SNAPSHOT:
case SQLCOM_SHUTDOWN:
case SQLCOM_END:
return "OTHER";
}
}