23#ifndef PFS_EVENTS_STATEMENTS_H
24#define PFS_EVENTS_STATEMENTS_H
166 size_t events_statements_history_long_sizing);
Some integer typedefs for easier portability.
unsigned long long int ulonglong
Definition: my_inttypes.h:55
#define MYSQL_ERRMSG_SIZE
Max length of a error message.
Definition: mysql_com.h:879
#define SQLSTATE_LENGTH
Definition: mysql_com.h:74
char * user
Definition: mysqladmin.cc:64
const char * host
Definition: mysqladmin.cc:63
Data types for columns used in the performance schema tables (declarations)
enum_object_type
Enum values for the various OBJECT_TYPE columns.
Definition: pfs_column_types.h:221
Statement Digest data structures (declarations).
Events data structures (declarations).
ulong nested_statement_lost
Definition: pfs_instr.cc:49
void reset_events_statements_by_account()
Reset table EVENTS_STATEMENTS_SUMMARY_BY_ACCOUNT_BY_EVENT_NAME data.
Definition: pfs_events_statements.cc:293
void reset_events_statements_by_user()
Reset table EVENTS_STATEMENTS_SUMMARY_BY_USER_BY_EVENT_NAME data.
Definition: pfs_events_statements.cc:302
void cleanup_events_statements_history_long()
Cleanup table EVENTS_STATEMENTS_HISTORY_LONG.
Definition: pfs_events_statements.cc:134
void insert_events_statements_history(PFS_thread *thread, PFS_events_statements *statement)
Insert a statement record in table EVENTS_STATEMENTS_HISTORY.
Definition: pfs_events_statements.cc:181
PFS_events_statements * events_statements_history_long_array
EVENTS_STATEMENTS_HISTORY_LONG circular buffer.
Definition: pfs_events_statements.cc:62
void reset_events_statements_by_thread()
Reset table EVENTS_STATEMENTS_SUMMARY_BY_THREAD_BY_EVENT_NAME data.
Definition: pfs_events_statements.cc:282
void reset_events_statements_current()
Reset table EVENTS_STATEMENTS_CURRENT data.
Definition: pfs_events_statements.cc:242
bool flag_events_statements_history_long
Consumer flag for table EVENTS_STATEMENTS_HISTORY_LONG.
Definition: pfs_events_statements.cc:55
void aggregate_account_statements(PFS_account *account)
PFS_cacheline_atomic_uint32 events_statements_history_long_index
Index in EVENTS_STATEMENTS_HISTORY_LONG circular buffer.
Definition: pfs_events_statements.cc:60
bool flag_events_statements_current
Consumer flag for table EVENTS_STATEMENTS_CURRENT.
Definition: pfs_events_statements.cc:51
bool events_statements_history_long_full
True if EVENTS_STATEMENTS_HISTORY_LONG circular buffer is full.
Definition: pfs_events_statements.cc:58
int init_events_statements_history_long(size_t events_statements_history_long_sizing)
Initialize table EVENTS_STATEMENTS_HISTORY_LONG.
Definition: pfs_events_statements.cc:71
void insert_events_statements_history_long(PFS_events_statements *statement)
Insert a statement record in table EVENTS_STATEMENTS_HISTORY_LONG.
Definition: pfs_events_statements.cc:213
size_t events_statements_history_long_size
Definition: pfs_events_statements.cc:47
void aggregate_host_statements(PFS_host *host)
bool flag_events_statements_history
Consumer flag for table EVENTS_STATEMENTS_HISTORY.
Definition: pfs_events_statements.cc:53
void reset_events_statements_history()
Reset table EVENTS_STATEMENTS_HISTORY data.
Definition: pfs_events_statements.cc:258
void reset_events_statements_by_host()
Reset table EVENTS_STATEMENTS_SUMMARY_BY_HOST_BY_EVENT_NAME data.
Definition: pfs_events_statements.cc:311
void aggregate_user_statements(PFS_user *user)
void reset_events_statements_history_long()
Reset table EVENTS_STATEMENTS_HISTORY_LONG data.
Definition: pfs_events_statements.cc:263
bool flag_events_statements_cpu
Consumer flag for CPU_TIME columns.
Definition: pfs_events_statements.cc:49
void reset_events_statements_global()
Reset table EVENTS_STATEMENTS_GLOBAL_BY_EVENT_NAME data.
Definition: pfs_events_statements.cc:316
Object names (declarations).
Per account statistics.
Definition: pfs_account.h:66
An atomic uint32 variable, guaranteed to be alone in a CPU cache line.
Definition: pfs_global.h:76
A statement record.
Definition: pfs_events_statements.h:46
uint m_sql_errno
Diagnostics area, error number.
Definition: pfs_events_statements.h:69
ulonglong m_select_scan
Optimizer metric, number of select scans.
Definition: pfs_events_statements.h:96
ulonglong m_created_tmp_tables
Optimizer metric, number of temporary tables created.
Definition: pfs_events_statements.h:86
uint m_warning_count
Diagnostics area, warning count.
Definition: pfs_events_statements.h:75
ulonglong m_sort_rows
Optimizer metric, number of sort rows.
Definition: pfs_events_statements.h:102
sql_digest_storage m_digest_storage
Statement digest.
Definition: pfs_events_statements.h:146
ulonglong m_lock_time
Locked time.
Definition: pfs_events_statements.h:64
char * m_sqltext
SQL_TEXT.
Definition: pfs_events_statements.h:138
enum_object_type m_sp_type
Definition: pfs_events_statements.h:56
ulonglong m_statement_id
STATEMENT_ID, from the SQL layer QUERY_ID.
Definition: pfs_events_statements.h:54
ulonglong m_select_full_join
Optimizer metric, number of full join.
Definition: pfs_events_statements.h:88
ulonglong m_no_good_index_used
Optimizer metric, number of 'no good index used'.
Definition: pfs_events_statements.h:108
ulonglong m_rows_affected
Diagnostics area, rows affected.
Definition: pfs_events_statements.h:77
PFS_schema_name m_current_schema_name
Database name.
Definition: pfs_events_statements.h:61
char m_sqlstate[SQLSTATE_LENGTH]
Diagnostics area, SQLSTATE.
Definition: pfs_events_statements.h:71
ulonglong m_select_full_range_join
Optimizer metric, number of full range join.
Definition: pfs_events_statements.h:90
ulonglong m_rows_sent
Optimizer metric, number of rows sent.
Definition: pfs_events_statements.h:80
bool m_sqltext_truncated
True if SQL_TEXT was truncated.
Definition: pfs_events_statements.h:120
char m_message_text[MYSQL_ERRMSG_SIZE+1]
Diagnostics area, message text.
Definition: pfs_events_statements.h:67
ulonglong m_select_range
Optimizer metric, number of select range.
Definition: pfs_events_statements.h:92
ulonglong m_sort_range
Optimizer metric, number of sort ranges.
Definition: pfs_events_statements.h:100
uint m_sqltext_cs_number
Statement character set number.
Definition: pfs_events_statements.h:122
ulonglong m_max_controlled_memory
Definition: pfs_events_statements.h:116
ulonglong m_sort_merge_passes
Optimizer metric, number of sort merge passes.
Definition: pfs_events_statements.h:98
uint m_sqltext_length
Length of m_sqltext.
Definition: pfs_events_statements.h:140
ulonglong m_max_total_memory
Definition: pfs_events_statements.h:117
ulonglong m_select_range_check
Optimizer metric, number of select range checks.
Definition: pfs_events_statements.h:94
ulonglong m_rows_examined
Optimizer metric, number of rows examined.
Definition: pfs_events_statements.h:82
ulonglong m_created_tmp_disk_tables
Optimizer metric, number of temporary tables created on disk.
Definition: pfs_events_statements.h:84
PFS_schema_name m_schema_name
Definition: pfs_events_statements.h:57
uint m_error_count
Diagnostics area, error count.
Definition: pfs_events_statements.h:73
ulonglong m_cpu_time
CPU time.
Definition: pfs_events_statements.h:114
ulonglong m_no_index_used
Optimizer metric, number of 'no index used'.
Definition: pfs_events_statements.h:106
bool m_secondary
Executed on the secondary engine.
Definition: pfs_events_statements.h:125
ulonglong m_sort_scan
Optimizer metric, number of sort scans.
Definition: pfs_events_statements.h:104
PFS_object_name m_object_name
Definition: pfs_events_statements.h:58
An event record.
Definition: pfs_events.h:37
Per host statistics.
Definition: pfs_host.h:63
Definition: pfs_name.h:184
Definition: pfs_name.h:117
Instrumented thread implementation.
Definition: pfs_instr.h:374
Per user statistics.
Definition: pfs_user.h:62
Structure to store token count/array for a statement on which digest is to be calculated.
Definition: sql_digest.h:97
Definition: mysqlslap.cc:218