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