table_error_log.cc File Reference

TABLE ERROR_LOG (implementation for table, indices, and keys). More...

#include "storage/perfschema/table_error_log.h"
#include <assert.h>
#include "lex_string.h"
#include "my_compiler.h"
#include "my_thread.h"
#include "sql/field.h"
#include "sql/plugin_table.h"
#include "sql/sql_parse.h"
#include "sql/table.h"
#include "storage/perfschema/pfs_buffer_container.h"
#include "storage/perfschema/pfs_instr.h"
#include "storage/perfschema/pfs_instr_class.h"

Detailed Description

TABLE ERROR_LOG (implementation for table, indices, and keys).

Try

SELECT RIGHT(logged,15),prio,error_code,subsystem,LEFT(data,22)

FROM performance_schema.error_log;

SELECT VARIABLE_NAME,VARIABLE_VALUE

FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "Error_log_%";

SELECT logged,prio,error_code,subsystem,LEFT(data,9)

FROM performance_schema.error_log WHERE prio="System";

SELECT RIGHT(logged,15),prio,error_code,subsystem,

IF(LEFT(data,1)='{',JSON_EXTRACT(data,'$.msg'),data) FROM performance_schema.error_log;