1show databases like 'performance_schema'; 2Database (performance_schema) 3performance_schema 4show create database performance_schema; 5Database Create Database 6performance_schema CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8 */ 7use performance_schema; 8show tables; 9Tables_in_performance_schema 10accounts 11cond_instances 12events_stages_current 13events_stages_history 14events_stages_history_long 15events_stages_summary_by_account_by_event_name 16events_stages_summary_by_host_by_event_name 17events_stages_summary_by_thread_by_event_name 18events_stages_summary_by_user_by_event_name 19events_stages_summary_global_by_event_name 20events_statements_current 21events_statements_history 22events_statements_history_long 23events_statements_summary_by_account_by_event_name 24events_statements_summary_by_digest 25events_statements_summary_by_host_by_event_name 26events_statements_summary_by_thread_by_event_name 27events_statements_summary_by_user_by_event_name 28events_statements_summary_global_by_event_name 29events_waits_current 30events_waits_history 31events_waits_history_long 32events_waits_summary_by_account_by_event_name 33events_waits_summary_by_host_by_event_name 34events_waits_summary_by_instance 35events_waits_summary_by_thread_by_event_name 36events_waits_summary_by_user_by_event_name 37events_waits_summary_global_by_event_name 38file_instances 39file_summary_by_event_name 40file_summary_by_instance 41host_cache 42hosts 43mutex_instances 44objects_summary_global_by_type 45performance_timers 46rwlock_instances 47session_account_connect_attrs 48session_connect_attrs 49setup_actors 50setup_consumers 51setup_instruments 52setup_objects 53setup_timers 54socket_instances 55socket_summary_by_event_name 56socket_summary_by_instance 57table_io_waits_summary_by_index_usage 58table_io_waits_summary_by_table 59table_lock_waits_summary_by_table 60threads 61users 62show create table accounts; 63Table Create Table 64accounts CREATE TABLE `accounts` ( 65 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 66 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 67 `CURRENT_CONNECTIONS` bigint(20) NOT NULL, 68 `TOTAL_CONNECTIONS` bigint(20) NOT NULL 69) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 70show create table cond_instances; 71Table Create Table 72cond_instances CREATE TABLE `cond_instances` ( 73 `NAME` varchar(128) NOT NULL, 74 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL 75) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 76show create table events_stages_current; 77Table Create Table 78events_stages_current CREATE TABLE `events_stages_current` ( 79 `THREAD_ID` bigint(20) unsigned NOT NULL, 80 `EVENT_ID` bigint(20) unsigned NOT NULL, 81 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 82 `EVENT_NAME` varchar(128) NOT NULL, 83 `SOURCE` varchar(64) DEFAULT NULL, 84 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 85 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 86 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 87 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 88 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 89) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 90show create table events_stages_history; 91Table Create Table 92events_stages_history CREATE TABLE `events_stages_history` ( 93 `THREAD_ID` bigint(20) unsigned NOT NULL, 94 `EVENT_ID` bigint(20) unsigned NOT NULL, 95 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 96 `EVENT_NAME` varchar(128) NOT NULL, 97 `SOURCE` varchar(64) DEFAULT NULL, 98 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 99 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 100 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 101 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 102 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 103) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 104show create table events_stages_history_long; 105Table Create Table 106events_stages_history_long CREATE TABLE `events_stages_history_long` ( 107 `THREAD_ID` bigint(20) unsigned NOT NULL, 108 `EVENT_ID` bigint(20) unsigned NOT NULL, 109 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 110 `EVENT_NAME` varchar(128) NOT NULL, 111 `SOURCE` varchar(64) DEFAULT NULL, 112 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 113 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 114 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 115 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 116 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 117) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 118show create table events_stages_summary_by_host_by_event_name; 119Table Create Table 120events_stages_summary_by_host_by_event_name CREATE TABLE `events_stages_summary_by_host_by_event_name` ( 121 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 122 `EVENT_NAME` varchar(128) NOT NULL, 123 `COUNT_STAR` bigint(20) unsigned NOT NULL, 124 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 125 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 126 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 127 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 128) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 129show create table events_stages_summary_by_thread_by_event_name; 130Table Create Table 131events_stages_summary_by_thread_by_event_name CREATE TABLE `events_stages_summary_by_thread_by_event_name` ( 132 `THREAD_ID` bigint(20) unsigned NOT NULL, 133 `EVENT_NAME` varchar(128) NOT NULL, 134 `COUNT_STAR` bigint(20) unsigned NOT NULL, 135 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 136 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 137 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 138 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 139) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 140show create table events_stages_summary_by_user_by_event_name; 141Table Create Table 142events_stages_summary_by_user_by_event_name CREATE TABLE `events_stages_summary_by_user_by_event_name` ( 143 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 144 `EVENT_NAME` varchar(128) NOT NULL, 145 `COUNT_STAR` bigint(20) unsigned NOT NULL, 146 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 147 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 148 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 149 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 150) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 151show create table events_stages_summary_by_account_by_event_name; 152Table Create Table 153events_stages_summary_by_account_by_event_name CREATE TABLE `events_stages_summary_by_account_by_event_name` ( 154 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 155 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 156 `EVENT_NAME` varchar(128) NOT NULL, 157 `COUNT_STAR` bigint(20) unsigned NOT NULL, 158 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 159 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 160 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 161 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 162) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 163show create table events_stages_summary_global_by_event_name; 164Table Create Table 165events_stages_summary_global_by_event_name CREATE TABLE `events_stages_summary_global_by_event_name` ( 166 `EVENT_NAME` varchar(128) NOT NULL, 167 `COUNT_STAR` bigint(20) unsigned NOT NULL, 168 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 169 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 170 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 171 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 172) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 173show create table events_statements_current; 174Table Create Table 175events_statements_current CREATE TABLE `events_statements_current` ( 176 `THREAD_ID` bigint(20) unsigned NOT NULL, 177 `EVENT_ID` bigint(20) unsigned NOT NULL, 178 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 179 `EVENT_NAME` varchar(128) NOT NULL, 180 `SOURCE` varchar(64) DEFAULT NULL, 181 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 182 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 183 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 184 `LOCK_TIME` bigint(20) unsigned NOT NULL, 185 `SQL_TEXT` longtext, 186 `DIGEST` varchar(32) DEFAULT NULL, 187 `DIGEST_TEXT` longtext, 188 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, 189 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 190 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 191 `OBJECT_NAME` varchar(64) DEFAULT NULL, 192 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, 193 `MYSQL_ERRNO` int(11) DEFAULT NULL, 194 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL, 195 `MESSAGE_TEXT` varchar(128) DEFAULT NULL, 196 `ERRORS` bigint(20) unsigned NOT NULL, 197 `WARNINGS` bigint(20) unsigned NOT NULL, 198 `ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 199 `ROWS_SENT` bigint(20) unsigned NOT NULL, 200 `ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 201 `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 202 `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 203 `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 204 `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 205 `SELECT_RANGE` bigint(20) unsigned NOT NULL, 206 `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 207 `SELECT_SCAN` bigint(20) unsigned NOT NULL, 208 `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 209 `SORT_RANGE` bigint(20) unsigned NOT NULL, 210 `SORT_ROWS` bigint(20) unsigned NOT NULL, 211 `SORT_SCAN` bigint(20) unsigned NOT NULL, 212 `NO_INDEX_USED` bigint(20) unsigned NOT NULL, 213 `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL, 214 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 215 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 216) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 217show create table events_statements_history; 218Table Create Table 219events_statements_history CREATE TABLE `events_statements_history` ( 220 `THREAD_ID` bigint(20) unsigned NOT NULL, 221 `EVENT_ID` bigint(20) unsigned NOT NULL, 222 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 223 `EVENT_NAME` varchar(128) NOT NULL, 224 `SOURCE` varchar(64) DEFAULT NULL, 225 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 226 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 227 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 228 `LOCK_TIME` bigint(20) unsigned NOT NULL, 229 `SQL_TEXT` longtext, 230 `DIGEST` varchar(32) DEFAULT NULL, 231 `DIGEST_TEXT` longtext, 232 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, 233 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 234 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 235 `OBJECT_NAME` varchar(64) DEFAULT NULL, 236 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, 237 `MYSQL_ERRNO` int(11) DEFAULT NULL, 238 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL, 239 `MESSAGE_TEXT` varchar(128) DEFAULT NULL, 240 `ERRORS` bigint(20) unsigned NOT NULL, 241 `WARNINGS` bigint(20) unsigned NOT NULL, 242 `ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 243 `ROWS_SENT` bigint(20) unsigned NOT NULL, 244 `ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 245 `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 246 `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 247 `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 248 `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 249 `SELECT_RANGE` bigint(20) unsigned NOT NULL, 250 `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 251 `SELECT_SCAN` bigint(20) unsigned NOT NULL, 252 `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 253 `SORT_RANGE` bigint(20) unsigned NOT NULL, 254 `SORT_ROWS` bigint(20) unsigned NOT NULL, 255 `SORT_SCAN` bigint(20) unsigned NOT NULL, 256 `NO_INDEX_USED` bigint(20) unsigned NOT NULL, 257 `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL, 258 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 259 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 260) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 261show create table events_statements_history_long; 262Table Create Table 263events_statements_history_long CREATE TABLE `events_statements_history_long` ( 264 `THREAD_ID` bigint(20) unsigned NOT NULL, 265 `EVENT_ID` bigint(20) unsigned NOT NULL, 266 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 267 `EVENT_NAME` varchar(128) NOT NULL, 268 `SOURCE` varchar(64) DEFAULT NULL, 269 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 270 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 271 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 272 `LOCK_TIME` bigint(20) unsigned NOT NULL, 273 `SQL_TEXT` longtext, 274 `DIGEST` varchar(32) DEFAULT NULL, 275 `DIGEST_TEXT` longtext, 276 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL, 277 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 278 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 279 `OBJECT_NAME` varchar(64) DEFAULT NULL, 280 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned DEFAULT NULL, 281 `MYSQL_ERRNO` int(11) DEFAULT NULL, 282 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL, 283 `MESSAGE_TEXT` varchar(128) DEFAULT NULL, 284 `ERRORS` bigint(20) unsigned NOT NULL, 285 `WARNINGS` bigint(20) unsigned NOT NULL, 286 `ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 287 `ROWS_SENT` bigint(20) unsigned NOT NULL, 288 `ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 289 `CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 290 `CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 291 `SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 292 `SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 293 `SELECT_RANGE` bigint(20) unsigned NOT NULL, 294 `SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 295 `SELECT_SCAN` bigint(20) unsigned NOT NULL, 296 `SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 297 `SORT_RANGE` bigint(20) unsigned NOT NULL, 298 `SORT_ROWS` bigint(20) unsigned NOT NULL, 299 `SORT_SCAN` bigint(20) unsigned NOT NULL, 300 `NO_INDEX_USED` bigint(20) unsigned NOT NULL, 301 `NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL, 302 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 303 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL 304) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 305show create table events_statements_summary_by_digest; 306Table Create Table 307events_statements_summary_by_digest CREATE TABLE `events_statements_summary_by_digest` ( 308 `SCHEMA_NAME` varchar(64) DEFAULT NULL, 309 `DIGEST` varchar(32) DEFAULT NULL, 310 `DIGEST_TEXT` longtext, 311 `COUNT_STAR` bigint(20) unsigned NOT NULL, 312 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 313 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 314 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 315 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 316 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 317 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 318 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 319 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 320 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 321 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 322 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 323 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 324 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 325 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 326 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 327 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 328 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 329 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 330 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 331 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 332 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 333 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 334 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL, 335 `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 336 `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' 337) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 338show create table events_statements_summary_by_host_by_event_name; 339Table Create Table 340events_statements_summary_by_host_by_event_name CREATE TABLE `events_statements_summary_by_host_by_event_name` ( 341 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 342 `EVENT_NAME` varchar(128) NOT NULL, 343 `COUNT_STAR` bigint(20) unsigned NOT NULL, 344 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 345 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 346 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 347 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 348 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 349 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 350 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 351 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 352 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 353 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 354 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 355 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 356 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 357 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 358 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 359 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 360 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 361 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 362 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 363 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 364 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 365 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 366 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL 367) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 368show create table events_statements_summary_by_thread_by_event_name; 369Table Create Table 370events_statements_summary_by_thread_by_event_name CREATE TABLE `events_statements_summary_by_thread_by_event_name` ( 371 `THREAD_ID` bigint(20) unsigned NOT NULL, 372 `EVENT_NAME` varchar(128) NOT NULL, 373 `COUNT_STAR` bigint(20) unsigned NOT NULL, 374 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 375 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 376 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 377 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 378 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 379 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 380 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 381 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 382 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 383 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 384 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 385 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 386 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 387 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 388 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 389 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 390 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 391 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 392 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 393 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 394 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 395 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 396 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL 397) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 398show create table events_statements_summary_by_user_by_event_name; 399Table Create Table 400events_statements_summary_by_user_by_event_name CREATE TABLE `events_statements_summary_by_user_by_event_name` ( 401 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 402 `EVENT_NAME` varchar(128) NOT NULL, 403 `COUNT_STAR` bigint(20) unsigned NOT NULL, 404 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 405 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 406 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 407 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 408 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 409 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 410 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 411 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 412 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 413 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 414 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 415 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 416 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 417 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 418 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 419 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 420 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 421 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 422 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 423 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 424 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 425 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 426 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL 427) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 428show create table events_statements_summary_by_account_by_event_name; 429Table Create Table 430events_statements_summary_by_account_by_event_name CREATE TABLE `events_statements_summary_by_account_by_event_name` ( 431 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 432 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 433 `EVENT_NAME` varchar(128) NOT NULL, 434 `COUNT_STAR` bigint(20) unsigned NOT NULL, 435 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 436 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 437 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 438 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 439 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 440 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 441 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 442 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 443 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 444 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 445 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 446 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 447 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 448 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 449 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 450 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 451 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 452 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 453 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 454 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 455 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 456 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 457 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL 458) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 459show create table events_statements_summary_global_by_event_name; 460Table Create Table 461events_statements_summary_global_by_event_name CREATE TABLE `events_statements_summary_global_by_event_name` ( 462 `EVENT_NAME` varchar(128) NOT NULL, 463 `COUNT_STAR` bigint(20) unsigned NOT NULL, 464 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 465 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 466 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 467 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 468 `SUM_LOCK_TIME` bigint(20) unsigned NOT NULL, 469 `SUM_ERRORS` bigint(20) unsigned NOT NULL, 470 `SUM_WARNINGS` bigint(20) unsigned NOT NULL, 471 `SUM_ROWS_AFFECTED` bigint(20) unsigned NOT NULL, 472 `SUM_ROWS_SENT` bigint(20) unsigned NOT NULL, 473 `SUM_ROWS_EXAMINED` bigint(20) unsigned NOT NULL, 474 `SUM_CREATED_TMP_DISK_TABLES` bigint(20) unsigned NOT NULL, 475 `SUM_CREATED_TMP_TABLES` bigint(20) unsigned NOT NULL, 476 `SUM_SELECT_FULL_JOIN` bigint(20) unsigned NOT NULL, 477 `SUM_SELECT_FULL_RANGE_JOIN` bigint(20) unsigned NOT NULL, 478 `SUM_SELECT_RANGE` bigint(20) unsigned NOT NULL, 479 `SUM_SELECT_RANGE_CHECK` bigint(20) unsigned NOT NULL, 480 `SUM_SELECT_SCAN` bigint(20) unsigned NOT NULL, 481 `SUM_SORT_MERGE_PASSES` bigint(20) unsigned NOT NULL, 482 `SUM_SORT_RANGE` bigint(20) unsigned NOT NULL, 483 `SUM_SORT_ROWS` bigint(20) unsigned NOT NULL, 484 `SUM_SORT_SCAN` bigint(20) unsigned NOT NULL, 485 `SUM_NO_INDEX_USED` bigint(20) unsigned NOT NULL, 486 `SUM_NO_GOOD_INDEX_USED` bigint(20) unsigned NOT NULL 487) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 488show create table events_waits_current; 489Table Create Table 490events_waits_current CREATE TABLE `events_waits_current` ( 491 `THREAD_ID` bigint(20) unsigned NOT NULL, 492 `EVENT_ID` bigint(20) unsigned NOT NULL, 493 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 494 `EVENT_NAME` varchar(128) NOT NULL, 495 `SOURCE` varchar(64) DEFAULT NULL, 496 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 497 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 498 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 499 `SPINS` int(10) unsigned DEFAULT NULL, 500 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 501 `OBJECT_NAME` varchar(512) DEFAULT NULL, 502 `INDEX_NAME` varchar(64) DEFAULT NULL, 503 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 504 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 505 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 506 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, 507 `OPERATION` varchar(32) NOT NULL, 508 `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, 509 `FLAGS` int(10) unsigned DEFAULT NULL 510) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 511show create table events_waits_history; 512Table Create Table 513events_waits_history CREATE TABLE `events_waits_history` ( 514 `THREAD_ID` bigint(20) unsigned NOT NULL, 515 `EVENT_ID` bigint(20) unsigned NOT NULL, 516 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 517 `EVENT_NAME` varchar(128) NOT NULL, 518 `SOURCE` varchar(64) DEFAULT NULL, 519 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 520 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 521 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 522 `SPINS` int(10) unsigned DEFAULT NULL, 523 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 524 `OBJECT_NAME` varchar(512) DEFAULT NULL, 525 `INDEX_NAME` varchar(64) DEFAULT NULL, 526 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 527 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 528 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 529 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, 530 `OPERATION` varchar(32) NOT NULL, 531 `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, 532 `FLAGS` int(10) unsigned DEFAULT NULL 533) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 534show create table events_waits_history_long; 535Table Create Table 536events_waits_history_long CREATE TABLE `events_waits_history_long` ( 537 `THREAD_ID` bigint(20) unsigned NOT NULL, 538 `EVENT_ID` bigint(20) unsigned NOT NULL, 539 `END_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 540 `EVENT_NAME` varchar(128) NOT NULL, 541 `SOURCE` varchar(64) DEFAULT NULL, 542 `TIMER_START` bigint(20) unsigned DEFAULT NULL, 543 `TIMER_END` bigint(20) unsigned DEFAULT NULL, 544 `TIMER_WAIT` bigint(20) unsigned DEFAULT NULL, 545 `SPINS` int(10) unsigned DEFAULT NULL, 546 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 547 `OBJECT_NAME` varchar(512) DEFAULT NULL, 548 `INDEX_NAME` varchar(64) DEFAULT NULL, 549 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 550 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 551 `NESTING_EVENT_ID` bigint(20) unsigned DEFAULT NULL, 552 `NESTING_EVENT_TYPE` enum('STATEMENT','STAGE','WAIT') DEFAULT NULL, 553 `OPERATION` varchar(32) NOT NULL, 554 `NUMBER_OF_BYTES` bigint(20) DEFAULT NULL, 555 `FLAGS` int(10) unsigned DEFAULT NULL 556) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 557show create table events_waits_summary_by_host_by_event_name; 558Table Create Table 559events_waits_summary_by_host_by_event_name CREATE TABLE `events_waits_summary_by_host_by_event_name` ( 560 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 561 `EVENT_NAME` varchar(128) NOT NULL, 562 `COUNT_STAR` bigint(20) unsigned NOT NULL, 563 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 564 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 565 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 566 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 567) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 568show create table events_waits_summary_by_instance; 569Table Create Table 570events_waits_summary_by_instance CREATE TABLE `events_waits_summary_by_instance` ( 571 `EVENT_NAME` varchar(128) NOT NULL, 572 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 573 `COUNT_STAR` bigint(20) unsigned NOT NULL, 574 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 575 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 576 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 577 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 578) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 579show create table events_waits_summary_by_thread_by_event_name; 580Table Create Table 581events_waits_summary_by_thread_by_event_name CREATE TABLE `events_waits_summary_by_thread_by_event_name` ( 582 `THREAD_ID` bigint(20) unsigned NOT NULL, 583 `EVENT_NAME` varchar(128) NOT NULL, 584 `COUNT_STAR` bigint(20) unsigned NOT NULL, 585 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 586 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 587 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 588 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 589) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 590show create table events_waits_summary_by_user_by_event_name; 591Table Create Table 592events_waits_summary_by_user_by_event_name CREATE TABLE `events_waits_summary_by_user_by_event_name` ( 593 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 594 `EVENT_NAME` varchar(128) NOT NULL, 595 `COUNT_STAR` bigint(20) unsigned NOT NULL, 596 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 597 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 598 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 599 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 600) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 601show create table events_waits_summary_by_account_by_event_name; 602Table Create Table 603events_waits_summary_by_account_by_event_name CREATE TABLE `events_waits_summary_by_account_by_event_name` ( 604 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 605 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 606 `EVENT_NAME` varchar(128) NOT NULL, 607 `COUNT_STAR` bigint(20) unsigned NOT NULL, 608 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 609 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 610 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 611 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 612) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 613show create table events_waits_summary_global_by_event_name; 614Table Create Table 615events_waits_summary_global_by_event_name CREATE TABLE `events_waits_summary_global_by_event_name` ( 616 `EVENT_NAME` varchar(128) NOT NULL, 617 `COUNT_STAR` bigint(20) unsigned NOT NULL, 618 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 619 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 620 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 621 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 622) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 623show create table file_instances; 624Table Create Table 625file_instances CREATE TABLE `file_instances` ( 626 `FILE_NAME` varchar(512) NOT NULL, 627 `EVENT_NAME` varchar(128) NOT NULL, 628 `OPEN_COUNT` int(10) unsigned NOT NULL 629) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 630show create table file_summary_by_event_name; 631Table Create Table 632file_summary_by_event_name CREATE TABLE `file_summary_by_event_name` ( 633 `EVENT_NAME` varchar(128) NOT NULL, 634 `COUNT_STAR` bigint(20) unsigned NOT NULL, 635 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 636 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 637 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 638 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 639 `COUNT_READ` bigint(20) unsigned NOT NULL, 640 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 641 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 642 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 643 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 644 `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL, 645 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 646 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 647 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 648 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 649 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 650 `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL, 651 `COUNT_MISC` bigint(20) unsigned NOT NULL, 652 `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, 653 `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, 654 `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, 655 `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL 656) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 657show create table file_summary_by_instance; 658Table Create Table 659file_summary_by_instance CREATE TABLE `file_summary_by_instance` ( 660 `FILE_NAME` varchar(512) NOT NULL, 661 `EVENT_NAME` varchar(128) NOT NULL, 662 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 663 `COUNT_STAR` bigint(20) unsigned NOT NULL, 664 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 665 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 666 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 667 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 668 `COUNT_READ` bigint(20) unsigned NOT NULL, 669 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 670 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 671 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 672 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 673 `SUM_NUMBER_OF_BYTES_READ` bigint(20) NOT NULL, 674 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 675 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 676 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 677 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 678 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 679 `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) NOT NULL, 680 `COUNT_MISC` bigint(20) unsigned NOT NULL, 681 `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, 682 `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, 683 `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, 684 `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL 685) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 686show create table host_cache; 687Table Create Table 688host_cache CREATE TABLE `host_cache` ( 689 `IP` varchar(64) NOT NULL, 690 `HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 691 `HOST_VALIDATED` enum('YES','NO') NOT NULL, 692 `SUM_CONNECT_ERRORS` bigint(20) NOT NULL, 693 `COUNT_HOST_BLOCKED_ERRORS` bigint(20) NOT NULL, 694 `COUNT_NAMEINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL, 695 `COUNT_NAMEINFO_PERMANENT_ERRORS` bigint(20) NOT NULL, 696 `COUNT_FORMAT_ERRORS` bigint(20) NOT NULL, 697 `COUNT_ADDRINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL, 698 `COUNT_ADDRINFO_PERMANENT_ERRORS` bigint(20) NOT NULL, 699 `COUNT_FCRDNS_ERRORS` bigint(20) NOT NULL, 700 `COUNT_HOST_ACL_ERRORS` bigint(20) NOT NULL, 701 `COUNT_NO_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL, 702 `COUNT_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL, 703 `COUNT_HANDSHAKE_ERRORS` bigint(20) NOT NULL, 704 `COUNT_PROXY_USER_ERRORS` bigint(20) NOT NULL, 705 `COUNT_PROXY_USER_ACL_ERRORS` bigint(20) NOT NULL, 706 `COUNT_AUTHENTICATION_ERRORS` bigint(20) NOT NULL, 707 `COUNT_SSL_ERRORS` bigint(20) NOT NULL, 708 `COUNT_MAX_USER_CONNECTIONS_ERRORS` bigint(20) NOT NULL, 709 `COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS` bigint(20) NOT NULL, 710 `COUNT_DEFAULT_DATABASE_ERRORS` bigint(20) NOT NULL, 711 `COUNT_INIT_CONNECT_ERRORS` bigint(20) NOT NULL, 712 `COUNT_LOCAL_ERRORS` bigint(20) NOT NULL, 713 `COUNT_UNKNOWN_ERRORS` bigint(20) NOT NULL, 714 `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 715 `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 716 `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00', 717 `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00' 718) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 719show create table hosts; 720Table Create Table 721hosts CREATE TABLE `hosts` ( 722 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 723 `CURRENT_CONNECTIONS` bigint(20) NOT NULL, 724 `TOTAL_CONNECTIONS` bigint(20) NOT NULL 725) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 726show create table mutex_instances; 727Table Create Table 728mutex_instances CREATE TABLE `mutex_instances` ( 729 `NAME` varchar(128) NOT NULL, 730 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 731 `LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL 732) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 733show create table objects_summary_global_by_type; 734Table Create Table 735objects_summary_global_by_type CREATE TABLE `objects_summary_global_by_type` ( 736 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 737 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 738 `OBJECT_NAME` varchar(64) DEFAULT NULL, 739 `COUNT_STAR` bigint(20) unsigned NOT NULL, 740 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 741 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 742 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 743 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL 744) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 745show create table performance_timers; 746Table Create Table 747performance_timers CREATE TABLE `performance_timers` ( 748 `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL, 749 `TIMER_FREQUENCY` bigint(20) DEFAULT NULL, 750 `TIMER_RESOLUTION` bigint(20) DEFAULT NULL, 751 `TIMER_OVERHEAD` bigint(20) DEFAULT NULL 752) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 753show create table rwlock_instances; 754Table Create Table 755rwlock_instances CREATE TABLE `rwlock_instances` ( 756 `NAME` varchar(128) NOT NULL, 757 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 758 `WRITE_LOCKED_BY_THREAD_ID` bigint(20) unsigned DEFAULT NULL, 759 `READ_LOCKED_BY_COUNT` int(10) unsigned NOT NULL 760) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 761show create table setup_actors; 762Table Create Table 763setup_actors CREATE TABLE `setup_actors` ( 764 `HOST` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', 765 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%', 766 `ROLE` char(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '%' 767) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 768show create table setup_consumers; 769Table Create Table 770setup_consumers CREATE TABLE `setup_consumers` ( 771 `NAME` varchar(64) NOT NULL, 772 `ENABLED` enum('YES','NO') NOT NULL 773) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 774show create table setup_instruments; 775Table Create Table 776setup_instruments CREATE TABLE `setup_instruments` ( 777 `NAME` varchar(128) NOT NULL, 778 `ENABLED` enum('YES','NO') NOT NULL, 779 `TIMED` enum('YES','NO') NOT NULL 780) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 781show create table setup_objects; 782Table Create Table 783setup_objects CREATE TABLE `setup_objects` ( 784 `OBJECT_TYPE` enum('TABLE') NOT NULL DEFAULT 'TABLE', 785 `OBJECT_SCHEMA` varchar(64) DEFAULT '%', 786 `OBJECT_NAME` varchar(64) NOT NULL DEFAULT '%', 787 `ENABLED` enum('YES','NO') NOT NULL DEFAULT 'YES', 788 `TIMED` enum('YES','NO') NOT NULL DEFAULT 'YES' 789) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 790show create table setup_timers; 791Table Create Table 792setup_timers CREATE TABLE `setup_timers` ( 793 `NAME` varchar(64) NOT NULL, 794 `TIMER_NAME` enum('CYCLE','NANOSECOND','MICROSECOND','MILLISECOND','TICK') NOT NULL 795) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 796show create table socket_instances; 797Table Create Table 798socket_instances CREATE TABLE `socket_instances` ( 799 `EVENT_NAME` varchar(128) NOT NULL, 800 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 801 `THREAD_ID` bigint(20) unsigned DEFAULT NULL, 802 `SOCKET_ID` int(11) NOT NULL, 803 `IP` varchar(64) NOT NULL, 804 `PORT` int(11) NOT NULL, 805 `STATE` enum('IDLE','ACTIVE') NOT NULL 806) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 807show create table socket_summary_by_instance; 808Table Create Table 809socket_summary_by_instance CREATE TABLE `socket_summary_by_instance` ( 810 `EVENT_NAME` varchar(128) NOT NULL, 811 `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL, 812 `COUNT_STAR` bigint(20) unsigned NOT NULL, 813 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 814 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 815 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 816 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 817 `COUNT_READ` bigint(20) unsigned NOT NULL, 818 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 819 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 820 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 821 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 822 `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL, 823 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 824 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 825 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 826 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 827 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 828 `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL, 829 `COUNT_MISC` bigint(20) unsigned NOT NULL, 830 `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, 831 `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, 832 `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, 833 `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL 834) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 835show create table socket_summary_by_event_name; 836Table Create Table 837socket_summary_by_event_name CREATE TABLE `socket_summary_by_event_name` ( 838 `EVENT_NAME` varchar(128) NOT NULL, 839 `COUNT_STAR` bigint(20) unsigned NOT NULL, 840 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 841 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 842 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 843 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 844 `COUNT_READ` bigint(20) unsigned NOT NULL, 845 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 846 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 847 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 848 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 849 `SUM_NUMBER_OF_BYTES_READ` bigint(20) unsigned NOT NULL, 850 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 851 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 852 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 853 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 854 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 855 `SUM_NUMBER_OF_BYTES_WRITE` bigint(20) unsigned NOT NULL, 856 `COUNT_MISC` bigint(20) unsigned NOT NULL, 857 `SUM_TIMER_MISC` bigint(20) unsigned NOT NULL, 858 `MIN_TIMER_MISC` bigint(20) unsigned NOT NULL, 859 `AVG_TIMER_MISC` bigint(20) unsigned NOT NULL, 860 `MAX_TIMER_MISC` bigint(20) unsigned NOT NULL 861) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 862show create table table_io_waits_summary_by_index_usage; 863Table Create Table 864table_io_waits_summary_by_index_usage CREATE TABLE `table_io_waits_summary_by_index_usage` ( 865 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 866 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 867 `OBJECT_NAME` varchar(64) DEFAULT NULL, 868 `INDEX_NAME` varchar(64) DEFAULT NULL, 869 `COUNT_STAR` bigint(20) unsigned NOT NULL, 870 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 871 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 872 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 873 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 874 `COUNT_READ` bigint(20) unsigned NOT NULL, 875 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 876 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 877 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 878 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 879 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 880 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 881 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 882 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 883 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 884 `COUNT_FETCH` bigint(20) unsigned NOT NULL, 885 `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL, 886 `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL, 887 `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL, 888 `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL, 889 `COUNT_INSERT` bigint(20) unsigned NOT NULL, 890 `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL, 891 `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL, 892 `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL, 893 `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL, 894 `COUNT_UPDATE` bigint(20) unsigned NOT NULL, 895 `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 896 `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 897 `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 898 `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 899 `COUNT_DELETE` bigint(20) unsigned NOT NULL, 900 `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL, 901 `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL, 902 `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL, 903 `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL 904) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 905show create table table_io_waits_summary_by_table; 906Table Create Table 907table_io_waits_summary_by_table CREATE TABLE `table_io_waits_summary_by_table` ( 908 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 909 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 910 `OBJECT_NAME` varchar(64) DEFAULT NULL, 911 `COUNT_STAR` bigint(20) unsigned NOT NULL, 912 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 913 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 914 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 915 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 916 `COUNT_READ` bigint(20) unsigned NOT NULL, 917 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 918 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 919 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 920 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 921 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 922 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 923 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 924 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 925 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 926 `COUNT_FETCH` bigint(20) unsigned NOT NULL, 927 `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL, 928 `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL, 929 `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL, 930 `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL, 931 `COUNT_INSERT` bigint(20) unsigned NOT NULL, 932 `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL, 933 `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL, 934 `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL, 935 `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL, 936 `COUNT_UPDATE` bigint(20) unsigned NOT NULL, 937 `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 938 `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 939 `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 940 `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL, 941 `COUNT_DELETE` bigint(20) unsigned NOT NULL, 942 `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL, 943 `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL, 944 `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL, 945 `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL 946) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 947show create table table_lock_waits_summary_by_table; 948Table Create Table 949table_lock_waits_summary_by_table CREATE TABLE `table_lock_waits_summary_by_table` ( 950 `OBJECT_TYPE` varchar(64) DEFAULT NULL, 951 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, 952 `OBJECT_NAME` varchar(64) DEFAULT NULL, 953 `COUNT_STAR` bigint(20) unsigned NOT NULL, 954 `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL, 955 `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL, 956 `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL, 957 `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL, 958 `COUNT_READ` bigint(20) unsigned NOT NULL, 959 `SUM_TIMER_READ` bigint(20) unsigned NOT NULL, 960 `MIN_TIMER_READ` bigint(20) unsigned NOT NULL, 961 `AVG_TIMER_READ` bigint(20) unsigned NOT NULL, 962 `MAX_TIMER_READ` bigint(20) unsigned NOT NULL, 963 `COUNT_WRITE` bigint(20) unsigned NOT NULL, 964 `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL, 965 `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL, 966 `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL, 967 `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL, 968 `COUNT_READ_NORMAL` bigint(20) unsigned NOT NULL, 969 `SUM_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL, 970 `MIN_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL, 971 `AVG_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL, 972 `MAX_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL, 973 `COUNT_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL, 974 `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL, 975 `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL, 976 `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL, 977 `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL, 978 `COUNT_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL, 979 `SUM_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL, 980 `MIN_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL, 981 `AVG_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL, 982 `MAX_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL, 983 `COUNT_READ_NO_INSERT` bigint(20) unsigned NOT NULL, 984 `SUM_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL, 985 `MIN_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL, 986 `AVG_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL, 987 `MAX_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL, 988 `COUNT_READ_EXTERNAL` bigint(20) unsigned NOT NULL, 989 `SUM_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL, 990 `MIN_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL, 991 `AVG_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL, 992 `MAX_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL, 993 `COUNT_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL, 994 `SUM_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL, 995 `MIN_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL, 996 `AVG_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL, 997 `MAX_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL, 998 `COUNT_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL, 999 `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL, 1000 `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL, 1001 `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL, 1002 `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL, 1003 `COUNT_WRITE_DELAYED` bigint(20) unsigned NOT NULL, 1004 `SUM_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL, 1005 `MIN_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL, 1006 `AVG_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL, 1007 `MAX_TIMER_WRITE_DELAYED` bigint(20) unsigned NOT NULL, 1008 `COUNT_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL, 1009 `SUM_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL, 1010 `MIN_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL, 1011 `AVG_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL, 1012 `MAX_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL, 1013 `COUNT_WRITE_NORMAL` bigint(20) unsigned NOT NULL, 1014 `SUM_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL, 1015 `MIN_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL, 1016 `AVG_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL, 1017 `MAX_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL, 1018 `COUNT_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, 1019 `SUM_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, 1020 `MIN_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, 1021 `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL, 1022 `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL 1023) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 1024show create table threads; 1025Table Create Table 1026threads CREATE TABLE `threads` ( 1027 `THREAD_ID` bigint(20) unsigned NOT NULL, 1028 `NAME` varchar(128) NOT NULL, 1029 `TYPE` varchar(10) NOT NULL, 1030 `PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL, 1031 `PROCESSLIST_USER` varchar(16) DEFAULT NULL, 1032 `PROCESSLIST_HOST` varchar(60) DEFAULT NULL, 1033 `PROCESSLIST_DB` varchar(64) DEFAULT NULL, 1034 `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL, 1035 `PROCESSLIST_TIME` bigint(20) DEFAULT NULL, 1036 `PROCESSLIST_STATE` varchar(64) DEFAULT NULL, 1037 `PROCESSLIST_INFO` longtext, 1038 `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL, 1039 `ROLE` varchar(64) DEFAULT NULL, 1040 `INSTRUMENTED` enum('YES','NO') NOT NULL 1041) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 1042show create table users; 1043Table Create Table 1044users CREATE TABLE `users` ( 1045 `USER` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, 1046 `CURRENT_CONNECTIONS` bigint(20) NOT NULL, 1047 `TOTAL_CONNECTIONS` bigint(20) NOT NULL 1048) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 1049