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