1update performance_schema.setup_instruments 2set enabled='NO' where name='wait/lock/table/sql/handler'; 3delete from performance_schema.setup_actors 4where user in ('user2', 'user4'); 5delete from performance_schema.setup_objects 6where object_name='t2'; 7select * from performance_schema.setup_actors 8order by USER, HOST, ROLE; 9HOST USER ROLE 10localhost user1 % 11localhost user3 % 12select * from performance_schema.setup_objects 13order by object_type, object_schema, object_name; 14OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED 15TABLE test t1 YES YES 16TABLE test t3 YES NO 17select * from performance_schema.setup_consumers; 18NAME ENABLED 19events_stages_current YES 20events_stages_history YES 21events_stages_history_long YES 22events_statements_current YES 23events_statements_history YES 24events_statements_history_long YES 25events_waits_current YES 26events_waits_history YES 27events_waits_history_long YES 28global_instrumentation YES 29thread_instrumentation YES 30statements_digest YES 31flush tables; 32truncate performance_schema.objects_summary_global_by_type; 33truncate performance_schema.table_io_waits_summary_by_index_usage; 34truncate performance_schema.table_io_waits_summary_by_table; 35truncate performance_schema.table_lock_waits_summary_by_table; 36truncate performance_schema.events_waits_summary_by_thread_by_event_name; 37truncate performance_schema.events_waits_summary_by_account_by_event_name; 38truncate performance_schema.events_waits_summary_by_user_by_event_name; 39truncate performance_schema.events_waits_summary_by_host_by_event_name; 40truncate performance_schema.events_waits_summary_global_by_event_name; 41truncate performance_schema.events_waits_history_long; 42show variables where 43`Variable_name` != "performance_schema_max_statement_classes" and 44`Variable_name` like "performance_schema%"; 45Variable_name Value 46performance_schema ON 47performance_schema_accounts_size 100 48performance_schema_digests_size 200 49performance_schema_events_stages_history_long_size 1000 50performance_schema_events_stages_history_size 10 51performance_schema_events_statements_history_long_size 1000 52performance_schema_events_statements_history_size 10 53performance_schema_events_waits_history_long_size 10000 54performance_schema_events_waits_history_size 10 55performance_schema_hosts_size 100 56performance_schema_max_cond_classes 80 57performance_schema_max_cond_instances 1000 58performance_schema_max_digest_length 1024 59performance_schema_max_file_classes 50 60performance_schema_max_file_handles 32768 61performance_schema_max_file_instances 10000 62performance_schema_max_mutex_classes 200 63performance_schema_max_mutex_instances 5000 64performance_schema_max_rwlock_classes 40 65performance_schema_max_rwlock_instances 5000 66performance_schema_max_socket_classes 10 67performance_schema_max_socket_instances 1000 68performance_schema_max_stage_classes 150 69performance_schema_max_table_handles 1000 70performance_schema_max_table_instances 500 71performance_schema_max_thread_classes 50 72performance_schema_max_thread_instances 200 73performance_schema_session_connect_attrs_size 2048 74performance_schema_setup_actors_size 100 75performance_schema_setup_objects_size 100 76performance_schema_users_size 100 77show status like "performance_schema%"; 78Variable_name Value 79Performance_schema_accounts_lost 0 80Performance_schema_cond_classes_lost 0 81Performance_schema_cond_instances_lost 0 82Performance_schema_digest_lost 0 83Performance_schema_file_classes_lost 0 84Performance_schema_file_handles_lost 0 85Performance_schema_file_instances_lost 0 86Performance_schema_hosts_lost 0 87Performance_schema_locker_lost 0 88Performance_schema_mutex_classes_lost 0 89Performance_schema_mutex_instances_lost 0 90Performance_schema_rwlock_classes_lost 0 91Performance_schema_rwlock_instances_lost 0 92Performance_schema_session_connect_attrs_lost 0 93Performance_schema_socket_classes_lost 0 94Performance_schema_socket_instances_lost 0 95Performance_schema_stage_classes_lost 0 96Performance_schema_statement_classes_lost 0 97Performance_schema_table_handles_lost 0 98Performance_schema_table_instances_lost 0 99Performance_schema_thread_classes_lost 0 100Performance_schema_thread_instances_lost 0 101Performance_schema_users_lost 0 102"================== Step 1 ==================" 103call dump_thread(); 104username status 105user1 not found 106username status 107user2 not found 108username status 109user3 not found 110username status 111user4 not found 112execute dump_waits_account; 113user host event_name count_star 114execute dump_waits_user; 115user event_name count_star 116execute dump_waits_host; 117host event_name count_star 118localhost wait/io/table/sql/handler 0 119localhost wait/lock/table/sql/handler 0 120execute dump_waits_global; 121event_name count_star 122wait/io/table/sql/handler 0 123wait/lock/table/sql/handler 0 124execute dump_waits_history; 125event_name count(event_name) object_type object_schema object_name 126execute dump_waits_index_io; 127object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 128TABLE test t1 NULL 0 0 0 0 0 0 0 129TABLE test t1 index_b 0 0 0 0 0 0 0 130TABLE test t1 index_cb 0 0 0 0 0 0 0 131TABLE test t1 PRIMARY 0 0 0 0 0 0 0 132TABLE test t2 NULL 0 0 0 0 0 0 0 133TABLE test t2 index_b 0 0 0 0 0 0 0 134TABLE test t2 index_cb 0 0 0 0 0 0 0 135TABLE test t2 PRIMARY 0 0 0 0 0 0 0 136TABLE test t3 NULL 0 0 0 0 0 0 0 137TABLE test t3 index_b 0 0 0 0 0 0 0 138TABLE test t3 index_cb 0 0 0 0 0 0 0 139TABLE test t3 PRIMARY 0 0 0 0 0 0 0 140execute dump_waits_table_io; 141object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 142TABLE test t1 0 0 0 0 0 0 0 143TABLE test t2 0 0 0 0 0 0 0 144TABLE test t3 0 0 0 0 0 0 0 145execute dump_waits_table_lock; 146object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 147TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 148TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 149TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 150execute dump_objects_summary; 151object_type object_schema object_name count_star 152TABLE test t1 0 153TABLE test t2 0 154TABLE test t3 0 155select concat(current_user(), " is connected") as status; 156status 157user1@localhost is connected 158"================== Step 2 ==================" 159call dump_thread(); 160username event_name count_star 161user1 wait/io/table/sql/handler 0 162user1 wait/lock/table/sql/handler 0 163username status 164user2 not found 165username status 166user3 not found 167username status 168user4 not found 169execute dump_waits_account; 170user host event_name count_star 171user1 localhost wait/io/table/sql/handler 0 172user1 localhost wait/lock/table/sql/handler 0 173execute dump_waits_user; 174user event_name count_star 175user1 wait/io/table/sql/handler 0 176user1 wait/lock/table/sql/handler 0 177execute dump_waits_host; 178host event_name count_star 179localhost wait/io/table/sql/handler 0 180localhost wait/lock/table/sql/handler 0 181execute dump_waits_global; 182event_name count_star 183wait/io/table/sql/handler 0 184wait/lock/table/sql/handler 0 185execute dump_waits_history; 186event_name count(event_name) object_type object_schema object_name 187execute dump_waits_index_io; 188object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 189TABLE test t1 NULL 0 0 0 0 0 0 0 190TABLE test t1 index_b 0 0 0 0 0 0 0 191TABLE test t1 index_cb 0 0 0 0 0 0 0 192TABLE test t1 PRIMARY 0 0 0 0 0 0 0 193TABLE test t2 NULL 0 0 0 0 0 0 0 194TABLE test t2 index_b 0 0 0 0 0 0 0 195TABLE test t2 index_cb 0 0 0 0 0 0 0 196TABLE test t2 PRIMARY 0 0 0 0 0 0 0 197TABLE test t3 NULL 0 0 0 0 0 0 0 198TABLE test t3 index_b 0 0 0 0 0 0 0 199TABLE test t3 index_cb 0 0 0 0 0 0 0 200TABLE test t3 PRIMARY 0 0 0 0 0 0 0 201execute dump_waits_table_io; 202object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 203TABLE test t1 0 0 0 0 0 0 0 204TABLE test t2 0 0 0 0 0 0 0 205TABLE test t3 0 0 0 0 0 0 0 206execute dump_waits_table_lock; 207object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 208TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 209TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 210TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 211execute dump_objects_summary; 212object_type object_schema object_name count_star 213TABLE test t1 0 214TABLE test t2 0 215TABLE test t3 0 216insert into test.t1 set a=101, b=1, c=1; 217insert into test.t2 set a=102, b=2, c=2; 218insert into test.t2 set a=103, b=3, c=3; 219insert into test.t3 set a=104, b=4, c=4; 220insert into test.t3 set a=105, b=5, c=5; 221insert into test.t3 set a=106, b=6, c=6; 222select * from test.t1; 223a b c d 224101 1 1 0 225select * from test.t2; 226a b c d 227102 2 2 0 228103 3 3 0 229select * from test.t3; 230a b c d 231104 4 4 0 232105 5 5 0 233106 6 6 0 234update test.t1 set d=d+1; 235update test.t2 set d=d+1; 236update test.t3 set d=d+1; 237update test.t1 set d=d+1 where a=101; 238update test.t2 set d=d+1 where a=101; 239update test.t3 set d=d+1 where a=101; 240select * from test.t1 where b=5; 241a b c d 242select * from test.t2 where b=5; 243a b c d 244select * from test.t3 where b=5; 245a b c d 246105 5 5 1 247"================== con1 marker ==================" 248"================== Step 3 ==================" 249call dump_thread(); 250username event_name count_star 251user1 wait/io/table/sql/handler 23 252user1 wait/lock/table/sql/handler 0 253username status 254user2 not found 255username status 256user3 not found 257username status 258user4 not found 259execute dump_waits_account; 260user host event_name count_star 261user1 localhost wait/io/table/sql/handler 23 262user1 localhost wait/lock/table/sql/handler 0 263execute dump_waits_user; 264user event_name count_star 265user1 wait/io/table/sql/handler 23 266user1 wait/lock/table/sql/handler 0 267execute dump_waits_host; 268host event_name count_star 269localhost wait/io/table/sql/handler 23 270localhost wait/lock/table/sql/handler 0 271execute dump_waits_global; 272event_name count_star 273wait/io/table/sql/handler 23 274wait/lock/table/sql/handler 0 275execute dump_waits_history; 276event_name count(event_name) object_type object_schema object_name 277wait/io/table/sql/handler 6 TABLE test t1 278wait/io/table/sql/handler 17 TABLE test t3 279execute dump_waits_index_io; 280object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 281TABLE test t1 NULL 4 2 2 2 1 1 0 282TABLE test t1 index_b 0 0 0 0 0 0 0 283TABLE test t1 index_cb 0 0 0 0 0 0 0 284TABLE test t1 PRIMARY 2 1 1 1 0 1 0 285TABLE test t2 NULL 0 0 0 0 0 0 0 286TABLE test t2 index_b 0 0 0 0 0 0 0 287TABLE test t2 index_cb 0 0 0 0 0 0 0 288TABLE test t2 PRIMARY 0 0 0 0 0 0 0 289TABLE test t3 NULL 14 8 6 8 3 3 0 290TABLE test t3 index_b 2 2 0 2 0 0 0 291TABLE test t3 index_cb 0 0 0 0 0 0 0 292TABLE test t3 PRIMARY 1 1 0 1 0 0 0 293execute dump_waits_table_io; 294object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 295TABLE test t1 6 3 3 3 1 2 0 296TABLE test t2 0 0 0 0 0 0 0 297TABLE test t3 17 11 6 11 3 3 0 298execute dump_waits_table_lock; 299object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 300TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 301TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 302TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 303execute dump_objects_summary; 304object_type object_schema object_name count_star 305TABLE test t1 6 306TABLE test t2 0 307TABLE test t3 17 308select concat(current_user(), " is connected") as status; 309status 310user2@localhost is connected 311"================== Step 4 ==================" 312call dump_thread(); 313username event_name count_star 314user1 wait/io/table/sql/handler 23 315user1 wait/lock/table/sql/handler 0 316username event_name count_star 317user2 wait/io/table/sql/handler 0 318user2 wait/lock/table/sql/handler 0 319username status 320user3 not found 321username status 322user4 not found 323execute dump_waits_account; 324user host event_name count_star 325user1 localhost wait/io/table/sql/handler 23 326user1 localhost wait/lock/table/sql/handler 0 327user2 localhost wait/io/table/sql/handler 0 328user2 localhost wait/lock/table/sql/handler 0 329execute dump_waits_user; 330user event_name count_star 331user1 wait/io/table/sql/handler 23 332user1 wait/lock/table/sql/handler 0 333user2 wait/io/table/sql/handler 0 334user2 wait/lock/table/sql/handler 0 335execute dump_waits_host; 336host event_name count_star 337localhost wait/io/table/sql/handler 23 338localhost wait/lock/table/sql/handler 0 339execute dump_waits_global; 340event_name count_star 341wait/io/table/sql/handler 23 342wait/lock/table/sql/handler 0 343execute dump_waits_history; 344event_name count(event_name) object_type object_schema object_name 345wait/io/table/sql/handler 6 TABLE test t1 346wait/io/table/sql/handler 17 TABLE test t3 347execute dump_waits_index_io; 348object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 349TABLE test t1 NULL 4 2 2 2 1 1 0 350TABLE test t1 index_b 0 0 0 0 0 0 0 351TABLE test t1 index_cb 0 0 0 0 0 0 0 352TABLE test t1 PRIMARY 2 1 1 1 0 1 0 353TABLE test t2 NULL 0 0 0 0 0 0 0 354TABLE test t2 index_b 0 0 0 0 0 0 0 355TABLE test t2 index_cb 0 0 0 0 0 0 0 356TABLE test t2 PRIMARY 0 0 0 0 0 0 0 357TABLE test t3 NULL 14 8 6 8 3 3 0 358TABLE test t3 index_b 2 2 0 2 0 0 0 359TABLE test t3 index_cb 0 0 0 0 0 0 0 360TABLE test t3 PRIMARY 1 1 0 1 0 0 0 361execute dump_waits_table_io; 362object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 363TABLE test t1 6 3 3 3 1 2 0 364TABLE test t2 0 0 0 0 0 0 0 365TABLE test t3 17 11 6 11 3 3 0 366execute dump_waits_table_lock; 367object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 368TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 369TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 370TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 371execute dump_objects_summary; 372object_type object_schema object_name count_star 373TABLE test t1 6 374TABLE test t2 0 375TABLE test t3 17 376insert into test.t1 set a=201, b=1, c=1; 377insert into test.t2 set a=202, b=2, c=2; 378insert into test.t2 set a=203, b=3, c=3; 379insert into test.t3 set a=204, b=4, c=4; 380insert into test.t3 set a=205, b=5, c=5; 381insert into test.t3 set a=206, b=6, c=6; 382select * from test.t1; 383a b c d 384101 1 1 2 385201 1 1 0 386select * from test.t2; 387a b c d 388102 2 2 1 389103 3 3 1 390202 2 2 0 391203 3 3 0 392select * from test.t3; 393a b c d 394104 4 4 1 395105 5 5 1 396106 6 6 1 397204 4 4 0 398205 5 5 0 399206 6 6 0 400update test.t1 set d=d+1; 401update test.t2 set d=d+1; 402update test.t3 set d=d+1; 403update test.t1 set d=d+1 where a=201; 404update test.t2 set d=d+1 where a=201; 405update test.t3 set d=d+1 where a=201; 406select * from test.t1 where b=5; 407a b c d 408select * from test.t2 where b=5; 409a b c d 410select * from test.t3 where b=5; 411a b c d 412105 5 5 2 413205 5 5 1 414"================== con2 marker ==================" 415"================== Step 5 ==================" 416call dump_thread(); 417username event_name count_star 418user1 wait/io/table/sql/handler 23 419user1 wait/lock/table/sql/handler 0 420username event_name count_star 421user2 wait/io/table/sql/handler 0 422user2 wait/lock/table/sql/handler 0 423username status 424user3 not found 425username status 426user4 not found 427execute dump_waits_account; 428user host event_name count_star 429user1 localhost wait/io/table/sql/handler 23 430user1 localhost wait/lock/table/sql/handler 0 431user2 localhost wait/io/table/sql/handler 0 432user2 localhost wait/lock/table/sql/handler 0 433execute dump_waits_user; 434user event_name count_star 435user1 wait/io/table/sql/handler 23 436user1 wait/lock/table/sql/handler 0 437user2 wait/io/table/sql/handler 0 438user2 wait/lock/table/sql/handler 0 439execute dump_waits_host; 440host event_name count_star 441localhost wait/io/table/sql/handler 23 442localhost wait/lock/table/sql/handler 0 443execute dump_waits_global; 444event_name count_star 445wait/io/table/sql/handler 23 446wait/lock/table/sql/handler 0 447execute dump_waits_history; 448event_name count(event_name) object_type object_schema object_name 449wait/io/table/sql/handler 6 TABLE test t1 450wait/io/table/sql/handler 17 TABLE test t3 451execute dump_waits_index_io; 452object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 453TABLE test t1 NULL 4 2 2 2 1 1 0 454TABLE test t1 index_b 0 0 0 0 0 0 0 455TABLE test t1 index_cb 0 0 0 0 0 0 0 456TABLE test t1 PRIMARY 2 1 1 1 0 1 0 457TABLE test t2 NULL 0 0 0 0 0 0 0 458TABLE test t2 index_b 0 0 0 0 0 0 0 459TABLE test t2 index_cb 0 0 0 0 0 0 0 460TABLE test t2 PRIMARY 0 0 0 0 0 0 0 461TABLE test t3 NULL 14 8 6 8 3 3 0 462TABLE test t3 index_b 2 2 0 2 0 0 0 463TABLE test t3 index_cb 0 0 0 0 0 0 0 464TABLE test t3 PRIMARY 1 1 0 1 0 0 0 465execute dump_waits_table_io; 466object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 467TABLE test t1 6 3 3 3 1 2 0 468TABLE test t2 0 0 0 0 0 0 0 469TABLE test t3 17 11 6 11 3 3 0 470execute dump_waits_table_lock; 471object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 472TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 473TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 474TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 475execute dump_objects_summary; 476object_type object_schema object_name count_star 477TABLE test t1 6 478TABLE test t2 0 479TABLE test t3 17 480select concat(current_user(), " is connected") as status; 481status 482user3@localhost is connected 483"================== Step 6 ==================" 484call dump_thread(); 485username event_name count_star 486user1 wait/io/table/sql/handler 23 487user1 wait/lock/table/sql/handler 0 488username event_name count_star 489user2 wait/io/table/sql/handler 0 490user2 wait/lock/table/sql/handler 0 491username event_name count_star 492user3 wait/io/table/sql/handler 0 493user3 wait/lock/table/sql/handler 0 494username status 495user4 not found 496execute dump_waits_account; 497user host event_name count_star 498user1 localhost wait/io/table/sql/handler 23 499user1 localhost wait/lock/table/sql/handler 0 500user2 localhost wait/io/table/sql/handler 0 501user2 localhost wait/lock/table/sql/handler 0 502user3 localhost wait/io/table/sql/handler 0 503user3 localhost wait/lock/table/sql/handler 0 504execute dump_waits_user; 505user event_name count_star 506user1 wait/io/table/sql/handler 23 507user1 wait/lock/table/sql/handler 0 508user2 wait/io/table/sql/handler 0 509user2 wait/lock/table/sql/handler 0 510user3 wait/io/table/sql/handler 0 511user3 wait/lock/table/sql/handler 0 512execute dump_waits_host; 513host event_name count_star 514localhost wait/io/table/sql/handler 23 515localhost wait/lock/table/sql/handler 0 516execute dump_waits_global; 517event_name count_star 518wait/io/table/sql/handler 23 519wait/lock/table/sql/handler 0 520execute dump_waits_history; 521event_name count(event_name) object_type object_schema object_name 522wait/io/table/sql/handler 6 TABLE test t1 523wait/io/table/sql/handler 17 TABLE test t3 524execute dump_waits_index_io; 525object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 526TABLE test t1 NULL 4 2 2 2 1 1 0 527TABLE test t1 index_b 0 0 0 0 0 0 0 528TABLE test t1 index_cb 0 0 0 0 0 0 0 529TABLE test t1 PRIMARY 2 1 1 1 0 1 0 530TABLE test t2 NULL 0 0 0 0 0 0 0 531TABLE test t2 index_b 0 0 0 0 0 0 0 532TABLE test t2 index_cb 0 0 0 0 0 0 0 533TABLE test t2 PRIMARY 0 0 0 0 0 0 0 534TABLE test t3 NULL 14 8 6 8 3 3 0 535TABLE test t3 index_b 2 2 0 2 0 0 0 536TABLE test t3 index_cb 0 0 0 0 0 0 0 537TABLE test t3 PRIMARY 1 1 0 1 0 0 0 538execute dump_waits_table_io; 539object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 540TABLE test t1 6 3 3 3 1 2 0 541TABLE test t2 0 0 0 0 0 0 0 542TABLE test t3 17 11 6 11 3 3 0 543execute dump_waits_table_lock; 544object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 545TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 546TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 547TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 548execute dump_objects_summary; 549object_type object_schema object_name count_star 550TABLE test t1 6 551TABLE test t2 0 552TABLE test t3 17 553insert into test.t1 set a=301, b=1, c=1; 554insert into test.t2 set a=302, b=2, c=2; 555insert into test.t2 set a=303, b=3, c=3; 556insert into test.t3 set a=304, b=4, c=4; 557insert into test.t3 set a=305, b=5, c=5; 558insert into test.t3 set a=306, b=6, c=6; 559select * from test.t1; 560a b c d 561101 1 1 3 562201 1 1 2 563301 1 1 0 564select * from test.t2; 565a b c d 566102 2 2 2 567103 3 3 2 568202 2 2 1 569203 3 3 1 570302 2 2 0 571303 3 3 0 572select * from test.t3; 573a b c d 574104 4 4 2 575105 5 5 2 576106 6 6 2 577204 4 4 1 578205 5 5 1 579206 6 6 1 580304 4 4 0 581305 5 5 0 582306 6 6 0 583update test.t1 set d=d+1; 584update test.t2 set d=d+1; 585update test.t3 set d=d+1; 586update test.t1 set d=d+1 where a=301; 587update test.t2 set d=d+1 where a=301; 588update test.t3 set d=d+1 where a=301; 589select * from test.t1 where b=5; 590a b c d 591select * from test.t2 where b=5; 592a b c d 593select * from test.t3 where b=5; 594a b c d 595105 5 5 3 596205 5 5 2 597305 5 5 1 598"================== con3 marker ==================" 599"================== Step 7 ==================" 600call dump_thread(); 601username event_name count_star 602user1 wait/io/table/sql/handler 23 603user1 wait/lock/table/sql/handler 0 604username event_name count_star 605user2 wait/io/table/sql/handler 0 606user2 wait/lock/table/sql/handler 0 607username event_name count_star 608user3 wait/io/table/sql/handler 52 609user3 wait/lock/table/sql/handler 0 610username status 611user4 not found 612execute dump_waits_account; 613user host event_name count_star 614user1 localhost wait/io/table/sql/handler 23 615user1 localhost wait/lock/table/sql/handler 0 616user2 localhost wait/io/table/sql/handler 0 617user2 localhost wait/lock/table/sql/handler 0 618user3 localhost wait/io/table/sql/handler 52 619user3 localhost wait/lock/table/sql/handler 0 620execute dump_waits_user; 621user event_name count_star 622user1 wait/io/table/sql/handler 23 623user1 wait/lock/table/sql/handler 0 624user2 wait/io/table/sql/handler 0 625user2 wait/lock/table/sql/handler 0 626user3 wait/io/table/sql/handler 52 627user3 wait/lock/table/sql/handler 0 628execute dump_waits_host; 629host event_name count_star 630localhost wait/io/table/sql/handler 75 631localhost wait/lock/table/sql/handler 0 632execute dump_waits_global; 633event_name count_star 634wait/io/table/sql/handler 75 635wait/lock/table/sql/handler 0 636execute dump_waits_history; 637event_name count(event_name) object_type object_schema object_name 638wait/io/table/sql/handler 21 TABLE test t1 639wait/io/table/sql/handler 54 TABLE test t3 640execute dump_waits_index_io; 641object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 642TABLE test t1 NULL 16 10 6 10 2 4 0 643TABLE test t1 index_b 1 1 0 1 0 0 0 644TABLE test t1 index_cb 0 0 0 0 0 0 0 645TABLE test t1 PRIMARY 4 2 2 2 0 2 0 646TABLE test t2 NULL 0 0 0 0 0 0 0 647TABLE test t2 index_b 0 0 0 0 0 0 0 648TABLE test t2 index_cb 0 0 0 0 0 0 0 649TABLE test t2 PRIMARY 0 0 0 0 0 0 0 650TABLE test t3 NULL 46 28 18 28 6 12 0 651TABLE test t3 index_b 6 6 0 6 0 0 0 652TABLE test t3 index_cb 0 0 0 0 0 0 0 653TABLE test t3 PRIMARY 2 2 0 2 0 0 0 654execute dump_waits_table_io; 655object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 656TABLE test t1 21 13 8 13 2 6 0 657TABLE test t2 0 0 0 0 0 0 0 658TABLE test t3 54 36 18 36 6 12 0 659execute dump_waits_table_lock; 660object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 661TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 662TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 663TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 664execute dump_objects_summary; 665object_type object_schema object_name count_star 666TABLE test t1 21 667TABLE test t2 0 668TABLE test t3 54 669select concat(current_user(), " is connected") as status; 670status 671user4@localhost is connected 672"================== Step 8 ==================" 673call dump_thread(); 674username event_name count_star 675user1 wait/io/table/sql/handler 23 676user1 wait/lock/table/sql/handler 0 677username event_name count_star 678user2 wait/io/table/sql/handler 0 679user2 wait/lock/table/sql/handler 0 680username event_name count_star 681user3 wait/io/table/sql/handler 52 682user3 wait/lock/table/sql/handler 0 683username event_name count_star 684user4 wait/io/table/sql/handler 0 685user4 wait/lock/table/sql/handler 0 686execute dump_waits_account; 687user host event_name count_star 688user1 localhost wait/io/table/sql/handler 23 689user1 localhost wait/lock/table/sql/handler 0 690user2 localhost wait/io/table/sql/handler 0 691user2 localhost wait/lock/table/sql/handler 0 692user3 localhost wait/io/table/sql/handler 52 693user3 localhost wait/lock/table/sql/handler 0 694user4 localhost wait/io/table/sql/handler 0 695user4 localhost wait/lock/table/sql/handler 0 696execute dump_waits_user; 697user event_name count_star 698user1 wait/io/table/sql/handler 23 699user1 wait/lock/table/sql/handler 0 700user2 wait/io/table/sql/handler 0 701user2 wait/lock/table/sql/handler 0 702user3 wait/io/table/sql/handler 52 703user3 wait/lock/table/sql/handler 0 704user4 wait/io/table/sql/handler 0 705user4 wait/lock/table/sql/handler 0 706execute dump_waits_host; 707host event_name count_star 708localhost wait/io/table/sql/handler 75 709localhost wait/lock/table/sql/handler 0 710execute dump_waits_global; 711event_name count_star 712wait/io/table/sql/handler 75 713wait/lock/table/sql/handler 0 714execute dump_waits_history; 715event_name count(event_name) object_type object_schema object_name 716wait/io/table/sql/handler 21 TABLE test t1 717wait/io/table/sql/handler 54 TABLE test t3 718execute dump_waits_index_io; 719object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 720TABLE test t1 NULL 16 10 6 10 2 4 0 721TABLE test t1 index_b 1 1 0 1 0 0 0 722TABLE test t1 index_cb 0 0 0 0 0 0 0 723TABLE test t1 PRIMARY 4 2 2 2 0 2 0 724TABLE test t2 NULL 0 0 0 0 0 0 0 725TABLE test t2 index_b 0 0 0 0 0 0 0 726TABLE test t2 index_cb 0 0 0 0 0 0 0 727TABLE test t2 PRIMARY 0 0 0 0 0 0 0 728TABLE test t3 NULL 46 28 18 28 6 12 0 729TABLE test t3 index_b 6 6 0 6 0 0 0 730TABLE test t3 index_cb 0 0 0 0 0 0 0 731TABLE test t3 PRIMARY 2 2 0 2 0 0 0 732execute dump_waits_table_io; 733object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 734TABLE test t1 21 13 8 13 2 6 0 735TABLE test t2 0 0 0 0 0 0 0 736TABLE test t3 54 36 18 36 6 12 0 737execute dump_waits_table_lock; 738object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 739TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 740TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 741TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 742execute dump_objects_summary; 743object_type object_schema object_name count_star 744TABLE test t1 21 745TABLE test t2 0 746TABLE test t3 54 747insert into test.t1 set a=401, b=1, c=1; 748insert into test.t2 set a=402, b=2, c=2; 749insert into test.t2 set a=403, b=3, c=3; 750insert into test.t3 set a=404, b=4, c=4; 751insert into test.t3 set a=405, b=5, c=5; 752insert into test.t3 set a=406, b=6, c=6; 753select * from test.t1; 754a b c d 755101 1 1 4 756201 1 1 3 757301 1 1 2 758401 1 1 0 759select * from test.t2; 760a b c d 761102 2 2 3 762103 3 3 3 763202 2 2 2 764203 3 3 2 765302 2 2 1 766303 3 3 1 767402 2 2 0 768403 3 3 0 769select * from test.t3; 770a b c d 771104 4 4 3 772105 5 5 3 773106 6 6 3 774204 4 4 2 775205 5 5 2 776206 6 6 2 777304 4 4 1 778305 5 5 1 779306 6 6 1 780404 4 4 0 781405 5 5 0 782406 6 6 0 783update test.t1 set d=d+1; 784update test.t2 set d=d+1; 785update test.t3 set d=d+1; 786update test.t1 set d=d+1 where a=401; 787update test.t2 set d=d+1 where a=401; 788update test.t3 set d=d+1 where a=401; 789select * from test.t1 where b=5; 790a b c d 791select * from test.t2 where b=5; 792a b c d 793select * from test.t3 where b=5; 794a b c d 795105 5 5 4 796205 5 5 3 797305 5 5 2 798405 5 5 1 799"================== con4 marker ==================" 800"================== Step 9 ==================" 801call dump_thread(); 802username event_name count_star 803user1 wait/io/table/sql/handler 23 804user1 wait/lock/table/sql/handler 0 805username event_name count_star 806user2 wait/io/table/sql/handler 0 807user2 wait/lock/table/sql/handler 0 808username event_name count_star 809user3 wait/io/table/sql/handler 52 810user3 wait/lock/table/sql/handler 0 811username event_name count_star 812user4 wait/io/table/sql/handler 0 813user4 wait/lock/table/sql/handler 0 814execute dump_waits_account; 815user host event_name count_star 816user1 localhost wait/io/table/sql/handler 23 817user1 localhost wait/lock/table/sql/handler 0 818user2 localhost wait/io/table/sql/handler 0 819user2 localhost wait/lock/table/sql/handler 0 820user3 localhost wait/io/table/sql/handler 52 821user3 localhost wait/lock/table/sql/handler 0 822user4 localhost wait/io/table/sql/handler 0 823user4 localhost wait/lock/table/sql/handler 0 824execute dump_waits_user; 825user event_name count_star 826user1 wait/io/table/sql/handler 23 827user1 wait/lock/table/sql/handler 0 828user2 wait/io/table/sql/handler 0 829user2 wait/lock/table/sql/handler 0 830user3 wait/io/table/sql/handler 52 831user3 wait/lock/table/sql/handler 0 832user4 wait/io/table/sql/handler 0 833user4 wait/lock/table/sql/handler 0 834execute dump_waits_host; 835host event_name count_star 836localhost wait/io/table/sql/handler 75 837localhost wait/lock/table/sql/handler 0 838execute dump_waits_global; 839event_name count_star 840wait/io/table/sql/handler 75 841wait/lock/table/sql/handler 0 842execute dump_waits_history; 843event_name count(event_name) object_type object_schema object_name 844wait/io/table/sql/handler 21 TABLE test t1 845wait/io/table/sql/handler 54 TABLE test t3 846execute dump_waits_index_io; 847object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 848TABLE test t1 NULL 16 10 6 10 2 4 0 849TABLE test t1 index_b 1 1 0 1 0 0 0 850TABLE test t1 index_cb 0 0 0 0 0 0 0 851TABLE test t1 PRIMARY 4 2 2 2 0 2 0 852TABLE test t2 NULL 0 0 0 0 0 0 0 853TABLE test t2 index_b 0 0 0 0 0 0 0 854TABLE test t2 index_cb 0 0 0 0 0 0 0 855TABLE test t2 PRIMARY 0 0 0 0 0 0 0 856TABLE test t3 NULL 46 28 18 28 6 12 0 857TABLE test t3 index_b 6 6 0 6 0 0 0 858TABLE test t3 index_cb 0 0 0 0 0 0 0 859TABLE test t3 PRIMARY 2 2 0 2 0 0 0 860execute dump_waits_table_io; 861object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 862TABLE test t1 21 13 8 13 2 6 0 863TABLE test t2 0 0 0 0 0 0 0 864TABLE test t3 54 36 18 36 6 12 0 865execute dump_waits_table_lock; 866object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 867TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 868TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 869TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 870execute dump_objects_summary; 871object_type object_schema object_name count_star 872TABLE test t1 21 873TABLE test t2 0 874TABLE test t3 54 875lock tables test.t1 read, test.t2 read, test.t3 read; 876unlock tables; 877lock tables test.t1 write, test.t2 write, test.t3 write; 878unlock tables; 879"================== con1 marker ==================" 880"================== Step 10 ==================" 881call dump_thread(); 882username event_name count_star 883user1 wait/io/table/sql/handler 23 884user1 wait/lock/table/sql/handler 0 885username event_name count_star 886user2 wait/io/table/sql/handler 0 887user2 wait/lock/table/sql/handler 0 888username event_name count_star 889user3 wait/io/table/sql/handler 52 890user3 wait/lock/table/sql/handler 0 891username event_name count_star 892user4 wait/io/table/sql/handler 0 893user4 wait/lock/table/sql/handler 0 894execute dump_waits_account; 895user host event_name count_star 896user1 localhost wait/io/table/sql/handler 23 897user1 localhost wait/lock/table/sql/handler 0 898user2 localhost wait/io/table/sql/handler 0 899user2 localhost wait/lock/table/sql/handler 0 900user3 localhost wait/io/table/sql/handler 52 901user3 localhost wait/lock/table/sql/handler 0 902user4 localhost wait/io/table/sql/handler 0 903user4 localhost wait/lock/table/sql/handler 0 904execute dump_waits_user; 905user event_name count_star 906user1 wait/io/table/sql/handler 23 907user1 wait/lock/table/sql/handler 0 908user2 wait/io/table/sql/handler 0 909user2 wait/lock/table/sql/handler 0 910user3 wait/io/table/sql/handler 52 911user3 wait/lock/table/sql/handler 0 912user4 wait/io/table/sql/handler 0 913user4 wait/lock/table/sql/handler 0 914execute dump_waits_host; 915host event_name count_star 916localhost wait/io/table/sql/handler 75 917localhost wait/lock/table/sql/handler 0 918execute dump_waits_global; 919event_name count_star 920wait/io/table/sql/handler 75 921wait/lock/table/sql/handler 0 922execute dump_waits_history; 923event_name count(event_name) object_type object_schema object_name 924wait/io/table/sql/handler 21 TABLE test t1 925wait/io/table/sql/handler 54 TABLE test t3 926execute dump_waits_index_io; 927object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 928TABLE test t1 NULL 16 10 6 10 2 4 0 929TABLE test t1 index_b 1 1 0 1 0 0 0 930TABLE test t1 index_cb 0 0 0 0 0 0 0 931TABLE test t1 PRIMARY 4 2 2 2 0 2 0 932TABLE test t2 NULL 0 0 0 0 0 0 0 933TABLE test t2 index_b 0 0 0 0 0 0 0 934TABLE test t2 index_cb 0 0 0 0 0 0 0 935TABLE test t2 PRIMARY 0 0 0 0 0 0 0 936TABLE test t3 NULL 46 28 18 28 6 12 0 937TABLE test t3 index_b 6 6 0 6 0 0 0 938TABLE test t3 index_cb 0 0 0 0 0 0 0 939TABLE test t3 PRIMARY 2 2 0 2 0 0 0 940execute dump_waits_table_io; 941object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 942TABLE test t1 21 13 8 13 2 6 0 943TABLE test t2 0 0 0 0 0 0 0 944TABLE test t3 54 36 18 36 6 12 0 945execute dump_waits_table_lock; 946object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 947TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 948TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 949TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 950execute dump_objects_summary; 951object_type object_schema object_name count_star 952TABLE test t1 21 953TABLE test t2 0 954TABLE test t3 54 955flush tables; 956"================== flush marker ==================" 957"================== Step 11 ==================" 958call dump_thread(); 959username event_name count_star 960user1 wait/io/table/sql/handler 23 961user1 wait/lock/table/sql/handler 0 962username event_name count_star 963user2 wait/io/table/sql/handler 0 964user2 wait/lock/table/sql/handler 0 965username event_name count_star 966user3 wait/io/table/sql/handler 52 967user3 wait/lock/table/sql/handler 0 968username event_name count_star 969user4 wait/io/table/sql/handler 0 970user4 wait/lock/table/sql/handler 0 971execute dump_waits_account; 972user host event_name count_star 973user1 localhost wait/io/table/sql/handler 23 974user1 localhost wait/lock/table/sql/handler 0 975user2 localhost wait/io/table/sql/handler 0 976user2 localhost wait/lock/table/sql/handler 0 977user3 localhost wait/io/table/sql/handler 52 978user3 localhost wait/lock/table/sql/handler 0 979user4 localhost wait/io/table/sql/handler 0 980user4 localhost wait/lock/table/sql/handler 0 981execute dump_waits_user; 982user event_name count_star 983user1 wait/io/table/sql/handler 23 984user1 wait/lock/table/sql/handler 0 985user2 wait/io/table/sql/handler 0 986user2 wait/lock/table/sql/handler 0 987user3 wait/io/table/sql/handler 52 988user3 wait/lock/table/sql/handler 0 989user4 wait/io/table/sql/handler 0 990user4 wait/lock/table/sql/handler 0 991execute dump_waits_host; 992host event_name count_star 993localhost wait/io/table/sql/handler 75 994localhost wait/lock/table/sql/handler 0 995execute dump_waits_global; 996event_name count_star 997wait/io/table/sql/handler 75 998wait/lock/table/sql/handler 0 999execute dump_waits_history; 1000event_name count(event_name) object_type object_schema object_name 1001wait/io/table/sql/handler 21 TABLE test t1 1002wait/io/table/sql/handler 54 TABLE test t3 1003execute dump_waits_index_io; 1004object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1005TABLE test t1 NULL 16 10 6 10 2 4 0 1006TABLE test t1 index_b 1 1 0 1 0 0 0 1007TABLE test t1 index_cb 0 0 0 0 0 0 0 1008TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1009TABLE test t2 NULL 0 0 0 0 0 0 0 1010TABLE test t2 index_b 0 0 0 0 0 0 0 1011TABLE test t2 index_cb 0 0 0 0 0 0 0 1012TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1013TABLE test t3 NULL 46 28 18 28 6 12 0 1014TABLE test t3 index_b 6 6 0 6 0 0 0 1015TABLE test t3 index_cb 0 0 0 0 0 0 0 1016TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1017execute dump_waits_table_io; 1018object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1019TABLE test t1 21 13 8 13 2 6 0 1020TABLE test t2 0 0 0 0 0 0 0 1021TABLE test t3 54 36 18 36 6 12 0 1022execute dump_waits_table_lock; 1023object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1024TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1025TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1026TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1027execute dump_objects_summary; 1028object_type object_schema object_name count_star 1029TABLE test t1 21 1030TABLE test t2 0 1031TABLE test t3 54 1032set global read_only=1; 1033set global read_only=0; 1034"================== global read_only marker ==================" 1035"================== Step 12 ==================" 1036call dump_thread(); 1037username event_name count_star 1038user1 wait/io/table/sql/handler 23 1039user1 wait/lock/table/sql/handler 0 1040username event_name count_star 1041user2 wait/io/table/sql/handler 0 1042user2 wait/lock/table/sql/handler 0 1043username event_name count_star 1044user3 wait/io/table/sql/handler 52 1045user3 wait/lock/table/sql/handler 0 1046username event_name count_star 1047user4 wait/io/table/sql/handler 0 1048user4 wait/lock/table/sql/handler 0 1049execute dump_waits_account; 1050user host event_name count_star 1051user1 localhost wait/io/table/sql/handler 23 1052user1 localhost wait/lock/table/sql/handler 0 1053user2 localhost wait/io/table/sql/handler 0 1054user2 localhost wait/lock/table/sql/handler 0 1055user3 localhost wait/io/table/sql/handler 52 1056user3 localhost wait/lock/table/sql/handler 0 1057user4 localhost wait/io/table/sql/handler 0 1058user4 localhost wait/lock/table/sql/handler 0 1059execute dump_waits_user; 1060user event_name count_star 1061user1 wait/io/table/sql/handler 23 1062user1 wait/lock/table/sql/handler 0 1063user2 wait/io/table/sql/handler 0 1064user2 wait/lock/table/sql/handler 0 1065user3 wait/io/table/sql/handler 52 1066user3 wait/lock/table/sql/handler 0 1067user4 wait/io/table/sql/handler 0 1068user4 wait/lock/table/sql/handler 0 1069execute dump_waits_host; 1070host event_name count_star 1071localhost wait/io/table/sql/handler 75 1072localhost wait/lock/table/sql/handler 0 1073execute dump_waits_global; 1074event_name count_star 1075wait/io/table/sql/handler 75 1076wait/lock/table/sql/handler 0 1077execute dump_waits_history; 1078event_name count(event_name) object_type object_schema object_name 1079wait/io/table/sql/handler 21 TABLE test t1 1080wait/io/table/sql/handler 54 TABLE test t3 1081execute dump_waits_index_io; 1082object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1083TABLE test t1 NULL 16 10 6 10 2 4 0 1084TABLE test t1 index_b 1 1 0 1 0 0 0 1085TABLE test t1 index_cb 0 0 0 0 0 0 0 1086TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1087TABLE test t2 NULL 0 0 0 0 0 0 0 1088TABLE test t2 index_b 0 0 0 0 0 0 0 1089TABLE test t2 index_cb 0 0 0 0 0 0 0 1090TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1091TABLE test t3 NULL 46 28 18 28 6 12 0 1092TABLE test t3 index_b 6 6 0 6 0 0 0 1093TABLE test t3 index_cb 0 0 0 0 0 0 0 1094TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1095execute dump_waits_table_io; 1096object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1097TABLE test t1 21 13 8 13 2 6 0 1098TABLE test t2 0 0 0 0 0 0 0 1099TABLE test t3 54 36 18 36 6 12 0 1100execute dump_waits_table_lock; 1101object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1102TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1103TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1104TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1105execute dump_objects_summary; 1106object_type object_schema object_name count_star 1107TABLE test t1 21 1108TABLE test t2 0 1109TABLE test t3 54 1110"================== con1 disconnected ==================" 1111"================== Step 13 ==================" 1112call dump_thread(); 1113username status 1114user1 not found 1115username event_name count_star 1116user2 wait/io/table/sql/handler 0 1117user2 wait/lock/table/sql/handler 0 1118username event_name count_star 1119user3 wait/io/table/sql/handler 52 1120user3 wait/lock/table/sql/handler 0 1121username event_name count_star 1122user4 wait/io/table/sql/handler 0 1123user4 wait/lock/table/sql/handler 0 1124execute dump_waits_account; 1125user host event_name count_star 1126user1 localhost wait/io/table/sql/handler 23 1127user1 localhost wait/lock/table/sql/handler 0 1128user2 localhost wait/io/table/sql/handler 0 1129user2 localhost wait/lock/table/sql/handler 0 1130user3 localhost wait/io/table/sql/handler 52 1131user3 localhost wait/lock/table/sql/handler 0 1132user4 localhost wait/io/table/sql/handler 0 1133user4 localhost wait/lock/table/sql/handler 0 1134execute dump_waits_user; 1135user event_name count_star 1136user1 wait/io/table/sql/handler 23 1137user1 wait/lock/table/sql/handler 0 1138user2 wait/io/table/sql/handler 0 1139user2 wait/lock/table/sql/handler 0 1140user3 wait/io/table/sql/handler 52 1141user3 wait/lock/table/sql/handler 0 1142user4 wait/io/table/sql/handler 0 1143user4 wait/lock/table/sql/handler 0 1144execute dump_waits_host; 1145host event_name count_star 1146localhost wait/io/table/sql/handler 75 1147localhost wait/lock/table/sql/handler 0 1148execute dump_waits_global; 1149event_name count_star 1150wait/io/table/sql/handler 75 1151wait/lock/table/sql/handler 0 1152execute dump_waits_history; 1153event_name count(event_name) object_type object_schema object_name 1154wait/io/table/sql/handler 21 TABLE test t1 1155wait/io/table/sql/handler 54 TABLE test t3 1156execute dump_waits_index_io; 1157object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1158TABLE test t1 NULL 16 10 6 10 2 4 0 1159TABLE test t1 index_b 1 1 0 1 0 0 0 1160TABLE test t1 index_cb 0 0 0 0 0 0 0 1161TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1162TABLE test t2 NULL 0 0 0 0 0 0 0 1163TABLE test t2 index_b 0 0 0 0 0 0 0 1164TABLE test t2 index_cb 0 0 0 0 0 0 0 1165TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1166TABLE test t3 NULL 46 28 18 28 6 12 0 1167TABLE test t3 index_b 6 6 0 6 0 0 0 1168TABLE test t3 index_cb 0 0 0 0 0 0 0 1169TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1170execute dump_waits_table_io; 1171object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1172TABLE test t1 21 13 8 13 2 6 0 1173TABLE test t2 0 0 0 0 0 0 0 1174TABLE test t3 54 36 18 36 6 12 0 1175execute dump_waits_table_lock; 1176object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1177TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1178TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1179TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1180execute dump_objects_summary; 1181object_type object_schema object_name count_star 1182TABLE test t1 21 1183TABLE test t2 0 1184TABLE test t3 54 1185"================== con2 disconnected ==================" 1186"================== Step 14 ==================" 1187call dump_thread(); 1188username status 1189user1 not found 1190username status 1191user2 not found 1192username event_name count_star 1193user3 wait/io/table/sql/handler 52 1194user3 wait/lock/table/sql/handler 0 1195username event_name count_star 1196user4 wait/io/table/sql/handler 0 1197user4 wait/lock/table/sql/handler 0 1198execute dump_waits_account; 1199user host event_name count_star 1200user1 localhost wait/io/table/sql/handler 23 1201user1 localhost wait/lock/table/sql/handler 0 1202user2 localhost wait/io/table/sql/handler 0 1203user2 localhost wait/lock/table/sql/handler 0 1204user3 localhost wait/io/table/sql/handler 52 1205user3 localhost wait/lock/table/sql/handler 0 1206user4 localhost wait/io/table/sql/handler 0 1207user4 localhost wait/lock/table/sql/handler 0 1208execute dump_waits_user; 1209user event_name count_star 1210user1 wait/io/table/sql/handler 23 1211user1 wait/lock/table/sql/handler 0 1212user2 wait/io/table/sql/handler 0 1213user2 wait/lock/table/sql/handler 0 1214user3 wait/io/table/sql/handler 52 1215user3 wait/lock/table/sql/handler 0 1216user4 wait/io/table/sql/handler 0 1217user4 wait/lock/table/sql/handler 0 1218execute dump_waits_host; 1219host event_name count_star 1220localhost wait/io/table/sql/handler 75 1221localhost wait/lock/table/sql/handler 0 1222execute dump_waits_global; 1223event_name count_star 1224wait/io/table/sql/handler 75 1225wait/lock/table/sql/handler 0 1226execute dump_waits_history; 1227event_name count(event_name) object_type object_schema object_name 1228wait/io/table/sql/handler 21 TABLE test t1 1229wait/io/table/sql/handler 54 TABLE test t3 1230execute dump_waits_index_io; 1231object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1232TABLE test t1 NULL 16 10 6 10 2 4 0 1233TABLE test t1 index_b 1 1 0 1 0 0 0 1234TABLE test t1 index_cb 0 0 0 0 0 0 0 1235TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1236TABLE test t2 NULL 0 0 0 0 0 0 0 1237TABLE test t2 index_b 0 0 0 0 0 0 0 1238TABLE test t2 index_cb 0 0 0 0 0 0 0 1239TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1240TABLE test t3 NULL 46 28 18 28 6 12 0 1241TABLE test t3 index_b 6 6 0 6 0 0 0 1242TABLE test t3 index_cb 0 0 0 0 0 0 0 1243TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1244execute dump_waits_table_io; 1245object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1246TABLE test t1 21 13 8 13 2 6 0 1247TABLE test t2 0 0 0 0 0 0 0 1248TABLE test t3 54 36 18 36 6 12 0 1249execute dump_waits_table_lock; 1250object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1251TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1252TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1253TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1254execute dump_objects_summary; 1255object_type object_schema object_name count_star 1256TABLE test t1 21 1257TABLE test t2 0 1258TABLE test t3 54 1259"================== con3 disconnected ==================" 1260"================== Step 15 ==================" 1261call dump_thread(); 1262username status 1263user1 not found 1264username status 1265user2 not found 1266username status 1267user3 not found 1268username event_name count_star 1269user4 wait/io/table/sql/handler 0 1270user4 wait/lock/table/sql/handler 0 1271execute dump_waits_account; 1272user host event_name count_star 1273user1 localhost wait/io/table/sql/handler 23 1274user1 localhost wait/lock/table/sql/handler 0 1275user2 localhost wait/io/table/sql/handler 0 1276user2 localhost wait/lock/table/sql/handler 0 1277user3 localhost wait/io/table/sql/handler 52 1278user3 localhost wait/lock/table/sql/handler 0 1279user4 localhost wait/io/table/sql/handler 0 1280user4 localhost wait/lock/table/sql/handler 0 1281execute dump_waits_user; 1282user event_name count_star 1283user1 wait/io/table/sql/handler 23 1284user1 wait/lock/table/sql/handler 0 1285user2 wait/io/table/sql/handler 0 1286user2 wait/lock/table/sql/handler 0 1287user3 wait/io/table/sql/handler 52 1288user3 wait/lock/table/sql/handler 0 1289user4 wait/io/table/sql/handler 0 1290user4 wait/lock/table/sql/handler 0 1291execute dump_waits_host; 1292host event_name count_star 1293localhost wait/io/table/sql/handler 75 1294localhost wait/lock/table/sql/handler 0 1295execute dump_waits_global; 1296event_name count_star 1297wait/io/table/sql/handler 75 1298wait/lock/table/sql/handler 0 1299execute dump_waits_history; 1300event_name count(event_name) object_type object_schema object_name 1301wait/io/table/sql/handler 21 TABLE test t1 1302wait/io/table/sql/handler 54 TABLE test t3 1303execute dump_waits_index_io; 1304object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1305TABLE test t1 NULL 16 10 6 10 2 4 0 1306TABLE test t1 index_b 1 1 0 1 0 0 0 1307TABLE test t1 index_cb 0 0 0 0 0 0 0 1308TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1309TABLE test t2 NULL 0 0 0 0 0 0 0 1310TABLE test t2 index_b 0 0 0 0 0 0 0 1311TABLE test t2 index_cb 0 0 0 0 0 0 0 1312TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1313TABLE test t3 NULL 46 28 18 28 6 12 0 1314TABLE test t3 index_b 6 6 0 6 0 0 0 1315TABLE test t3 index_cb 0 0 0 0 0 0 0 1316TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1317execute dump_waits_table_io; 1318object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1319TABLE test t1 21 13 8 13 2 6 0 1320TABLE test t2 0 0 0 0 0 0 0 1321TABLE test t3 54 36 18 36 6 12 0 1322execute dump_waits_table_lock; 1323object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1324TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1325TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1326TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1327execute dump_objects_summary; 1328object_type object_schema object_name count_star 1329TABLE test t1 21 1330TABLE test t2 0 1331TABLE test t3 54 1332"================== con4 disconnected ==================" 1333"================== Step 16 ==================" 1334call dump_thread(); 1335username status 1336user1 not found 1337username status 1338user2 not found 1339username status 1340user3 not found 1341username status 1342user4 not found 1343execute dump_waits_account; 1344user host event_name count_star 1345user1 localhost wait/io/table/sql/handler 23 1346user1 localhost wait/lock/table/sql/handler 0 1347user2 localhost wait/io/table/sql/handler 0 1348user2 localhost wait/lock/table/sql/handler 0 1349user3 localhost wait/io/table/sql/handler 52 1350user3 localhost wait/lock/table/sql/handler 0 1351user4 localhost wait/io/table/sql/handler 0 1352user4 localhost wait/lock/table/sql/handler 0 1353execute dump_waits_user; 1354user event_name count_star 1355user1 wait/io/table/sql/handler 23 1356user1 wait/lock/table/sql/handler 0 1357user2 wait/io/table/sql/handler 0 1358user2 wait/lock/table/sql/handler 0 1359user3 wait/io/table/sql/handler 52 1360user3 wait/lock/table/sql/handler 0 1361user4 wait/io/table/sql/handler 0 1362user4 wait/lock/table/sql/handler 0 1363execute dump_waits_host; 1364host event_name count_star 1365localhost wait/io/table/sql/handler 75 1366localhost wait/lock/table/sql/handler 0 1367execute dump_waits_global; 1368event_name count_star 1369wait/io/table/sql/handler 75 1370wait/lock/table/sql/handler 0 1371execute dump_waits_history; 1372event_name count(event_name) object_type object_schema object_name 1373wait/io/table/sql/handler 21 TABLE test t1 1374wait/io/table/sql/handler 54 TABLE test t3 1375execute dump_waits_index_io; 1376object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1377TABLE test t1 NULL 16 10 6 10 2 4 0 1378TABLE test t1 index_b 1 1 0 1 0 0 0 1379TABLE test t1 index_cb 0 0 0 0 0 0 0 1380TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1381TABLE test t2 NULL 0 0 0 0 0 0 0 1382TABLE test t2 index_b 0 0 0 0 0 0 0 1383TABLE test t2 index_cb 0 0 0 0 0 0 0 1384TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1385TABLE test t3 NULL 46 28 18 28 6 12 0 1386TABLE test t3 index_b 6 6 0 6 0 0 0 1387TABLE test t3 index_cb 0 0 0 0 0 0 0 1388TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1389execute dump_waits_table_io; 1390object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1391TABLE test t1 21 13 8 13 2 6 0 1392TABLE test t2 0 0 0 0 0 0 0 1393TABLE test t3 54 36 18 36 6 12 0 1394execute dump_waits_table_lock; 1395object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1396TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1397TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1398TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1399execute dump_objects_summary; 1400object_type object_schema object_name count_star 1401TABLE test t1 21 1402TABLE test t2 0 1403TABLE test t3 54 1404truncate performance_schema.events_waits_summary_by_thread_by_event_name; 1405"================== BY_THREAD truncated ==================" 1406"================== Step 17 ==================" 1407call dump_thread(); 1408username status 1409user1 not found 1410username status 1411user2 not found 1412username status 1413user3 not found 1414username status 1415user4 not found 1416execute dump_waits_account; 1417user host event_name count_star 1418user1 localhost wait/io/table/sql/handler 23 1419user1 localhost wait/lock/table/sql/handler 0 1420user2 localhost wait/io/table/sql/handler 0 1421user2 localhost wait/lock/table/sql/handler 0 1422user3 localhost wait/io/table/sql/handler 52 1423user3 localhost wait/lock/table/sql/handler 0 1424user4 localhost wait/io/table/sql/handler 0 1425user4 localhost wait/lock/table/sql/handler 0 1426execute dump_waits_user; 1427user event_name count_star 1428user1 wait/io/table/sql/handler 23 1429user1 wait/lock/table/sql/handler 0 1430user2 wait/io/table/sql/handler 0 1431user2 wait/lock/table/sql/handler 0 1432user3 wait/io/table/sql/handler 52 1433user3 wait/lock/table/sql/handler 0 1434user4 wait/io/table/sql/handler 0 1435user4 wait/lock/table/sql/handler 0 1436execute dump_waits_host; 1437host event_name count_star 1438localhost wait/io/table/sql/handler 75 1439localhost wait/lock/table/sql/handler 0 1440execute dump_waits_global; 1441event_name count_star 1442wait/io/table/sql/handler 75 1443wait/lock/table/sql/handler 0 1444execute dump_waits_history; 1445event_name count(event_name) object_type object_schema object_name 1446wait/io/table/sql/handler 21 TABLE test t1 1447wait/io/table/sql/handler 54 TABLE test t3 1448execute dump_waits_index_io; 1449object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1450TABLE test t1 NULL 16 10 6 10 2 4 0 1451TABLE test t1 index_b 1 1 0 1 0 0 0 1452TABLE test t1 index_cb 0 0 0 0 0 0 0 1453TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1454TABLE test t2 NULL 0 0 0 0 0 0 0 1455TABLE test t2 index_b 0 0 0 0 0 0 0 1456TABLE test t2 index_cb 0 0 0 0 0 0 0 1457TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1458TABLE test t3 NULL 46 28 18 28 6 12 0 1459TABLE test t3 index_b 6 6 0 6 0 0 0 1460TABLE test t3 index_cb 0 0 0 0 0 0 0 1461TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1462execute dump_waits_table_io; 1463object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1464TABLE test t1 21 13 8 13 2 6 0 1465TABLE test t2 0 0 0 0 0 0 0 1466TABLE test t3 54 36 18 36 6 12 0 1467execute dump_waits_table_lock; 1468object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1469TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1470TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1471TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1472execute dump_objects_summary; 1473object_type object_schema object_name count_star 1474TABLE test t1 21 1475TABLE test t2 0 1476TABLE test t3 54 1477truncate performance_schema.events_waits_summary_by_account_by_event_name; 1478"================== BY_ACCOUNT truncated ==================" 1479"================== Step 18 ==================" 1480call dump_thread(); 1481username status 1482user1 not found 1483username status 1484user2 not found 1485username status 1486user3 not found 1487username status 1488user4 not found 1489execute dump_waits_account; 1490user host event_name count_star 1491user1 localhost wait/io/table/sql/handler 0 1492user1 localhost wait/lock/table/sql/handler 0 1493user2 localhost wait/io/table/sql/handler 0 1494user2 localhost wait/lock/table/sql/handler 0 1495user3 localhost wait/io/table/sql/handler 0 1496user3 localhost wait/lock/table/sql/handler 0 1497user4 localhost wait/io/table/sql/handler 0 1498user4 localhost wait/lock/table/sql/handler 0 1499execute dump_waits_user; 1500user event_name count_star 1501user1 wait/io/table/sql/handler 23 1502user1 wait/lock/table/sql/handler 0 1503user2 wait/io/table/sql/handler 0 1504user2 wait/lock/table/sql/handler 0 1505user3 wait/io/table/sql/handler 52 1506user3 wait/lock/table/sql/handler 0 1507user4 wait/io/table/sql/handler 0 1508user4 wait/lock/table/sql/handler 0 1509execute dump_waits_host; 1510host event_name count_star 1511localhost wait/io/table/sql/handler 75 1512localhost wait/lock/table/sql/handler 0 1513execute dump_waits_global; 1514event_name count_star 1515wait/io/table/sql/handler 75 1516wait/lock/table/sql/handler 0 1517execute dump_waits_history; 1518event_name count(event_name) object_type object_schema object_name 1519wait/io/table/sql/handler 21 TABLE test t1 1520wait/io/table/sql/handler 54 TABLE test t3 1521execute dump_waits_index_io; 1522object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1523TABLE test t1 NULL 16 10 6 10 2 4 0 1524TABLE test t1 index_b 1 1 0 1 0 0 0 1525TABLE test t1 index_cb 0 0 0 0 0 0 0 1526TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1527TABLE test t2 NULL 0 0 0 0 0 0 0 1528TABLE test t2 index_b 0 0 0 0 0 0 0 1529TABLE test t2 index_cb 0 0 0 0 0 0 0 1530TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1531TABLE test t3 NULL 46 28 18 28 6 12 0 1532TABLE test t3 index_b 6 6 0 6 0 0 0 1533TABLE test t3 index_cb 0 0 0 0 0 0 0 1534TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1535execute dump_waits_table_io; 1536object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1537TABLE test t1 21 13 8 13 2 6 0 1538TABLE test t2 0 0 0 0 0 0 0 1539TABLE test t3 54 36 18 36 6 12 0 1540execute dump_waits_table_lock; 1541object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1542TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1543TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1544TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1545execute dump_objects_summary; 1546object_type object_schema object_name count_star 1547TABLE test t1 21 1548TABLE test t2 0 1549TABLE test t3 54 1550truncate performance_schema.events_waits_summary_by_user_by_event_name; 1551"================== BY_USER truncated ==================" 1552"================== Step 19 ==================" 1553call dump_thread(); 1554username status 1555user1 not found 1556username status 1557user2 not found 1558username status 1559user3 not found 1560username status 1561user4 not found 1562execute dump_waits_account; 1563user host event_name count_star 1564user1 localhost wait/io/table/sql/handler 0 1565user1 localhost wait/lock/table/sql/handler 0 1566user2 localhost wait/io/table/sql/handler 0 1567user2 localhost wait/lock/table/sql/handler 0 1568user3 localhost wait/io/table/sql/handler 0 1569user3 localhost wait/lock/table/sql/handler 0 1570user4 localhost wait/io/table/sql/handler 0 1571user4 localhost wait/lock/table/sql/handler 0 1572execute dump_waits_user; 1573user event_name count_star 1574user1 wait/io/table/sql/handler 0 1575user1 wait/lock/table/sql/handler 0 1576user2 wait/io/table/sql/handler 0 1577user2 wait/lock/table/sql/handler 0 1578user3 wait/io/table/sql/handler 0 1579user3 wait/lock/table/sql/handler 0 1580user4 wait/io/table/sql/handler 0 1581user4 wait/lock/table/sql/handler 0 1582execute dump_waits_host; 1583host event_name count_star 1584localhost wait/io/table/sql/handler 75 1585localhost wait/lock/table/sql/handler 0 1586execute dump_waits_global; 1587event_name count_star 1588wait/io/table/sql/handler 75 1589wait/lock/table/sql/handler 0 1590execute dump_waits_history; 1591event_name count(event_name) object_type object_schema object_name 1592wait/io/table/sql/handler 21 TABLE test t1 1593wait/io/table/sql/handler 54 TABLE test t3 1594execute dump_waits_index_io; 1595object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1596TABLE test t1 NULL 16 10 6 10 2 4 0 1597TABLE test t1 index_b 1 1 0 1 0 0 0 1598TABLE test t1 index_cb 0 0 0 0 0 0 0 1599TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1600TABLE test t2 NULL 0 0 0 0 0 0 0 1601TABLE test t2 index_b 0 0 0 0 0 0 0 1602TABLE test t2 index_cb 0 0 0 0 0 0 0 1603TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1604TABLE test t3 NULL 46 28 18 28 6 12 0 1605TABLE test t3 index_b 6 6 0 6 0 0 0 1606TABLE test t3 index_cb 0 0 0 0 0 0 0 1607TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1608execute dump_waits_table_io; 1609object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1610TABLE test t1 21 13 8 13 2 6 0 1611TABLE test t2 0 0 0 0 0 0 0 1612TABLE test t3 54 36 18 36 6 12 0 1613execute dump_waits_table_lock; 1614object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1615TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1616TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1617TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1618execute dump_objects_summary; 1619object_type object_schema object_name count_star 1620TABLE test t1 21 1621TABLE test t2 0 1622TABLE test t3 54 1623truncate performance_schema.events_waits_summary_by_host_by_event_name; 1624"================== BY_HOST truncated ==================" 1625"================== Step 21 ==================" 1626call dump_thread(); 1627username status 1628user1 not found 1629username status 1630user2 not found 1631username status 1632user3 not found 1633username status 1634user4 not found 1635execute dump_waits_account; 1636user host event_name count_star 1637user1 localhost wait/io/table/sql/handler 0 1638user1 localhost wait/lock/table/sql/handler 0 1639user2 localhost wait/io/table/sql/handler 0 1640user2 localhost wait/lock/table/sql/handler 0 1641user3 localhost wait/io/table/sql/handler 0 1642user3 localhost wait/lock/table/sql/handler 0 1643user4 localhost wait/io/table/sql/handler 0 1644user4 localhost wait/lock/table/sql/handler 0 1645execute dump_waits_user; 1646user event_name count_star 1647user1 wait/io/table/sql/handler 0 1648user1 wait/lock/table/sql/handler 0 1649user2 wait/io/table/sql/handler 0 1650user2 wait/lock/table/sql/handler 0 1651user3 wait/io/table/sql/handler 0 1652user3 wait/lock/table/sql/handler 0 1653user4 wait/io/table/sql/handler 0 1654user4 wait/lock/table/sql/handler 0 1655execute dump_waits_host; 1656host event_name count_star 1657localhost wait/io/table/sql/handler 0 1658localhost wait/lock/table/sql/handler 0 1659execute dump_waits_global; 1660event_name count_star 1661wait/io/table/sql/handler 75 1662wait/lock/table/sql/handler 0 1663execute dump_waits_history; 1664event_name count(event_name) object_type object_schema object_name 1665wait/io/table/sql/handler 21 TABLE test t1 1666wait/io/table/sql/handler 54 TABLE test t3 1667execute dump_waits_index_io; 1668object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1669TABLE test t1 NULL 16 10 6 10 2 4 0 1670TABLE test t1 index_b 1 1 0 1 0 0 0 1671TABLE test t1 index_cb 0 0 0 0 0 0 0 1672TABLE test t1 PRIMARY 4 2 2 2 0 2 0 1673TABLE test t2 NULL 0 0 0 0 0 0 0 1674TABLE test t2 index_b 0 0 0 0 0 0 0 1675TABLE test t2 index_cb 0 0 0 0 0 0 0 1676TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1677TABLE test t3 NULL 46 28 18 28 6 12 0 1678TABLE test t3 index_b 6 6 0 6 0 0 0 1679TABLE test t3 index_cb 0 0 0 0 0 0 0 1680TABLE test t3 PRIMARY 2 2 0 2 0 0 0 1681execute dump_waits_table_io; 1682object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1683TABLE test t1 21 13 8 13 2 6 0 1684TABLE test t2 0 0 0 0 0 0 0 1685TABLE test t3 54 36 18 36 6 12 0 1686execute dump_waits_table_lock; 1687object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1688TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1689TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1690TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1691execute dump_objects_summary; 1692object_type object_schema object_name count_star 1693TABLE test t1 21 1694TABLE test t2 0 1695TABLE test t3 54 1696truncate performance_schema.events_waits_summary_global_by_event_name; 1697"================== GLOBAL truncated ==================" 1698"================== Step 21 ==================" 1699call dump_thread(); 1700username status 1701user1 not found 1702username status 1703user2 not found 1704username status 1705user3 not found 1706username status 1707user4 not found 1708execute dump_waits_account; 1709user host event_name count_star 1710user1 localhost wait/io/table/sql/handler 0 1711user1 localhost wait/lock/table/sql/handler 0 1712user2 localhost wait/io/table/sql/handler 0 1713user2 localhost wait/lock/table/sql/handler 0 1714user3 localhost wait/io/table/sql/handler 0 1715user3 localhost wait/lock/table/sql/handler 0 1716user4 localhost wait/io/table/sql/handler 0 1717user4 localhost wait/lock/table/sql/handler 0 1718execute dump_waits_user; 1719user event_name count_star 1720user1 wait/io/table/sql/handler 0 1721user1 wait/lock/table/sql/handler 0 1722user2 wait/io/table/sql/handler 0 1723user2 wait/lock/table/sql/handler 0 1724user3 wait/io/table/sql/handler 0 1725user3 wait/lock/table/sql/handler 0 1726user4 wait/io/table/sql/handler 0 1727user4 wait/lock/table/sql/handler 0 1728execute dump_waits_host; 1729host event_name count_star 1730localhost wait/io/table/sql/handler 0 1731localhost wait/lock/table/sql/handler 0 1732execute dump_waits_global; 1733event_name count_star 1734wait/io/table/sql/handler 0 1735wait/lock/table/sql/handler 0 1736execute dump_waits_history; 1737event_name count(event_name) object_type object_schema object_name 1738wait/io/table/sql/handler 21 TABLE test t1 1739wait/io/table/sql/handler 54 TABLE test t3 1740execute dump_waits_index_io; 1741object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete 1742TABLE test t1 NULL 0 0 0 0 0 0 0 1743TABLE test t1 index_b 0 0 0 0 0 0 0 1744TABLE test t1 index_cb 0 0 0 0 0 0 0 1745TABLE test t1 PRIMARY 0 0 0 0 0 0 0 1746TABLE test t2 NULL 0 0 0 0 0 0 0 1747TABLE test t2 index_b 0 0 0 0 0 0 0 1748TABLE test t2 index_cb 0 0 0 0 0 0 0 1749TABLE test t2 PRIMARY 0 0 0 0 0 0 0 1750TABLE test t3 NULL 0 0 0 0 0 0 0 1751TABLE test t3 index_b 0 0 0 0 0 0 0 1752TABLE test t3 index_cb 0 0 0 0 0 0 0 1753TABLE test t3 PRIMARY 0 0 0 0 0 0 0 1754execute dump_waits_table_io; 1755object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete 1756TABLE test t1 0 0 0 0 0 0 0 1757TABLE test t2 0 0 0 0 0 0 0 1758TABLE test t3 0 0 0 0 0 0 0 1759execute dump_waits_table_lock; 1760object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external 1761TABLE test t1 0 0 0 0 0 0 0 0 0 0 0 1762TABLE test t2 0 0 0 0 0 0 0 0 0 0 0 1763TABLE test t3 0 0 0 0 0 0 0 0 0 0 0 1764execute dump_objects_summary; 1765object_type object_schema object_name count_star 1766TABLE test t1 0 1767TABLE test t2 0 1768TABLE test t3 0 1769show status like "performance_schema%"; 1770Variable_name Value 1771Performance_schema_accounts_lost 0 1772Performance_schema_cond_classes_lost 0 1773Performance_schema_cond_instances_lost 0 1774Performance_schema_digest_lost 0 1775Performance_schema_file_classes_lost 0 1776Performance_schema_file_handles_lost 0 1777Performance_schema_file_instances_lost 0 1778Performance_schema_hosts_lost 0 1779Performance_schema_locker_lost 0 1780Performance_schema_mutex_classes_lost 0 1781Performance_schema_mutex_instances_lost 0 1782Performance_schema_rwlock_classes_lost 0 1783Performance_schema_rwlock_instances_lost 0 1784Performance_schema_session_connect_attrs_lost 0 1785Performance_schema_socket_classes_lost 0 1786Performance_schema_socket_instances_lost 0 1787Performance_schema_stage_classes_lost 0 1788Performance_schema_statement_classes_lost 0 1789Performance_schema_table_handles_lost 0 1790Performance_schema_table_instances_lost 0 1791Performance_schema_thread_classes_lost 0 1792Performance_schema_thread_instances_lost 0 1793Performance_schema_users_lost 0 1794