1 /* Copyright (c) 2010, 2021, Oracle and/or its affiliates. 2 3 This program is free software; you can redistribute it and/or modify 4 it under the terms of the GNU General Public License, version 2.0, 5 as published by the Free Software Foundation. 6 7 This program is also distributed with certain software (including 8 but not limited to OpenSSL) that is licensed under separate terms, 9 as designated in a particular file or component or in included license 10 documentation. The authors of MySQL hereby grant you an additional 11 permission to link the program and your derivative works with the 12 separately licensed software that they have included with MySQL. 13 14 This program is distributed in the hope that it will be useful, 15 but WITHOUT ANY WARRANTY; without even the implied warranty of 16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 17 GNU General Public License, version 2.0, for more details. 18 19 You should have received a copy of the GNU General Public License 20 along with this program; if not, write to the Free Software 21 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ 22 23 #ifndef PFS_EVENTS_STATEMENTS_H 24 #define PFS_EVENTS_STATEMENTS_H 25 26 /** 27 @file storage/perfschema/pfs_events_statements.h 28 Events statements data structures (declarations). 29 */ 30 31 #include "pfs_column_types.h" 32 #include "pfs_events.h" 33 #include "pfs_digest.h" 34 35 struct PFS_thread; 36 struct PFS_account; 37 struct PFS_user; 38 struct PFS_host; 39 40 /** A statement record. */ 41 struct PFS_events_statements : public PFS_events 42 { 43 enum_object_type m_sp_type; 44 char m_schema_name[NAME_LEN]; 45 uint m_schema_name_length; 46 char m_object_name[NAME_LEN]; 47 uint m_object_name_length; 48 49 /** Database name. */ 50 char m_current_schema_name[NAME_LEN]; 51 /** Length of @c m_current_schema_name. */ 52 uint m_current_schema_name_length; 53 54 /** Locked time. */ 55 ulonglong m_lock_time; 56 57 /** Diagnostics area, message text. */ 58 char m_message_text[MYSQL_ERRMSG_SIZE+1]; 59 /** Diagnostics area, error number. */ 60 uint m_sql_errno; 61 /** Diagnostics area, SQLSTATE. */ 62 char m_sqlstate[SQLSTATE_LENGTH]; 63 /** Diagnostics area, error count. */ 64 uint m_error_count; 65 /** Diagnostics area, warning count. */ 66 uint m_warning_count; 67 /** Diagnostics area, rows affected. */ 68 ulonglong m_rows_affected; 69 70 /** Optimizer metric, number of rows sent. */ 71 ulonglong m_rows_sent; 72 /** Optimizer metric, number of rows examined. */ 73 ulonglong m_rows_examined; 74 /** Optimizer metric, number of temporary tables created on disk. */ 75 ulonglong m_created_tmp_disk_tables; 76 /** Optimizer metric, number of temporary tables created. */ 77 ulonglong m_created_tmp_tables; 78 /** Optimizer metric, number of full join. */ 79 ulonglong m_select_full_join; 80 /** Optimizer metric, number of full range join. */ 81 ulonglong m_select_full_range_join; 82 /** Optimizer metric, number of select range. */ 83 ulonglong m_select_range; 84 /** Optimizer metric, number of select range checks. */ 85 ulonglong m_select_range_check; 86 /** Optimizer metric, number of select scans. */ 87 ulonglong m_select_scan; 88 /** Optimizer metric, number of sort merge passes. */ 89 ulonglong m_sort_merge_passes; 90 /** Optimizer metric, number of sort ranges. */ 91 ulonglong m_sort_range; 92 /** Optimizer metric, number of sort rows. */ 93 ulonglong m_sort_rows; 94 /** Optimizer metric, number of sort scans. */ 95 ulonglong m_sort_scan; 96 /** Optimizer metric, number of 'no index used'. */ 97 ulonglong m_no_index_used; 98 /** Optimizer metric, number of 'no good index used'. */ 99 ulonglong m_no_good_index_used; 100 101 /** True if sqltext was truncated. */ 102 bool m_sqltext_truncated; 103 /** Statement character set number. */ 104 uint m_sqltext_cs_number; 105 106 /** 107 SQL_TEXT. 108 This pointer is immutable, 109 and always point to pre allocated memory. 110 */ 111 char *m_sqltext; 112 /** Length of @ m_info. */ 113 uint m_sqltext_length; 114 /** 115 Statement digest. 116 This underlying token array storage pointer is immutable, 117 and always point to pre allocated memory. 118 */ 119 sql_digest_storage m_digest_storage; 120 }; 121 122 void insert_events_statements_history(PFS_thread *thread, PFS_events_statements *statement); 123 void insert_events_statements_history_long(PFS_events_statements *statement); 124 125 extern ulong nested_statement_lost; 126 127 extern bool flag_events_statements_current; 128 extern bool flag_events_statements_history; 129 extern bool flag_events_statements_history_long; 130 131 extern bool events_statements_history_long_full; 132 extern PFS_ALIGNED PFS_cacheline_uint32 events_statements_history_long_index; 133 extern PFS_events_statements *events_statements_history_long_array; 134 extern size_t events_statements_history_long_size; 135 136 int init_events_statements_history_long(size_t events_statements_history_long_sizing); 137 void cleanup_events_statements_history_long(); 138 139 void reset_events_statements_current(); 140 void reset_events_statements_history(); 141 void reset_events_statements_history_long(); 142 void reset_events_statements_by_thread(); 143 void reset_events_statements_by_account(); 144 void reset_events_statements_by_user(); 145 void reset_events_statements_by_host(); 146 void reset_events_statements_global(); 147 void aggregate_account_statements(PFS_account *account); 148 void aggregate_user_statements(PFS_user *user); 149 void aggregate_host_statements(PFS_host *host); 150 151 #endif 152 153