1"================== Step 1 ==================" 2call dump_thread(); 3username status 4user1 not found 5username status 6user2 not found 7username status 8user3 not found 9username status 10user4 not found 11execute dump_waits_account; 12user host event_name count_star 13execute dump_waits_user; 14user event_name count_star 15execute dump_waits_host; 16host event_name count_star 17localhost wait/io/file/sql/query_log 0 18localhost wait/synch/rwlock/sql/LOCK_grant 0 19execute dump_waits_global; 20event_name count_star 21wait/io/file/sql/query_log 0 22wait/synch/rwlock/sql/LOCK_grant 0 23execute dump_waits_history; 24event_name count(event_name) 25execute dump_stages_account; 26user host event_name count_star 27execute dump_stages_user; 28user event_name count_star 29execute dump_stages_host; 30host event_name count_star 31localhost stage/sql/checking permissions 0 32localhost stage/sql/closing tables 0 33localhost stage/sql/init 0 34localhost stage/sql/Opening tables 0 35localhost stage/sql/starting 0 36execute dump_stages_global; 37event_name count_star 38stage/sql/checking permissions 0 39stage/sql/closing tables 0 40stage/sql/init 0 41stage/sql/Opening tables 0 42stage/sql/starting 0 43execute dump_stages_history; 44event_name count(event_name) 45execute dump_statements_account; 46user host event_name count_star 47execute dump_statements_user; 48user event_name count_star 49execute dump_statements_host; 50host event_name count_star 51localhost statement/com/Error 0 52localhost statement/com/Quit 0 53localhost statement/sp/freturn 0 54localhost statement/sql/insert 0 55localhost statement/sql/select 0 56execute dump_statements_global; 57event_name count_star 58statement/com/Error 0 59statement/com/Quit 0 60statement/sp/freturn 0 61statement/sql/insert 0 62statement/sql/select 0 63execute dump_statements_history; 64event_name count(event_name) 65execute dump_transactions_account; 66user host event_name count_star 67execute dump_transactions_user; 68user event_name count_star 69execute dump_transactions_host; 70host event_name count_star 71localhost transaction 0 72execute dump_transactions_global; 73event_name count_star 74transaction 0 75execute dump_transactions_history; 76event_name count(event_name) 77execute dump_accounts; 78USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 79root localhost 1 1 80execute dump_users; 81USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 82root 1 1 83execute dump_hosts; 84HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 85localhost 1 1 86connect con1, localhost, user1, , ; 87connection default; 88"================== Step 2 ==================" 89call dump_thread(); 90username event_name count_star 91user1 wait/io/file/sql/query_log 1 92user1 wait/synch/rwlock/sql/LOCK_grant 0 93username status 94user2 not found 95username status 96user3 not found 97username status 98user4 not found 99execute dump_waits_account; 100user host event_name count_star 101user1 localhost wait/io/file/sql/query_log 1 102user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 103execute dump_waits_user; 104user event_name count_star 105user1 wait/io/file/sql/query_log 1 106user1 wait/synch/rwlock/sql/LOCK_grant 0 107execute dump_waits_host; 108host event_name count_star 109localhost wait/io/file/sql/query_log 1 110localhost wait/synch/rwlock/sql/LOCK_grant 0 111execute dump_waits_global; 112event_name count_star 113wait/io/file/sql/query_log 1 114wait/synch/rwlock/sql/LOCK_grant 0 115execute dump_waits_history; 116event_name count(event_name) 117wait/io/file/sql/query_log 1 118execute dump_stages_account; 119user host event_name count_star 120user1 localhost stage/sql/checking permissions 0 121user1 localhost stage/sql/closing tables 0 122user1 localhost stage/sql/init 0 123user1 localhost stage/sql/Opening tables 0 124user1 localhost stage/sql/starting 0 125execute dump_stages_user; 126user event_name count_star 127user1 stage/sql/checking permissions 0 128user1 stage/sql/closing tables 0 129user1 stage/sql/init 0 130user1 stage/sql/Opening tables 0 131user1 stage/sql/starting 0 132execute dump_stages_host; 133host event_name count_star 134localhost stage/sql/checking permissions 0 135localhost stage/sql/closing tables 0 136localhost stage/sql/init 0 137localhost stage/sql/Opening tables 0 138localhost stage/sql/starting 0 139execute dump_stages_global; 140event_name count_star 141stage/sql/checking permissions 0 142stage/sql/closing tables 0 143stage/sql/init 0 144stage/sql/Opening tables 0 145stage/sql/starting 0 146execute dump_stages_history; 147event_name count(event_name) 148execute dump_statements_account; 149user host event_name count_star 150user1 localhost statement/com/Error 0 151user1 localhost statement/com/Quit 0 152user1 localhost statement/sp/freturn 0 153user1 localhost statement/sql/insert 0 154user1 localhost statement/sql/select 0 155execute dump_statements_user; 156user event_name count_star 157user1 statement/com/Error 0 158user1 statement/com/Quit 0 159user1 statement/sp/freturn 0 160user1 statement/sql/insert 0 161user1 statement/sql/select 0 162execute dump_statements_host; 163host event_name count_star 164localhost statement/com/Error 0 165localhost statement/com/Quit 0 166localhost statement/sp/freturn 0 167localhost statement/sql/insert 0 168localhost statement/sql/select 0 169execute dump_statements_global; 170event_name count_star 171statement/com/Error 0 172statement/com/Quit 0 173statement/sp/freturn 0 174statement/sql/insert 0 175statement/sql/select 0 176execute dump_statements_history; 177event_name count(event_name) 178execute dump_transactions_account; 179user host event_name count_star 180user1 localhost transaction 0 181execute dump_transactions_user; 182user event_name count_star 183user1 transaction 0 184execute dump_transactions_host; 185host event_name count_star 186localhost transaction 0 187execute dump_transactions_global; 188event_name count_star 189transaction 0 190execute dump_transactions_history; 191event_name count(event_name) 192execute dump_accounts; 193USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 194root localhost 1 1 195user1 localhost 1 1 196execute dump_users; 197USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 198root 1 1 199user1 1 1 200execute dump_hosts; 201HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 202localhost 2 2 203connection con1; 204select uuid_short() <> 1; 205uuid_short() <> 1 2061 207select uuid_short() <> 1; 208uuid_short() <> 1 2091 210start transaction; 211insert into test.t1 values ("marker"); 212commit; 213select test.f(10,20); 214test.f(10,20) 21530 216connection default; 217"================== Step 3 ==================" 218call dump_thread(); 219username event_name count_star 220user1 wait/io/file/sql/query_log 7 221user1 wait/synch/rwlock/sql/LOCK_grant 1 222username status 223user2 not found 224username status 225user3 not found 226username status 227user4 not found 228execute dump_waits_account; 229user host event_name count_star 230user1 localhost wait/io/file/sql/query_log 7 231user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 232execute dump_waits_user; 233user event_name count_star 234user1 wait/io/file/sql/query_log 7 235user1 wait/synch/rwlock/sql/LOCK_grant 1 236execute dump_waits_host; 237host event_name count_star 238localhost wait/io/file/sql/query_log 7 239localhost wait/synch/rwlock/sql/LOCK_grant 1 240execute dump_waits_global; 241event_name count_star 242wait/io/file/sql/query_log 7 243wait/synch/rwlock/sql/LOCK_grant 1 244execute dump_waits_history; 245event_name count(event_name) 246wait/io/file/sql/query_log 7 247wait/synch/rwlock/sql/LOCK_grant 1 248execute dump_stages_account; 249user host event_name count_star 250user1 localhost stage/sql/checking permissions 4 251user1 localhost stage/sql/closing tables 11 252user1 localhost stage/sql/init 3 253user1 localhost stage/sql/Opening tables 7 254user1 localhost stage/sql/starting 6 255execute dump_stages_user; 256user event_name count_star 257user1 stage/sql/checking permissions 4 258user1 stage/sql/closing tables 11 259user1 stage/sql/init 3 260user1 stage/sql/Opening tables 7 261user1 stage/sql/starting 6 262execute dump_stages_host; 263host event_name count_star 264localhost stage/sql/checking permissions 4 265localhost stage/sql/closing tables 11 266localhost stage/sql/init 3 267localhost stage/sql/Opening tables 7 268localhost stage/sql/starting 6 269execute dump_stages_global; 270event_name count_star 271stage/sql/checking permissions 4 272stage/sql/closing tables 11 273stage/sql/init 3 274stage/sql/Opening tables 7 275stage/sql/starting 6 276execute dump_stages_history; 277event_name count(event_name) 278stage/sql/checking permissions 4 279stage/sql/closing tables 11 280stage/sql/init 3 281stage/sql/Opening tables 7 282stage/sql/starting 6 283execute dump_statements_account; 284user host event_name count_star 285user1 localhost statement/com/Error 0 286user1 localhost statement/com/Quit 0 287user1 localhost statement/sp/freturn 1 288user1 localhost statement/sql/insert 1 289user1 localhost statement/sql/select 3 290execute dump_statements_user; 291user event_name count_star 292user1 statement/com/Error 0 293user1 statement/com/Quit 0 294user1 statement/sp/freturn 1 295user1 statement/sql/insert 1 296user1 statement/sql/select 3 297execute dump_statements_host; 298host event_name count_star 299localhost statement/com/Error 0 300localhost statement/com/Quit 0 301localhost statement/sp/freturn 1 302localhost statement/sql/insert 1 303localhost statement/sql/select 3 304execute dump_statements_global; 305event_name count_star 306statement/com/Error 0 307statement/com/Quit 0 308statement/sp/freturn 1 309statement/sql/insert 1 310statement/sql/select 3 311execute dump_statements_history; 312event_name count(event_name) 313statement/sp/freturn 1 314statement/sql/insert 1 315statement/sql/select 3 316execute dump_transactions_account; 317user host event_name count_star 318user1 localhost transaction 2 319execute dump_transactions_user; 320user event_name count_star 321user1 transaction 2 322execute dump_transactions_host; 323host event_name count_star 324localhost transaction 2 325execute dump_transactions_global; 326event_name count_star 327transaction 2 328execute dump_transactions_history; 329event_name count(event_name) 330transaction 2 331execute dump_accounts; 332USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 333root localhost 1 1 334user1 localhost 1 1 335execute dump_users; 336USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 337root 1 1 338user1 1 1 339execute dump_hosts; 340HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 341localhost 2 2 342connect con2, localhost, user2, , ; 343connection default; 344"================== Step 4 ==================" 345call dump_thread(); 346username event_name count_star 347user1 wait/io/file/sql/query_log 7 348user1 wait/synch/rwlock/sql/LOCK_grant 1 349username event_name count_star 350user2 wait/io/file/sql/query_log 1 351user2 wait/synch/rwlock/sql/LOCK_grant 0 352username status 353user3 not found 354username status 355user4 not found 356execute dump_waits_account; 357user host event_name count_star 358user1 localhost wait/io/file/sql/query_log 7 359user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 360user2 localhost wait/io/file/sql/query_log 1 361user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 362execute dump_waits_user; 363user event_name count_star 364user1 wait/io/file/sql/query_log 7 365user1 wait/synch/rwlock/sql/LOCK_grant 1 366user2 wait/io/file/sql/query_log 1 367user2 wait/synch/rwlock/sql/LOCK_grant 0 368execute dump_waits_host; 369host event_name count_star 370localhost wait/io/file/sql/query_log 8 371localhost wait/synch/rwlock/sql/LOCK_grant 1 372execute dump_waits_global; 373event_name count_star 374wait/io/file/sql/query_log 8 375wait/synch/rwlock/sql/LOCK_grant 1 376execute dump_waits_history; 377event_name count(event_name) 378wait/io/file/sql/query_log 8 379wait/synch/rwlock/sql/LOCK_grant 1 380execute dump_stages_account; 381user host event_name count_star 382user1 localhost stage/sql/checking permissions 4 383user1 localhost stage/sql/closing tables 11 384user1 localhost stage/sql/init 3 385user1 localhost stage/sql/Opening tables 7 386user1 localhost stage/sql/starting 6 387user2 localhost stage/sql/checking permissions 0 388user2 localhost stage/sql/closing tables 0 389user2 localhost stage/sql/init 0 390user2 localhost stage/sql/Opening tables 0 391user2 localhost stage/sql/starting 0 392execute dump_stages_user; 393user event_name count_star 394user1 stage/sql/checking permissions 4 395user1 stage/sql/closing tables 11 396user1 stage/sql/init 3 397user1 stage/sql/Opening tables 7 398user1 stage/sql/starting 6 399user2 stage/sql/checking permissions 0 400user2 stage/sql/closing tables 0 401user2 stage/sql/init 0 402user2 stage/sql/Opening tables 0 403user2 stage/sql/starting 0 404execute dump_stages_host; 405host event_name count_star 406localhost stage/sql/checking permissions 4 407localhost stage/sql/closing tables 11 408localhost stage/sql/init 3 409localhost stage/sql/Opening tables 7 410localhost stage/sql/starting 6 411execute dump_stages_global; 412event_name count_star 413stage/sql/checking permissions 4 414stage/sql/closing tables 11 415stage/sql/init 3 416stage/sql/Opening tables 7 417stage/sql/starting 6 418execute dump_stages_history; 419event_name count(event_name) 420stage/sql/checking permissions 4 421stage/sql/closing tables 11 422stage/sql/init 3 423stage/sql/Opening tables 7 424stage/sql/starting 6 425execute dump_statements_account; 426user host event_name count_star 427user1 localhost statement/com/Error 0 428user1 localhost statement/com/Quit 0 429user1 localhost statement/sp/freturn 1 430user1 localhost statement/sql/insert 1 431user1 localhost statement/sql/select 3 432user2 localhost statement/com/Error 0 433user2 localhost statement/com/Quit 0 434user2 localhost statement/sp/freturn 0 435user2 localhost statement/sql/insert 0 436user2 localhost statement/sql/select 0 437execute dump_statements_user; 438user event_name count_star 439user1 statement/com/Error 0 440user1 statement/com/Quit 0 441user1 statement/sp/freturn 1 442user1 statement/sql/insert 1 443user1 statement/sql/select 3 444user2 statement/com/Error 0 445user2 statement/com/Quit 0 446user2 statement/sp/freturn 0 447user2 statement/sql/insert 0 448user2 statement/sql/select 0 449execute dump_statements_host; 450host event_name count_star 451localhost statement/com/Error 0 452localhost statement/com/Quit 0 453localhost statement/sp/freturn 1 454localhost statement/sql/insert 1 455localhost statement/sql/select 3 456execute dump_statements_global; 457event_name count_star 458statement/com/Error 0 459statement/com/Quit 0 460statement/sp/freturn 1 461statement/sql/insert 1 462statement/sql/select 3 463execute dump_statements_history; 464event_name count(event_name) 465statement/sp/freturn 1 466statement/sql/insert 1 467statement/sql/select 3 468execute dump_transactions_account; 469user host event_name count_star 470user1 localhost transaction 2 471user2 localhost transaction 0 472execute dump_transactions_user; 473user event_name count_star 474user1 transaction 2 475user2 transaction 0 476execute dump_transactions_host; 477host event_name count_star 478localhost transaction 2 479execute dump_transactions_global; 480event_name count_star 481transaction 2 482execute dump_transactions_history; 483event_name count(event_name) 484transaction 2 485execute dump_accounts; 486USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 487root localhost 1 1 488user1 localhost 1 1 489user2 localhost 1 1 490execute dump_users; 491USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 492root 1 1 493user1 1 1 494user2 1 1 495execute dump_hosts; 496HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 497localhost 3 3 498connection con2; 499select uuid_short() <> 1; 500uuid_short() <> 1 5011 502select uuid_short() <> 1; 503uuid_short() <> 1 5041 505start transaction; 506insert into test.t1 values ("marker"); 507commit; 508select test.f(10,20); 509test.f(10,20) 51030 511connection default; 512"================== Step 5 ==================" 513call dump_thread(); 514username event_name count_star 515user1 wait/io/file/sql/query_log 7 516user1 wait/synch/rwlock/sql/LOCK_grant 1 517username event_name count_star 518user2 wait/io/file/sql/query_log 7 519user2 wait/synch/rwlock/sql/LOCK_grant 1 520username status 521user3 not found 522username status 523user4 not found 524execute dump_waits_account; 525user host event_name count_star 526user1 localhost wait/io/file/sql/query_log 7 527user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 528user2 localhost wait/io/file/sql/query_log 7 529user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 530execute dump_waits_user; 531user event_name count_star 532user1 wait/io/file/sql/query_log 7 533user1 wait/synch/rwlock/sql/LOCK_grant 1 534user2 wait/io/file/sql/query_log 7 535user2 wait/synch/rwlock/sql/LOCK_grant 1 536execute dump_waits_host; 537host event_name count_star 538localhost wait/io/file/sql/query_log 14 539localhost wait/synch/rwlock/sql/LOCK_grant 2 540execute dump_waits_global; 541event_name count_star 542wait/io/file/sql/query_log 14 543wait/synch/rwlock/sql/LOCK_grant 2 544execute dump_waits_history; 545event_name count(event_name) 546wait/io/file/sql/query_log 14 547wait/synch/rwlock/sql/LOCK_grant 2 548execute dump_stages_account; 549user host event_name count_star 550user1 localhost stage/sql/checking permissions 4 551user1 localhost stage/sql/closing tables 11 552user1 localhost stage/sql/init 3 553user1 localhost stage/sql/Opening tables 7 554user1 localhost stage/sql/starting 6 555user2 localhost stage/sql/checking permissions 4 556user2 localhost stage/sql/closing tables 10 557user2 localhost stage/sql/init 3 558user2 localhost stage/sql/Opening tables 6 559user2 localhost stage/sql/starting 6 560execute dump_stages_user; 561user event_name count_star 562user1 stage/sql/checking permissions 4 563user1 stage/sql/closing tables 11 564user1 stage/sql/init 3 565user1 stage/sql/Opening tables 7 566user1 stage/sql/starting 6 567user2 stage/sql/checking permissions 4 568user2 stage/sql/closing tables 10 569user2 stage/sql/init 3 570user2 stage/sql/Opening tables 6 571user2 stage/sql/starting 6 572execute dump_stages_host; 573host event_name count_star 574localhost stage/sql/checking permissions 8 575localhost stage/sql/closing tables 21 576localhost stage/sql/init 6 577localhost stage/sql/Opening tables 13 578localhost stage/sql/starting 12 579execute dump_stages_global; 580event_name count_star 581stage/sql/checking permissions 8 582stage/sql/closing tables 21 583stage/sql/init 6 584stage/sql/Opening tables 13 585stage/sql/starting 12 586execute dump_stages_history; 587event_name count(event_name) 588stage/sql/checking permissions 8 589stage/sql/closing tables 21 590stage/sql/init 6 591stage/sql/Opening tables 13 592stage/sql/starting 12 593execute dump_statements_account; 594user host event_name count_star 595user1 localhost statement/com/Error 0 596user1 localhost statement/com/Quit 0 597user1 localhost statement/sp/freturn 1 598user1 localhost statement/sql/insert 1 599user1 localhost statement/sql/select 3 600user2 localhost statement/com/Error 0 601user2 localhost statement/com/Quit 0 602user2 localhost statement/sp/freturn 1 603user2 localhost statement/sql/insert 1 604user2 localhost statement/sql/select 3 605execute dump_statements_user; 606user event_name count_star 607user1 statement/com/Error 0 608user1 statement/com/Quit 0 609user1 statement/sp/freturn 1 610user1 statement/sql/insert 1 611user1 statement/sql/select 3 612user2 statement/com/Error 0 613user2 statement/com/Quit 0 614user2 statement/sp/freturn 1 615user2 statement/sql/insert 1 616user2 statement/sql/select 3 617execute dump_statements_host; 618host event_name count_star 619localhost statement/com/Error 0 620localhost statement/com/Quit 0 621localhost statement/sp/freturn 2 622localhost statement/sql/insert 2 623localhost statement/sql/select 6 624execute dump_statements_global; 625event_name count_star 626statement/com/Error 0 627statement/com/Quit 0 628statement/sp/freturn 2 629statement/sql/insert 2 630statement/sql/select 6 631execute dump_statements_history; 632event_name count(event_name) 633statement/sp/freturn 2 634statement/sql/insert 2 635statement/sql/select 6 636execute dump_transactions_account; 637user host event_name count_star 638user1 localhost transaction 2 639user2 localhost transaction 2 640execute dump_transactions_user; 641user event_name count_star 642user1 transaction 2 643user2 transaction 2 644execute dump_transactions_host; 645host event_name count_star 646localhost transaction 4 647execute dump_transactions_global; 648event_name count_star 649transaction 4 650execute dump_transactions_history; 651event_name count(event_name) 652transaction 4 653execute dump_accounts; 654USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 655root localhost 1 1 656user1 localhost 1 1 657user2 localhost 1 1 658execute dump_users; 659USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 660root 1 1 661user1 1 1 662user2 1 1 663execute dump_hosts; 664HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 665localhost 3 3 666connect con3, localhost, user3, , ; 667connection default; 668"================== Step 6 ==================" 669call dump_thread(); 670username event_name count_star 671user1 wait/io/file/sql/query_log 7 672user1 wait/synch/rwlock/sql/LOCK_grant 1 673username event_name count_star 674user2 wait/io/file/sql/query_log 7 675user2 wait/synch/rwlock/sql/LOCK_grant 1 676username event_name count_star 677user3 wait/io/file/sql/query_log 1 678user3 wait/synch/rwlock/sql/LOCK_grant 0 679username status 680user4 not found 681execute dump_waits_account; 682user host event_name count_star 683user1 localhost wait/io/file/sql/query_log 7 684user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 685user2 localhost wait/io/file/sql/query_log 7 686user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 687user3 localhost wait/io/file/sql/query_log 1 688user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 689execute dump_waits_user; 690user event_name count_star 691user1 wait/io/file/sql/query_log 7 692user1 wait/synch/rwlock/sql/LOCK_grant 1 693user2 wait/io/file/sql/query_log 7 694user2 wait/synch/rwlock/sql/LOCK_grant 1 695user3 wait/io/file/sql/query_log 1 696user3 wait/synch/rwlock/sql/LOCK_grant 0 697execute dump_waits_host; 698host event_name count_star 699localhost wait/io/file/sql/query_log 15 700localhost wait/synch/rwlock/sql/LOCK_grant 2 701execute dump_waits_global; 702event_name count_star 703wait/io/file/sql/query_log 15 704wait/synch/rwlock/sql/LOCK_grant 2 705execute dump_waits_history; 706event_name count(event_name) 707wait/io/file/sql/query_log 15 708wait/synch/rwlock/sql/LOCK_grant 2 709execute dump_stages_account; 710user host event_name count_star 711user1 localhost stage/sql/checking permissions 4 712user1 localhost stage/sql/closing tables 11 713user1 localhost stage/sql/init 3 714user1 localhost stage/sql/Opening tables 7 715user1 localhost stage/sql/starting 6 716user2 localhost stage/sql/checking permissions 4 717user2 localhost stage/sql/closing tables 10 718user2 localhost stage/sql/init 3 719user2 localhost stage/sql/Opening tables 6 720user2 localhost stage/sql/starting 6 721user3 localhost stage/sql/checking permissions 0 722user3 localhost stage/sql/closing tables 0 723user3 localhost stage/sql/init 0 724user3 localhost stage/sql/Opening tables 0 725user3 localhost stage/sql/starting 0 726execute dump_stages_user; 727user event_name count_star 728user1 stage/sql/checking permissions 4 729user1 stage/sql/closing tables 11 730user1 stage/sql/init 3 731user1 stage/sql/Opening tables 7 732user1 stage/sql/starting 6 733user2 stage/sql/checking permissions 4 734user2 stage/sql/closing tables 10 735user2 stage/sql/init 3 736user2 stage/sql/Opening tables 6 737user2 stage/sql/starting 6 738user3 stage/sql/checking permissions 0 739user3 stage/sql/closing tables 0 740user3 stage/sql/init 0 741user3 stage/sql/Opening tables 0 742user3 stage/sql/starting 0 743execute dump_stages_host; 744host event_name count_star 745localhost stage/sql/checking permissions 8 746localhost stage/sql/closing tables 21 747localhost stage/sql/init 6 748localhost stage/sql/Opening tables 13 749localhost stage/sql/starting 12 750execute dump_stages_global; 751event_name count_star 752stage/sql/checking permissions 8 753stage/sql/closing tables 21 754stage/sql/init 6 755stage/sql/Opening tables 13 756stage/sql/starting 12 757execute dump_stages_history; 758event_name count(event_name) 759stage/sql/checking permissions 8 760stage/sql/closing tables 21 761stage/sql/init 6 762stage/sql/Opening tables 13 763stage/sql/starting 12 764execute dump_statements_account; 765user host event_name count_star 766user1 localhost statement/com/Error 0 767user1 localhost statement/com/Quit 0 768user1 localhost statement/sp/freturn 1 769user1 localhost statement/sql/insert 1 770user1 localhost statement/sql/select 3 771user2 localhost statement/com/Error 0 772user2 localhost statement/com/Quit 0 773user2 localhost statement/sp/freturn 1 774user2 localhost statement/sql/insert 1 775user2 localhost statement/sql/select 3 776user3 localhost statement/com/Error 0 777user3 localhost statement/com/Quit 0 778user3 localhost statement/sp/freturn 0 779user3 localhost statement/sql/insert 0 780user3 localhost statement/sql/select 0 781execute dump_statements_user; 782user event_name count_star 783user1 statement/com/Error 0 784user1 statement/com/Quit 0 785user1 statement/sp/freturn 1 786user1 statement/sql/insert 1 787user1 statement/sql/select 3 788user2 statement/com/Error 0 789user2 statement/com/Quit 0 790user2 statement/sp/freturn 1 791user2 statement/sql/insert 1 792user2 statement/sql/select 3 793user3 statement/com/Error 0 794user3 statement/com/Quit 0 795user3 statement/sp/freturn 0 796user3 statement/sql/insert 0 797user3 statement/sql/select 0 798execute dump_statements_host; 799host event_name count_star 800localhost statement/com/Error 0 801localhost statement/com/Quit 0 802localhost statement/sp/freturn 2 803localhost statement/sql/insert 2 804localhost statement/sql/select 6 805execute dump_statements_global; 806event_name count_star 807statement/com/Error 0 808statement/com/Quit 0 809statement/sp/freturn 2 810statement/sql/insert 2 811statement/sql/select 6 812execute dump_statements_history; 813event_name count(event_name) 814statement/sp/freturn 2 815statement/sql/insert 2 816statement/sql/select 6 817execute dump_transactions_account; 818user host event_name count_star 819user1 localhost transaction 2 820user2 localhost transaction 2 821user3 localhost transaction 0 822execute dump_transactions_user; 823user event_name count_star 824user1 transaction 2 825user2 transaction 2 826user3 transaction 0 827execute dump_transactions_host; 828host event_name count_star 829localhost transaction 4 830execute dump_transactions_global; 831event_name count_star 832transaction 4 833execute dump_transactions_history; 834event_name count(event_name) 835transaction 4 836execute dump_accounts; 837USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 838root localhost 1 1 839user1 localhost 1 1 840user2 localhost 1 1 841user3 localhost 1 1 842execute dump_users; 843USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 844root 1 1 845user1 1 1 846user2 1 1 847user3 1 1 848execute dump_hosts; 849HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 850localhost 4 4 851connection con3; 852select uuid_short() <> 1; 853uuid_short() <> 1 8541 855select uuid_short() <> 1; 856uuid_short() <> 1 8571 858start transaction; 859insert into test.t1 values ("marker"); 860commit; 861select test.f(10,20); 862test.f(10,20) 86330 864connection default; 865"================== Step 7 ==================" 866call dump_thread(); 867username event_name count_star 868user1 wait/io/file/sql/query_log 7 869user1 wait/synch/rwlock/sql/LOCK_grant 1 870username event_name count_star 871user2 wait/io/file/sql/query_log 7 872user2 wait/synch/rwlock/sql/LOCK_grant 1 873username event_name count_star 874user3 wait/io/file/sql/query_log 7 875user3 wait/synch/rwlock/sql/LOCK_grant 1 876username status 877user4 not found 878execute dump_waits_account; 879user host event_name count_star 880user1 localhost wait/io/file/sql/query_log 7 881user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 882user2 localhost wait/io/file/sql/query_log 7 883user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 884user3 localhost wait/io/file/sql/query_log 7 885user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 886execute dump_waits_user; 887user event_name count_star 888user1 wait/io/file/sql/query_log 7 889user1 wait/synch/rwlock/sql/LOCK_grant 1 890user2 wait/io/file/sql/query_log 7 891user2 wait/synch/rwlock/sql/LOCK_grant 1 892user3 wait/io/file/sql/query_log 7 893user3 wait/synch/rwlock/sql/LOCK_grant 1 894execute dump_waits_host; 895host event_name count_star 896localhost wait/io/file/sql/query_log 21 897localhost wait/synch/rwlock/sql/LOCK_grant 3 898execute dump_waits_global; 899event_name count_star 900wait/io/file/sql/query_log 21 901wait/synch/rwlock/sql/LOCK_grant 3 902execute dump_waits_history; 903event_name count(event_name) 904wait/io/file/sql/query_log 21 905wait/synch/rwlock/sql/LOCK_grant 3 906execute dump_stages_account; 907user host event_name count_star 908user1 localhost stage/sql/checking permissions 4 909user1 localhost stage/sql/closing tables 11 910user1 localhost stage/sql/init 3 911user1 localhost stage/sql/Opening tables 7 912user1 localhost stage/sql/starting 6 913user2 localhost stage/sql/checking permissions 4 914user2 localhost stage/sql/closing tables 10 915user2 localhost stage/sql/init 3 916user2 localhost stage/sql/Opening tables 6 917user2 localhost stage/sql/starting 6 918user3 localhost stage/sql/checking permissions 4 919user3 localhost stage/sql/closing tables 10 920user3 localhost stage/sql/init 3 921user3 localhost stage/sql/Opening tables 6 922user3 localhost stage/sql/starting 6 923execute dump_stages_user; 924user event_name count_star 925user1 stage/sql/checking permissions 4 926user1 stage/sql/closing tables 11 927user1 stage/sql/init 3 928user1 stage/sql/Opening tables 7 929user1 stage/sql/starting 6 930user2 stage/sql/checking permissions 4 931user2 stage/sql/closing tables 10 932user2 stage/sql/init 3 933user2 stage/sql/Opening tables 6 934user2 stage/sql/starting 6 935user3 stage/sql/checking permissions 4 936user3 stage/sql/closing tables 10 937user3 stage/sql/init 3 938user3 stage/sql/Opening tables 6 939user3 stage/sql/starting 6 940execute dump_stages_host; 941host event_name count_star 942localhost stage/sql/checking permissions 12 943localhost stage/sql/closing tables 31 944localhost stage/sql/init 9 945localhost stage/sql/Opening tables 19 946localhost stage/sql/starting 18 947execute dump_stages_global; 948event_name count_star 949stage/sql/checking permissions 12 950stage/sql/closing tables 31 951stage/sql/init 9 952stage/sql/Opening tables 19 953stage/sql/starting 18 954execute dump_stages_history; 955event_name count(event_name) 956stage/sql/checking permissions 12 957stage/sql/closing tables 31 958stage/sql/init 9 959stage/sql/Opening tables 19 960stage/sql/starting 18 961execute dump_statements_account; 962user host event_name count_star 963user1 localhost statement/com/Error 0 964user1 localhost statement/com/Quit 0 965user1 localhost statement/sp/freturn 1 966user1 localhost statement/sql/insert 1 967user1 localhost statement/sql/select 3 968user2 localhost statement/com/Error 0 969user2 localhost statement/com/Quit 0 970user2 localhost statement/sp/freturn 1 971user2 localhost statement/sql/insert 1 972user2 localhost statement/sql/select 3 973user3 localhost statement/com/Error 0 974user3 localhost statement/com/Quit 0 975user3 localhost statement/sp/freturn 1 976user3 localhost statement/sql/insert 1 977user3 localhost statement/sql/select 3 978execute dump_statements_user; 979user event_name count_star 980user1 statement/com/Error 0 981user1 statement/com/Quit 0 982user1 statement/sp/freturn 1 983user1 statement/sql/insert 1 984user1 statement/sql/select 3 985user2 statement/com/Error 0 986user2 statement/com/Quit 0 987user2 statement/sp/freturn 1 988user2 statement/sql/insert 1 989user2 statement/sql/select 3 990user3 statement/com/Error 0 991user3 statement/com/Quit 0 992user3 statement/sp/freturn 1 993user3 statement/sql/insert 1 994user3 statement/sql/select 3 995execute dump_statements_host; 996host event_name count_star 997localhost statement/com/Error 0 998localhost statement/com/Quit 0 999localhost statement/sp/freturn 3 1000localhost statement/sql/insert 3 1001localhost statement/sql/select 9 1002execute dump_statements_global; 1003event_name count_star 1004statement/com/Error 0 1005statement/com/Quit 0 1006statement/sp/freturn 3 1007statement/sql/insert 3 1008statement/sql/select 9 1009execute dump_statements_history; 1010event_name count(event_name) 1011statement/sp/freturn 3 1012statement/sql/insert 3 1013statement/sql/select 9 1014execute dump_transactions_account; 1015user host event_name count_star 1016user1 localhost transaction 2 1017user2 localhost transaction 2 1018user3 localhost transaction 2 1019execute dump_transactions_user; 1020user event_name count_star 1021user1 transaction 2 1022user2 transaction 2 1023user3 transaction 2 1024execute dump_transactions_host; 1025host event_name count_star 1026localhost transaction 6 1027execute dump_transactions_global; 1028event_name count_star 1029transaction 6 1030execute dump_transactions_history; 1031event_name count(event_name) 1032transaction 6 1033execute dump_accounts; 1034USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1035root localhost 1 1 1036user1 localhost 1 1 1037user2 localhost 1 1 1038user3 localhost 1 1 1039execute dump_users; 1040USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1041root 1 1 1042user1 1 1 1043user2 1 1 1044user3 1 1 1045execute dump_hosts; 1046HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1047localhost 4 4 1048connect con4, localhost, user4, , ; 1049connection default; 1050"================== Step 8 ==================" 1051call dump_thread(); 1052username event_name count_star 1053user1 wait/io/file/sql/query_log 7 1054user1 wait/synch/rwlock/sql/LOCK_grant 1 1055username event_name count_star 1056user2 wait/io/file/sql/query_log 7 1057user2 wait/synch/rwlock/sql/LOCK_grant 1 1058username event_name count_star 1059user3 wait/io/file/sql/query_log 7 1060user3 wait/synch/rwlock/sql/LOCK_grant 1 1061username event_name count_star 1062user4 wait/io/file/sql/query_log 1 1063user4 wait/synch/rwlock/sql/LOCK_grant 0 1064execute dump_waits_account; 1065user host event_name count_star 1066user1 localhost wait/io/file/sql/query_log 7 1067user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 1068user2 localhost wait/io/file/sql/query_log 7 1069user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 1070user3 localhost wait/io/file/sql/query_log 7 1071user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 1072user4 localhost wait/io/file/sql/query_log 1 1073user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 1074execute dump_waits_user; 1075user event_name count_star 1076user1 wait/io/file/sql/query_log 7 1077user1 wait/synch/rwlock/sql/LOCK_grant 1 1078user2 wait/io/file/sql/query_log 7 1079user2 wait/synch/rwlock/sql/LOCK_grant 1 1080user3 wait/io/file/sql/query_log 7 1081user3 wait/synch/rwlock/sql/LOCK_grant 1 1082user4 wait/io/file/sql/query_log 1 1083user4 wait/synch/rwlock/sql/LOCK_grant 0 1084execute dump_waits_host; 1085host event_name count_star 1086localhost wait/io/file/sql/query_log 22 1087localhost wait/synch/rwlock/sql/LOCK_grant 3 1088execute dump_waits_global; 1089event_name count_star 1090wait/io/file/sql/query_log 22 1091wait/synch/rwlock/sql/LOCK_grant 3 1092execute dump_waits_history; 1093event_name count(event_name) 1094wait/io/file/sql/query_log 22 1095wait/synch/rwlock/sql/LOCK_grant 3 1096execute dump_stages_account; 1097user host event_name count_star 1098user1 localhost stage/sql/checking permissions 4 1099user1 localhost stage/sql/closing tables 11 1100user1 localhost stage/sql/init 3 1101user1 localhost stage/sql/Opening tables 7 1102user1 localhost stage/sql/starting 6 1103user2 localhost stage/sql/checking permissions 4 1104user2 localhost stage/sql/closing tables 10 1105user2 localhost stage/sql/init 3 1106user2 localhost stage/sql/Opening tables 6 1107user2 localhost stage/sql/starting 6 1108user3 localhost stage/sql/checking permissions 4 1109user3 localhost stage/sql/closing tables 10 1110user3 localhost stage/sql/init 3 1111user3 localhost stage/sql/Opening tables 6 1112user3 localhost stage/sql/starting 6 1113user4 localhost stage/sql/checking permissions 0 1114user4 localhost stage/sql/closing tables 0 1115user4 localhost stage/sql/init 0 1116user4 localhost stage/sql/Opening tables 0 1117user4 localhost stage/sql/starting 0 1118execute dump_stages_user; 1119user event_name count_star 1120user1 stage/sql/checking permissions 4 1121user1 stage/sql/closing tables 11 1122user1 stage/sql/init 3 1123user1 stage/sql/Opening tables 7 1124user1 stage/sql/starting 6 1125user2 stage/sql/checking permissions 4 1126user2 stage/sql/closing tables 10 1127user2 stage/sql/init 3 1128user2 stage/sql/Opening tables 6 1129user2 stage/sql/starting 6 1130user3 stage/sql/checking permissions 4 1131user3 stage/sql/closing tables 10 1132user3 stage/sql/init 3 1133user3 stage/sql/Opening tables 6 1134user3 stage/sql/starting 6 1135user4 stage/sql/checking permissions 0 1136user4 stage/sql/closing tables 0 1137user4 stage/sql/init 0 1138user4 stage/sql/Opening tables 0 1139user4 stage/sql/starting 0 1140execute dump_stages_host; 1141host event_name count_star 1142localhost stage/sql/checking permissions 12 1143localhost stage/sql/closing tables 31 1144localhost stage/sql/init 9 1145localhost stage/sql/Opening tables 19 1146localhost stage/sql/starting 18 1147execute dump_stages_global; 1148event_name count_star 1149stage/sql/checking permissions 12 1150stage/sql/closing tables 31 1151stage/sql/init 9 1152stage/sql/Opening tables 19 1153stage/sql/starting 18 1154execute dump_stages_history; 1155event_name count(event_name) 1156stage/sql/checking permissions 12 1157stage/sql/closing tables 31 1158stage/sql/init 9 1159stage/sql/Opening tables 19 1160stage/sql/starting 18 1161execute dump_statements_account; 1162user host event_name count_star 1163user1 localhost statement/com/Error 0 1164user1 localhost statement/com/Quit 0 1165user1 localhost statement/sp/freturn 1 1166user1 localhost statement/sql/insert 1 1167user1 localhost statement/sql/select 3 1168user2 localhost statement/com/Error 0 1169user2 localhost statement/com/Quit 0 1170user2 localhost statement/sp/freturn 1 1171user2 localhost statement/sql/insert 1 1172user2 localhost statement/sql/select 3 1173user3 localhost statement/com/Error 0 1174user3 localhost statement/com/Quit 0 1175user3 localhost statement/sp/freturn 1 1176user3 localhost statement/sql/insert 1 1177user3 localhost statement/sql/select 3 1178user4 localhost statement/com/Error 0 1179user4 localhost statement/com/Quit 0 1180user4 localhost statement/sp/freturn 0 1181user4 localhost statement/sql/insert 0 1182user4 localhost statement/sql/select 0 1183execute dump_statements_user; 1184user event_name count_star 1185user1 statement/com/Error 0 1186user1 statement/com/Quit 0 1187user1 statement/sp/freturn 1 1188user1 statement/sql/insert 1 1189user1 statement/sql/select 3 1190user2 statement/com/Error 0 1191user2 statement/com/Quit 0 1192user2 statement/sp/freturn 1 1193user2 statement/sql/insert 1 1194user2 statement/sql/select 3 1195user3 statement/com/Error 0 1196user3 statement/com/Quit 0 1197user3 statement/sp/freturn 1 1198user3 statement/sql/insert 1 1199user3 statement/sql/select 3 1200user4 statement/com/Error 0 1201user4 statement/com/Quit 0 1202user4 statement/sp/freturn 0 1203user4 statement/sql/insert 0 1204user4 statement/sql/select 0 1205execute dump_statements_host; 1206host event_name count_star 1207localhost statement/com/Error 0 1208localhost statement/com/Quit 0 1209localhost statement/sp/freturn 3 1210localhost statement/sql/insert 3 1211localhost statement/sql/select 9 1212execute dump_statements_global; 1213event_name count_star 1214statement/com/Error 0 1215statement/com/Quit 0 1216statement/sp/freturn 3 1217statement/sql/insert 3 1218statement/sql/select 9 1219execute dump_statements_history; 1220event_name count(event_name) 1221statement/sp/freturn 3 1222statement/sql/insert 3 1223statement/sql/select 9 1224execute dump_transactions_account; 1225user host event_name count_star 1226user1 localhost transaction 2 1227user2 localhost transaction 2 1228user3 localhost transaction 2 1229user4 localhost transaction 0 1230execute dump_transactions_user; 1231user event_name count_star 1232user1 transaction 2 1233user2 transaction 2 1234user3 transaction 2 1235user4 transaction 0 1236execute dump_transactions_host; 1237host event_name count_star 1238localhost transaction 6 1239execute dump_transactions_global; 1240event_name count_star 1241transaction 6 1242execute dump_transactions_history; 1243event_name count(event_name) 1244transaction 6 1245execute dump_accounts; 1246USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1247root localhost 1 1 1248user1 localhost 1 1 1249user2 localhost 1 1 1250user3 localhost 1 1 1251user4 localhost 1 1 1252execute dump_users; 1253USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1254root 1 1 1255user1 1 1 1256user2 1 1 1257user3 1 1 1258user4 1 1 1259execute dump_hosts; 1260HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1261localhost 5 5 1262connection con4; 1263select uuid_short() <> 1; 1264uuid_short() <> 1 12651 1266select uuid_short() <> 1; 1267uuid_short() <> 1 12681 1269start transaction; 1270insert into test.t1 values ("marker"); 1271commit; 1272select test.f(10,20); 1273test.f(10,20) 127430 1275connection default; 1276"================== Step 9 ==================" 1277call dump_thread(); 1278username event_name count_star 1279user1 wait/io/file/sql/query_log 7 1280user1 wait/synch/rwlock/sql/LOCK_grant 1 1281username event_name count_star 1282user2 wait/io/file/sql/query_log 7 1283user2 wait/synch/rwlock/sql/LOCK_grant 1 1284username event_name count_star 1285user3 wait/io/file/sql/query_log 7 1286user3 wait/synch/rwlock/sql/LOCK_grant 1 1287username event_name count_star 1288user4 wait/io/file/sql/query_log 7 1289user4 wait/synch/rwlock/sql/LOCK_grant 1 1290execute dump_waits_account; 1291user host event_name count_star 1292user1 localhost wait/io/file/sql/query_log 7 1293user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 1294user2 localhost wait/io/file/sql/query_log 7 1295user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 1296user3 localhost wait/io/file/sql/query_log 7 1297user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 1298user4 localhost wait/io/file/sql/query_log 7 1299user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 1300execute dump_waits_user; 1301user event_name count_star 1302user1 wait/io/file/sql/query_log 7 1303user1 wait/synch/rwlock/sql/LOCK_grant 1 1304user2 wait/io/file/sql/query_log 7 1305user2 wait/synch/rwlock/sql/LOCK_grant 1 1306user3 wait/io/file/sql/query_log 7 1307user3 wait/synch/rwlock/sql/LOCK_grant 1 1308user4 wait/io/file/sql/query_log 7 1309user4 wait/synch/rwlock/sql/LOCK_grant 1 1310execute dump_waits_host; 1311host event_name count_star 1312localhost wait/io/file/sql/query_log 28 1313localhost wait/synch/rwlock/sql/LOCK_grant 4 1314execute dump_waits_global; 1315event_name count_star 1316wait/io/file/sql/query_log 28 1317wait/synch/rwlock/sql/LOCK_grant 4 1318execute dump_waits_history; 1319event_name count(event_name) 1320wait/io/file/sql/query_log 28 1321wait/synch/rwlock/sql/LOCK_grant 4 1322execute dump_stages_account; 1323user host event_name count_star 1324user1 localhost stage/sql/checking permissions 4 1325user1 localhost stage/sql/closing tables 11 1326user1 localhost stage/sql/init 3 1327user1 localhost stage/sql/Opening tables 7 1328user1 localhost stage/sql/starting 6 1329user2 localhost stage/sql/checking permissions 4 1330user2 localhost stage/sql/closing tables 10 1331user2 localhost stage/sql/init 3 1332user2 localhost stage/sql/Opening tables 6 1333user2 localhost stage/sql/starting 6 1334user3 localhost stage/sql/checking permissions 4 1335user3 localhost stage/sql/closing tables 10 1336user3 localhost stage/sql/init 3 1337user3 localhost stage/sql/Opening tables 6 1338user3 localhost stage/sql/starting 6 1339user4 localhost stage/sql/checking permissions 4 1340user4 localhost stage/sql/closing tables 10 1341user4 localhost stage/sql/init 3 1342user4 localhost stage/sql/Opening tables 6 1343user4 localhost stage/sql/starting 6 1344execute dump_stages_user; 1345user event_name count_star 1346user1 stage/sql/checking permissions 4 1347user1 stage/sql/closing tables 11 1348user1 stage/sql/init 3 1349user1 stage/sql/Opening tables 7 1350user1 stage/sql/starting 6 1351user2 stage/sql/checking permissions 4 1352user2 stage/sql/closing tables 10 1353user2 stage/sql/init 3 1354user2 stage/sql/Opening tables 6 1355user2 stage/sql/starting 6 1356user3 stage/sql/checking permissions 4 1357user3 stage/sql/closing tables 10 1358user3 stage/sql/init 3 1359user3 stage/sql/Opening tables 6 1360user3 stage/sql/starting 6 1361user4 stage/sql/checking permissions 4 1362user4 stage/sql/closing tables 10 1363user4 stage/sql/init 3 1364user4 stage/sql/Opening tables 6 1365user4 stage/sql/starting 6 1366execute dump_stages_host; 1367host event_name count_star 1368localhost stage/sql/checking permissions 16 1369localhost stage/sql/closing tables 41 1370localhost stage/sql/init 12 1371localhost stage/sql/Opening tables 25 1372localhost stage/sql/starting 24 1373execute dump_stages_global; 1374event_name count_star 1375stage/sql/checking permissions 16 1376stage/sql/closing tables 41 1377stage/sql/init 12 1378stage/sql/Opening tables 25 1379stage/sql/starting 24 1380execute dump_stages_history; 1381event_name count(event_name) 1382stage/sql/checking permissions 16 1383stage/sql/closing tables 41 1384stage/sql/init 12 1385stage/sql/Opening tables 25 1386stage/sql/starting 24 1387execute dump_statements_account; 1388user host event_name count_star 1389user1 localhost statement/com/Error 0 1390user1 localhost statement/com/Quit 0 1391user1 localhost statement/sp/freturn 1 1392user1 localhost statement/sql/insert 1 1393user1 localhost statement/sql/select 3 1394user2 localhost statement/com/Error 0 1395user2 localhost statement/com/Quit 0 1396user2 localhost statement/sp/freturn 1 1397user2 localhost statement/sql/insert 1 1398user2 localhost statement/sql/select 3 1399user3 localhost statement/com/Error 0 1400user3 localhost statement/com/Quit 0 1401user3 localhost statement/sp/freturn 1 1402user3 localhost statement/sql/insert 1 1403user3 localhost statement/sql/select 3 1404user4 localhost statement/com/Error 0 1405user4 localhost statement/com/Quit 0 1406user4 localhost statement/sp/freturn 1 1407user4 localhost statement/sql/insert 1 1408user4 localhost statement/sql/select 3 1409execute dump_statements_user; 1410user event_name count_star 1411user1 statement/com/Error 0 1412user1 statement/com/Quit 0 1413user1 statement/sp/freturn 1 1414user1 statement/sql/insert 1 1415user1 statement/sql/select 3 1416user2 statement/com/Error 0 1417user2 statement/com/Quit 0 1418user2 statement/sp/freturn 1 1419user2 statement/sql/insert 1 1420user2 statement/sql/select 3 1421user3 statement/com/Error 0 1422user3 statement/com/Quit 0 1423user3 statement/sp/freturn 1 1424user3 statement/sql/insert 1 1425user3 statement/sql/select 3 1426user4 statement/com/Error 0 1427user4 statement/com/Quit 0 1428user4 statement/sp/freturn 1 1429user4 statement/sql/insert 1 1430user4 statement/sql/select 3 1431execute dump_statements_host; 1432host event_name count_star 1433localhost statement/com/Error 0 1434localhost statement/com/Quit 0 1435localhost statement/sp/freturn 4 1436localhost statement/sql/insert 4 1437localhost statement/sql/select 12 1438execute dump_statements_global; 1439event_name count_star 1440statement/com/Error 0 1441statement/com/Quit 0 1442statement/sp/freturn 4 1443statement/sql/insert 4 1444statement/sql/select 12 1445execute dump_statements_history; 1446event_name count(event_name) 1447statement/sp/freturn 4 1448statement/sql/insert 4 1449statement/sql/select 12 1450execute dump_transactions_account; 1451user host event_name count_star 1452user1 localhost transaction 2 1453user2 localhost transaction 2 1454user3 localhost transaction 2 1455user4 localhost transaction 2 1456execute dump_transactions_user; 1457user event_name count_star 1458user1 transaction 2 1459user2 transaction 2 1460user3 transaction 2 1461user4 transaction 2 1462execute dump_transactions_host; 1463host event_name count_star 1464localhost transaction 8 1465execute dump_transactions_global; 1466event_name count_star 1467transaction 8 1468execute dump_transactions_history; 1469event_name count(event_name) 1470transaction 8 1471execute dump_accounts; 1472USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1473root localhost 1 1 1474user1 localhost 1 1 1475user2 localhost 1 1 1476user3 localhost 1 1 1477user4 localhost 1 1 1478execute dump_users; 1479USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1480root 1 1 1481user1 1 1 1482user2 1 1 1483user3 1 1 1484user4 1 1 1485execute dump_hosts; 1486HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1487localhost 5 5 1488disconnect con1; 1489connection default; 1490"================== Step 10 ==================" 1491call dump_thread(); 1492username status 1493user1 not found 1494username event_name count_star 1495user2 wait/io/file/sql/query_log 7 1496user2 wait/synch/rwlock/sql/LOCK_grant 1 1497username event_name count_star 1498user3 wait/io/file/sql/query_log 7 1499user3 wait/synch/rwlock/sql/LOCK_grant 1 1500username event_name count_star 1501user4 wait/io/file/sql/query_log 7 1502user4 wait/synch/rwlock/sql/LOCK_grant 1 1503execute dump_waits_account; 1504user host event_name count_star 1505user1 localhost wait/io/file/sql/query_log 8 1506user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 1507user2 localhost wait/io/file/sql/query_log 7 1508user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 1509user3 localhost wait/io/file/sql/query_log 7 1510user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 1511user4 localhost wait/io/file/sql/query_log 7 1512user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 1513execute dump_waits_user; 1514user event_name count_star 1515user1 wait/io/file/sql/query_log 8 1516user1 wait/synch/rwlock/sql/LOCK_grant 1 1517user2 wait/io/file/sql/query_log 7 1518user2 wait/synch/rwlock/sql/LOCK_grant 1 1519user3 wait/io/file/sql/query_log 7 1520user3 wait/synch/rwlock/sql/LOCK_grant 1 1521user4 wait/io/file/sql/query_log 7 1522user4 wait/synch/rwlock/sql/LOCK_grant 1 1523execute dump_waits_host; 1524host event_name count_star 1525localhost wait/io/file/sql/query_log 29 1526localhost wait/synch/rwlock/sql/LOCK_grant 4 1527execute dump_waits_global; 1528event_name count_star 1529wait/io/file/sql/query_log 29 1530wait/synch/rwlock/sql/LOCK_grant 4 1531execute dump_waits_history; 1532event_name count(event_name) 1533wait/io/file/sql/query_log 29 1534wait/synch/rwlock/sql/LOCK_grant 4 1535execute dump_stages_account; 1536user host event_name count_star 1537user1 localhost stage/sql/checking permissions 4 1538user1 localhost stage/sql/closing tables 11 1539user1 localhost stage/sql/init 3 1540user1 localhost stage/sql/Opening tables 7 1541user1 localhost stage/sql/starting 7 1542user2 localhost stage/sql/checking permissions 4 1543user2 localhost stage/sql/closing tables 10 1544user2 localhost stage/sql/init 3 1545user2 localhost stage/sql/Opening tables 6 1546user2 localhost stage/sql/starting 6 1547user3 localhost stage/sql/checking permissions 4 1548user3 localhost stage/sql/closing tables 10 1549user3 localhost stage/sql/init 3 1550user3 localhost stage/sql/Opening tables 6 1551user3 localhost stage/sql/starting 6 1552user4 localhost stage/sql/checking permissions 4 1553user4 localhost stage/sql/closing tables 10 1554user4 localhost stage/sql/init 3 1555user4 localhost stage/sql/Opening tables 6 1556user4 localhost stage/sql/starting 6 1557execute dump_stages_user; 1558user event_name count_star 1559user1 stage/sql/checking permissions 4 1560user1 stage/sql/closing tables 11 1561user1 stage/sql/init 3 1562user1 stage/sql/Opening tables 7 1563user1 stage/sql/starting 7 1564user2 stage/sql/checking permissions 4 1565user2 stage/sql/closing tables 10 1566user2 stage/sql/init 3 1567user2 stage/sql/Opening tables 6 1568user2 stage/sql/starting 6 1569user3 stage/sql/checking permissions 4 1570user3 stage/sql/closing tables 10 1571user3 stage/sql/init 3 1572user3 stage/sql/Opening tables 6 1573user3 stage/sql/starting 6 1574user4 stage/sql/checking permissions 4 1575user4 stage/sql/closing tables 10 1576user4 stage/sql/init 3 1577user4 stage/sql/Opening tables 6 1578user4 stage/sql/starting 6 1579execute dump_stages_host; 1580host event_name count_star 1581localhost stage/sql/checking permissions 16 1582localhost stage/sql/closing tables 41 1583localhost stage/sql/init 12 1584localhost stage/sql/Opening tables 25 1585localhost stage/sql/starting 25 1586execute dump_stages_global; 1587event_name count_star 1588stage/sql/checking permissions 16 1589stage/sql/closing tables 41 1590stage/sql/init 12 1591stage/sql/Opening tables 25 1592stage/sql/starting 25 1593execute dump_stages_history; 1594event_name count(event_name) 1595stage/sql/checking permissions 16 1596stage/sql/closing tables 41 1597stage/sql/init 12 1598stage/sql/Opening tables 25 1599stage/sql/starting 25 1600execute dump_statements_account; 1601user host event_name count_star 1602user1 localhost statement/com/Error 0 1603user1 localhost statement/com/Quit 1 1604user1 localhost statement/sp/freturn 1 1605user1 localhost statement/sql/insert 1 1606user1 localhost statement/sql/select 3 1607user2 localhost statement/com/Error 0 1608user2 localhost statement/com/Quit 0 1609user2 localhost statement/sp/freturn 1 1610user2 localhost statement/sql/insert 1 1611user2 localhost statement/sql/select 3 1612user3 localhost statement/com/Error 0 1613user3 localhost statement/com/Quit 0 1614user3 localhost statement/sp/freturn 1 1615user3 localhost statement/sql/insert 1 1616user3 localhost statement/sql/select 3 1617user4 localhost statement/com/Error 0 1618user4 localhost statement/com/Quit 0 1619user4 localhost statement/sp/freturn 1 1620user4 localhost statement/sql/insert 1 1621user4 localhost statement/sql/select 3 1622execute dump_statements_user; 1623user event_name count_star 1624user1 statement/com/Error 0 1625user1 statement/com/Quit 1 1626user1 statement/sp/freturn 1 1627user1 statement/sql/insert 1 1628user1 statement/sql/select 3 1629user2 statement/com/Error 0 1630user2 statement/com/Quit 0 1631user2 statement/sp/freturn 1 1632user2 statement/sql/insert 1 1633user2 statement/sql/select 3 1634user3 statement/com/Error 0 1635user3 statement/com/Quit 0 1636user3 statement/sp/freturn 1 1637user3 statement/sql/insert 1 1638user3 statement/sql/select 3 1639user4 statement/com/Error 0 1640user4 statement/com/Quit 0 1641user4 statement/sp/freturn 1 1642user4 statement/sql/insert 1 1643user4 statement/sql/select 3 1644execute dump_statements_host; 1645host event_name count_star 1646localhost statement/com/Error 0 1647localhost statement/com/Quit 1 1648localhost statement/sp/freturn 4 1649localhost statement/sql/insert 4 1650localhost statement/sql/select 12 1651execute dump_statements_global; 1652event_name count_star 1653statement/com/Error 0 1654statement/com/Quit 1 1655statement/sp/freturn 4 1656statement/sql/insert 4 1657statement/sql/select 12 1658execute dump_statements_history; 1659event_name count(event_name) 1660statement/com/Quit 1 1661statement/sp/freturn 4 1662statement/sql/insert 4 1663statement/sql/select 12 1664execute dump_transactions_account; 1665user host event_name count_star 1666user1 localhost transaction 2 1667user2 localhost transaction 2 1668user3 localhost transaction 2 1669user4 localhost transaction 2 1670execute dump_transactions_user; 1671user event_name count_star 1672user1 transaction 2 1673user2 transaction 2 1674user3 transaction 2 1675user4 transaction 2 1676execute dump_transactions_host; 1677host event_name count_star 1678localhost transaction 8 1679execute dump_transactions_global; 1680event_name count_star 1681transaction 8 1682execute dump_transactions_history; 1683event_name count(event_name) 1684transaction 8 1685execute dump_accounts; 1686USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1687root localhost 1 1 1688user1 localhost 0 1 1689user2 localhost 1 1 1690user3 localhost 1 1 1691user4 localhost 1 1 1692execute dump_users; 1693USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1694root 1 1 1695user1 0 1 1696user2 1 1 1697user3 1 1 1698user4 1 1 1699execute dump_hosts; 1700HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1701localhost 4 5 1702disconnect con2; 1703connection default; 1704"================== Step 11 ==================" 1705call dump_thread(); 1706username status 1707user1 not found 1708username status 1709user2 not found 1710username event_name count_star 1711user3 wait/io/file/sql/query_log 7 1712user3 wait/synch/rwlock/sql/LOCK_grant 1 1713username event_name count_star 1714user4 wait/io/file/sql/query_log 7 1715user4 wait/synch/rwlock/sql/LOCK_grant 1 1716execute dump_waits_account; 1717user host event_name count_star 1718user1 localhost wait/io/file/sql/query_log 8 1719user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 1720user2 localhost wait/io/file/sql/query_log 8 1721user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 1722user3 localhost wait/io/file/sql/query_log 7 1723user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 1724user4 localhost wait/io/file/sql/query_log 7 1725user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 1726execute dump_waits_user; 1727user event_name count_star 1728user1 wait/io/file/sql/query_log 8 1729user1 wait/synch/rwlock/sql/LOCK_grant 1 1730user2 wait/io/file/sql/query_log 8 1731user2 wait/synch/rwlock/sql/LOCK_grant 1 1732user3 wait/io/file/sql/query_log 7 1733user3 wait/synch/rwlock/sql/LOCK_grant 1 1734user4 wait/io/file/sql/query_log 7 1735user4 wait/synch/rwlock/sql/LOCK_grant 1 1736execute dump_waits_host; 1737host event_name count_star 1738localhost wait/io/file/sql/query_log 30 1739localhost wait/synch/rwlock/sql/LOCK_grant 4 1740execute dump_waits_global; 1741event_name count_star 1742wait/io/file/sql/query_log 30 1743wait/synch/rwlock/sql/LOCK_grant 4 1744execute dump_waits_history; 1745event_name count(event_name) 1746wait/io/file/sql/query_log 30 1747wait/synch/rwlock/sql/LOCK_grant 4 1748execute dump_stages_account; 1749user host event_name count_star 1750user1 localhost stage/sql/checking permissions 4 1751user1 localhost stage/sql/closing tables 11 1752user1 localhost stage/sql/init 3 1753user1 localhost stage/sql/Opening tables 7 1754user1 localhost stage/sql/starting 7 1755user2 localhost stage/sql/checking permissions 4 1756user2 localhost stage/sql/closing tables 10 1757user2 localhost stage/sql/init 3 1758user2 localhost stage/sql/Opening tables 6 1759user2 localhost stage/sql/starting 7 1760user3 localhost stage/sql/checking permissions 4 1761user3 localhost stage/sql/closing tables 10 1762user3 localhost stage/sql/init 3 1763user3 localhost stage/sql/Opening tables 6 1764user3 localhost stage/sql/starting 6 1765user4 localhost stage/sql/checking permissions 4 1766user4 localhost stage/sql/closing tables 10 1767user4 localhost stage/sql/init 3 1768user4 localhost stage/sql/Opening tables 6 1769user4 localhost stage/sql/starting 6 1770execute dump_stages_user; 1771user event_name count_star 1772user1 stage/sql/checking permissions 4 1773user1 stage/sql/closing tables 11 1774user1 stage/sql/init 3 1775user1 stage/sql/Opening tables 7 1776user1 stage/sql/starting 7 1777user2 stage/sql/checking permissions 4 1778user2 stage/sql/closing tables 10 1779user2 stage/sql/init 3 1780user2 stage/sql/Opening tables 6 1781user2 stage/sql/starting 7 1782user3 stage/sql/checking permissions 4 1783user3 stage/sql/closing tables 10 1784user3 stage/sql/init 3 1785user3 stage/sql/Opening tables 6 1786user3 stage/sql/starting 6 1787user4 stage/sql/checking permissions 4 1788user4 stage/sql/closing tables 10 1789user4 stage/sql/init 3 1790user4 stage/sql/Opening tables 6 1791user4 stage/sql/starting 6 1792execute dump_stages_host; 1793host event_name count_star 1794localhost stage/sql/checking permissions 16 1795localhost stage/sql/closing tables 41 1796localhost stage/sql/init 12 1797localhost stage/sql/Opening tables 25 1798localhost stage/sql/starting 26 1799execute dump_stages_global; 1800event_name count_star 1801stage/sql/checking permissions 16 1802stage/sql/closing tables 41 1803stage/sql/init 12 1804stage/sql/Opening tables 25 1805stage/sql/starting 26 1806execute dump_stages_history; 1807event_name count(event_name) 1808stage/sql/checking permissions 16 1809stage/sql/closing tables 41 1810stage/sql/init 12 1811stage/sql/Opening tables 25 1812stage/sql/starting 26 1813execute dump_statements_account; 1814user host event_name count_star 1815user1 localhost statement/com/Error 0 1816user1 localhost statement/com/Quit 1 1817user1 localhost statement/sp/freturn 1 1818user1 localhost statement/sql/insert 1 1819user1 localhost statement/sql/select 3 1820user2 localhost statement/com/Error 0 1821user2 localhost statement/com/Quit 1 1822user2 localhost statement/sp/freturn 1 1823user2 localhost statement/sql/insert 1 1824user2 localhost statement/sql/select 3 1825user3 localhost statement/com/Error 0 1826user3 localhost statement/com/Quit 0 1827user3 localhost statement/sp/freturn 1 1828user3 localhost statement/sql/insert 1 1829user3 localhost statement/sql/select 3 1830user4 localhost statement/com/Error 0 1831user4 localhost statement/com/Quit 0 1832user4 localhost statement/sp/freturn 1 1833user4 localhost statement/sql/insert 1 1834user4 localhost statement/sql/select 3 1835execute dump_statements_user; 1836user event_name count_star 1837user1 statement/com/Error 0 1838user1 statement/com/Quit 1 1839user1 statement/sp/freturn 1 1840user1 statement/sql/insert 1 1841user1 statement/sql/select 3 1842user2 statement/com/Error 0 1843user2 statement/com/Quit 1 1844user2 statement/sp/freturn 1 1845user2 statement/sql/insert 1 1846user2 statement/sql/select 3 1847user3 statement/com/Error 0 1848user3 statement/com/Quit 0 1849user3 statement/sp/freturn 1 1850user3 statement/sql/insert 1 1851user3 statement/sql/select 3 1852user4 statement/com/Error 0 1853user4 statement/com/Quit 0 1854user4 statement/sp/freturn 1 1855user4 statement/sql/insert 1 1856user4 statement/sql/select 3 1857execute dump_statements_host; 1858host event_name count_star 1859localhost statement/com/Error 0 1860localhost statement/com/Quit 2 1861localhost statement/sp/freturn 4 1862localhost statement/sql/insert 4 1863localhost statement/sql/select 12 1864execute dump_statements_global; 1865event_name count_star 1866statement/com/Error 0 1867statement/com/Quit 2 1868statement/sp/freturn 4 1869statement/sql/insert 4 1870statement/sql/select 12 1871execute dump_statements_history; 1872event_name count(event_name) 1873statement/com/Quit 2 1874statement/sp/freturn 4 1875statement/sql/insert 4 1876statement/sql/select 12 1877execute dump_transactions_account; 1878user host event_name count_star 1879user1 localhost transaction 2 1880user2 localhost transaction 2 1881user3 localhost transaction 2 1882user4 localhost transaction 2 1883execute dump_transactions_user; 1884user event_name count_star 1885user1 transaction 2 1886user2 transaction 2 1887user3 transaction 2 1888user4 transaction 2 1889execute dump_transactions_host; 1890host event_name count_star 1891localhost transaction 8 1892execute dump_transactions_global; 1893event_name count_star 1894transaction 8 1895execute dump_transactions_history; 1896event_name count(event_name) 1897transaction 8 1898execute dump_accounts; 1899USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1900root localhost 1 1 1901user1 localhost 0 1 1902user2 localhost 0 1 1903user3 localhost 1 1 1904user4 localhost 1 1 1905execute dump_users; 1906USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1907root 1 1 1908user1 0 1 1909user2 0 1 1910user3 1 1 1911user4 1 1 1912execute dump_hosts; 1913HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1914localhost 3 5 1915disconnect con3; 1916connection default; 1917"================== Step 12 ==================" 1918call dump_thread(); 1919username status 1920user1 not found 1921username status 1922user2 not found 1923username status 1924user3 not found 1925username event_name count_star 1926user4 wait/io/file/sql/query_log 7 1927user4 wait/synch/rwlock/sql/LOCK_grant 1 1928execute dump_waits_account; 1929user host event_name count_star 1930user1 localhost wait/io/file/sql/query_log 8 1931user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 1932user2 localhost wait/io/file/sql/query_log 8 1933user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 1934user3 localhost wait/io/file/sql/query_log 8 1935user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 1936user4 localhost wait/io/file/sql/query_log 7 1937user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 1938execute dump_waits_user; 1939user event_name count_star 1940user1 wait/io/file/sql/query_log 8 1941user1 wait/synch/rwlock/sql/LOCK_grant 1 1942user2 wait/io/file/sql/query_log 8 1943user2 wait/synch/rwlock/sql/LOCK_grant 1 1944user3 wait/io/file/sql/query_log 8 1945user3 wait/synch/rwlock/sql/LOCK_grant 1 1946user4 wait/io/file/sql/query_log 7 1947user4 wait/synch/rwlock/sql/LOCK_grant 1 1948execute dump_waits_host; 1949host event_name count_star 1950localhost wait/io/file/sql/query_log 31 1951localhost wait/synch/rwlock/sql/LOCK_grant 4 1952execute dump_waits_global; 1953event_name count_star 1954wait/io/file/sql/query_log 31 1955wait/synch/rwlock/sql/LOCK_grant 4 1956execute dump_waits_history; 1957event_name count(event_name) 1958wait/io/file/sql/query_log 31 1959wait/synch/rwlock/sql/LOCK_grant 4 1960execute dump_stages_account; 1961user host event_name count_star 1962user1 localhost stage/sql/checking permissions 4 1963user1 localhost stage/sql/closing tables 11 1964user1 localhost stage/sql/init 3 1965user1 localhost stage/sql/Opening tables 7 1966user1 localhost stage/sql/starting 7 1967user2 localhost stage/sql/checking permissions 4 1968user2 localhost stage/sql/closing tables 10 1969user2 localhost stage/sql/init 3 1970user2 localhost stage/sql/Opening tables 6 1971user2 localhost stage/sql/starting 7 1972user3 localhost stage/sql/checking permissions 4 1973user3 localhost stage/sql/closing tables 10 1974user3 localhost stage/sql/init 3 1975user3 localhost stage/sql/Opening tables 6 1976user3 localhost stage/sql/starting 7 1977user4 localhost stage/sql/checking permissions 4 1978user4 localhost stage/sql/closing tables 10 1979user4 localhost stage/sql/init 3 1980user4 localhost stage/sql/Opening tables 6 1981user4 localhost stage/sql/starting 6 1982execute dump_stages_user; 1983user event_name count_star 1984user1 stage/sql/checking permissions 4 1985user1 stage/sql/closing tables 11 1986user1 stage/sql/init 3 1987user1 stage/sql/Opening tables 7 1988user1 stage/sql/starting 7 1989user2 stage/sql/checking permissions 4 1990user2 stage/sql/closing tables 10 1991user2 stage/sql/init 3 1992user2 stage/sql/Opening tables 6 1993user2 stage/sql/starting 7 1994user3 stage/sql/checking permissions 4 1995user3 stage/sql/closing tables 10 1996user3 stage/sql/init 3 1997user3 stage/sql/Opening tables 6 1998user3 stage/sql/starting 7 1999user4 stage/sql/checking permissions 4 2000user4 stage/sql/closing tables 10 2001user4 stage/sql/init 3 2002user4 stage/sql/Opening tables 6 2003user4 stage/sql/starting 6 2004execute dump_stages_host; 2005host event_name count_star 2006localhost stage/sql/checking permissions 16 2007localhost stage/sql/closing tables 41 2008localhost stage/sql/init 12 2009localhost stage/sql/Opening tables 25 2010localhost stage/sql/starting 27 2011execute dump_stages_global; 2012event_name count_star 2013stage/sql/checking permissions 16 2014stage/sql/closing tables 41 2015stage/sql/init 12 2016stage/sql/Opening tables 25 2017stage/sql/starting 27 2018execute dump_stages_history; 2019event_name count(event_name) 2020stage/sql/checking permissions 16 2021stage/sql/closing tables 41 2022stage/sql/init 12 2023stage/sql/Opening tables 25 2024stage/sql/starting 27 2025execute dump_statements_account; 2026user host event_name count_star 2027user1 localhost statement/com/Error 0 2028user1 localhost statement/com/Quit 1 2029user1 localhost statement/sp/freturn 1 2030user1 localhost statement/sql/insert 1 2031user1 localhost statement/sql/select 3 2032user2 localhost statement/com/Error 0 2033user2 localhost statement/com/Quit 1 2034user2 localhost statement/sp/freturn 1 2035user2 localhost statement/sql/insert 1 2036user2 localhost statement/sql/select 3 2037user3 localhost statement/com/Error 0 2038user3 localhost statement/com/Quit 1 2039user3 localhost statement/sp/freturn 1 2040user3 localhost statement/sql/insert 1 2041user3 localhost statement/sql/select 3 2042user4 localhost statement/com/Error 0 2043user4 localhost statement/com/Quit 0 2044user4 localhost statement/sp/freturn 1 2045user4 localhost statement/sql/insert 1 2046user4 localhost statement/sql/select 3 2047execute dump_statements_user; 2048user event_name count_star 2049user1 statement/com/Error 0 2050user1 statement/com/Quit 1 2051user1 statement/sp/freturn 1 2052user1 statement/sql/insert 1 2053user1 statement/sql/select 3 2054user2 statement/com/Error 0 2055user2 statement/com/Quit 1 2056user2 statement/sp/freturn 1 2057user2 statement/sql/insert 1 2058user2 statement/sql/select 3 2059user3 statement/com/Error 0 2060user3 statement/com/Quit 1 2061user3 statement/sp/freturn 1 2062user3 statement/sql/insert 1 2063user3 statement/sql/select 3 2064user4 statement/com/Error 0 2065user4 statement/com/Quit 0 2066user4 statement/sp/freturn 1 2067user4 statement/sql/insert 1 2068user4 statement/sql/select 3 2069execute dump_statements_host; 2070host event_name count_star 2071localhost statement/com/Error 0 2072localhost statement/com/Quit 3 2073localhost statement/sp/freturn 4 2074localhost statement/sql/insert 4 2075localhost statement/sql/select 12 2076execute dump_statements_global; 2077event_name count_star 2078statement/com/Error 0 2079statement/com/Quit 3 2080statement/sp/freturn 4 2081statement/sql/insert 4 2082statement/sql/select 12 2083execute dump_statements_history; 2084event_name count(event_name) 2085statement/com/Quit 3 2086statement/sp/freturn 4 2087statement/sql/insert 4 2088statement/sql/select 12 2089execute dump_transactions_account; 2090user host event_name count_star 2091user1 localhost transaction 2 2092user2 localhost transaction 2 2093user3 localhost transaction 2 2094user4 localhost transaction 2 2095execute dump_transactions_user; 2096user event_name count_star 2097user1 transaction 2 2098user2 transaction 2 2099user3 transaction 2 2100user4 transaction 2 2101execute dump_transactions_host; 2102host event_name count_star 2103localhost transaction 8 2104execute dump_transactions_global; 2105event_name count_star 2106transaction 8 2107execute dump_transactions_history; 2108event_name count(event_name) 2109transaction 8 2110execute dump_accounts; 2111USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2112root localhost 1 1 2113user1 localhost 0 1 2114user2 localhost 0 1 2115user3 localhost 0 1 2116user4 localhost 1 1 2117execute dump_users; 2118USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2119root 1 1 2120user1 0 1 2121user2 0 1 2122user3 0 1 2123user4 1 1 2124execute dump_hosts; 2125HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2126localhost 2 5 2127disconnect con4; 2128connection default; 2129"================== Step 13 ==================" 2130call dump_thread(); 2131username status 2132user1 not found 2133username status 2134user2 not found 2135username status 2136user3 not found 2137username status 2138user4 not found 2139execute dump_waits_account; 2140user host event_name count_star 2141user1 localhost wait/io/file/sql/query_log 8 2142user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 2143user2 localhost wait/io/file/sql/query_log 8 2144user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 2145user3 localhost wait/io/file/sql/query_log 8 2146user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 2147user4 localhost wait/io/file/sql/query_log 8 2148user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 2149execute dump_waits_user; 2150user event_name count_star 2151user1 wait/io/file/sql/query_log 8 2152user1 wait/synch/rwlock/sql/LOCK_grant 1 2153user2 wait/io/file/sql/query_log 8 2154user2 wait/synch/rwlock/sql/LOCK_grant 1 2155user3 wait/io/file/sql/query_log 8 2156user3 wait/synch/rwlock/sql/LOCK_grant 1 2157user4 wait/io/file/sql/query_log 8 2158user4 wait/synch/rwlock/sql/LOCK_grant 1 2159execute dump_waits_host; 2160host event_name count_star 2161localhost wait/io/file/sql/query_log 32 2162localhost wait/synch/rwlock/sql/LOCK_grant 4 2163execute dump_waits_global; 2164event_name count_star 2165wait/io/file/sql/query_log 32 2166wait/synch/rwlock/sql/LOCK_grant 4 2167execute dump_waits_history; 2168event_name count(event_name) 2169wait/io/file/sql/query_log 32 2170wait/synch/rwlock/sql/LOCK_grant 4 2171execute dump_stages_account; 2172user host event_name count_star 2173user1 localhost stage/sql/checking permissions 4 2174user1 localhost stage/sql/closing tables 11 2175user1 localhost stage/sql/init 3 2176user1 localhost stage/sql/Opening tables 7 2177user1 localhost stage/sql/starting 7 2178user2 localhost stage/sql/checking permissions 4 2179user2 localhost stage/sql/closing tables 10 2180user2 localhost stage/sql/init 3 2181user2 localhost stage/sql/Opening tables 6 2182user2 localhost stage/sql/starting 7 2183user3 localhost stage/sql/checking permissions 4 2184user3 localhost stage/sql/closing tables 10 2185user3 localhost stage/sql/init 3 2186user3 localhost stage/sql/Opening tables 6 2187user3 localhost stage/sql/starting 7 2188user4 localhost stage/sql/checking permissions 4 2189user4 localhost stage/sql/closing tables 10 2190user4 localhost stage/sql/init 3 2191user4 localhost stage/sql/Opening tables 6 2192user4 localhost stage/sql/starting 7 2193execute dump_stages_user; 2194user event_name count_star 2195user1 stage/sql/checking permissions 4 2196user1 stage/sql/closing tables 11 2197user1 stage/sql/init 3 2198user1 stage/sql/Opening tables 7 2199user1 stage/sql/starting 7 2200user2 stage/sql/checking permissions 4 2201user2 stage/sql/closing tables 10 2202user2 stage/sql/init 3 2203user2 stage/sql/Opening tables 6 2204user2 stage/sql/starting 7 2205user3 stage/sql/checking permissions 4 2206user3 stage/sql/closing tables 10 2207user3 stage/sql/init 3 2208user3 stage/sql/Opening tables 6 2209user3 stage/sql/starting 7 2210user4 stage/sql/checking permissions 4 2211user4 stage/sql/closing tables 10 2212user4 stage/sql/init 3 2213user4 stage/sql/Opening tables 6 2214user4 stage/sql/starting 7 2215execute dump_stages_host; 2216host event_name count_star 2217localhost stage/sql/checking permissions 16 2218localhost stage/sql/closing tables 41 2219localhost stage/sql/init 12 2220localhost stage/sql/Opening tables 25 2221localhost stage/sql/starting 28 2222execute dump_stages_global; 2223event_name count_star 2224stage/sql/checking permissions 16 2225stage/sql/closing tables 41 2226stage/sql/init 12 2227stage/sql/Opening tables 25 2228stage/sql/starting 28 2229execute dump_stages_history; 2230event_name count(event_name) 2231stage/sql/checking permissions 16 2232stage/sql/closing tables 41 2233stage/sql/init 12 2234stage/sql/Opening tables 25 2235stage/sql/starting 28 2236execute dump_statements_account; 2237user host event_name count_star 2238user1 localhost statement/com/Error 0 2239user1 localhost statement/com/Quit 1 2240user1 localhost statement/sp/freturn 1 2241user1 localhost statement/sql/insert 1 2242user1 localhost statement/sql/select 3 2243user2 localhost statement/com/Error 0 2244user2 localhost statement/com/Quit 1 2245user2 localhost statement/sp/freturn 1 2246user2 localhost statement/sql/insert 1 2247user2 localhost statement/sql/select 3 2248user3 localhost statement/com/Error 0 2249user3 localhost statement/com/Quit 1 2250user3 localhost statement/sp/freturn 1 2251user3 localhost statement/sql/insert 1 2252user3 localhost statement/sql/select 3 2253user4 localhost statement/com/Error 0 2254user4 localhost statement/com/Quit 1 2255user4 localhost statement/sp/freturn 1 2256user4 localhost statement/sql/insert 1 2257user4 localhost statement/sql/select 3 2258execute dump_statements_user; 2259user event_name count_star 2260user1 statement/com/Error 0 2261user1 statement/com/Quit 1 2262user1 statement/sp/freturn 1 2263user1 statement/sql/insert 1 2264user1 statement/sql/select 3 2265user2 statement/com/Error 0 2266user2 statement/com/Quit 1 2267user2 statement/sp/freturn 1 2268user2 statement/sql/insert 1 2269user2 statement/sql/select 3 2270user3 statement/com/Error 0 2271user3 statement/com/Quit 1 2272user3 statement/sp/freturn 1 2273user3 statement/sql/insert 1 2274user3 statement/sql/select 3 2275user4 statement/com/Error 0 2276user4 statement/com/Quit 1 2277user4 statement/sp/freturn 1 2278user4 statement/sql/insert 1 2279user4 statement/sql/select 3 2280execute dump_statements_host; 2281host event_name count_star 2282localhost statement/com/Error 0 2283localhost statement/com/Quit 4 2284localhost statement/sp/freturn 4 2285localhost statement/sql/insert 4 2286localhost statement/sql/select 12 2287execute dump_statements_global; 2288event_name count_star 2289statement/com/Error 0 2290statement/com/Quit 4 2291statement/sp/freturn 4 2292statement/sql/insert 4 2293statement/sql/select 12 2294execute dump_statements_history; 2295event_name count(event_name) 2296statement/com/Quit 4 2297statement/sp/freturn 4 2298statement/sql/insert 4 2299statement/sql/select 12 2300execute dump_transactions_account; 2301user host event_name count_star 2302user1 localhost transaction 2 2303user2 localhost transaction 2 2304user3 localhost transaction 2 2305user4 localhost transaction 2 2306execute dump_transactions_user; 2307user event_name count_star 2308user1 transaction 2 2309user2 transaction 2 2310user3 transaction 2 2311user4 transaction 2 2312execute dump_transactions_host; 2313host event_name count_star 2314localhost transaction 8 2315execute dump_transactions_global; 2316event_name count_star 2317transaction 8 2318execute dump_transactions_history; 2319event_name count(event_name) 2320transaction 8 2321execute dump_accounts; 2322USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2323root localhost 1 1 2324user1 localhost 0 1 2325user2 localhost 0 1 2326user3 localhost 0 1 2327user4 localhost 0 1 2328execute dump_users; 2329USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2330root 1 1 2331user1 0 1 2332user2 0 1 2333user3 0 1 2334user4 0 1 2335execute dump_hosts; 2336HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2337localhost 1 5 2338connection default; 2339truncate performance_schema.events_waits_summary_by_thread_by_event_name; 2340"================== WAITS_BY_THREAD truncated ==================" 2341"================== Step 14 ==================" 2342call dump_thread(); 2343username status 2344user1 not found 2345username status 2346user2 not found 2347username status 2348user3 not found 2349username status 2350user4 not found 2351execute dump_waits_account; 2352user host event_name count_star 2353user1 localhost wait/io/file/sql/query_log 8 2354user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 2355user2 localhost wait/io/file/sql/query_log 8 2356user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 2357user3 localhost wait/io/file/sql/query_log 8 2358user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 2359user4 localhost wait/io/file/sql/query_log 8 2360user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 2361execute dump_waits_user; 2362user event_name count_star 2363user1 wait/io/file/sql/query_log 8 2364user1 wait/synch/rwlock/sql/LOCK_grant 1 2365user2 wait/io/file/sql/query_log 8 2366user2 wait/synch/rwlock/sql/LOCK_grant 1 2367user3 wait/io/file/sql/query_log 8 2368user3 wait/synch/rwlock/sql/LOCK_grant 1 2369user4 wait/io/file/sql/query_log 8 2370user4 wait/synch/rwlock/sql/LOCK_grant 1 2371execute dump_waits_host; 2372host event_name count_star 2373localhost wait/io/file/sql/query_log 32 2374localhost wait/synch/rwlock/sql/LOCK_grant 4 2375execute dump_waits_global; 2376event_name count_star 2377wait/io/file/sql/query_log 32 2378wait/synch/rwlock/sql/LOCK_grant 4 2379execute dump_waits_history; 2380event_name count(event_name) 2381wait/io/file/sql/query_log 32 2382wait/synch/rwlock/sql/LOCK_grant 4 2383execute dump_stages_account; 2384user host event_name count_star 2385user1 localhost stage/sql/checking permissions 4 2386user1 localhost stage/sql/closing tables 11 2387user1 localhost stage/sql/init 3 2388user1 localhost stage/sql/Opening tables 7 2389user1 localhost stage/sql/starting 7 2390user2 localhost stage/sql/checking permissions 4 2391user2 localhost stage/sql/closing tables 10 2392user2 localhost stage/sql/init 3 2393user2 localhost stage/sql/Opening tables 6 2394user2 localhost stage/sql/starting 7 2395user3 localhost stage/sql/checking permissions 4 2396user3 localhost stage/sql/closing tables 10 2397user3 localhost stage/sql/init 3 2398user3 localhost stage/sql/Opening tables 6 2399user3 localhost stage/sql/starting 7 2400user4 localhost stage/sql/checking permissions 4 2401user4 localhost stage/sql/closing tables 10 2402user4 localhost stage/sql/init 3 2403user4 localhost stage/sql/Opening tables 6 2404user4 localhost stage/sql/starting 7 2405execute dump_stages_user; 2406user event_name count_star 2407user1 stage/sql/checking permissions 4 2408user1 stage/sql/closing tables 11 2409user1 stage/sql/init 3 2410user1 stage/sql/Opening tables 7 2411user1 stage/sql/starting 7 2412user2 stage/sql/checking permissions 4 2413user2 stage/sql/closing tables 10 2414user2 stage/sql/init 3 2415user2 stage/sql/Opening tables 6 2416user2 stage/sql/starting 7 2417user3 stage/sql/checking permissions 4 2418user3 stage/sql/closing tables 10 2419user3 stage/sql/init 3 2420user3 stage/sql/Opening tables 6 2421user3 stage/sql/starting 7 2422user4 stage/sql/checking permissions 4 2423user4 stage/sql/closing tables 10 2424user4 stage/sql/init 3 2425user4 stage/sql/Opening tables 6 2426user4 stage/sql/starting 7 2427execute dump_stages_host; 2428host event_name count_star 2429localhost stage/sql/checking permissions 16 2430localhost stage/sql/closing tables 41 2431localhost stage/sql/init 12 2432localhost stage/sql/Opening tables 25 2433localhost stage/sql/starting 28 2434execute dump_stages_global; 2435event_name count_star 2436stage/sql/checking permissions 16 2437stage/sql/closing tables 41 2438stage/sql/init 12 2439stage/sql/Opening tables 25 2440stage/sql/starting 28 2441execute dump_stages_history; 2442event_name count(event_name) 2443stage/sql/checking permissions 16 2444stage/sql/closing tables 41 2445stage/sql/init 12 2446stage/sql/Opening tables 25 2447stage/sql/starting 28 2448execute dump_statements_account; 2449user host event_name count_star 2450user1 localhost statement/com/Error 0 2451user1 localhost statement/com/Quit 1 2452user1 localhost statement/sp/freturn 1 2453user1 localhost statement/sql/insert 1 2454user1 localhost statement/sql/select 3 2455user2 localhost statement/com/Error 0 2456user2 localhost statement/com/Quit 1 2457user2 localhost statement/sp/freturn 1 2458user2 localhost statement/sql/insert 1 2459user2 localhost statement/sql/select 3 2460user3 localhost statement/com/Error 0 2461user3 localhost statement/com/Quit 1 2462user3 localhost statement/sp/freturn 1 2463user3 localhost statement/sql/insert 1 2464user3 localhost statement/sql/select 3 2465user4 localhost statement/com/Error 0 2466user4 localhost statement/com/Quit 1 2467user4 localhost statement/sp/freturn 1 2468user4 localhost statement/sql/insert 1 2469user4 localhost statement/sql/select 3 2470execute dump_statements_user; 2471user event_name count_star 2472user1 statement/com/Error 0 2473user1 statement/com/Quit 1 2474user1 statement/sp/freturn 1 2475user1 statement/sql/insert 1 2476user1 statement/sql/select 3 2477user2 statement/com/Error 0 2478user2 statement/com/Quit 1 2479user2 statement/sp/freturn 1 2480user2 statement/sql/insert 1 2481user2 statement/sql/select 3 2482user3 statement/com/Error 0 2483user3 statement/com/Quit 1 2484user3 statement/sp/freturn 1 2485user3 statement/sql/insert 1 2486user3 statement/sql/select 3 2487user4 statement/com/Error 0 2488user4 statement/com/Quit 1 2489user4 statement/sp/freturn 1 2490user4 statement/sql/insert 1 2491user4 statement/sql/select 3 2492execute dump_statements_host; 2493host event_name count_star 2494localhost statement/com/Error 0 2495localhost statement/com/Quit 4 2496localhost statement/sp/freturn 4 2497localhost statement/sql/insert 4 2498localhost statement/sql/select 12 2499execute dump_statements_global; 2500event_name count_star 2501statement/com/Error 0 2502statement/com/Quit 4 2503statement/sp/freturn 4 2504statement/sql/insert 4 2505statement/sql/select 12 2506execute dump_statements_history; 2507event_name count(event_name) 2508statement/com/Quit 4 2509statement/sp/freturn 4 2510statement/sql/insert 4 2511statement/sql/select 12 2512execute dump_transactions_account; 2513user host event_name count_star 2514user1 localhost transaction 2 2515user2 localhost transaction 2 2516user3 localhost transaction 2 2517user4 localhost transaction 2 2518execute dump_transactions_user; 2519user event_name count_star 2520user1 transaction 2 2521user2 transaction 2 2522user3 transaction 2 2523user4 transaction 2 2524execute dump_transactions_host; 2525host event_name count_star 2526localhost transaction 8 2527execute dump_transactions_global; 2528event_name count_star 2529transaction 8 2530execute dump_transactions_history; 2531event_name count(event_name) 2532transaction 8 2533execute dump_accounts; 2534USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2535root localhost 1 1 2536user1 localhost 0 1 2537user2 localhost 0 1 2538user3 localhost 0 1 2539user4 localhost 0 1 2540execute dump_users; 2541USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2542root 1 1 2543user1 0 1 2544user2 0 1 2545user3 0 1 2546user4 0 1 2547execute dump_hosts; 2548HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2549localhost 1 5 2550truncate performance_schema.events_waits_summary_by_account_by_event_name; 2551"================== WAITS_BY_ACCOUNT truncated ==================" 2552"================== Step 15 ==================" 2553call dump_thread(); 2554username status 2555user1 not found 2556username status 2557user2 not found 2558username status 2559user3 not found 2560username status 2561user4 not found 2562execute dump_waits_account; 2563user host event_name count_star 2564user1 localhost wait/io/file/sql/query_log 0 2565user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2566user2 localhost wait/io/file/sql/query_log 0 2567user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2568user3 localhost wait/io/file/sql/query_log 0 2569user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2570user4 localhost wait/io/file/sql/query_log 0 2571user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2572execute dump_waits_user; 2573user event_name count_star 2574user1 wait/io/file/sql/query_log 8 2575user1 wait/synch/rwlock/sql/LOCK_grant 1 2576user2 wait/io/file/sql/query_log 8 2577user2 wait/synch/rwlock/sql/LOCK_grant 1 2578user3 wait/io/file/sql/query_log 8 2579user3 wait/synch/rwlock/sql/LOCK_grant 1 2580user4 wait/io/file/sql/query_log 8 2581user4 wait/synch/rwlock/sql/LOCK_grant 1 2582execute dump_waits_host; 2583host event_name count_star 2584localhost wait/io/file/sql/query_log 32 2585localhost wait/synch/rwlock/sql/LOCK_grant 4 2586execute dump_waits_global; 2587event_name count_star 2588wait/io/file/sql/query_log 32 2589wait/synch/rwlock/sql/LOCK_grant 4 2590execute dump_waits_history; 2591event_name count(event_name) 2592wait/io/file/sql/query_log 32 2593wait/synch/rwlock/sql/LOCK_grant 4 2594execute dump_stages_account; 2595user host event_name count_star 2596user1 localhost stage/sql/checking permissions 4 2597user1 localhost stage/sql/closing tables 11 2598user1 localhost stage/sql/init 3 2599user1 localhost stage/sql/Opening tables 7 2600user1 localhost stage/sql/starting 7 2601user2 localhost stage/sql/checking permissions 4 2602user2 localhost stage/sql/closing tables 10 2603user2 localhost stage/sql/init 3 2604user2 localhost stage/sql/Opening tables 6 2605user2 localhost stage/sql/starting 7 2606user3 localhost stage/sql/checking permissions 4 2607user3 localhost stage/sql/closing tables 10 2608user3 localhost stage/sql/init 3 2609user3 localhost stage/sql/Opening tables 6 2610user3 localhost stage/sql/starting 7 2611user4 localhost stage/sql/checking permissions 4 2612user4 localhost stage/sql/closing tables 10 2613user4 localhost stage/sql/init 3 2614user4 localhost stage/sql/Opening tables 6 2615user4 localhost stage/sql/starting 7 2616execute dump_stages_user; 2617user event_name count_star 2618user1 stage/sql/checking permissions 4 2619user1 stage/sql/closing tables 11 2620user1 stage/sql/init 3 2621user1 stage/sql/Opening tables 7 2622user1 stage/sql/starting 7 2623user2 stage/sql/checking permissions 4 2624user2 stage/sql/closing tables 10 2625user2 stage/sql/init 3 2626user2 stage/sql/Opening tables 6 2627user2 stage/sql/starting 7 2628user3 stage/sql/checking permissions 4 2629user3 stage/sql/closing tables 10 2630user3 stage/sql/init 3 2631user3 stage/sql/Opening tables 6 2632user3 stage/sql/starting 7 2633user4 stage/sql/checking permissions 4 2634user4 stage/sql/closing tables 10 2635user4 stage/sql/init 3 2636user4 stage/sql/Opening tables 6 2637user4 stage/sql/starting 7 2638execute dump_stages_host; 2639host event_name count_star 2640localhost stage/sql/checking permissions 16 2641localhost stage/sql/closing tables 41 2642localhost stage/sql/init 12 2643localhost stage/sql/Opening tables 25 2644localhost stage/sql/starting 28 2645execute dump_stages_global; 2646event_name count_star 2647stage/sql/checking permissions 16 2648stage/sql/closing tables 41 2649stage/sql/init 12 2650stage/sql/Opening tables 25 2651stage/sql/starting 28 2652execute dump_stages_history; 2653event_name count(event_name) 2654stage/sql/checking permissions 16 2655stage/sql/closing tables 41 2656stage/sql/init 12 2657stage/sql/Opening tables 25 2658stage/sql/starting 28 2659execute dump_statements_account; 2660user host event_name count_star 2661user1 localhost statement/com/Error 0 2662user1 localhost statement/com/Quit 1 2663user1 localhost statement/sp/freturn 1 2664user1 localhost statement/sql/insert 1 2665user1 localhost statement/sql/select 3 2666user2 localhost statement/com/Error 0 2667user2 localhost statement/com/Quit 1 2668user2 localhost statement/sp/freturn 1 2669user2 localhost statement/sql/insert 1 2670user2 localhost statement/sql/select 3 2671user3 localhost statement/com/Error 0 2672user3 localhost statement/com/Quit 1 2673user3 localhost statement/sp/freturn 1 2674user3 localhost statement/sql/insert 1 2675user3 localhost statement/sql/select 3 2676user4 localhost statement/com/Error 0 2677user4 localhost statement/com/Quit 1 2678user4 localhost statement/sp/freturn 1 2679user4 localhost statement/sql/insert 1 2680user4 localhost statement/sql/select 3 2681execute dump_statements_user; 2682user event_name count_star 2683user1 statement/com/Error 0 2684user1 statement/com/Quit 1 2685user1 statement/sp/freturn 1 2686user1 statement/sql/insert 1 2687user1 statement/sql/select 3 2688user2 statement/com/Error 0 2689user2 statement/com/Quit 1 2690user2 statement/sp/freturn 1 2691user2 statement/sql/insert 1 2692user2 statement/sql/select 3 2693user3 statement/com/Error 0 2694user3 statement/com/Quit 1 2695user3 statement/sp/freturn 1 2696user3 statement/sql/insert 1 2697user3 statement/sql/select 3 2698user4 statement/com/Error 0 2699user4 statement/com/Quit 1 2700user4 statement/sp/freturn 1 2701user4 statement/sql/insert 1 2702user4 statement/sql/select 3 2703execute dump_statements_host; 2704host event_name count_star 2705localhost statement/com/Error 0 2706localhost statement/com/Quit 4 2707localhost statement/sp/freturn 4 2708localhost statement/sql/insert 4 2709localhost statement/sql/select 12 2710execute dump_statements_global; 2711event_name count_star 2712statement/com/Error 0 2713statement/com/Quit 4 2714statement/sp/freturn 4 2715statement/sql/insert 4 2716statement/sql/select 12 2717execute dump_statements_history; 2718event_name count(event_name) 2719statement/com/Quit 4 2720statement/sp/freturn 4 2721statement/sql/insert 4 2722statement/sql/select 12 2723execute dump_transactions_account; 2724user host event_name count_star 2725user1 localhost transaction 2 2726user2 localhost transaction 2 2727user3 localhost transaction 2 2728user4 localhost transaction 2 2729execute dump_transactions_user; 2730user event_name count_star 2731user1 transaction 2 2732user2 transaction 2 2733user3 transaction 2 2734user4 transaction 2 2735execute dump_transactions_host; 2736host event_name count_star 2737localhost transaction 8 2738execute dump_transactions_global; 2739event_name count_star 2740transaction 8 2741execute dump_transactions_history; 2742event_name count(event_name) 2743transaction 8 2744execute dump_accounts; 2745USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2746root localhost 1 1 2747user1 localhost 0 1 2748user2 localhost 0 1 2749user3 localhost 0 1 2750user4 localhost 0 1 2751execute dump_users; 2752USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2753root 1 1 2754user1 0 1 2755user2 0 1 2756user3 0 1 2757user4 0 1 2758execute dump_hosts; 2759HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2760localhost 1 5 2761truncate performance_schema.events_waits_summary_by_user_by_event_name; 2762"================== WAITS_BY_USER truncated ==================" 2763"================== Step 16 ==================" 2764call dump_thread(); 2765username status 2766user1 not found 2767username status 2768user2 not found 2769username status 2770user3 not found 2771username status 2772user4 not found 2773execute dump_waits_account; 2774user host event_name count_star 2775user1 localhost wait/io/file/sql/query_log 0 2776user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2777user2 localhost wait/io/file/sql/query_log 0 2778user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2779user3 localhost wait/io/file/sql/query_log 0 2780user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2781user4 localhost wait/io/file/sql/query_log 0 2782user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2783execute dump_waits_user; 2784user event_name count_star 2785user1 wait/io/file/sql/query_log 0 2786user1 wait/synch/rwlock/sql/LOCK_grant 0 2787user2 wait/io/file/sql/query_log 0 2788user2 wait/synch/rwlock/sql/LOCK_grant 0 2789user3 wait/io/file/sql/query_log 0 2790user3 wait/synch/rwlock/sql/LOCK_grant 0 2791user4 wait/io/file/sql/query_log 0 2792user4 wait/synch/rwlock/sql/LOCK_grant 0 2793execute dump_waits_host; 2794host event_name count_star 2795localhost wait/io/file/sql/query_log 32 2796localhost wait/synch/rwlock/sql/LOCK_grant 4 2797execute dump_waits_global; 2798event_name count_star 2799wait/io/file/sql/query_log 32 2800wait/synch/rwlock/sql/LOCK_grant 4 2801execute dump_waits_history; 2802event_name count(event_name) 2803wait/io/file/sql/query_log 32 2804wait/synch/rwlock/sql/LOCK_grant 4 2805execute dump_stages_account; 2806user host event_name count_star 2807user1 localhost stage/sql/checking permissions 4 2808user1 localhost stage/sql/closing tables 11 2809user1 localhost stage/sql/init 3 2810user1 localhost stage/sql/Opening tables 7 2811user1 localhost stage/sql/starting 7 2812user2 localhost stage/sql/checking permissions 4 2813user2 localhost stage/sql/closing tables 10 2814user2 localhost stage/sql/init 3 2815user2 localhost stage/sql/Opening tables 6 2816user2 localhost stage/sql/starting 7 2817user3 localhost stage/sql/checking permissions 4 2818user3 localhost stage/sql/closing tables 10 2819user3 localhost stage/sql/init 3 2820user3 localhost stage/sql/Opening tables 6 2821user3 localhost stage/sql/starting 7 2822user4 localhost stage/sql/checking permissions 4 2823user4 localhost stage/sql/closing tables 10 2824user4 localhost stage/sql/init 3 2825user4 localhost stage/sql/Opening tables 6 2826user4 localhost stage/sql/starting 7 2827execute dump_stages_user; 2828user event_name count_star 2829user1 stage/sql/checking permissions 4 2830user1 stage/sql/closing tables 11 2831user1 stage/sql/init 3 2832user1 stage/sql/Opening tables 7 2833user1 stage/sql/starting 7 2834user2 stage/sql/checking permissions 4 2835user2 stage/sql/closing tables 10 2836user2 stage/sql/init 3 2837user2 stage/sql/Opening tables 6 2838user2 stage/sql/starting 7 2839user3 stage/sql/checking permissions 4 2840user3 stage/sql/closing tables 10 2841user3 stage/sql/init 3 2842user3 stage/sql/Opening tables 6 2843user3 stage/sql/starting 7 2844user4 stage/sql/checking permissions 4 2845user4 stage/sql/closing tables 10 2846user4 stage/sql/init 3 2847user4 stage/sql/Opening tables 6 2848user4 stage/sql/starting 7 2849execute dump_stages_host; 2850host event_name count_star 2851localhost stage/sql/checking permissions 16 2852localhost stage/sql/closing tables 41 2853localhost stage/sql/init 12 2854localhost stage/sql/Opening tables 25 2855localhost stage/sql/starting 28 2856execute dump_stages_global; 2857event_name count_star 2858stage/sql/checking permissions 16 2859stage/sql/closing tables 41 2860stage/sql/init 12 2861stage/sql/Opening tables 25 2862stage/sql/starting 28 2863execute dump_stages_history; 2864event_name count(event_name) 2865stage/sql/checking permissions 16 2866stage/sql/closing tables 41 2867stage/sql/init 12 2868stage/sql/Opening tables 25 2869stage/sql/starting 28 2870execute dump_statements_account; 2871user host event_name count_star 2872user1 localhost statement/com/Error 0 2873user1 localhost statement/com/Quit 1 2874user1 localhost statement/sp/freturn 1 2875user1 localhost statement/sql/insert 1 2876user1 localhost statement/sql/select 3 2877user2 localhost statement/com/Error 0 2878user2 localhost statement/com/Quit 1 2879user2 localhost statement/sp/freturn 1 2880user2 localhost statement/sql/insert 1 2881user2 localhost statement/sql/select 3 2882user3 localhost statement/com/Error 0 2883user3 localhost statement/com/Quit 1 2884user3 localhost statement/sp/freturn 1 2885user3 localhost statement/sql/insert 1 2886user3 localhost statement/sql/select 3 2887user4 localhost statement/com/Error 0 2888user4 localhost statement/com/Quit 1 2889user4 localhost statement/sp/freturn 1 2890user4 localhost statement/sql/insert 1 2891user4 localhost statement/sql/select 3 2892execute dump_statements_user; 2893user event_name count_star 2894user1 statement/com/Error 0 2895user1 statement/com/Quit 1 2896user1 statement/sp/freturn 1 2897user1 statement/sql/insert 1 2898user1 statement/sql/select 3 2899user2 statement/com/Error 0 2900user2 statement/com/Quit 1 2901user2 statement/sp/freturn 1 2902user2 statement/sql/insert 1 2903user2 statement/sql/select 3 2904user3 statement/com/Error 0 2905user3 statement/com/Quit 1 2906user3 statement/sp/freturn 1 2907user3 statement/sql/insert 1 2908user3 statement/sql/select 3 2909user4 statement/com/Error 0 2910user4 statement/com/Quit 1 2911user4 statement/sp/freturn 1 2912user4 statement/sql/insert 1 2913user4 statement/sql/select 3 2914execute dump_statements_host; 2915host event_name count_star 2916localhost statement/com/Error 0 2917localhost statement/com/Quit 4 2918localhost statement/sp/freturn 4 2919localhost statement/sql/insert 4 2920localhost statement/sql/select 12 2921execute dump_statements_global; 2922event_name count_star 2923statement/com/Error 0 2924statement/com/Quit 4 2925statement/sp/freturn 4 2926statement/sql/insert 4 2927statement/sql/select 12 2928execute dump_statements_history; 2929event_name count(event_name) 2930statement/com/Quit 4 2931statement/sp/freturn 4 2932statement/sql/insert 4 2933statement/sql/select 12 2934execute dump_transactions_account; 2935user host event_name count_star 2936user1 localhost transaction 2 2937user2 localhost transaction 2 2938user3 localhost transaction 2 2939user4 localhost transaction 2 2940execute dump_transactions_user; 2941user event_name count_star 2942user1 transaction 2 2943user2 transaction 2 2944user3 transaction 2 2945user4 transaction 2 2946execute dump_transactions_host; 2947host event_name count_star 2948localhost transaction 8 2949execute dump_transactions_global; 2950event_name count_star 2951transaction 8 2952execute dump_transactions_history; 2953event_name count(event_name) 2954transaction 8 2955execute dump_accounts; 2956USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2957root localhost 1 1 2958user1 localhost 0 1 2959user2 localhost 0 1 2960user3 localhost 0 1 2961user4 localhost 0 1 2962execute dump_users; 2963USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2964root 1 1 2965user1 0 1 2966user2 0 1 2967user3 0 1 2968user4 0 1 2969execute dump_hosts; 2970HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2971localhost 1 5 2972truncate performance_schema.events_waits_summary_by_host_by_event_name; 2973"================== WAITS_BY_HOST truncated ==================" 2974"================== Step 17 ==================" 2975call dump_thread(); 2976username status 2977user1 not found 2978username status 2979user2 not found 2980username status 2981user3 not found 2982username status 2983user4 not found 2984execute dump_waits_account; 2985user host event_name count_star 2986user1 localhost wait/io/file/sql/query_log 0 2987user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2988user2 localhost wait/io/file/sql/query_log 0 2989user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2990user3 localhost wait/io/file/sql/query_log 0 2991user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2992user4 localhost wait/io/file/sql/query_log 0 2993user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2994execute dump_waits_user; 2995user event_name count_star 2996user1 wait/io/file/sql/query_log 0 2997user1 wait/synch/rwlock/sql/LOCK_grant 0 2998user2 wait/io/file/sql/query_log 0 2999user2 wait/synch/rwlock/sql/LOCK_grant 0 3000user3 wait/io/file/sql/query_log 0 3001user3 wait/synch/rwlock/sql/LOCK_grant 0 3002user4 wait/io/file/sql/query_log 0 3003user4 wait/synch/rwlock/sql/LOCK_grant 0 3004execute dump_waits_host; 3005host event_name count_star 3006localhost wait/io/file/sql/query_log 0 3007localhost wait/synch/rwlock/sql/LOCK_grant 0 3008execute dump_waits_global; 3009event_name count_star 3010wait/io/file/sql/query_log 32 3011wait/synch/rwlock/sql/LOCK_grant 4 3012execute dump_waits_history; 3013event_name count(event_name) 3014wait/io/file/sql/query_log 32 3015wait/synch/rwlock/sql/LOCK_grant 4 3016execute dump_stages_account; 3017user host event_name count_star 3018user1 localhost stage/sql/checking permissions 4 3019user1 localhost stage/sql/closing tables 11 3020user1 localhost stage/sql/init 3 3021user1 localhost stage/sql/Opening tables 7 3022user1 localhost stage/sql/starting 7 3023user2 localhost stage/sql/checking permissions 4 3024user2 localhost stage/sql/closing tables 10 3025user2 localhost stage/sql/init 3 3026user2 localhost stage/sql/Opening tables 6 3027user2 localhost stage/sql/starting 7 3028user3 localhost stage/sql/checking permissions 4 3029user3 localhost stage/sql/closing tables 10 3030user3 localhost stage/sql/init 3 3031user3 localhost stage/sql/Opening tables 6 3032user3 localhost stage/sql/starting 7 3033user4 localhost stage/sql/checking permissions 4 3034user4 localhost stage/sql/closing tables 10 3035user4 localhost stage/sql/init 3 3036user4 localhost stage/sql/Opening tables 6 3037user4 localhost stage/sql/starting 7 3038execute dump_stages_user; 3039user event_name count_star 3040user1 stage/sql/checking permissions 4 3041user1 stage/sql/closing tables 11 3042user1 stage/sql/init 3 3043user1 stage/sql/Opening tables 7 3044user1 stage/sql/starting 7 3045user2 stage/sql/checking permissions 4 3046user2 stage/sql/closing tables 10 3047user2 stage/sql/init 3 3048user2 stage/sql/Opening tables 6 3049user2 stage/sql/starting 7 3050user3 stage/sql/checking permissions 4 3051user3 stage/sql/closing tables 10 3052user3 stage/sql/init 3 3053user3 stage/sql/Opening tables 6 3054user3 stage/sql/starting 7 3055user4 stage/sql/checking permissions 4 3056user4 stage/sql/closing tables 10 3057user4 stage/sql/init 3 3058user4 stage/sql/Opening tables 6 3059user4 stage/sql/starting 7 3060execute dump_stages_host; 3061host event_name count_star 3062localhost stage/sql/checking permissions 16 3063localhost stage/sql/closing tables 41 3064localhost stage/sql/init 12 3065localhost stage/sql/Opening tables 25 3066localhost stage/sql/starting 28 3067execute dump_stages_global; 3068event_name count_star 3069stage/sql/checking permissions 16 3070stage/sql/closing tables 41 3071stage/sql/init 12 3072stage/sql/Opening tables 25 3073stage/sql/starting 28 3074execute dump_stages_history; 3075event_name count(event_name) 3076stage/sql/checking permissions 16 3077stage/sql/closing tables 41 3078stage/sql/init 12 3079stage/sql/Opening tables 25 3080stage/sql/starting 28 3081execute dump_statements_account; 3082user host event_name count_star 3083user1 localhost statement/com/Error 0 3084user1 localhost statement/com/Quit 1 3085user1 localhost statement/sp/freturn 1 3086user1 localhost statement/sql/insert 1 3087user1 localhost statement/sql/select 3 3088user2 localhost statement/com/Error 0 3089user2 localhost statement/com/Quit 1 3090user2 localhost statement/sp/freturn 1 3091user2 localhost statement/sql/insert 1 3092user2 localhost statement/sql/select 3 3093user3 localhost statement/com/Error 0 3094user3 localhost statement/com/Quit 1 3095user3 localhost statement/sp/freturn 1 3096user3 localhost statement/sql/insert 1 3097user3 localhost statement/sql/select 3 3098user4 localhost statement/com/Error 0 3099user4 localhost statement/com/Quit 1 3100user4 localhost statement/sp/freturn 1 3101user4 localhost statement/sql/insert 1 3102user4 localhost statement/sql/select 3 3103execute dump_statements_user; 3104user event_name count_star 3105user1 statement/com/Error 0 3106user1 statement/com/Quit 1 3107user1 statement/sp/freturn 1 3108user1 statement/sql/insert 1 3109user1 statement/sql/select 3 3110user2 statement/com/Error 0 3111user2 statement/com/Quit 1 3112user2 statement/sp/freturn 1 3113user2 statement/sql/insert 1 3114user2 statement/sql/select 3 3115user3 statement/com/Error 0 3116user3 statement/com/Quit 1 3117user3 statement/sp/freturn 1 3118user3 statement/sql/insert 1 3119user3 statement/sql/select 3 3120user4 statement/com/Error 0 3121user4 statement/com/Quit 1 3122user4 statement/sp/freturn 1 3123user4 statement/sql/insert 1 3124user4 statement/sql/select 3 3125execute dump_statements_host; 3126host event_name count_star 3127localhost statement/com/Error 0 3128localhost statement/com/Quit 4 3129localhost statement/sp/freturn 4 3130localhost statement/sql/insert 4 3131localhost statement/sql/select 12 3132execute dump_statements_global; 3133event_name count_star 3134statement/com/Error 0 3135statement/com/Quit 4 3136statement/sp/freturn 4 3137statement/sql/insert 4 3138statement/sql/select 12 3139execute dump_statements_history; 3140event_name count(event_name) 3141statement/com/Quit 4 3142statement/sp/freturn 4 3143statement/sql/insert 4 3144statement/sql/select 12 3145execute dump_transactions_account; 3146user host event_name count_star 3147user1 localhost transaction 2 3148user2 localhost transaction 2 3149user3 localhost transaction 2 3150user4 localhost transaction 2 3151execute dump_transactions_user; 3152user event_name count_star 3153user1 transaction 2 3154user2 transaction 2 3155user3 transaction 2 3156user4 transaction 2 3157execute dump_transactions_host; 3158host event_name count_star 3159localhost transaction 8 3160execute dump_transactions_global; 3161event_name count_star 3162transaction 8 3163execute dump_transactions_history; 3164event_name count(event_name) 3165transaction 8 3166execute dump_accounts; 3167USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3168root localhost 1 1 3169user1 localhost 0 1 3170user2 localhost 0 1 3171user3 localhost 0 1 3172user4 localhost 0 1 3173execute dump_users; 3174USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3175root 1 1 3176user1 0 1 3177user2 0 1 3178user3 0 1 3179user4 0 1 3180execute dump_hosts; 3181HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3182localhost 1 5 3183truncate performance_schema.events_waits_summary_global_by_event_name; 3184"================== WAITS_GLOBAL truncated ==================" 3185"================== Step 18 ==================" 3186call dump_thread(); 3187username status 3188user1 not found 3189username status 3190user2 not found 3191username status 3192user3 not found 3193username status 3194user4 not found 3195execute dump_waits_account; 3196user host event_name count_star 3197user1 localhost wait/io/file/sql/query_log 0 3198user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3199user2 localhost wait/io/file/sql/query_log 0 3200user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3201user3 localhost wait/io/file/sql/query_log 0 3202user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3203user4 localhost wait/io/file/sql/query_log 0 3204user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3205execute dump_waits_user; 3206user event_name count_star 3207user1 wait/io/file/sql/query_log 0 3208user1 wait/synch/rwlock/sql/LOCK_grant 0 3209user2 wait/io/file/sql/query_log 0 3210user2 wait/synch/rwlock/sql/LOCK_grant 0 3211user3 wait/io/file/sql/query_log 0 3212user3 wait/synch/rwlock/sql/LOCK_grant 0 3213user4 wait/io/file/sql/query_log 0 3214user4 wait/synch/rwlock/sql/LOCK_grant 0 3215execute dump_waits_host; 3216host event_name count_star 3217localhost wait/io/file/sql/query_log 0 3218localhost wait/synch/rwlock/sql/LOCK_grant 0 3219execute dump_waits_global; 3220event_name count_star 3221wait/io/file/sql/query_log 0 3222wait/synch/rwlock/sql/LOCK_grant 0 3223execute dump_waits_history; 3224event_name count(event_name) 3225wait/io/file/sql/query_log 32 3226wait/synch/rwlock/sql/LOCK_grant 4 3227execute dump_stages_account; 3228user host event_name count_star 3229user1 localhost stage/sql/checking permissions 4 3230user1 localhost stage/sql/closing tables 11 3231user1 localhost stage/sql/init 3 3232user1 localhost stage/sql/Opening tables 7 3233user1 localhost stage/sql/starting 7 3234user2 localhost stage/sql/checking permissions 4 3235user2 localhost stage/sql/closing tables 10 3236user2 localhost stage/sql/init 3 3237user2 localhost stage/sql/Opening tables 6 3238user2 localhost stage/sql/starting 7 3239user3 localhost stage/sql/checking permissions 4 3240user3 localhost stage/sql/closing tables 10 3241user3 localhost stage/sql/init 3 3242user3 localhost stage/sql/Opening tables 6 3243user3 localhost stage/sql/starting 7 3244user4 localhost stage/sql/checking permissions 4 3245user4 localhost stage/sql/closing tables 10 3246user4 localhost stage/sql/init 3 3247user4 localhost stage/sql/Opening tables 6 3248user4 localhost stage/sql/starting 7 3249execute dump_stages_user; 3250user event_name count_star 3251user1 stage/sql/checking permissions 4 3252user1 stage/sql/closing tables 11 3253user1 stage/sql/init 3 3254user1 stage/sql/Opening tables 7 3255user1 stage/sql/starting 7 3256user2 stage/sql/checking permissions 4 3257user2 stage/sql/closing tables 10 3258user2 stage/sql/init 3 3259user2 stage/sql/Opening tables 6 3260user2 stage/sql/starting 7 3261user3 stage/sql/checking permissions 4 3262user3 stage/sql/closing tables 10 3263user3 stage/sql/init 3 3264user3 stage/sql/Opening tables 6 3265user3 stage/sql/starting 7 3266user4 stage/sql/checking permissions 4 3267user4 stage/sql/closing tables 10 3268user4 stage/sql/init 3 3269user4 stage/sql/Opening tables 6 3270user4 stage/sql/starting 7 3271execute dump_stages_host; 3272host event_name count_star 3273localhost stage/sql/checking permissions 16 3274localhost stage/sql/closing tables 41 3275localhost stage/sql/init 12 3276localhost stage/sql/Opening tables 25 3277localhost stage/sql/starting 28 3278execute dump_stages_global; 3279event_name count_star 3280stage/sql/checking permissions 16 3281stage/sql/closing tables 41 3282stage/sql/init 12 3283stage/sql/Opening tables 25 3284stage/sql/starting 28 3285execute dump_stages_history; 3286event_name count(event_name) 3287stage/sql/checking permissions 16 3288stage/sql/closing tables 41 3289stage/sql/init 12 3290stage/sql/Opening tables 25 3291stage/sql/starting 28 3292execute dump_statements_account; 3293user host event_name count_star 3294user1 localhost statement/com/Error 0 3295user1 localhost statement/com/Quit 1 3296user1 localhost statement/sp/freturn 1 3297user1 localhost statement/sql/insert 1 3298user1 localhost statement/sql/select 3 3299user2 localhost statement/com/Error 0 3300user2 localhost statement/com/Quit 1 3301user2 localhost statement/sp/freturn 1 3302user2 localhost statement/sql/insert 1 3303user2 localhost statement/sql/select 3 3304user3 localhost statement/com/Error 0 3305user3 localhost statement/com/Quit 1 3306user3 localhost statement/sp/freturn 1 3307user3 localhost statement/sql/insert 1 3308user3 localhost statement/sql/select 3 3309user4 localhost statement/com/Error 0 3310user4 localhost statement/com/Quit 1 3311user4 localhost statement/sp/freturn 1 3312user4 localhost statement/sql/insert 1 3313user4 localhost statement/sql/select 3 3314execute dump_statements_user; 3315user event_name count_star 3316user1 statement/com/Error 0 3317user1 statement/com/Quit 1 3318user1 statement/sp/freturn 1 3319user1 statement/sql/insert 1 3320user1 statement/sql/select 3 3321user2 statement/com/Error 0 3322user2 statement/com/Quit 1 3323user2 statement/sp/freturn 1 3324user2 statement/sql/insert 1 3325user2 statement/sql/select 3 3326user3 statement/com/Error 0 3327user3 statement/com/Quit 1 3328user3 statement/sp/freturn 1 3329user3 statement/sql/insert 1 3330user3 statement/sql/select 3 3331user4 statement/com/Error 0 3332user4 statement/com/Quit 1 3333user4 statement/sp/freturn 1 3334user4 statement/sql/insert 1 3335user4 statement/sql/select 3 3336execute dump_statements_host; 3337host event_name count_star 3338localhost statement/com/Error 0 3339localhost statement/com/Quit 4 3340localhost statement/sp/freturn 4 3341localhost statement/sql/insert 4 3342localhost statement/sql/select 12 3343execute dump_statements_global; 3344event_name count_star 3345statement/com/Error 0 3346statement/com/Quit 4 3347statement/sp/freturn 4 3348statement/sql/insert 4 3349statement/sql/select 12 3350execute dump_statements_history; 3351event_name count(event_name) 3352statement/com/Quit 4 3353statement/sp/freturn 4 3354statement/sql/insert 4 3355statement/sql/select 12 3356execute dump_transactions_account; 3357user host event_name count_star 3358user1 localhost transaction 2 3359user2 localhost transaction 2 3360user3 localhost transaction 2 3361user4 localhost transaction 2 3362execute dump_transactions_user; 3363user event_name count_star 3364user1 transaction 2 3365user2 transaction 2 3366user3 transaction 2 3367user4 transaction 2 3368execute dump_transactions_host; 3369host event_name count_star 3370localhost transaction 8 3371execute dump_transactions_global; 3372event_name count_star 3373transaction 8 3374execute dump_transactions_history; 3375event_name count(event_name) 3376transaction 8 3377execute dump_accounts; 3378USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3379root localhost 1 1 3380user1 localhost 0 1 3381user2 localhost 0 1 3382user3 localhost 0 1 3383user4 localhost 0 1 3384execute dump_users; 3385USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3386root 1 1 3387user1 0 1 3388user2 0 1 3389user3 0 1 3390user4 0 1 3391execute dump_hosts; 3392HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3393localhost 1 5 3394truncate performance_schema.events_stages_summary_by_thread_by_event_name; 3395"================== STAGES_BY_THREAD truncated ==================" 3396"================== Step 19 ==================" 3397call dump_thread(); 3398username status 3399user1 not found 3400username status 3401user2 not found 3402username status 3403user3 not found 3404username status 3405user4 not found 3406execute dump_waits_account; 3407user host event_name count_star 3408user1 localhost wait/io/file/sql/query_log 0 3409user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3410user2 localhost wait/io/file/sql/query_log 0 3411user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3412user3 localhost wait/io/file/sql/query_log 0 3413user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3414user4 localhost wait/io/file/sql/query_log 0 3415user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3416execute dump_waits_user; 3417user event_name count_star 3418user1 wait/io/file/sql/query_log 0 3419user1 wait/synch/rwlock/sql/LOCK_grant 0 3420user2 wait/io/file/sql/query_log 0 3421user2 wait/synch/rwlock/sql/LOCK_grant 0 3422user3 wait/io/file/sql/query_log 0 3423user3 wait/synch/rwlock/sql/LOCK_grant 0 3424user4 wait/io/file/sql/query_log 0 3425user4 wait/synch/rwlock/sql/LOCK_grant 0 3426execute dump_waits_host; 3427host event_name count_star 3428localhost wait/io/file/sql/query_log 0 3429localhost wait/synch/rwlock/sql/LOCK_grant 0 3430execute dump_waits_global; 3431event_name count_star 3432wait/io/file/sql/query_log 0 3433wait/synch/rwlock/sql/LOCK_grant 0 3434execute dump_waits_history; 3435event_name count(event_name) 3436wait/io/file/sql/query_log 32 3437wait/synch/rwlock/sql/LOCK_grant 4 3438execute dump_stages_account; 3439user host event_name count_star 3440user1 localhost stage/sql/checking permissions 4 3441user1 localhost stage/sql/closing tables 11 3442user1 localhost stage/sql/init 3 3443user1 localhost stage/sql/Opening tables 7 3444user1 localhost stage/sql/starting 7 3445user2 localhost stage/sql/checking permissions 4 3446user2 localhost stage/sql/closing tables 10 3447user2 localhost stage/sql/init 3 3448user2 localhost stage/sql/Opening tables 6 3449user2 localhost stage/sql/starting 7 3450user3 localhost stage/sql/checking permissions 4 3451user3 localhost stage/sql/closing tables 10 3452user3 localhost stage/sql/init 3 3453user3 localhost stage/sql/Opening tables 6 3454user3 localhost stage/sql/starting 7 3455user4 localhost stage/sql/checking permissions 4 3456user4 localhost stage/sql/closing tables 10 3457user4 localhost stage/sql/init 3 3458user4 localhost stage/sql/Opening tables 6 3459user4 localhost stage/sql/starting 7 3460execute dump_stages_user; 3461user event_name count_star 3462user1 stage/sql/checking permissions 4 3463user1 stage/sql/closing tables 11 3464user1 stage/sql/init 3 3465user1 stage/sql/Opening tables 7 3466user1 stage/sql/starting 7 3467user2 stage/sql/checking permissions 4 3468user2 stage/sql/closing tables 10 3469user2 stage/sql/init 3 3470user2 stage/sql/Opening tables 6 3471user2 stage/sql/starting 7 3472user3 stage/sql/checking permissions 4 3473user3 stage/sql/closing tables 10 3474user3 stage/sql/init 3 3475user3 stage/sql/Opening tables 6 3476user3 stage/sql/starting 7 3477user4 stage/sql/checking permissions 4 3478user4 stage/sql/closing tables 10 3479user4 stage/sql/init 3 3480user4 stage/sql/Opening tables 6 3481user4 stage/sql/starting 7 3482execute dump_stages_host; 3483host event_name count_star 3484localhost stage/sql/checking permissions 16 3485localhost stage/sql/closing tables 41 3486localhost stage/sql/init 12 3487localhost stage/sql/Opening tables 25 3488localhost stage/sql/starting 28 3489execute dump_stages_global; 3490event_name count_star 3491stage/sql/checking permissions 16 3492stage/sql/closing tables 41 3493stage/sql/init 12 3494stage/sql/Opening tables 25 3495stage/sql/starting 28 3496execute dump_stages_history; 3497event_name count(event_name) 3498stage/sql/checking permissions 16 3499stage/sql/closing tables 41 3500stage/sql/init 12 3501stage/sql/Opening tables 25 3502stage/sql/starting 28 3503execute dump_statements_account; 3504user host event_name count_star 3505user1 localhost statement/com/Error 0 3506user1 localhost statement/com/Quit 1 3507user1 localhost statement/sp/freturn 1 3508user1 localhost statement/sql/insert 1 3509user1 localhost statement/sql/select 3 3510user2 localhost statement/com/Error 0 3511user2 localhost statement/com/Quit 1 3512user2 localhost statement/sp/freturn 1 3513user2 localhost statement/sql/insert 1 3514user2 localhost statement/sql/select 3 3515user3 localhost statement/com/Error 0 3516user3 localhost statement/com/Quit 1 3517user3 localhost statement/sp/freturn 1 3518user3 localhost statement/sql/insert 1 3519user3 localhost statement/sql/select 3 3520user4 localhost statement/com/Error 0 3521user4 localhost statement/com/Quit 1 3522user4 localhost statement/sp/freturn 1 3523user4 localhost statement/sql/insert 1 3524user4 localhost statement/sql/select 3 3525execute dump_statements_user; 3526user event_name count_star 3527user1 statement/com/Error 0 3528user1 statement/com/Quit 1 3529user1 statement/sp/freturn 1 3530user1 statement/sql/insert 1 3531user1 statement/sql/select 3 3532user2 statement/com/Error 0 3533user2 statement/com/Quit 1 3534user2 statement/sp/freturn 1 3535user2 statement/sql/insert 1 3536user2 statement/sql/select 3 3537user3 statement/com/Error 0 3538user3 statement/com/Quit 1 3539user3 statement/sp/freturn 1 3540user3 statement/sql/insert 1 3541user3 statement/sql/select 3 3542user4 statement/com/Error 0 3543user4 statement/com/Quit 1 3544user4 statement/sp/freturn 1 3545user4 statement/sql/insert 1 3546user4 statement/sql/select 3 3547execute dump_statements_host; 3548host event_name count_star 3549localhost statement/com/Error 0 3550localhost statement/com/Quit 4 3551localhost statement/sp/freturn 4 3552localhost statement/sql/insert 4 3553localhost statement/sql/select 12 3554execute dump_statements_global; 3555event_name count_star 3556statement/com/Error 0 3557statement/com/Quit 4 3558statement/sp/freturn 4 3559statement/sql/insert 4 3560statement/sql/select 12 3561execute dump_statements_history; 3562event_name count(event_name) 3563statement/com/Quit 4 3564statement/sp/freturn 4 3565statement/sql/insert 4 3566statement/sql/select 12 3567execute dump_transactions_account; 3568user host event_name count_star 3569user1 localhost transaction 2 3570user2 localhost transaction 2 3571user3 localhost transaction 2 3572user4 localhost transaction 2 3573execute dump_transactions_user; 3574user event_name count_star 3575user1 transaction 2 3576user2 transaction 2 3577user3 transaction 2 3578user4 transaction 2 3579execute dump_transactions_host; 3580host event_name count_star 3581localhost transaction 8 3582execute dump_transactions_global; 3583event_name count_star 3584transaction 8 3585execute dump_transactions_history; 3586event_name count(event_name) 3587transaction 8 3588execute dump_accounts; 3589USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3590root localhost 1 1 3591user1 localhost 0 1 3592user2 localhost 0 1 3593user3 localhost 0 1 3594user4 localhost 0 1 3595execute dump_users; 3596USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3597root 1 1 3598user1 0 1 3599user2 0 1 3600user3 0 1 3601user4 0 1 3602execute dump_hosts; 3603HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3604localhost 1 5 3605truncate performance_schema.events_stages_summary_by_account_by_event_name; 3606"================== STAGES_BY_ACCOUNT truncated ==================" 3607"================== Step 20 ==================" 3608call dump_thread(); 3609username status 3610user1 not found 3611username status 3612user2 not found 3613username status 3614user3 not found 3615username status 3616user4 not found 3617execute dump_waits_account; 3618user host event_name count_star 3619user1 localhost wait/io/file/sql/query_log 0 3620user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3621user2 localhost wait/io/file/sql/query_log 0 3622user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3623user3 localhost wait/io/file/sql/query_log 0 3624user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3625user4 localhost wait/io/file/sql/query_log 0 3626user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3627execute dump_waits_user; 3628user event_name count_star 3629user1 wait/io/file/sql/query_log 0 3630user1 wait/synch/rwlock/sql/LOCK_grant 0 3631user2 wait/io/file/sql/query_log 0 3632user2 wait/synch/rwlock/sql/LOCK_grant 0 3633user3 wait/io/file/sql/query_log 0 3634user3 wait/synch/rwlock/sql/LOCK_grant 0 3635user4 wait/io/file/sql/query_log 0 3636user4 wait/synch/rwlock/sql/LOCK_grant 0 3637execute dump_waits_host; 3638host event_name count_star 3639localhost wait/io/file/sql/query_log 0 3640localhost wait/synch/rwlock/sql/LOCK_grant 0 3641execute dump_waits_global; 3642event_name count_star 3643wait/io/file/sql/query_log 0 3644wait/synch/rwlock/sql/LOCK_grant 0 3645execute dump_waits_history; 3646event_name count(event_name) 3647wait/io/file/sql/query_log 32 3648wait/synch/rwlock/sql/LOCK_grant 4 3649execute dump_stages_account; 3650user host event_name count_star 3651user1 localhost stage/sql/checking permissions 0 3652user1 localhost stage/sql/closing tables 0 3653user1 localhost stage/sql/init 0 3654user1 localhost stage/sql/Opening tables 0 3655user1 localhost stage/sql/starting 0 3656user2 localhost stage/sql/checking permissions 0 3657user2 localhost stage/sql/closing tables 0 3658user2 localhost stage/sql/init 0 3659user2 localhost stage/sql/Opening tables 0 3660user2 localhost stage/sql/starting 0 3661user3 localhost stage/sql/checking permissions 0 3662user3 localhost stage/sql/closing tables 0 3663user3 localhost stage/sql/init 0 3664user3 localhost stage/sql/Opening tables 0 3665user3 localhost stage/sql/starting 0 3666user4 localhost stage/sql/checking permissions 0 3667user4 localhost stage/sql/closing tables 0 3668user4 localhost stage/sql/init 0 3669user4 localhost stage/sql/Opening tables 0 3670user4 localhost stage/sql/starting 0 3671execute dump_stages_user; 3672user event_name count_star 3673user1 stage/sql/checking permissions 4 3674user1 stage/sql/closing tables 11 3675user1 stage/sql/init 3 3676user1 stage/sql/Opening tables 7 3677user1 stage/sql/starting 7 3678user2 stage/sql/checking permissions 4 3679user2 stage/sql/closing tables 10 3680user2 stage/sql/init 3 3681user2 stage/sql/Opening tables 6 3682user2 stage/sql/starting 7 3683user3 stage/sql/checking permissions 4 3684user3 stage/sql/closing tables 10 3685user3 stage/sql/init 3 3686user3 stage/sql/Opening tables 6 3687user3 stage/sql/starting 7 3688user4 stage/sql/checking permissions 4 3689user4 stage/sql/closing tables 10 3690user4 stage/sql/init 3 3691user4 stage/sql/Opening tables 6 3692user4 stage/sql/starting 7 3693execute dump_stages_host; 3694host event_name count_star 3695localhost stage/sql/checking permissions 16 3696localhost stage/sql/closing tables 41 3697localhost stage/sql/init 12 3698localhost stage/sql/Opening tables 25 3699localhost stage/sql/starting 28 3700execute dump_stages_global; 3701event_name count_star 3702stage/sql/checking permissions 16 3703stage/sql/closing tables 41 3704stage/sql/init 12 3705stage/sql/Opening tables 25 3706stage/sql/starting 28 3707execute dump_stages_history; 3708event_name count(event_name) 3709stage/sql/checking permissions 16 3710stage/sql/closing tables 41 3711stage/sql/init 12 3712stage/sql/Opening tables 25 3713stage/sql/starting 28 3714execute dump_statements_account; 3715user host event_name count_star 3716user1 localhost statement/com/Error 0 3717user1 localhost statement/com/Quit 1 3718user1 localhost statement/sp/freturn 1 3719user1 localhost statement/sql/insert 1 3720user1 localhost statement/sql/select 3 3721user2 localhost statement/com/Error 0 3722user2 localhost statement/com/Quit 1 3723user2 localhost statement/sp/freturn 1 3724user2 localhost statement/sql/insert 1 3725user2 localhost statement/sql/select 3 3726user3 localhost statement/com/Error 0 3727user3 localhost statement/com/Quit 1 3728user3 localhost statement/sp/freturn 1 3729user3 localhost statement/sql/insert 1 3730user3 localhost statement/sql/select 3 3731user4 localhost statement/com/Error 0 3732user4 localhost statement/com/Quit 1 3733user4 localhost statement/sp/freturn 1 3734user4 localhost statement/sql/insert 1 3735user4 localhost statement/sql/select 3 3736execute dump_statements_user; 3737user event_name count_star 3738user1 statement/com/Error 0 3739user1 statement/com/Quit 1 3740user1 statement/sp/freturn 1 3741user1 statement/sql/insert 1 3742user1 statement/sql/select 3 3743user2 statement/com/Error 0 3744user2 statement/com/Quit 1 3745user2 statement/sp/freturn 1 3746user2 statement/sql/insert 1 3747user2 statement/sql/select 3 3748user3 statement/com/Error 0 3749user3 statement/com/Quit 1 3750user3 statement/sp/freturn 1 3751user3 statement/sql/insert 1 3752user3 statement/sql/select 3 3753user4 statement/com/Error 0 3754user4 statement/com/Quit 1 3755user4 statement/sp/freturn 1 3756user4 statement/sql/insert 1 3757user4 statement/sql/select 3 3758execute dump_statements_host; 3759host event_name count_star 3760localhost statement/com/Error 0 3761localhost statement/com/Quit 4 3762localhost statement/sp/freturn 4 3763localhost statement/sql/insert 4 3764localhost statement/sql/select 12 3765execute dump_statements_global; 3766event_name count_star 3767statement/com/Error 0 3768statement/com/Quit 4 3769statement/sp/freturn 4 3770statement/sql/insert 4 3771statement/sql/select 12 3772execute dump_statements_history; 3773event_name count(event_name) 3774statement/com/Quit 4 3775statement/sp/freturn 4 3776statement/sql/insert 4 3777statement/sql/select 12 3778execute dump_transactions_account; 3779user host event_name count_star 3780user1 localhost transaction 2 3781user2 localhost transaction 2 3782user3 localhost transaction 2 3783user4 localhost transaction 2 3784execute dump_transactions_user; 3785user event_name count_star 3786user1 transaction 2 3787user2 transaction 2 3788user3 transaction 2 3789user4 transaction 2 3790execute dump_transactions_host; 3791host event_name count_star 3792localhost transaction 8 3793execute dump_transactions_global; 3794event_name count_star 3795transaction 8 3796execute dump_transactions_history; 3797event_name count(event_name) 3798transaction 8 3799execute dump_accounts; 3800USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3801root localhost 1 1 3802user1 localhost 0 1 3803user2 localhost 0 1 3804user3 localhost 0 1 3805user4 localhost 0 1 3806execute dump_users; 3807USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3808root 1 1 3809user1 0 1 3810user2 0 1 3811user3 0 1 3812user4 0 1 3813execute dump_hosts; 3814HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3815localhost 1 5 3816truncate performance_schema.events_stages_summary_by_user_by_event_name; 3817"================== STAGES_BY_USER truncated ==================" 3818"================== Step 21 ==================" 3819call dump_thread(); 3820username status 3821user1 not found 3822username status 3823user2 not found 3824username status 3825user3 not found 3826username status 3827user4 not found 3828execute dump_waits_account; 3829user host event_name count_star 3830user1 localhost wait/io/file/sql/query_log 0 3831user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3832user2 localhost wait/io/file/sql/query_log 0 3833user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3834user3 localhost wait/io/file/sql/query_log 0 3835user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3836user4 localhost wait/io/file/sql/query_log 0 3837user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3838execute dump_waits_user; 3839user event_name count_star 3840user1 wait/io/file/sql/query_log 0 3841user1 wait/synch/rwlock/sql/LOCK_grant 0 3842user2 wait/io/file/sql/query_log 0 3843user2 wait/synch/rwlock/sql/LOCK_grant 0 3844user3 wait/io/file/sql/query_log 0 3845user3 wait/synch/rwlock/sql/LOCK_grant 0 3846user4 wait/io/file/sql/query_log 0 3847user4 wait/synch/rwlock/sql/LOCK_grant 0 3848execute dump_waits_host; 3849host event_name count_star 3850localhost wait/io/file/sql/query_log 0 3851localhost wait/synch/rwlock/sql/LOCK_grant 0 3852execute dump_waits_global; 3853event_name count_star 3854wait/io/file/sql/query_log 0 3855wait/synch/rwlock/sql/LOCK_grant 0 3856execute dump_waits_history; 3857event_name count(event_name) 3858wait/io/file/sql/query_log 32 3859wait/synch/rwlock/sql/LOCK_grant 4 3860execute dump_stages_account; 3861user host event_name count_star 3862user1 localhost stage/sql/checking permissions 0 3863user1 localhost stage/sql/closing tables 0 3864user1 localhost stage/sql/init 0 3865user1 localhost stage/sql/Opening tables 0 3866user1 localhost stage/sql/starting 0 3867user2 localhost stage/sql/checking permissions 0 3868user2 localhost stage/sql/closing tables 0 3869user2 localhost stage/sql/init 0 3870user2 localhost stage/sql/Opening tables 0 3871user2 localhost stage/sql/starting 0 3872user3 localhost stage/sql/checking permissions 0 3873user3 localhost stage/sql/closing tables 0 3874user3 localhost stage/sql/init 0 3875user3 localhost stage/sql/Opening tables 0 3876user3 localhost stage/sql/starting 0 3877user4 localhost stage/sql/checking permissions 0 3878user4 localhost stage/sql/closing tables 0 3879user4 localhost stage/sql/init 0 3880user4 localhost stage/sql/Opening tables 0 3881user4 localhost stage/sql/starting 0 3882execute dump_stages_user; 3883user event_name count_star 3884user1 stage/sql/checking permissions 0 3885user1 stage/sql/closing tables 0 3886user1 stage/sql/init 0 3887user1 stage/sql/Opening tables 0 3888user1 stage/sql/starting 0 3889user2 stage/sql/checking permissions 0 3890user2 stage/sql/closing tables 0 3891user2 stage/sql/init 0 3892user2 stage/sql/Opening tables 0 3893user2 stage/sql/starting 0 3894user3 stage/sql/checking permissions 0 3895user3 stage/sql/closing tables 0 3896user3 stage/sql/init 0 3897user3 stage/sql/Opening tables 0 3898user3 stage/sql/starting 0 3899user4 stage/sql/checking permissions 0 3900user4 stage/sql/closing tables 0 3901user4 stage/sql/init 0 3902user4 stage/sql/Opening tables 0 3903user4 stage/sql/starting 0 3904execute dump_stages_host; 3905host event_name count_star 3906localhost stage/sql/checking permissions 16 3907localhost stage/sql/closing tables 41 3908localhost stage/sql/init 12 3909localhost stage/sql/Opening tables 25 3910localhost stage/sql/starting 28 3911execute dump_stages_global; 3912event_name count_star 3913stage/sql/checking permissions 16 3914stage/sql/closing tables 41 3915stage/sql/init 12 3916stage/sql/Opening tables 25 3917stage/sql/starting 28 3918execute dump_stages_history; 3919event_name count(event_name) 3920stage/sql/checking permissions 16 3921stage/sql/closing tables 41 3922stage/sql/init 12 3923stage/sql/Opening tables 25 3924stage/sql/starting 28 3925execute dump_statements_account; 3926user host event_name count_star 3927user1 localhost statement/com/Error 0 3928user1 localhost statement/com/Quit 1 3929user1 localhost statement/sp/freturn 1 3930user1 localhost statement/sql/insert 1 3931user1 localhost statement/sql/select 3 3932user2 localhost statement/com/Error 0 3933user2 localhost statement/com/Quit 1 3934user2 localhost statement/sp/freturn 1 3935user2 localhost statement/sql/insert 1 3936user2 localhost statement/sql/select 3 3937user3 localhost statement/com/Error 0 3938user3 localhost statement/com/Quit 1 3939user3 localhost statement/sp/freturn 1 3940user3 localhost statement/sql/insert 1 3941user3 localhost statement/sql/select 3 3942user4 localhost statement/com/Error 0 3943user4 localhost statement/com/Quit 1 3944user4 localhost statement/sp/freturn 1 3945user4 localhost statement/sql/insert 1 3946user4 localhost statement/sql/select 3 3947execute dump_statements_user; 3948user event_name count_star 3949user1 statement/com/Error 0 3950user1 statement/com/Quit 1 3951user1 statement/sp/freturn 1 3952user1 statement/sql/insert 1 3953user1 statement/sql/select 3 3954user2 statement/com/Error 0 3955user2 statement/com/Quit 1 3956user2 statement/sp/freturn 1 3957user2 statement/sql/insert 1 3958user2 statement/sql/select 3 3959user3 statement/com/Error 0 3960user3 statement/com/Quit 1 3961user3 statement/sp/freturn 1 3962user3 statement/sql/insert 1 3963user3 statement/sql/select 3 3964user4 statement/com/Error 0 3965user4 statement/com/Quit 1 3966user4 statement/sp/freturn 1 3967user4 statement/sql/insert 1 3968user4 statement/sql/select 3 3969execute dump_statements_host; 3970host event_name count_star 3971localhost statement/com/Error 0 3972localhost statement/com/Quit 4 3973localhost statement/sp/freturn 4 3974localhost statement/sql/insert 4 3975localhost statement/sql/select 12 3976execute dump_statements_global; 3977event_name count_star 3978statement/com/Error 0 3979statement/com/Quit 4 3980statement/sp/freturn 4 3981statement/sql/insert 4 3982statement/sql/select 12 3983execute dump_statements_history; 3984event_name count(event_name) 3985statement/com/Quit 4 3986statement/sp/freturn 4 3987statement/sql/insert 4 3988statement/sql/select 12 3989execute dump_transactions_account; 3990user host event_name count_star 3991user1 localhost transaction 2 3992user2 localhost transaction 2 3993user3 localhost transaction 2 3994user4 localhost transaction 2 3995execute dump_transactions_user; 3996user event_name count_star 3997user1 transaction 2 3998user2 transaction 2 3999user3 transaction 2 4000user4 transaction 2 4001execute dump_transactions_host; 4002host event_name count_star 4003localhost transaction 8 4004execute dump_transactions_global; 4005event_name count_star 4006transaction 8 4007execute dump_transactions_history; 4008event_name count(event_name) 4009transaction 8 4010execute dump_accounts; 4011USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4012root localhost 1 1 4013user1 localhost 0 1 4014user2 localhost 0 1 4015user3 localhost 0 1 4016user4 localhost 0 1 4017execute dump_users; 4018USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4019root 1 1 4020user1 0 1 4021user2 0 1 4022user3 0 1 4023user4 0 1 4024execute dump_hosts; 4025HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4026localhost 1 5 4027truncate performance_schema.events_stages_summary_by_host_by_event_name; 4028"================== STAGES_BY_HOST truncated ==================" 4029"================== Step 22 ==================" 4030call dump_thread(); 4031username status 4032user1 not found 4033username status 4034user2 not found 4035username status 4036user3 not found 4037username status 4038user4 not found 4039execute dump_waits_account; 4040user host event_name count_star 4041user1 localhost wait/io/file/sql/query_log 0 4042user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 4043user2 localhost wait/io/file/sql/query_log 0 4044user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 4045user3 localhost wait/io/file/sql/query_log 0 4046user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 4047user4 localhost wait/io/file/sql/query_log 0 4048user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 4049execute dump_waits_user; 4050user event_name count_star 4051user1 wait/io/file/sql/query_log 0 4052user1 wait/synch/rwlock/sql/LOCK_grant 0 4053user2 wait/io/file/sql/query_log 0 4054user2 wait/synch/rwlock/sql/LOCK_grant 0 4055user3 wait/io/file/sql/query_log 0 4056user3 wait/synch/rwlock/sql/LOCK_grant 0 4057user4 wait/io/file/sql/query_log 0 4058user4 wait/synch/rwlock/sql/LOCK_grant 0 4059execute dump_waits_host; 4060host event_name count_star 4061localhost wait/io/file/sql/query_log 0 4062localhost wait/synch/rwlock/sql/LOCK_grant 0 4063execute dump_waits_global; 4064event_name count_star 4065wait/io/file/sql/query_log 0 4066wait/synch/rwlock/sql/LOCK_grant 0 4067execute dump_waits_history; 4068event_name count(event_name) 4069wait/io/file/sql/query_log 32 4070wait/synch/rwlock/sql/LOCK_grant 4 4071execute dump_stages_account; 4072user host event_name count_star 4073user1 localhost stage/sql/checking permissions 0 4074user1 localhost stage/sql/closing tables 0 4075user1 localhost stage/sql/init 0 4076user1 localhost stage/sql/Opening tables 0 4077user1 localhost stage/sql/starting 0 4078user2 localhost stage/sql/checking permissions 0 4079user2 localhost stage/sql/closing tables 0 4080user2 localhost stage/sql/init 0 4081user2 localhost stage/sql/Opening tables 0 4082user2 localhost stage/sql/starting 0 4083user3 localhost stage/sql/checking permissions 0 4084user3 localhost stage/sql/closing tables 0 4085user3 localhost stage/sql/init 0 4086user3 localhost stage/sql/Opening tables 0 4087user3 localhost stage/sql/starting 0 4088user4 localhost stage/sql/checking permissions 0 4089user4 localhost stage/sql/closing tables 0 4090user4 localhost stage/sql/init 0 4091user4 localhost stage/sql/Opening tables 0 4092user4 localhost stage/sql/starting 0 4093execute dump_stages_user; 4094user event_name count_star 4095user1 stage/sql/checking permissions 0 4096user1 stage/sql/closing tables 0 4097user1 stage/sql/init 0 4098user1 stage/sql/Opening tables 0 4099user1 stage/sql/starting 0 4100user2 stage/sql/checking permissions 0 4101user2 stage/sql/closing tables 0 4102user2 stage/sql/init 0 4103user2 stage/sql/Opening tables 0 4104user2 stage/sql/starting 0 4105user3 stage/sql/checking permissions 0 4106user3 stage/sql/closing tables 0 4107user3 stage/sql/init 0 4108user3 stage/sql/Opening tables 0 4109user3 stage/sql/starting 0 4110user4 stage/sql/checking permissions 0 4111user4 stage/sql/closing tables 0 4112user4 stage/sql/init 0 4113user4 stage/sql/Opening tables 0 4114user4 stage/sql/starting 0 4115execute dump_stages_host; 4116host event_name count_star 4117localhost stage/sql/checking permissions 0 4118localhost stage/sql/closing tables 0 4119localhost stage/sql/init 0 4120localhost stage/sql/Opening tables 0 4121localhost stage/sql/starting 0 4122execute dump_stages_global; 4123event_name count_star 4124stage/sql/checking permissions 16 4125stage/sql/closing tables 41 4126stage/sql/init 12 4127stage/sql/Opening tables 25 4128stage/sql/starting 28 4129execute dump_stages_history; 4130event_name count(event_name) 4131stage/sql/checking permissions 16 4132stage/sql/closing tables 41 4133stage/sql/init 12 4134stage/sql/Opening tables 25 4135stage/sql/starting 28 4136execute dump_statements_account; 4137user host event_name count_star 4138user1 localhost statement/com/Error 0 4139user1 localhost statement/com/Quit 1 4140user1 localhost statement/sp/freturn 1 4141user1 localhost statement/sql/insert 1 4142user1 localhost statement/sql/select 3 4143user2 localhost statement/com/Error 0 4144user2 localhost statement/com/Quit 1 4145user2 localhost statement/sp/freturn 1 4146user2 localhost statement/sql/insert 1 4147user2 localhost statement/sql/select 3 4148user3 localhost statement/com/Error 0 4149user3 localhost statement/com/Quit 1 4150user3 localhost statement/sp/freturn 1 4151user3 localhost statement/sql/insert 1 4152user3 localhost statement/sql/select 3 4153user4 localhost statement/com/Error 0 4154user4 localhost statement/com/Quit 1 4155user4 localhost statement/sp/freturn 1 4156user4 localhost statement/sql/insert 1 4157user4 localhost statement/sql/select 3 4158execute dump_statements_user; 4159user event_name count_star 4160user1 statement/com/Error 0 4161user1 statement/com/Quit 1 4162user1 statement/sp/freturn 1 4163user1 statement/sql/insert 1 4164user1 statement/sql/select 3 4165user2 statement/com/Error 0 4166user2 statement/com/Quit 1 4167user2 statement/sp/freturn 1 4168user2 statement/sql/insert 1 4169user2 statement/sql/select 3 4170user3 statement/com/Error 0 4171user3 statement/com/Quit 1 4172user3 statement/sp/freturn 1 4173user3 statement/sql/insert 1 4174user3 statement/sql/select 3 4175user4 statement/com/Error 0 4176user4 statement/com/Quit 1 4177user4 statement/sp/freturn 1 4178user4 statement/sql/insert 1 4179user4 statement/sql/select 3 4180execute dump_statements_host; 4181host event_name count_star 4182localhost statement/com/Error 0 4183localhost statement/com/Quit 4 4184localhost statement/sp/freturn 4 4185localhost statement/sql/insert 4 4186localhost statement/sql/select 12 4187execute dump_statements_global; 4188event_name count_star 4189statement/com/Error 0 4190statement/com/Quit 4 4191statement/sp/freturn 4 4192statement/sql/insert 4 4193statement/sql/select 12 4194execute dump_statements_history; 4195event_name count(event_name) 4196statement/com/Quit 4 4197statement/sp/freturn 4 4198statement/sql/insert 4 4199statement/sql/select 12 4200execute dump_transactions_account; 4201user host event_name count_star 4202user1 localhost transaction 2 4203user2 localhost transaction 2 4204user3 localhost transaction 2 4205user4 localhost transaction 2 4206execute dump_transactions_user; 4207user event_name count_star 4208user1 transaction 2 4209user2 transaction 2 4210user3 transaction 2 4211user4 transaction 2 4212execute dump_transactions_host; 4213host event_name count_star 4214localhost transaction 8 4215execute dump_transactions_global; 4216event_name count_star 4217transaction 8 4218execute dump_transactions_history; 4219event_name count(event_name) 4220transaction 8 4221execute dump_accounts; 4222USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4223root localhost 1 1 4224user1 localhost 0 1 4225user2 localhost 0 1 4226user3 localhost 0 1 4227user4 localhost 0 1 4228execute dump_users; 4229USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4230root 1 1 4231user1 0 1 4232user2 0 1 4233user3 0 1 4234user4 0 1 4235execute dump_hosts; 4236HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4237localhost 1 5 4238truncate performance_schema.events_stages_summary_global_by_event_name; 4239"================== STAGES_GLOBAL truncated ==================" 4240"================== Step 23 ==================" 4241call dump_thread(); 4242username status 4243user1 not found 4244username status 4245user2 not found 4246username status 4247user3 not found 4248username status 4249user4 not found 4250execute dump_waits_account; 4251user host event_name count_star 4252user1 localhost wait/io/file/sql/query_log 0 4253user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 4254user2 localhost wait/io/file/sql/query_log 0 4255user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 4256user3 localhost wait/io/file/sql/query_log 0 4257user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 4258user4 localhost wait/io/file/sql/query_log 0 4259user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 4260execute dump_waits_user; 4261user event_name count_star 4262user1 wait/io/file/sql/query_log 0 4263user1 wait/synch/rwlock/sql/LOCK_grant 0 4264user2 wait/io/file/sql/query_log 0 4265user2 wait/synch/rwlock/sql/LOCK_grant 0 4266user3 wait/io/file/sql/query_log 0 4267user3 wait/synch/rwlock/sql/LOCK_grant 0 4268user4 wait/io/file/sql/query_log 0 4269user4 wait/synch/rwlock/sql/LOCK_grant 0 4270execute dump_waits_host; 4271host event_name count_star 4272localhost wait/io/file/sql/query_log 0 4273localhost wait/synch/rwlock/sql/LOCK_grant 0 4274execute dump_waits_global; 4275event_name count_star 4276wait/io/file/sql/query_log 0 4277wait/synch/rwlock/sql/LOCK_grant 0 4278execute dump_waits_history; 4279event_name count(event_name) 4280wait/io/file/sql/query_log 32 4281wait/synch/rwlock/sql/LOCK_grant 4 4282execute dump_stages_account; 4283user host event_name count_star 4284user1 localhost stage/sql/checking permissions 0 4285user1 localhost stage/sql/closing tables 0 4286user1 localhost stage/sql/init 0 4287user1 localhost stage/sql/Opening tables 0 4288user1 localhost stage/sql/starting 0 4289user2 localhost stage/sql/checking permissions 0 4290user2 localhost stage/sql/closing tables 0 4291user2 localhost stage/sql/init 0 4292user2 localhost stage/sql/Opening tables 0 4293user2 localhost stage/sql/starting 0 4294user3 localhost stage/sql/checking permissions 0 4295user3 localhost stage/sql/closing tables 0 4296user3 localhost stage/sql/init 0 4297user3 localhost stage/sql/Opening tables 0 4298user3 localhost stage/sql/starting 0 4299user4 localhost stage/sql/checking permissions 0 4300user4 localhost stage/sql/closing tables 0 4301user4 localhost stage/sql/init 0 4302user4 localhost stage/sql/Opening tables 0 4303user4 localhost stage/sql/starting 0 4304execute dump_stages_user; 4305user event_name count_star 4306user1 stage/sql/checking permissions 0 4307user1 stage/sql/closing tables 0 4308user1 stage/sql/init 0 4309user1 stage/sql/Opening tables 0 4310user1 stage/sql/starting 0 4311user2 stage/sql/checking permissions 0 4312user2 stage/sql/closing tables 0 4313user2 stage/sql/init 0 4314user2 stage/sql/Opening tables 0 4315user2 stage/sql/starting 0 4316user3 stage/sql/checking permissions 0 4317user3 stage/sql/closing tables 0 4318user3 stage/sql/init 0 4319user3 stage/sql/Opening tables 0 4320user3 stage/sql/starting 0 4321user4 stage/sql/checking permissions 0 4322user4 stage/sql/closing tables 0 4323user4 stage/sql/init 0 4324user4 stage/sql/Opening tables 0 4325user4 stage/sql/starting 0 4326execute dump_stages_host; 4327host event_name count_star 4328localhost stage/sql/checking permissions 0 4329localhost stage/sql/closing tables 0 4330localhost stage/sql/init 0 4331localhost stage/sql/Opening tables 0 4332localhost stage/sql/starting 0 4333execute dump_stages_global; 4334event_name count_star 4335stage/sql/checking permissions 0 4336stage/sql/closing tables 0 4337stage/sql/init 0 4338stage/sql/Opening tables 0 4339stage/sql/starting 0 4340execute dump_stages_history; 4341event_name count(event_name) 4342stage/sql/checking permissions 16 4343stage/sql/closing tables 41 4344stage/sql/init 12 4345stage/sql/Opening tables 25 4346stage/sql/starting 28 4347execute dump_statements_account; 4348user host event_name count_star 4349user1 localhost statement/com/Error 0 4350user1 localhost statement/com/Quit 1 4351user1 localhost statement/sp/freturn 1 4352user1 localhost statement/sql/insert 1 4353user1 localhost statement/sql/select 3 4354user2 localhost statement/com/Error 0 4355user2 localhost statement/com/Quit 1 4356user2 localhost statement/sp/freturn 1 4357user2 localhost statement/sql/insert 1 4358user2 localhost statement/sql/select 3 4359user3 localhost statement/com/Error 0 4360user3 localhost statement/com/Quit 1 4361user3 localhost statement/sp/freturn 1 4362user3 localhost statement/sql/insert 1 4363user3 localhost statement/sql/select 3 4364user4 localhost statement/com/Error 0 4365user4 localhost statement/com/Quit 1 4366user4 localhost statement/sp/freturn 1 4367user4 localhost statement/sql/insert 1 4368user4 localhost statement/sql/select 3 4369execute dump_statements_user; 4370user event_name count_star 4371user1 statement/com/Error 0 4372user1 statement/com/Quit 1 4373user1 statement/sp/freturn 1 4374user1 statement/sql/insert 1 4375user1 statement/sql/select 3 4376user2 statement/com/Error 0 4377user2 statement/com/Quit 1 4378user2 statement/sp/freturn 1 4379user2 statement/sql/insert 1 4380user2 statement/sql/select 3 4381user3 statement/com/Error 0 4382user3 statement/com/Quit 1 4383user3 statement/sp/freturn 1 4384user3 statement/sql/insert 1 4385user3 statement/sql/select 3 4386user4 statement/com/Error 0 4387user4 statement/com/Quit 1 4388user4 statement/sp/freturn 1 4389user4 statement/sql/insert 1 4390user4 statement/sql/select 3 4391execute dump_statements_host; 4392host event_name count_star 4393localhost statement/com/Error 0 4394localhost statement/com/Quit 4 4395localhost statement/sp/freturn 4 4396localhost statement/sql/insert 4 4397localhost statement/sql/select 12 4398execute dump_statements_global; 4399event_name count_star 4400statement/com/Error 0 4401statement/com/Quit 4 4402statement/sp/freturn 4 4403statement/sql/insert 4 4404statement/sql/select 12 4405execute dump_statements_history; 4406event_name count(event_name) 4407statement/com/Quit 4 4408statement/sp/freturn 4 4409statement/sql/insert 4 4410statement/sql/select 12 4411execute dump_transactions_account; 4412user host event_name count_star 4413user1 localhost transaction 2 4414user2 localhost transaction 2 4415user3 localhost transaction 2 4416user4 localhost transaction 2 4417execute dump_transactions_user; 4418user event_name count_star 4419user1 transaction 2 4420user2 transaction 2 4421user3 transaction 2 4422user4 transaction 2 4423execute dump_transactions_host; 4424host event_name count_star 4425localhost transaction 8 4426execute dump_transactions_global; 4427event_name count_star 4428transaction 8 4429execute dump_transactions_history; 4430event_name count(event_name) 4431transaction 8 4432execute dump_accounts; 4433USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4434root localhost 1 1 4435user1 localhost 0 1 4436user2 localhost 0 1 4437user3 localhost 0 1 4438user4 localhost 0 1 4439execute dump_users; 4440USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4441root 1 1 4442user1 0 1 4443user2 0 1 4444user3 0 1 4445user4 0 1 4446execute dump_hosts; 4447HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4448localhost 1 5 4449truncate performance_schema.events_statements_summary_by_thread_by_event_name; 4450"================== STATEMENTS_BY_THREAD truncated ==================" 4451"================== Step 24 ==================" 4452call dump_thread(); 4453username status 4454user1 not found 4455username status 4456user2 not found 4457username status 4458user3 not found 4459username status 4460user4 not found 4461execute dump_waits_account; 4462user host event_name count_star 4463user1 localhost wait/io/file/sql/query_log 0 4464user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 4465user2 localhost wait/io/file/sql/query_log 0 4466user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 4467user3 localhost wait/io/file/sql/query_log 0 4468user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 4469user4 localhost wait/io/file/sql/query_log 0 4470user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 4471execute dump_waits_user; 4472user event_name count_star 4473user1 wait/io/file/sql/query_log 0 4474user1 wait/synch/rwlock/sql/LOCK_grant 0 4475user2 wait/io/file/sql/query_log 0 4476user2 wait/synch/rwlock/sql/LOCK_grant 0 4477user3 wait/io/file/sql/query_log 0 4478user3 wait/synch/rwlock/sql/LOCK_grant 0 4479user4 wait/io/file/sql/query_log 0 4480user4 wait/synch/rwlock/sql/LOCK_grant 0 4481execute dump_waits_host; 4482host event_name count_star 4483localhost wait/io/file/sql/query_log 0 4484localhost wait/synch/rwlock/sql/LOCK_grant 0 4485execute dump_waits_global; 4486event_name count_star 4487wait/io/file/sql/query_log 0 4488wait/synch/rwlock/sql/LOCK_grant 0 4489execute dump_waits_history; 4490event_name count(event_name) 4491wait/io/file/sql/query_log 32 4492wait/synch/rwlock/sql/LOCK_grant 4 4493execute dump_stages_account; 4494user host event_name count_star 4495user1 localhost stage/sql/checking permissions 0 4496user1 localhost stage/sql/closing tables 0 4497user1 localhost stage/sql/init 0 4498user1 localhost stage/sql/Opening tables 0 4499user1 localhost stage/sql/starting 0 4500user2 localhost stage/sql/checking permissions 0 4501user2 localhost stage/sql/closing tables 0 4502user2 localhost stage/sql/init 0 4503user2 localhost stage/sql/Opening tables 0 4504user2 localhost stage/sql/starting 0 4505user3 localhost stage/sql/checking permissions 0 4506user3 localhost stage/sql/closing tables 0 4507user3 localhost stage/sql/init 0 4508user3 localhost stage/sql/Opening tables 0 4509user3 localhost stage/sql/starting 0 4510user4 localhost stage/sql/checking permissions 0 4511user4 localhost stage/sql/closing tables 0 4512user4 localhost stage/sql/init 0 4513user4 localhost stage/sql/Opening tables 0 4514user4 localhost stage/sql/starting 0 4515execute dump_stages_user; 4516user event_name count_star 4517user1 stage/sql/checking permissions 0 4518user1 stage/sql/closing tables 0 4519user1 stage/sql/init 0 4520user1 stage/sql/Opening tables 0 4521user1 stage/sql/starting 0 4522user2 stage/sql/checking permissions 0 4523user2 stage/sql/closing tables 0 4524user2 stage/sql/init 0 4525user2 stage/sql/Opening tables 0 4526user2 stage/sql/starting 0 4527user3 stage/sql/checking permissions 0 4528user3 stage/sql/closing tables 0 4529user3 stage/sql/init 0 4530user3 stage/sql/Opening tables 0 4531user3 stage/sql/starting 0 4532user4 stage/sql/checking permissions 0 4533user4 stage/sql/closing tables 0 4534user4 stage/sql/init 0 4535user4 stage/sql/Opening tables 0 4536user4 stage/sql/starting 0 4537execute dump_stages_host; 4538host event_name count_star 4539localhost stage/sql/checking permissions 0 4540localhost stage/sql/closing tables 0 4541localhost stage/sql/init 0 4542localhost stage/sql/Opening tables 0 4543localhost stage/sql/starting 0 4544execute dump_stages_global; 4545event_name count_star 4546stage/sql/checking permissions 0 4547stage/sql/closing tables 0 4548stage/sql/init 0 4549stage/sql/Opening tables 0 4550stage/sql/starting 0 4551execute dump_stages_history; 4552event_name count(event_name) 4553stage/sql/checking permissions 16 4554stage/sql/closing tables 41 4555stage/sql/init 12 4556stage/sql/Opening tables 25 4557stage/sql/starting 28 4558execute dump_statements_account; 4559user host event_name count_star 4560user1 localhost statement/com/Error 0 4561user1 localhost statement/com/Quit 1 4562user1 localhost statement/sp/freturn 1 4563user1 localhost statement/sql/insert 1 4564user1 localhost statement/sql/select 3 4565user2 localhost statement/com/Error 0 4566user2 localhost statement/com/Quit 1 4567user2 localhost statement/sp/freturn 1 4568user2 localhost statement/sql/insert 1 4569user2 localhost statement/sql/select 3 4570user3 localhost statement/com/Error 0 4571user3 localhost statement/com/Quit 1 4572user3 localhost statement/sp/freturn 1 4573user3 localhost statement/sql/insert 1 4574user3 localhost statement/sql/select 3 4575user4 localhost statement/com/Error 0 4576user4 localhost statement/com/Quit 1 4577user4 localhost statement/sp/freturn 1 4578user4 localhost statement/sql/insert 1 4579user4 localhost statement/sql/select 3 4580execute dump_statements_user; 4581user event_name count_star 4582user1 statement/com/Error 0 4583user1 statement/com/Quit 1 4584user1 statement/sp/freturn 1 4585user1 statement/sql/insert 1 4586user1 statement/sql/select 3 4587user2 statement/com/Error 0 4588user2 statement/com/Quit 1 4589user2 statement/sp/freturn 1 4590user2 statement/sql/insert 1 4591user2 statement/sql/select 3 4592user3 statement/com/Error 0 4593user3 statement/com/Quit 1 4594user3 statement/sp/freturn 1 4595user3 statement/sql/insert 1 4596user3 statement/sql/select 3 4597user4 statement/com/Error 0 4598user4 statement/com/Quit 1 4599user4 statement/sp/freturn 1 4600user4 statement/sql/insert 1 4601user4 statement/sql/select 3 4602execute dump_statements_host; 4603host event_name count_star 4604localhost statement/com/Error 0 4605localhost statement/com/Quit 4 4606localhost statement/sp/freturn 4 4607localhost statement/sql/insert 4 4608localhost statement/sql/select 12 4609execute dump_statements_global; 4610event_name count_star 4611statement/com/Error 0 4612statement/com/Quit 4 4613statement/sp/freturn 4 4614statement/sql/insert 4 4615statement/sql/select 12 4616execute dump_statements_history; 4617event_name count(event_name) 4618statement/com/Quit 4 4619statement/sp/freturn 4 4620statement/sql/insert 4 4621statement/sql/select 12 4622execute dump_transactions_account; 4623user host event_name count_star 4624user1 localhost transaction 2 4625user2 localhost transaction 2 4626user3 localhost transaction 2 4627user4 localhost transaction 2 4628execute dump_transactions_user; 4629user event_name count_star 4630user1 transaction 2 4631user2 transaction 2 4632user3 transaction 2 4633user4 transaction 2 4634execute dump_transactions_host; 4635host event_name count_star 4636localhost transaction 8 4637execute dump_transactions_global; 4638event_name count_star 4639transaction 8 4640execute dump_transactions_history; 4641event_name count(event_name) 4642transaction 8 4643execute dump_accounts; 4644USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4645root localhost 1 1 4646user1 localhost 0 1 4647user2 localhost 0 1 4648user3 localhost 0 1 4649user4 localhost 0 1 4650execute dump_users; 4651USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4652root 1 1 4653user1 0 1 4654user2 0 1 4655user3 0 1 4656user4 0 1 4657execute dump_hosts; 4658HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4659localhost 1 5 4660truncate performance_schema.events_statements_summary_by_account_by_event_name; 4661"================== STATEMENTS_BY_ACCOUNT truncated ==================" 4662"================== Step 25 ==================" 4663call dump_thread(); 4664username status 4665user1 not found 4666username status 4667user2 not found 4668username status 4669user3 not found 4670username status 4671user4 not found 4672execute dump_waits_account; 4673user host event_name count_star 4674user1 localhost wait/io/file/sql/query_log 0 4675user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 4676user2 localhost wait/io/file/sql/query_log 0 4677user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 4678user3 localhost wait/io/file/sql/query_log 0 4679user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 4680user4 localhost wait/io/file/sql/query_log 0 4681user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 4682execute dump_waits_user; 4683user event_name count_star 4684user1 wait/io/file/sql/query_log 0 4685user1 wait/synch/rwlock/sql/LOCK_grant 0 4686user2 wait/io/file/sql/query_log 0 4687user2 wait/synch/rwlock/sql/LOCK_grant 0 4688user3 wait/io/file/sql/query_log 0 4689user3 wait/synch/rwlock/sql/LOCK_grant 0 4690user4 wait/io/file/sql/query_log 0 4691user4 wait/synch/rwlock/sql/LOCK_grant 0 4692execute dump_waits_host; 4693host event_name count_star 4694localhost wait/io/file/sql/query_log 0 4695localhost wait/synch/rwlock/sql/LOCK_grant 0 4696execute dump_waits_global; 4697event_name count_star 4698wait/io/file/sql/query_log 0 4699wait/synch/rwlock/sql/LOCK_grant 0 4700execute dump_waits_history; 4701event_name count(event_name) 4702wait/io/file/sql/query_log 32 4703wait/synch/rwlock/sql/LOCK_grant 4 4704execute dump_stages_account; 4705user host event_name count_star 4706user1 localhost stage/sql/checking permissions 0 4707user1 localhost stage/sql/closing tables 0 4708user1 localhost stage/sql/init 0 4709user1 localhost stage/sql/Opening tables 0 4710user1 localhost stage/sql/starting 0 4711user2 localhost stage/sql/checking permissions 0 4712user2 localhost stage/sql/closing tables 0 4713user2 localhost stage/sql/init 0 4714user2 localhost stage/sql/Opening tables 0 4715user2 localhost stage/sql/starting 0 4716user3 localhost stage/sql/checking permissions 0 4717user3 localhost stage/sql/closing tables 0 4718user3 localhost stage/sql/init 0 4719user3 localhost stage/sql/Opening tables 0 4720user3 localhost stage/sql/starting 0 4721user4 localhost stage/sql/checking permissions 0 4722user4 localhost stage/sql/closing tables 0 4723user4 localhost stage/sql/init 0 4724user4 localhost stage/sql/Opening tables 0 4725user4 localhost stage/sql/starting 0 4726execute dump_stages_user; 4727user event_name count_star 4728user1 stage/sql/checking permissions 0 4729user1 stage/sql/closing tables 0 4730user1 stage/sql/init 0 4731user1 stage/sql/Opening tables 0 4732user1 stage/sql/starting 0 4733user2 stage/sql/checking permissions 0 4734user2 stage/sql/closing tables 0 4735user2 stage/sql/init 0 4736user2 stage/sql/Opening tables 0 4737user2 stage/sql/starting 0 4738user3 stage/sql/checking permissions 0 4739user3 stage/sql/closing tables 0 4740user3 stage/sql/init 0 4741user3 stage/sql/Opening tables 0 4742user3 stage/sql/starting 0 4743user4 stage/sql/checking permissions 0 4744user4 stage/sql/closing tables 0 4745user4 stage/sql/init 0 4746user4 stage/sql/Opening tables 0 4747user4 stage/sql/starting 0 4748execute dump_stages_host; 4749host event_name count_star 4750localhost stage/sql/checking permissions 0 4751localhost stage/sql/closing tables 0 4752localhost stage/sql/init 0 4753localhost stage/sql/Opening tables 0 4754localhost stage/sql/starting 0 4755execute dump_stages_global; 4756event_name count_star 4757stage/sql/checking permissions 0 4758stage/sql/closing tables 0 4759stage/sql/init 0 4760stage/sql/Opening tables 0 4761stage/sql/starting 0 4762execute dump_stages_history; 4763event_name count(event_name) 4764stage/sql/checking permissions 16 4765stage/sql/closing tables 41 4766stage/sql/init 12 4767stage/sql/Opening tables 25 4768stage/sql/starting 28 4769execute dump_statements_account; 4770user host event_name count_star 4771user1 localhost statement/com/Error 0 4772user1 localhost statement/com/Quit 0 4773user1 localhost statement/sp/freturn 0 4774user1 localhost statement/sql/insert 0 4775user1 localhost statement/sql/select 0 4776user2 localhost statement/com/Error 0 4777user2 localhost statement/com/Quit 0 4778user2 localhost statement/sp/freturn 0 4779user2 localhost statement/sql/insert 0 4780user2 localhost statement/sql/select 0 4781user3 localhost statement/com/Error 0 4782user3 localhost statement/com/Quit 0 4783user3 localhost statement/sp/freturn 0 4784user3 localhost statement/sql/insert 0 4785user3 localhost statement/sql/select 0 4786user4 localhost statement/com/Error 0 4787user4 localhost statement/com/Quit 0 4788user4 localhost statement/sp/freturn 0 4789user4 localhost statement/sql/insert 0 4790user4 localhost statement/sql/select 0 4791execute dump_statements_user; 4792user event_name count_star 4793user1 statement/com/Error 0 4794user1 statement/com/Quit 1 4795user1 statement/sp/freturn 1 4796user1 statement/sql/insert 1 4797user1 statement/sql/select 3 4798user2 statement/com/Error 0 4799user2 statement/com/Quit 1 4800user2 statement/sp/freturn 1 4801user2 statement/sql/insert 1 4802user2 statement/sql/select 3 4803user3 statement/com/Error 0 4804user3 statement/com/Quit 1 4805user3 statement/sp/freturn 1 4806user3 statement/sql/insert 1 4807user3 statement/sql/select 3 4808user4 statement/com/Error 0 4809user4 statement/com/Quit 1 4810user4 statement/sp/freturn 1 4811user4 statement/sql/insert 1 4812user4 statement/sql/select 3 4813execute dump_statements_host; 4814host event_name count_star 4815localhost statement/com/Error 0 4816localhost statement/com/Quit 4 4817localhost statement/sp/freturn 4 4818localhost statement/sql/insert 4 4819localhost statement/sql/select 12 4820execute dump_statements_global; 4821event_name count_star 4822statement/com/Error 0 4823statement/com/Quit 4 4824statement/sp/freturn 4 4825statement/sql/insert 4 4826statement/sql/select 12 4827execute dump_statements_history; 4828event_name count(event_name) 4829statement/com/Quit 4 4830statement/sp/freturn 4 4831statement/sql/insert 4 4832statement/sql/select 12 4833execute dump_transactions_account; 4834user host event_name count_star 4835user1 localhost transaction 2 4836user2 localhost transaction 2 4837user3 localhost transaction 2 4838user4 localhost transaction 2 4839execute dump_transactions_user; 4840user event_name count_star 4841user1 transaction 2 4842user2 transaction 2 4843user3 transaction 2 4844user4 transaction 2 4845execute dump_transactions_host; 4846host event_name count_star 4847localhost transaction 8 4848execute dump_transactions_global; 4849event_name count_star 4850transaction 8 4851execute dump_transactions_history; 4852event_name count(event_name) 4853transaction 8 4854execute dump_accounts; 4855USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4856root localhost 1 1 4857user1 localhost 0 1 4858user2 localhost 0 1 4859user3 localhost 0 1 4860user4 localhost 0 1 4861execute dump_users; 4862USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4863root 1 1 4864user1 0 1 4865user2 0 1 4866user3 0 1 4867user4 0 1 4868execute dump_hosts; 4869HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 4870localhost 1 5 4871truncate performance_schema.events_statements_summary_by_user_by_event_name; 4872"================== STATEMENTS_BY_USER truncated ==================" 4873"================== Step 26 ==================" 4874call dump_thread(); 4875username status 4876user1 not found 4877username status 4878user2 not found 4879username status 4880user3 not found 4881username status 4882user4 not found 4883execute dump_waits_account; 4884user host event_name count_star 4885user1 localhost wait/io/file/sql/query_log 0 4886user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 4887user2 localhost wait/io/file/sql/query_log 0 4888user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 4889user3 localhost wait/io/file/sql/query_log 0 4890user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 4891user4 localhost wait/io/file/sql/query_log 0 4892user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 4893execute dump_waits_user; 4894user event_name count_star 4895user1 wait/io/file/sql/query_log 0 4896user1 wait/synch/rwlock/sql/LOCK_grant 0 4897user2 wait/io/file/sql/query_log 0 4898user2 wait/synch/rwlock/sql/LOCK_grant 0 4899user3 wait/io/file/sql/query_log 0 4900user3 wait/synch/rwlock/sql/LOCK_grant 0 4901user4 wait/io/file/sql/query_log 0 4902user4 wait/synch/rwlock/sql/LOCK_grant 0 4903execute dump_waits_host; 4904host event_name count_star 4905localhost wait/io/file/sql/query_log 0 4906localhost wait/synch/rwlock/sql/LOCK_grant 0 4907execute dump_waits_global; 4908event_name count_star 4909wait/io/file/sql/query_log 0 4910wait/synch/rwlock/sql/LOCK_grant 0 4911execute dump_waits_history; 4912event_name count(event_name) 4913wait/io/file/sql/query_log 32 4914wait/synch/rwlock/sql/LOCK_grant 4 4915execute dump_stages_account; 4916user host event_name count_star 4917user1 localhost stage/sql/checking permissions 0 4918user1 localhost stage/sql/closing tables 0 4919user1 localhost stage/sql/init 0 4920user1 localhost stage/sql/Opening tables 0 4921user1 localhost stage/sql/starting 0 4922user2 localhost stage/sql/checking permissions 0 4923user2 localhost stage/sql/closing tables 0 4924user2 localhost stage/sql/init 0 4925user2 localhost stage/sql/Opening tables 0 4926user2 localhost stage/sql/starting 0 4927user3 localhost stage/sql/checking permissions 0 4928user3 localhost stage/sql/closing tables 0 4929user3 localhost stage/sql/init 0 4930user3 localhost stage/sql/Opening tables 0 4931user3 localhost stage/sql/starting 0 4932user4 localhost stage/sql/checking permissions 0 4933user4 localhost stage/sql/closing tables 0 4934user4 localhost stage/sql/init 0 4935user4 localhost stage/sql/Opening tables 0 4936user4 localhost stage/sql/starting 0 4937execute dump_stages_user; 4938user event_name count_star 4939user1 stage/sql/checking permissions 0 4940user1 stage/sql/closing tables 0 4941user1 stage/sql/init 0 4942user1 stage/sql/Opening tables 0 4943user1 stage/sql/starting 0 4944user2 stage/sql/checking permissions 0 4945user2 stage/sql/closing tables 0 4946user2 stage/sql/init 0 4947user2 stage/sql/Opening tables 0 4948user2 stage/sql/starting 0 4949user3 stage/sql/checking permissions 0 4950user3 stage/sql/closing tables 0 4951user3 stage/sql/init 0 4952user3 stage/sql/Opening tables 0 4953user3 stage/sql/starting 0 4954user4 stage/sql/checking permissions 0 4955user4 stage/sql/closing tables 0 4956user4 stage/sql/init 0 4957user4 stage/sql/Opening tables 0 4958user4 stage/sql/starting 0 4959execute dump_stages_host; 4960host event_name count_star 4961localhost stage/sql/checking permissions 0 4962localhost stage/sql/closing tables 0 4963localhost stage/sql/init 0 4964localhost stage/sql/Opening tables 0 4965localhost stage/sql/starting 0 4966execute dump_stages_global; 4967event_name count_star 4968stage/sql/checking permissions 0 4969stage/sql/closing tables 0 4970stage/sql/init 0 4971stage/sql/Opening tables 0 4972stage/sql/starting 0 4973execute dump_stages_history; 4974event_name count(event_name) 4975stage/sql/checking permissions 16 4976stage/sql/closing tables 41 4977stage/sql/init 12 4978stage/sql/Opening tables 25 4979stage/sql/starting 28 4980execute dump_statements_account; 4981user host event_name count_star 4982user1 localhost statement/com/Error 0 4983user1 localhost statement/com/Quit 0 4984user1 localhost statement/sp/freturn 0 4985user1 localhost statement/sql/insert 0 4986user1 localhost statement/sql/select 0 4987user2 localhost statement/com/Error 0 4988user2 localhost statement/com/Quit 0 4989user2 localhost statement/sp/freturn 0 4990user2 localhost statement/sql/insert 0 4991user2 localhost statement/sql/select 0 4992user3 localhost statement/com/Error 0 4993user3 localhost statement/com/Quit 0 4994user3 localhost statement/sp/freturn 0 4995user3 localhost statement/sql/insert 0 4996user3 localhost statement/sql/select 0 4997user4 localhost statement/com/Error 0 4998user4 localhost statement/com/Quit 0 4999user4 localhost statement/sp/freturn 0 5000user4 localhost statement/sql/insert 0 5001user4 localhost statement/sql/select 0 5002execute dump_statements_user; 5003user event_name count_star 5004user1 statement/com/Error 0 5005user1 statement/com/Quit 0 5006user1 statement/sp/freturn 0 5007user1 statement/sql/insert 0 5008user1 statement/sql/select 0 5009user2 statement/com/Error 0 5010user2 statement/com/Quit 0 5011user2 statement/sp/freturn 0 5012user2 statement/sql/insert 0 5013user2 statement/sql/select 0 5014user3 statement/com/Error 0 5015user3 statement/com/Quit 0 5016user3 statement/sp/freturn 0 5017user3 statement/sql/insert 0 5018user3 statement/sql/select 0 5019user4 statement/com/Error 0 5020user4 statement/com/Quit 0 5021user4 statement/sp/freturn 0 5022user4 statement/sql/insert 0 5023user4 statement/sql/select 0 5024execute dump_statements_host; 5025host event_name count_star 5026localhost statement/com/Error 0 5027localhost statement/com/Quit 4 5028localhost statement/sp/freturn 4 5029localhost statement/sql/insert 4 5030localhost statement/sql/select 12 5031execute dump_statements_global; 5032event_name count_star 5033statement/com/Error 0 5034statement/com/Quit 4 5035statement/sp/freturn 4 5036statement/sql/insert 4 5037statement/sql/select 12 5038execute dump_statements_history; 5039event_name count(event_name) 5040statement/com/Quit 4 5041statement/sp/freturn 4 5042statement/sql/insert 4 5043statement/sql/select 12 5044execute dump_transactions_account; 5045user host event_name count_star 5046user1 localhost transaction 2 5047user2 localhost transaction 2 5048user3 localhost transaction 2 5049user4 localhost transaction 2 5050execute dump_transactions_user; 5051user event_name count_star 5052user1 transaction 2 5053user2 transaction 2 5054user3 transaction 2 5055user4 transaction 2 5056execute dump_transactions_host; 5057host event_name count_star 5058localhost transaction 8 5059execute dump_transactions_global; 5060event_name count_star 5061transaction 8 5062execute dump_transactions_history; 5063event_name count(event_name) 5064transaction 8 5065execute dump_accounts; 5066USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5067root localhost 1 1 5068user1 localhost 0 1 5069user2 localhost 0 1 5070user3 localhost 0 1 5071user4 localhost 0 1 5072execute dump_users; 5073USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5074root 1 1 5075user1 0 1 5076user2 0 1 5077user3 0 1 5078user4 0 1 5079execute dump_hosts; 5080HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5081localhost 1 5 5082truncate performance_schema.events_statements_summary_by_host_by_event_name; 5083"================== STATEMENTS_BY_HOST truncated ==================" 5084"================== Step 27 ==================" 5085call dump_thread(); 5086username status 5087user1 not found 5088username status 5089user2 not found 5090username status 5091user3 not found 5092username status 5093user4 not found 5094execute dump_waits_account; 5095user host event_name count_star 5096user1 localhost wait/io/file/sql/query_log 0 5097user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 5098user2 localhost wait/io/file/sql/query_log 0 5099user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 5100user3 localhost wait/io/file/sql/query_log 0 5101user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 5102user4 localhost wait/io/file/sql/query_log 0 5103user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 5104execute dump_waits_user; 5105user event_name count_star 5106user1 wait/io/file/sql/query_log 0 5107user1 wait/synch/rwlock/sql/LOCK_grant 0 5108user2 wait/io/file/sql/query_log 0 5109user2 wait/synch/rwlock/sql/LOCK_grant 0 5110user3 wait/io/file/sql/query_log 0 5111user3 wait/synch/rwlock/sql/LOCK_grant 0 5112user4 wait/io/file/sql/query_log 0 5113user4 wait/synch/rwlock/sql/LOCK_grant 0 5114execute dump_waits_host; 5115host event_name count_star 5116localhost wait/io/file/sql/query_log 0 5117localhost wait/synch/rwlock/sql/LOCK_grant 0 5118execute dump_waits_global; 5119event_name count_star 5120wait/io/file/sql/query_log 0 5121wait/synch/rwlock/sql/LOCK_grant 0 5122execute dump_waits_history; 5123event_name count(event_name) 5124wait/io/file/sql/query_log 32 5125wait/synch/rwlock/sql/LOCK_grant 4 5126execute dump_stages_account; 5127user host event_name count_star 5128user1 localhost stage/sql/checking permissions 0 5129user1 localhost stage/sql/closing tables 0 5130user1 localhost stage/sql/init 0 5131user1 localhost stage/sql/Opening tables 0 5132user1 localhost stage/sql/starting 0 5133user2 localhost stage/sql/checking permissions 0 5134user2 localhost stage/sql/closing tables 0 5135user2 localhost stage/sql/init 0 5136user2 localhost stage/sql/Opening tables 0 5137user2 localhost stage/sql/starting 0 5138user3 localhost stage/sql/checking permissions 0 5139user3 localhost stage/sql/closing tables 0 5140user3 localhost stage/sql/init 0 5141user3 localhost stage/sql/Opening tables 0 5142user3 localhost stage/sql/starting 0 5143user4 localhost stage/sql/checking permissions 0 5144user4 localhost stage/sql/closing tables 0 5145user4 localhost stage/sql/init 0 5146user4 localhost stage/sql/Opening tables 0 5147user4 localhost stage/sql/starting 0 5148execute dump_stages_user; 5149user event_name count_star 5150user1 stage/sql/checking permissions 0 5151user1 stage/sql/closing tables 0 5152user1 stage/sql/init 0 5153user1 stage/sql/Opening tables 0 5154user1 stage/sql/starting 0 5155user2 stage/sql/checking permissions 0 5156user2 stage/sql/closing tables 0 5157user2 stage/sql/init 0 5158user2 stage/sql/Opening tables 0 5159user2 stage/sql/starting 0 5160user3 stage/sql/checking permissions 0 5161user3 stage/sql/closing tables 0 5162user3 stage/sql/init 0 5163user3 stage/sql/Opening tables 0 5164user3 stage/sql/starting 0 5165user4 stage/sql/checking permissions 0 5166user4 stage/sql/closing tables 0 5167user4 stage/sql/init 0 5168user4 stage/sql/Opening tables 0 5169user4 stage/sql/starting 0 5170execute dump_stages_host; 5171host event_name count_star 5172localhost stage/sql/checking permissions 0 5173localhost stage/sql/closing tables 0 5174localhost stage/sql/init 0 5175localhost stage/sql/Opening tables 0 5176localhost stage/sql/starting 0 5177execute dump_stages_global; 5178event_name count_star 5179stage/sql/checking permissions 0 5180stage/sql/closing tables 0 5181stage/sql/init 0 5182stage/sql/Opening tables 0 5183stage/sql/starting 0 5184execute dump_stages_history; 5185event_name count(event_name) 5186stage/sql/checking permissions 16 5187stage/sql/closing tables 41 5188stage/sql/init 12 5189stage/sql/Opening tables 25 5190stage/sql/starting 28 5191execute dump_statements_account; 5192user host event_name count_star 5193user1 localhost statement/com/Error 0 5194user1 localhost statement/com/Quit 0 5195user1 localhost statement/sp/freturn 0 5196user1 localhost statement/sql/insert 0 5197user1 localhost statement/sql/select 0 5198user2 localhost statement/com/Error 0 5199user2 localhost statement/com/Quit 0 5200user2 localhost statement/sp/freturn 0 5201user2 localhost statement/sql/insert 0 5202user2 localhost statement/sql/select 0 5203user3 localhost statement/com/Error 0 5204user3 localhost statement/com/Quit 0 5205user3 localhost statement/sp/freturn 0 5206user3 localhost statement/sql/insert 0 5207user3 localhost statement/sql/select 0 5208user4 localhost statement/com/Error 0 5209user4 localhost statement/com/Quit 0 5210user4 localhost statement/sp/freturn 0 5211user4 localhost statement/sql/insert 0 5212user4 localhost statement/sql/select 0 5213execute dump_statements_user; 5214user event_name count_star 5215user1 statement/com/Error 0 5216user1 statement/com/Quit 0 5217user1 statement/sp/freturn 0 5218user1 statement/sql/insert 0 5219user1 statement/sql/select 0 5220user2 statement/com/Error 0 5221user2 statement/com/Quit 0 5222user2 statement/sp/freturn 0 5223user2 statement/sql/insert 0 5224user2 statement/sql/select 0 5225user3 statement/com/Error 0 5226user3 statement/com/Quit 0 5227user3 statement/sp/freturn 0 5228user3 statement/sql/insert 0 5229user3 statement/sql/select 0 5230user4 statement/com/Error 0 5231user4 statement/com/Quit 0 5232user4 statement/sp/freturn 0 5233user4 statement/sql/insert 0 5234user4 statement/sql/select 0 5235execute dump_statements_host; 5236host event_name count_star 5237localhost statement/com/Error 0 5238localhost statement/com/Quit 0 5239localhost statement/sp/freturn 0 5240localhost statement/sql/insert 0 5241localhost statement/sql/select 0 5242execute dump_statements_global; 5243event_name count_star 5244statement/com/Error 0 5245statement/com/Quit 4 5246statement/sp/freturn 4 5247statement/sql/insert 4 5248statement/sql/select 12 5249execute dump_statements_history; 5250event_name count(event_name) 5251statement/com/Quit 4 5252statement/sp/freturn 4 5253statement/sql/insert 4 5254statement/sql/select 12 5255execute dump_transactions_account; 5256user host event_name count_star 5257user1 localhost transaction 2 5258user2 localhost transaction 2 5259user3 localhost transaction 2 5260user4 localhost transaction 2 5261execute dump_transactions_user; 5262user event_name count_star 5263user1 transaction 2 5264user2 transaction 2 5265user3 transaction 2 5266user4 transaction 2 5267execute dump_transactions_host; 5268host event_name count_star 5269localhost transaction 8 5270execute dump_transactions_global; 5271event_name count_star 5272transaction 8 5273execute dump_transactions_history; 5274event_name count(event_name) 5275transaction 8 5276execute dump_accounts; 5277USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5278root localhost 1 1 5279user1 localhost 0 1 5280user2 localhost 0 1 5281user3 localhost 0 1 5282user4 localhost 0 1 5283execute dump_users; 5284USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5285root 1 1 5286user1 0 1 5287user2 0 1 5288user3 0 1 5289user4 0 1 5290execute dump_hosts; 5291HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5292localhost 1 5 5293truncate performance_schema.events_statements_summary_global_by_event_name; 5294"================== STATEMENTS_GLOBAL truncated ==================" 5295"================== Step 28 ==================" 5296call dump_thread(); 5297username status 5298user1 not found 5299username status 5300user2 not found 5301username status 5302user3 not found 5303username status 5304user4 not found 5305execute dump_waits_account; 5306user host event_name count_star 5307user1 localhost wait/io/file/sql/query_log 0 5308user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 5309user2 localhost wait/io/file/sql/query_log 0 5310user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 5311user3 localhost wait/io/file/sql/query_log 0 5312user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 5313user4 localhost wait/io/file/sql/query_log 0 5314user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 5315execute dump_waits_user; 5316user event_name count_star 5317user1 wait/io/file/sql/query_log 0 5318user1 wait/synch/rwlock/sql/LOCK_grant 0 5319user2 wait/io/file/sql/query_log 0 5320user2 wait/synch/rwlock/sql/LOCK_grant 0 5321user3 wait/io/file/sql/query_log 0 5322user3 wait/synch/rwlock/sql/LOCK_grant 0 5323user4 wait/io/file/sql/query_log 0 5324user4 wait/synch/rwlock/sql/LOCK_grant 0 5325execute dump_waits_host; 5326host event_name count_star 5327localhost wait/io/file/sql/query_log 0 5328localhost wait/synch/rwlock/sql/LOCK_grant 0 5329execute dump_waits_global; 5330event_name count_star 5331wait/io/file/sql/query_log 0 5332wait/synch/rwlock/sql/LOCK_grant 0 5333execute dump_waits_history; 5334event_name count(event_name) 5335wait/io/file/sql/query_log 32 5336wait/synch/rwlock/sql/LOCK_grant 4 5337execute dump_stages_account; 5338user host event_name count_star 5339user1 localhost stage/sql/checking permissions 0 5340user1 localhost stage/sql/closing tables 0 5341user1 localhost stage/sql/init 0 5342user1 localhost stage/sql/Opening tables 0 5343user1 localhost stage/sql/starting 0 5344user2 localhost stage/sql/checking permissions 0 5345user2 localhost stage/sql/closing tables 0 5346user2 localhost stage/sql/init 0 5347user2 localhost stage/sql/Opening tables 0 5348user2 localhost stage/sql/starting 0 5349user3 localhost stage/sql/checking permissions 0 5350user3 localhost stage/sql/closing tables 0 5351user3 localhost stage/sql/init 0 5352user3 localhost stage/sql/Opening tables 0 5353user3 localhost stage/sql/starting 0 5354user4 localhost stage/sql/checking permissions 0 5355user4 localhost stage/sql/closing tables 0 5356user4 localhost stage/sql/init 0 5357user4 localhost stage/sql/Opening tables 0 5358user4 localhost stage/sql/starting 0 5359execute dump_stages_user; 5360user event_name count_star 5361user1 stage/sql/checking permissions 0 5362user1 stage/sql/closing tables 0 5363user1 stage/sql/init 0 5364user1 stage/sql/Opening tables 0 5365user1 stage/sql/starting 0 5366user2 stage/sql/checking permissions 0 5367user2 stage/sql/closing tables 0 5368user2 stage/sql/init 0 5369user2 stage/sql/Opening tables 0 5370user2 stage/sql/starting 0 5371user3 stage/sql/checking permissions 0 5372user3 stage/sql/closing tables 0 5373user3 stage/sql/init 0 5374user3 stage/sql/Opening tables 0 5375user3 stage/sql/starting 0 5376user4 stage/sql/checking permissions 0 5377user4 stage/sql/closing tables 0 5378user4 stage/sql/init 0 5379user4 stage/sql/Opening tables 0 5380user4 stage/sql/starting 0 5381execute dump_stages_host; 5382host event_name count_star 5383localhost stage/sql/checking permissions 0 5384localhost stage/sql/closing tables 0 5385localhost stage/sql/init 0 5386localhost stage/sql/Opening tables 0 5387localhost stage/sql/starting 0 5388execute dump_stages_global; 5389event_name count_star 5390stage/sql/checking permissions 0 5391stage/sql/closing tables 0 5392stage/sql/init 0 5393stage/sql/Opening tables 0 5394stage/sql/starting 0 5395execute dump_stages_history; 5396event_name count(event_name) 5397stage/sql/checking permissions 16 5398stage/sql/closing tables 41 5399stage/sql/init 12 5400stage/sql/Opening tables 25 5401stage/sql/starting 28 5402execute dump_statements_account; 5403user host event_name count_star 5404user1 localhost statement/com/Error 0 5405user1 localhost statement/com/Quit 0 5406user1 localhost statement/sp/freturn 0 5407user1 localhost statement/sql/insert 0 5408user1 localhost statement/sql/select 0 5409user2 localhost statement/com/Error 0 5410user2 localhost statement/com/Quit 0 5411user2 localhost statement/sp/freturn 0 5412user2 localhost statement/sql/insert 0 5413user2 localhost statement/sql/select 0 5414user3 localhost statement/com/Error 0 5415user3 localhost statement/com/Quit 0 5416user3 localhost statement/sp/freturn 0 5417user3 localhost statement/sql/insert 0 5418user3 localhost statement/sql/select 0 5419user4 localhost statement/com/Error 0 5420user4 localhost statement/com/Quit 0 5421user4 localhost statement/sp/freturn 0 5422user4 localhost statement/sql/insert 0 5423user4 localhost statement/sql/select 0 5424execute dump_statements_user; 5425user event_name count_star 5426user1 statement/com/Error 0 5427user1 statement/com/Quit 0 5428user1 statement/sp/freturn 0 5429user1 statement/sql/insert 0 5430user1 statement/sql/select 0 5431user2 statement/com/Error 0 5432user2 statement/com/Quit 0 5433user2 statement/sp/freturn 0 5434user2 statement/sql/insert 0 5435user2 statement/sql/select 0 5436user3 statement/com/Error 0 5437user3 statement/com/Quit 0 5438user3 statement/sp/freturn 0 5439user3 statement/sql/insert 0 5440user3 statement/sql/select 0 5441user4 statement/com/Error 0 5442user4 statement/com/Quit 0 5443user4 statement/sp/freturn 0 5444user4 statement/sql/insert 0 5445user4 statement/sql/select 0 5446execute dump_statements_host; 5447host event_name count_star 5448localhost statement/com/Error 0 5449localhost statement/com/Quit 0 5450localhost statement/sp/freturn 0 5451localhost statement/sql/insert 0 5452localhost statement/sql/select 0 5453execute dump_statements_global; 5454event_name count_star 5455statement/com/Error 0 5456statement/com/Quit 0 5457statement/sp/freturn 0 5458statement/sql/insert 0 5459statement/sql/select 0 5460execute dump_statements_history; 5461event_name count(event_name) 5462statement/com/Quit 4 5463statement/sp/freturn 4 5464statement/sql/insert 4 5465statement/sql/select 12 5466execute dump_transactions_account; 5467user host event_name count_star 5468user1 localhost transaction 2 5469user2 localhost transaction 2 5470user3 localhost transaction 2 5471user4 localhost transaction 2 5472execute dump_transactions_user; 5473user event_name count_star 5474user1 transaction 2 5475user2 transaction 2 5476user3 transaction 2 5477user4 transaction 2 5478execute dump_transactions_host; 5479host event_name count_star 5480localhost transaction 8 5481execute dump_transactions_global; 5482event_name count_star 5483transaction 8 5484execute dump_transactions_history; 5485event_name count(event_name) 5486transaction 8 5487execute dump_accounts; 5488USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5489root localhost 1 1 5490user1 localhost 0 1 5491user2 localhost 0 1 5492user3 localhost 0 1 5493user4 localhost 0 1 5494execute dump_users; 5495USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5496root 1 1 5497user1 0 1 5498user2 0 1 5499user3 0 1 5500user4 0 1 5501execute dump_hosts; 5502HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5503localhost 1 5 5504truncate performance_schema.events_transactions_summary_by_thread_by_event_name; 5505"================== TRANSACTIONS_BY_THREAD truncated ==================" 5506"================== Step 29 ==================" 5507call dump_thread(); 5508username status 5509user1 not found 5510username status 5511user2 not found 5512username status 5513user3 not found 5514username status 5515user4 not found 5516execute dump_waits_account; 5517user host event_name count_star 5518user1 localhost wait/io/file/sql/query_log 0 5519user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 5520user2 localhost wait/io/file/sql/query_log 0 5521user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 5522user3 localhost wait/io/file/sql/query_log 0 5523user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 5524user4 localhost wait/io/file/sql/query_log 0 5525user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 5526execute dump_waits_user; 5527user event_name count_star 5528user1 wait/io/file/sql/query_log 0 5529user1 wait/synch/rwlock/sql/LOCK_grant 0 5530user2 wait/io/file/sql/query_log 0 5531user2 wait/synch/rwlock/sql/LOCK_grant 0 5532user3 wait/io/file/sql/query_log 0 5533user3 wait/synch/rwlock/sql/LOCK_grant 0 5534user4 wait/io/file/sql/query_log 0 5535user4 wait/synch/rwlock/sql/LOCK_grant 0 5536execute dump_waits_host; 5537host event_name count_star 5538localhost wait/io/file/sql/query_log 0 5539localhost wait/synch/rwlock/sql/LOCK_grant 0 5540execute dump_waits_global; 5541event_name count_star 5542wait/io/file/sql/query_log 0 5543wait/synch/rwlock/sql/LOCK_grant 0 5544execute dump_waits_history; 5545event_name count(event_name) 5546wait/io/file/sql/query_log 32 5547wait/synch/rwlock/sql/LOCK_grant 4 5548execute dump_stages_account; 5549user host event_name count_star 5550user1 localhost stage/sql/checking permissions 0 5551user1 localhost stage/sql/closing tables 0 5552user1 localhost stage/sql/init 0 5553user1 localhost stage/sql/Opening tables 0 5554user1 localhost stage/sql/starting 0 5555user2 localhost stage/sql/checking permissions 0 5556user2 localhost stage/sql/closing tables 0 5557user2 localhost stage/sql/init 0 5558user2 localhost stage/sql/Opening tables 0 5559user2 localhost stage/sql/starting 0 5560user3 localhost stage/sql/checking permissions 0 5561user3 localhost stage/sql/closing tables 0 5562user3 localhost stage/sql/init 0 5563user3 localhost stage/sql/Opening tables 0 5564user3 localhost stage/sql/starting 0 5565user4 localhost stage/sql/checking permissions 0 5566user4 localhost stage/sql/closing tables 0 5567user4 localhost stage/sql/init 0 5568user4 localhost stage/sql/Opening tables 0 5569user4 localhost stage/sql/starting 0 5570execute dump_stages_user; 5571user event_name count_star 5572user1 stage/sql/checking permissions 0 5573user1 stage/sql/closing tables 0 5574user1 stage/sql/init 0 5575user1 stage/sql/Opening tables 0 5576user1 stage/sql/starting 0 5577user2 stage/sql/checking permissions 0 5578user2 stage/sql/closing tables 0 5579user2 stage/sql/init 0 5580user2 stage/sql/Opening tables 0 5581user2 stage/sql/starting 0 5582user3 stage/sql/checking permissions 0 5583user3 stage/sql/closing tables 0 5584user3 stage/sql/init 0 5585user3 stage/sql/Opening tables 0 5586user3 stage/sql/starting 0 5587user4 stage/sql/checking permissions 0 5588user4 stage/sql/closing tables 0 5589user4 stage/sql/init 0 5590user4 stage/sql/Opening tables 0 5591user4 stage/sql/starting 0 5592execute dump_stages_host; 5593host event_name count_star 5594localhost stage/sql/checking permissions 0 5595localhost stage/sql/closing tables 0 5596localhost stage/sql/init 0 5597localhost stage/sql/Opening tables 0 5598localhost stage/sql/starting 0 5599execute dump_stages_global; 5600event_name count_star 5601stage/sql/checking permissions 0 5602stage/sql/closing tables 0 5603stage/sql/init 0 5604stage/sql/Opening tables 0 5605stage/sql/starting 0 5606execute dump_stages_history; 5607event_name count(event_name) 5608stage/sql/checking permissions 16 5609stage/sql/closing tables 41 5610stage/sql/init 12 5611stage/sql/Opening tables 25 5612stage/sql/starting 28 5613execute dump_statements_account; 5614user host event_name count_star 5615user1 localhost statement/com/Error 0 5616user1 localhost statement/com/Quit 0 5617user1 localhost statement/sp/freturn 0 5618user1 localhost statement/sql/insert 0 5619user1 localhost statement/sql/select 0 5620user2 localhost statement/com/Error 0 5621user2 localhost statement/com/Quit 0 5622user2 localhost statement/sp/freturn 0 5623user2 localhost statement/sql/insert 0 5624user2 localhost statement/sql/select 0 5625user3 localhost statement/com/Error 0 5626user3 localhost statement/com/Quit 0 5627user3 localhost statement/sp/freturn 0 5628user3 localhost statement/sql/insert 0 5629user3 localhost statement/sql/select 0 5630user4 localhost statement/com/Error 0 5631user4 localhost statement/com/Quit 0 5632user4 localhost statement/sp/freturn 0 5633user4 localhost statement/sql/insert 0 5634user4 localhost statement/sql/select 0 5635execute dump_statements_user; 5636user event_name count_star 5637user1 statement/com/Error 0 5638user1 statement/com/Quit 0 5639user1 statement/sp/freturn 0 5640user1 statement/sql/insert 0 5641user1 statement/sql/select 0 5642user2 statement/com/Error 0 5643user2 statement/com/Quit 0 5644user2 statement/sp/freturn 0 5645user2 statement/sql/insert 0 5646user2 statement/sql/select 0 5647user3 statement/com/Error 0 5648user3 statement/com/Quit 0 5649user3 statement/sp/freturn 0 5650user3 statement/sql/insert 0 5651user3 statement/sql/select 0 5652user4 statement/com/Error 0 5653user4 statement/com/Quit 0 5654user4 statement/sp/freturn 0 5655user4 statement/sql/insert 0 5656user4 statement/sql/select 0 5657execute dump_statements_host; 5658host event_name count_star 5659localhost statement/com/Error 0 5660localhost statement/com/Quit 0 5661localhost statement/sp/freturn 0 5662localhost statement/sql/insert 0 5663localhost statement/sql/select 0 5664execute dump_statements_global; 5665event_name count_star 5666statement/com/Error 0 5667statement/com/Quit 0 5668statement/sp/freturn 0 5669statement/sql/insert 0 5670statement/sql/select 0 5671execute dump_statements_history; 5672event_name count(event_name) 5673statement/com/Quit 4 5674statement/sp/freturn 4 5675statement/sql/insert 4 5676statement/sql/select 12 5677execute dump_transactions_account; 5678user host event_name count_star 5679user1 localhost transaction 2 5680user2 localhost transaction 2 5681user3 localhost transaction 2 5682user4 localhost transaction 2 5683execute dump_transactions_user; 5684user event_name count_star 5685user1 transaction 2 5686user2 transaction 2 5687user3 transaction 2 5688user4 transaction 2 5689execute dump_transactions_host; 5690host event_name count_star 5691localhost transaction 8 5692execute dump_transactions_global; 5693event_name count_star 5694transaction 8 5695execute dump_transactions_history; 5696event_name count(event_name) 5697transaction 8 5698execute dump_accounts; 5699USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5700root localhost 1 1 5701user1 localhost 0 1 5702user2 localhost 0 1 5703user3 localhost 0 1 5704user4 localhost 0 1 5705execute dump_users; 5706USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5707root 1 1 5708user1 0 1 5709user2 0 1 5710user3 0 1 5711user4 0 1 5712execute dump_hosts; 5713HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5714localhost 1 5 5715truncate performance_schema.events_transactions_summary_by_account_by_event_name; 5716"================== TRANSACTIONS_BY_ACCOUNT truncated ==================" 5717"================== Step 30 ==================" 5718call dump_thread(); 5719username status 5720user1 not found 5721username status 5722user2 not found 5723username status 5724user3 not found 5725username status 5726user4 not found 5727execute dump_waits_account; 5728user host event_name count_star 5729user1 localhost wait/io/file/sql/query_log 0 5730user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 5731user2 localhost wait/io/file/sql/query_log 0 5732user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 5733user3 localhost wait/io/file/sql/query_log 0 5734user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 5735user4 localhost wait/io/file/sql/query_log 0 5736user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 5737execute dump_waits_user; 5738user event_name count_star 5739user1 wait/io/file/sql/query_log 0 5740user1 wait/synch/rwlock/sql/LOCK_grant 0 5741user2 wait/io/file/sql/query_log 0 5742user2 wait/synch/rwlock/sql/LOCK_grant 0 5743user3 wait/io/file/sql/query_log 0 5744user3 wait/synch/rwlock/sql/LOCK_grant 0 5745user4 wait/io/file/sql/query_log 0 5746user4 wait/synch/rwlock/sql/LOCK_grant 0 5747execute dump_waits_host; 5748host event_name count_star 5749localhost wait/io/file/sql/query_log 0 5750localhost wait/synch/rwlock/sql/LOCK_grant 0 5751execute dump_waits_global; 5752event_name count_star 5753wait/io/file/sql/query_log 0 5754wait/synch/rwlock/sql/LOCK_grant 0 5755execute dump_waits_history; 5756event_name count(event_name) 5757wait/io/file/sql/query_log 32 5758wait/synch/rwlock/sql/LOCK_grant 4 5759execute dump_stages_account; 5760user host event_name count_star 5761user1 localhost stage/sql/checking permissions 0 5762user1 localhost stage/sql/closing tables 0 5763user1 localhost stage/sql/init 0 5764user1 localhost stage/sql/Opening tables 0 5765user1 localhost stage/sql/starting 0 5766user2 localhost stage/sql/checking permissions 0 5767user2 localhost stage/sql/closing tables 0 5768user2 localhost stage/sql/init 0 5769user2 localhost stage/sql/Opening tables 0 5770user2 localhost stage/sql/starting 0 5771user3 localhost stage/sql/checking permissions 0 5772user3 localhost stage/sql/closing tables 0 5773user3 localhost stage/sql/init 0 5774user3 localhost stage/sql/Opening tables 0 5775user3 localhost stage/sql/starting 0 5776user4 localhost stage/sql/checking permissions 0 5777user4 localhost stage/sql/closing tables 0 5778user4 localhost stage/sql/init 0 5779user4 localhost stage/sql/Opening tables 0 5780user4 localhost stage/sql/starting 0 5781execute dump_stages_user; 5782user event_name count_star 5783user1 stage/sql/checking permissions 0 5784user1 stage/sql/closing tables 0 5785user1 stage/sql/init 0 5786user1 stage/sql/Opening tables 0 5787user1 stage/sql/starting 0 5788user2 stage/sql/checking permissions 0 5789user2 stage/sql/closing tables 0 5790user2 stage/sql/init 0 5791user2 stage/sql/Opening tables 0 5792user2 stage/sql/starting 0 5793user3 stage/sql/checking permissions 0 5794user3 stage/sql/closing tables 0 5795user3 stage/sql/init 0 5796user3 stage/sql/Opening tables 0 5797user3 stage/sql/starting 0 5798user4 stage/sql/checking permissions 0 5799user4 stage/sql/closing tables 0 5800user4 stage/sql/init 0 5801user4 stage/sql/Opening tables 0 5802user4 stage/sql/starting 0 5803execute dump_stages_host; 5804host event_name count_star 5805localhost stage/sql/checking permissions 0 5806localhost stage/sql/closing tables 0 5807localhost stage/sql/init 0 5808localhost stage/sql/Opening tables 0 5809localhost stage/sql/starting 0 5810execute dump_stages_global; 5811event_name count_star 5812stage/sql/checking permissions 0 5813stage/sql/closing tables 0 5814stage/sql/init 0 5815stage/sql/Opening tables 0 5816stage/sql/starting 0 5817execute dump_stages_history; 5818event_name count(event_name) 5819stage/sql/checking permissions 16 5820stage/sql/closing tables 41 5821stage/sql/init 12 5822stage/sql/Opening tables 25 5823stage/sql/starting 28 5824execute dump_statements_account; 5825user host event_name count_star 5826user1 localhost statement/com/Error 0 5827user1 localhost statement/com/Quit 0 5828user1 localhost statement/sp/freturn 0 5829user1 localhost statement/sql/insert 0 5830user1 localhost statement/sql/select 0 5831user2 localhost statement/com/Error 0 5832user2 localhost statement/com/Quit 0 5833user2 localhost statement/sp/freturn 0 5834user2 localhost statement/sql/insert 0 5835user2 localhost statement/sql/select 0 5836user3 localhost statement/com/Error 0 5837user3 localhost statement/com/Quit 0 5838user3 localhost statement/sp/freturn 0 5839user3 localhost statement/sql/insert 0 5840user3 localhost statement/sql/select 0 5841user4 localhost statement/com/Error 0 5842user4 localhost statement/com/Quit 0 5843user4 localhost statement/sp/freturn 0 5844user4 localhost statement/sql/insert 0 5845user4 localhost statement/sql/select 0 5846execute dump_statements_user; 5847user event_name count_star 5848user1 statement/com/Error 0 5849user1 statement/com/Quit 0 5850user1 statement/sp/freturn 0 5851user1 statement/sql/insert 0 5852user1 statement/sql/select 0 5853user2 statement/com/Error 0 5854user2 statement/com/Quit 0 5855user2 statement/sp/freturn 0 5856user2 statement/sql/insert 0 5857user2 statement/sql/select 0 5858user3 statement/com/Error 0 5859user3 statement/com/Quit 0 5860user3 statement/sp/freturn 0 5861user3 statement/sql/insert 0 5862user3 statement/sql/select 0 5863user4 statement/com/Error 0 5864user4 statement/com/Quit 0 5865user4 statement/sp/freturn 0 5866user4 statement/sql/insert 0 5867user4 statement/sql/select 0 5868execute dump_statements_host; 5869host event_name count_star 5870localhost statement/com/Error 0 5871localhost statement/com/Quit 0 5872localhost statement/sp/freturn 0 5873localhost statement/sql/insert 0 5874localhost statement/sql/select 0 5875execute dump_statements_global; 5876event_name count_star 5877statement/com/Error 0 5878statement/com/Quit 0 5879statement/sp/freturn 0 5880statement/sql/insert 0 5881statement/sql/select 0 5882execute dump_statements_history; 5883event_name count(event_name) 5884statement/com/Quit 4 5885statement/sp/freturn 4 5886statement/sql/insert 4 5887statement/sql/select 12 5888execute dump_transactions_account; 5889user host event_name count_star 5890user1 localhost transaction 0 5891user2 localhost transaction 0 5892user3 localhost transaction 0 5893user4 localhost transaction 0 5894execute dump_transactions_user; 5895user event_name count_star 5896user1 transaction 2 5897user2 transaction 2 5898user3 transaction 2 5899user4 transaction 2 5900execute dump_transactions_host; 5901host event_name count_star 5902localhost transaction 8 5903execute dump_transactions_global; 5904event_name count_star 5905transaction 8 5906execute dump_transactions_history; 5907event_name count(event_name) 5908transaction 8 5909execute dump_accounts; 5910USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5911root localhost 1 1 5912user1 localhost 0 1 5913user2 localhost 0 1 5914user3 localhost 0 1 5915user4 localhost 0 1 5916execute dump_users; 5917USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5918root 1 1 5919user1 0 1 5920user2 0 1 5921user3 0 1 5922user4 0 1 5923execute dump_hosts; 5924HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 5925localhost 1 5 5926truncate performance_schema.events_transactions_summary_by_user_by_event_name; 5927"================== TRANSACTIONS_BY_USER truncated ==================" 5928"================== Step 31 ==================" 5929call dump_thread(); 5930username status 5931user1 not found 5932username status 5933user2 not found 5934username status 5935user3 not found 5936username status 5937user4 not found 5938execute dump_waits_account; 5939user host event_name count_star 5940user1 localhost wait/io/file/sql/query_log 0 5941user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 5942user2 localhost wait/io/file/sql/query_log 0 5943user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 5944user3 localhost wait/io/file/sql/query_log 0 5945user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 5946user4 localhost wait/io/file/sql/query_log 0 5947user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 5948execute dump_waits_user; 5949user event_name count_star 5950user1 wait/io/file/sql/query_log 0 5951user1 wait/synch/rwlock/sql/LOCK_grant 0 5952user2 wait/io/file/sql/query_log 0 5953user2 wait/synch/rwlock/sql/LOCK_grant 0 5954user3 wait/io/file/sql/query_log 0 5955user3 wait/synch/rwlock/sql/LOCK_grant 0 5956user4 wait/io/file/sql/query_log 0 5957user4 wait/synch/rwlock/sql/LOCK_grant 0 5958execute dump_waits_host; 5959host event_name count_star 5960localhost wait/io/file/sql/query_log 0 5961localhost wait/synch/rwlock/sql/LOCK_grant 0 5962execute dump_waits_global; 5963event_name count_star 5964wait/io/file/sql/query_log 0 5965wait/synch/rwlock/sql/LOCK_grant 0 5966execute dump_waits_history; 5967event_name count(event_name) 5968wait/io/file/sql/query_log 32 5969wait/synch/rwlock/sql/LOCK_grant 4 5970execute dump_stages_account; 5971user host event_name count_star 5972user1 localhost stage/sql/checking permissions 0 5973user1 localhost stage/sql/closing tables 0 5974user1 localhost stage/sql/init 0 5975user1 localhost stage/sql/Opening tables 0 5976user1 localhost stage/sql/starting 0 5977user2 localhost stage/sql/checking permissions 0 5978user2 localhost stage/sql/closing tables 0 5979user2 localhost stage/sql/init 0 5980user2 localhost stage/sql/Opening tables 0 5981user2 localhost stage/sql/starting 0 5982user3 localhost stage/sql/checking permissions 0 5983user3 localhost stage/sql/closing tables 0 5984user3 localhost stage/sql/init 0 5985user3 localhost stage/sql/Opening tables 0 5986user3 localhost stage/sql/starting 0 5987user4 localhost stage/sql/checking permissions 0 5988user4 localhost stage/sql/closing tables 0 5989user4 localhost stage/sql/init 0 5990user4 localhost stage/sql/Opening tables 0 5991user4 localhost stage/sql/starting 0 5992execute dump_stages_user; 5993user event_name count_star 5994user1 stage/sql/checking permissions 0 5995user1 stage/sql/closing tables 0 5996user1 stage/sql/init 0 5997user1 stage/sql/Opening tables 0 5998user1 stage/sql/starting 0 5999user2 stage/sql/checking permissions 0 6000user2 stage/sql/closing tables 0 6001user2 stage/sql/init 0 6002user2 stage/sql/Opening tables 0 6003user2 stage/sql/starting 0 6004user3 stage/sql/checking permissions 0 6005user3 stage/sql/closing tables 0 6006user3 stage/sql/init 0 6007user3 stage/sql/Opening tables 0 6008user3 stage/sql/starting 0 6009user4 stage/sql/checking permissions 0 6010user4 stage/sql/closing tables 0 6011user4 stage/sql/init 0 6012user4 stage/sql/Opening tables 0 6013user4 stage/sql/starting 0 6014execute dump_stages_host; 6015host event_name count_star 6016localhost stage/sql/checking permissions 0 6017localhost stage/sql/closing tables 0 6018localhost stage/sql/init 0 6019localhost stage/sql/Opening tables 0 6020localhost stage/sql/starting 0 6021execute dump_stages_global; 6022event_name count_star 6023stage/sql/checking permissions 0 6024stage/sql/closing tables 0 6025stage/sql/init 0 6026stage/sql/Opening tables 0 6027stage/sql/starting 0 6028execute dump_stages_history; 6029event_name count(event_name) 6030stage/sql/checking permissions 16 6031stage/sql/closing tables 41 6032stage/sql/init 12 6033stage/sql/Opening tables 25 6034stage/sql/starting 28 6035execute dump_statements_account; 6036user host event_name count_star 6037user1 localhost statement/com/Error 0 6038user1 localhost statement/com/Quit 0 6039user1 localhost statement/sp/freturn 0 6040user1 localhost statement/sql/insert 0 6041user1 localhost statement/sql/select 0 6042user2 localhost statement/com/Error 0 6043user2 localhost statement/com/Quit 0 6044user2 localhost statement/sp/freturn 0 6045user2 localhost statement/sql/insert 0 6046user2 localhost statement/sql/select 0 6047user3 localhost statement/com/Error 0 6048user3 localhost statement/com/Quit 0 6049user3 localhost statement/sp/freturn 0 6050user3 localhost statement/sql/insert 0 6051user3 localhost statement/sql/select 0 6052user4 localhost statement/com/Error 0 6053user4 localhost statement/com/Quit 0 6054user4 localhost statement/sp/freturn 0 6055user4 localhost statement/sql/insert 0 6056user4 localhost statement/sql/select 0 6057execute dump_statements_user; 6058user event_name count_star 6059user1 statement/com/Error 0 6060user1 statement/com/Quit 0 6061user1 statement/sp/freturn 0 6062user1 statement/sql/insert 0 6063user1 statement/sql/select 0 6064user2 statement/com/Error 0 6065user2 statement/com/Quit 0 6066user2 statement/sp/freturn 0 6067user2 statement/sql/insert 0 6068user2 statement/sql/select 0 6069user3 statement/com/Error 0 6070user3 statement/com/Quit 0 6071user3 statement/sp/freturn 0 6072user3 statement/sql/insert 0 6073user3 statement/sql/select 0 6074user4 statement/com/Error 0 6075user4 statement/com/Quit 0 6076user4 statement/sp/freturn 0 6077user4 statement/sql/insert 0 6078user4 statement/sql/select 0 6079execute dump_statements_host; 6080host event_name count_star 6081localhost statement/com/Error 0 6082localhost statement/com/Quit 0 6083localhost statement/sp/freturn 0 6084localhost statement/sql/insert 0 6085localhost statement/sql/select 0 6086execute dump_statements_global; 6087event_name count_star 6088statement/com/Error 0 6089statement/com/Quit 0 6090statement/sp/freturn 0 6091statement/sql/insert 0 6092statement/sql/select 0 6093execute dump_statements_history; 6094event_name count(event_name) 6095statement/com/Quit 4 6096statement/sp/freturn 4 6097statement/sql/insert 4 6098statement/sql/select 12 6099execute dump_transactions_account; 6100user host event_name count_star 6101user1 localhost transaction 0 6102user2 localhost transaction 0 6103user3 localhost transaction 0 6104user4 localhost transaction 0 6105execute dump_transactions_user; 6106user event_name count_star 6107user1 transaction 0 6108user2 transaction 0 6109user3 transaction 0 6110user4 transaction 0 6111execute dump_transactions_host; 6112host event_name count_star 6113localhost transaction 8 6114execute dump_transactions_global; 6115event_name count_star 6116transaction 8 6117execute dump_transactions_history; 6118event_name count(event_name) 6119transaction 8 6120execute dump_accounts; 6121USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6122root localhost 1 1 6123user1 localhost 0 1 6124user2 localhost 0 1 6125user3 localhost 0 1 6126user4 localhost 0 1 6127execute dump_users; 6128USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6129root 1 1 6130user1 0 1 6131user2 0 1 6132user3 0 1 6133user4 0 1 6134execute dump_hosts; 6135HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6136localhost 1 5 6137truncate performance_schema.events_transactions_summary_by_host_by_event_name; 6138"================== TRANSACTIONS_BY_HOST truncated ==================" 6139"================== Step 32 ==================" 6140call dump_thread(); 6141username status 6142user1 not found 6143username status 6144user2 not found 6145username status 6146user3 not found 6147username status 6148user4 not found 6149execute dump_waits_account; 6150user host event_name count_star 6151user1 localhost wait/io/file/sql/query_log 0 6152user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 6153user2 localhost wait/io/file/sql/query_log 0 6154user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 6155user3 localhost wait/io/file/sql/query_log 0 6156user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 6157user4 localhost wait/io/file/sql/query_log 0 6158user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 6159execute dump_waits_user; 6160user event_name count_star 6161user1 wait/io/file/sql/query_log 0 6162user1 wait/synch/rwlock/sql/LOCK_grant 0 6163user2 wait/io/file/sql/query_log 0 6164user2 wait/synch/rwlock/sql/LOCK_grant 0 6165user3 wait/io/file/sql/query_log 0 6166user3 wait/synch/rwlock/sql/LOCK_grant 0 6167user4 wait/io/file/sql/query_log 0 6168user4 wait/synch/rwlock/sql/LOCK_grant 0 6169execute dump_waits_host; 6170host event_name count_star 6171localhost wait/io/file/sql/query_log 0 6172localhost wait/synch/rwlock/sql/LOCK_grant 0 6173execute dump_waits_global; 6174event_name count_star 6175wait/io/file/sql/query_log 0 6176wait/synch/rwlock/sql/LOCK_grant 0 6177execute dump_waits_history; 6178event_name count(event_name) 6179wait/io/file/sql/query_log 32 6180wait/synch/rwlock/sql/LOCK_grant 4 6181execute dump_stages_account; 6182user host event_name count_star 6183user1 localhost stage/sql/checking permissions 0 6184user1 localhost stage/sql/closing tables 0 6185user1 localhost stage/sql/init 0 6186user1 localhost stage/sql/Opening tables 0 6187user1 localhost stage/sql/starting 0 6188user2 localhost stage/sql/checking permissions 0 6189user2 localhost stage/sql/closing tables 0 6190user2 localhost stage/sql/init 0 6191user2 localhost stage/sql/Opening tables 0 6192user2 localhost stage/sql/starting 0 6193user3 localhost stage/sql/checking permissions 0 6194user3 localhost stage/sql/closing tables 0 6195user3 localhost stage/sql/init 0 6196user3 localhost stage/sql/Opening tables 0 6197user3 localhost stage/sql/starting 0 6198user4 localhost stage/sql/checking permissions 0 6199user4 localhost stage/sql/closing tables 0 6200user4 localhost stage/sql/init 0 6201user4 localhost stage/sql/Opening tables 0 6202user4 localhost stage/sql/starting 0 6203execute dump_stages_user; 6204user event_name count_star 6205user1 stage/sql/checking permissions 0 6206user1 stage/sql/closing tables 0 6207user1 stage/sql/init 0 6208user1 stage/sql/Opening tables 0 6209user1 stage/sql/starting 0 6210user2 stage/sql/checking permissions 0 6211user2 stage/sql/closing tables 0 6212user2 stage/sql/init 0 6213user2 stage/sql/Opening tables 0 6214user2 stage/sql/starting 0 6215user3 stage/sql/checking permissions 0 6216user3 stage/sql/closing tables 0 6217user3 stage/sql/init 0 6218user3 stage/sql/Opening tables 0 6219user3 stage/sql/starting 0 6220user4 stage/sql/checking permissions 0 6221user4 stage/sql/closing tables 0 6222user4 stage/sql/init 0 6223user4 stage/sql/Opening tables 0 6224user4 stage/sql/starting 0 6225execute dump_stages_host; 6226host event_name count_star 6227localhost stage/sql/checking permissions 0 6228localhost stage/sql/closing tables 0 6229localhost stage/sql/init 0 6230localhost stage/sql/Opening tables 0 6231localhost stage/sql/starting 0 6232execute dump_stages_global; 6233event_name count_star 6234stage/sql/checking permissions 0 6235stage/sql/closing tables 0 6236stage/sql/init 0 6237stage/sql/Opening tables 0 6238stage/sql/starting 0 6239execute dump_stages_history; 6240event_name count(event_name) 6241stage/sql/checking permissions 16 6242stage/sql/closing tables 41 6243stage/sql/init 12 6244stage/sql/Opening tables 25 6245stage/sql/starting 28 6246execute dump_statements_account; 6247user host event_name count_star 6248user1 localhost statement/com/Error 0 6249user1 localhost statement/com/Quit 0 6250user1 localhost statement/sp/freturn 0 6251user1 localhost statement/sql/insert 0 6252user1 localhost statement/sql/select 0 6253user2 localhost statement/com/Error 0 6254user2 localhost statement/com/Quit 0 6255user2 localhost statement/sp/freturn 0 6256user2 localhost statement/sql/insert 0 6257user2 localhost statement/sql/select 0 6258user3 localhost statement/com/Error 0 6259user3 localhost statement/com/Quit 0 6260user3 localhost statement/sp/freturn 0 6261user3 localhost statement/sql/insert 0 6262user3 localhost statement/sql/select 0 6263user4 localhost statement/com/Error 0 6264user4 localhost statement/com/Quit 0 6265user4 localhost statement/sp/freturn 0 6266user4 localhost statement/sql/insert 0 6267user4 localhost statement/sql/select 0 6268execute dump_statements_user; 6269user event_name count_star 6270user1 statement/com/Error 0 6271user1 statement/com/Quit 0 6272user1 statement/sp/freturn 0 6273user1 statement/sql/insert 0 6274user1 statement/sql/select 0 6275user2 statement/com/Error 0 6276user2 statement/com/Quit 0 6277user2 statement/sp/freturn 0 6278user2 statement/sql/insert 0 6279user2 statement/sql/select 0 6280user3 statement/com/Error 0 6281user3 statement/com/Quit 0 6282user3 statement/sp/freturn 0 6283user3 statement/sql/insert 0 6284user3 statement/sql/select 0 6285user4 statement/com/Error 0 6286user4 statement/com/Quit 0 6287user4 statement/sp/freturn 0 6288user4 statement/sql/insert 0 6289user4 statement/sql/select 0 6290execute dump_statements_host; 6291host event_name count_star 6292localhost statement/com/Error 0 6293localhost statement/com/Quit 0 6294localhost statement/sp/freturn 0 6295localhost statement/sql/insert 0 6296localhost statement/sql/select 0 6297execute dump_statements_global; 6298event_name count_star 6299statement/com/Error 0 6300statement/com/Quit 0 6301statement/sp/freturn 0 6302statement/sql/insert 0 6303statement/sql/select 0 6304execute dump_statements_history; 6305event_name count(event_name) 6306statement/com/Quit 4 6307statement/sp/freturn 4 6308statement/sql/insert 4 6309statement/sql/select 12 6310execute dump_transactions_account; 6311user host event_name count_star 6312user1 localhost transaction 0 6313user2 localhost transaction 0 6314user3 localhost transaction 0 6315user4 localhost transaction 0 6316execute dump_transactions_user; 6317user event_name count_star 6318user1 transaction 0 6319user2 transaction 0 6320user3 transaction 0 6321user4 transaction 0 6322execute dump_transactions_host; 6323host event_name count_star 6324localhost transaction 0 6325execute dump_transactions_global; 6326event_name count_star 6327transaction 8 6328execute dump_transactions_history; 6329event_name count(event_name) 6330transaction 8 6331execute dump_accounts; 6332USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6333root localhost 1 1 6334user1 localhost 0 1 6335user2 localhost 0 1 6336user3 localhost 0 1 6337user4 localhost 0 1 6338execute dump_users; 6339USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6340root 1 1 6341user1 0 1 6342user2 0 1 6343user3 0 1 6344user4 0 1 6345execute dump_hosts; 6346HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6347localhost 1 5 6348truncate performance_schema.events_transactions_summary_global_by_event_name; 6349"================== TRANSACTIONS_GLOBAL truncated ==================" 6350"================== Step 33 ==================" 6351call dump_thread(); 6352username status 6353user1 not found 6354username status 6355user2 not found 6356username status 6357user3 not found 6358username status 6359user4 not found 6360execute dump_waits_account; 6361user host event_name count_star 6362user1 localhost wait/io/file/sql/query_log 0 6363user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 6364user2 localhost wait/io/file/sql/query_log 0 6365user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 6366user3 localhost wait/io/file/sql/query_log 0 6367user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 6368user4 localhost wait/io/file/sql/query_log 0 6369user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 6370execute dump_waits_user; 6371user event_name count_star 6372user1 wait/io/file/sql/query_log 0 6373user1 wait/synch/rwlock/sql/LOCK_grant 0 6374user2 wait/io/file/sql/query_log 0 6375user2 wait/synch/rwlock/sql/LOCK_grant 0 6376user3 wait/io/file/sql/query_log 0 6377user3 wait/synch/rwlock/sql/LOCK_grant 0 6378user4 wait/io/file/sql/query_log 0 6379user4 wait/synch/rwlock/sql/LOCK_grant 0 6380execute dump_waits_host; 6381host event_name count_star 6382localhost wait/io/file/sql/query_log 0 6383localhost wait/synch/rwlock/sql/LOCK_grant 0 6384execute dump_waits_global; 6385event_name count_star 6386wait/io/file/sql/query_log 0 6387wait/synch/rwlock/sql/LOCK_grant 0 6388execute dump_waits_history; 6389event_name count(event_name) 6390wait/io/file/sql/query_log 32 6391wait/synch/rwlock/sql/LOCK_grant 4 6392execute dump_stages_account; 6393user host event_name count_star 6394user1 localhost stage/sql/checking permissions 0 6395user1 localhost stage/sql/closing tables 0 6396user1 localhost stage/sql/init 0 6397user1 localhost stage/sql/Opening tables 0 6398user1 localhost stage/sql/starting 0 6399user2 localhost stage/sql/checking permissions 0 6400user2 localhost stage/sql/closing tables 0 6401user2 localhost stage/sql/init 0 6402user2 localhost stage/sql/Opening tables 0 6403user2 localhost stage/sql/starting 0 6404user3 localhost stage/sql/checking permissions 0 6405user3 localhost stage/sql/closing tables 0 6406user3 localhost stage/sql/init 0 6407user3 localhost stage/sql/Opening tables 0 6408user3 localhost stage/sql/starting 0 6409user4 localhost stage/sql/checking permissions 0 6410user4 localhost stage/sql/closing tables 0 6411user4 localhost stage/sql/init 0 6412user4 localhost stage/sql/Opening tables 0 6413user4 localhost stage/sql/starting 0 6414execute dump_stages_user; 6415user event_name count_star 6416user1 stage/sql/checking permissions 0 6417user1 stage/sql/closing tables 0 6418user1 stage/sql/init 0 6419user1 stage/sql/Opening tables 0 6420user1 stage/sql/starting 0 6421user2 stage/sql/checking permissions 0 6422user2 stage/sql/closing tables 0 6423user2 stage/sql/init 0 6424user2 stage/sql/Opening tables 0 6425user2 stage/sql/starting 0 6426user3 stage/sql/checking permissions 0 6427user3 stage/sql/closing tables 0 6428user3 stage/sql/init 0 6429user3 stage/sql/Opening tables 0 6430user3 stage/sql/starting 0 6431user4 stage/sql/checking permissions 0 6432user4 stage/sql/closing tables 0 6433user4 stage/sql/init 0 6434user4 stage/sql/Opening tables 0 6435user4 stage/sql/starting 0 6436execute dump_stages_host; 6437host event_name count_star 6438localhost stage/sql/checking permissions 0 6439localhost stage/sql/closing tables 0 6440localhost stage/sql/init 0 6441localhost stage/sql/Opening tables 0 6442localhost stage/sql/starting 0 6443execute dump_stages_global; 6444event_name count_star 6445stage/sql/checking permissions 0 6446stage/sql/closing tables 0 6447stage/sql/init 0 6448stage/sql/Opening tables 0 6449stage/sql/starting 0 6450execute dump_stages_history; 6451event_name count(event_name) 6452stage/sql/checking permissions 16 6453stage/sql/closing tables 41 6454stage/sql/init 12 6455stage/sql/Opening tables 25 6456stage/sql/starting 28 6457execute dump_statements_account; 6458user host event_name count_star 6459user1 localhost statement/com/Error 0 6460user1 localhost statement/com/Quit 0 6461user1 localhost statement/sp/freturn 0 6462user1 localhost statement/sql/insert 0 6463user1 localhost statement/sql/select 0 6464user2 localhost statement/com/Error 0 6465user2 localhost statement/com/Quit 0 6466user2 localhost statement/sp/freturn 0 6467user2 localhost statement/sql/insert 0 6468user2 localhost statement/sql/select 0 6469user3 localhost statement/com/Error 0 6470user3 localhost statement/com/Quit 0 6471user3 localhost statement/sp/freturn 0 6472user3 localhost statement/sql/insert 0 6473user3 localhost statement/sql/select 0 6474user4 localhost statement/com/Error 0 6475user4 localhost statement/com/Quit 0 6476user4 localhost statement/sp/freturn 0 6477user4 localhost statement/sql/insert 0 6478user4 localhost statement/sql/select 0 6479execute dump_statements_user; 6480user event_name count_star 6481user1 statement/com/Error 0 6482user1 statement/com/Quit 0 6483user1 statement/sp/freturn 0 6484user1 statement/sql/insert 0 6485user1 statement/sql/select 0 6486user2 statement/com/Error 0 6487user2 statement/com/Quit 0 6488user2 statement/sp/freturn 0 6489user2 statement/sql/insert 0 6490user2 statement/sql/select 0 6491user3 statement/com/Error 0 6492user3 statement/com/Quit 0 6493user3 statement/sp/freturn 0 6494user3 statement/sql/insert 0 6495user3 statement/sql/select 0 6496user4 statement/com/Error 0 6497user4 statement/com/Quit 0 6498user4 statement/sp/freturn 0 6499user4 statement/sql/insert 0 6500user4 statement/sql/select 0 6501execute dump_statements_host; 6502host event_name count_star 6503localhost statement/com/Error 0 6504localhost statement/com/Quit 0 6505localhost statement/sp/freturn 0 6506localhost statement/sql/insert 0 6507localhost statement/sql/select 0 6508execute dump_statements_global; 6509event_name count_star 6510statement/com/Error 0 6511statement/com/Quit 0 6512statement/sp/freturn 0 6513statement/sql/insert 0 6514statement/sql/select 0 6515execute dump_statements_history; 6516event_name count(event_name) 6517statement/com/Quit 4 6518statement/sp/freturn 4 6519statement/sql/insert 4 6520statement/sql/select 12 6521execute dump_transactions_account; 6522user host event_name count_star 6523user1 localhost transaction 0 6524user2 localhost transaction 0 6525user3 localhost transaction 0 6526user4 localhost transaction 0 6527execute dump_transactions_user; 6528user event_name count_star 6529user1 transaction 0 6530user2 transaction 0 6531user3 transaction 0 6532user4 transaction 0 6533execute dump_transactions_host; 6534host event_name count_star 6535localhost transaction 0 6536execute dump_transactions_global; 6537event_name count_star 6538transaction 0 6539execute dump_transactions_history; 6540event_name count(event_name) 6541transaction 8 6542execute dump_accounts; 6543USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6544root localhost 1 1 6545user1 localhost 0 1 6546user2 localhost 0 1 6547user3 localhost 0 1 6548user4 localhost 0 1 6549execute dump_users; 6550USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6551root 1 1 6552user1 0 1 6553user2 0 1 6554user3 0 1 6555user4 0 1 6556execute dump_hosts; 6557HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6558localhost 1 5 6559truncate performance_schema.accounts; 6560"================== ACCOUNTS truncated ==================" 6561"================== Step 34 ==================" 6562call dump_thread(); 6563username status 6564user1 not found 6565username status 6566user2 not found 6567username status 6568user3 not found 6569username status 6570user4 not found 6571execute dump_waits_account; 6572user host event_name count_star 6573execute dump_waits_user; 6574user event_name count_star 6575user1 wait/io/file/sql/query_log 0 6576user1 wait/synch/rwlock/sql/LOCK_grant 0 6577user2 wait/io/file/sql/query_log 0 6578user2 wait/synch/rwlock/sql/LOCK_grant 0 6579user3 wait/io/file/sql/query_log 0 6580user3 wait/synch/rwlock/sql/LOCK_grant 0 6581user4 wait/io/file/sql/query_log 0 6582user4 wait/synch/rwlock/sql/LOCK_grant 0 6583execute dump_waits_host; 6584host event_name count_star 6585localhost wait/io/file/sql/query_log 0 6586localhost wait/synch/rwlock/sql/LOCK_grant 0 6587execute dump_waits_global; 6588event_name count_star 6589wait/io/file/sql/query_log 0 6590wait/synch/rwlock/sql/LOCK_grant 0 6591execute dump_waits_history; 6592event_name count(event_name) 6593wait/io/file/sql/query_log 32 6594wait/synch/rwlock/sql/LOCK_grant 4 6595execute dump_stages_account; 6596user host event_name count_star 6597execute dump_stages_user; 6598user event_name count_star 6599user1 stage/sql/checking permissions 0 6600user1 stage/sql/closing tables 0 6601user1 stage/sql/init 0 6602user1 stage/sql/Opening tables 0 6603user1 stage/sql/starting 0 6604user2 stage/sql/checking permissions 0 6605user2 stage/sql/closing tables 0 6606user2 stage/sql/init 0 6607user2 stage/sql/Opening tables 0 6608user2 stage/sql/starting 0 6609user3 stage/sql/checking permissions 0 6610user3 stage/sql/closing tables 0 6611user3 stage/sql/init 0 6612user3 stage/sql/Opening tables 0 6613user3 stage/sql/starting 0 6614user4 stage/sql/checking permissions 0 6615user4 stage/sql/closing tables 0 6616user4 stage/sql/init 0 6617user4 stage/sql/Opening tables 0 6618user4 stage/sql/starting 0 6619execute dump_stages_host; 6620host event_name count_star 6621localhost stage/sql/checking permissions 0 6622localhost stage/sql/closing tables 0 6623localhost stage/sql/init 0 6624localhost stage/sql/Opening tables 0 6625localhost stage/sql/starting 0 6626execute dump_stages_global; 6627event_name count_star 6628stage/sql/checking permissions 0 6629stage/sql/closing tables 0 6630stage/sql/init 0 6631stage/sql/Opening tables 0 6632stage/sql/starting 0 6633execute dump_stages_history; 6634event_name count(event_name) 6635stage/sql/checking permissions 16 6636stage/sql/closing tables 41 6637stage/sql/init 12 6638stage/sql/Opening tables 25 6639stage/sql/starting 28 6640execute dump_statements_account; 6641user host event_name count_star 6642execute dump_statements_user; 6643user event_name count_star 6644user1 statement/com/Error 0 6645user1 statement/com/Quit 0 6646user1 statement/sp/freturn 0 6647user1 statement/sql/insert 0 6648user1 statement/sql/select 0 6649user2 statement/com/Error 0 6650user2 statement/com/Quit 0 6651user2 statement/sp/freturn 0 6652user2 statement/sql/insert 0 6653user2 statement/sql/select 0 6654user3 statement/com/Error 0 6655user3 statement/com/Quit 0 6656user3 statement/sp/freturn 0 6657user3 statement/sql/insert 0 6658user3 statement/sql/select 0 6659user4 statement/com/Error 0 6660user4 statement/com/Quit 0 6661user4 statement/sp/freturn 0 6662user4 statement/sql/insert 0 6663user4 statement/sql/select 0 6664execute dump_statements_host; 6665host event_name count_star 6666localhost statement/com/Error 0 6667localhost statement/com/Quit 0 6668localhost statement/sp/freturn 0 6669localhost statement/sql/insert 0 6670localhost statement/sql/select 0 6671execute dump_statements_global; 6672event_name count_star 6673statement/com/Error 0 6674statement/com/Quit 0 6675statement/sp/freturn 0 6676statement/sql/insert 0 6677statement/sql/select 0 6678execute dump_statements_history; 6679event_name count(event_name) 6680statement/com/Quit 4 6681statement/sp/freturn 4 6682statement/sql/insert 4 6683statement/sql/select 12 6684execute dump_transactions_account; 6685user host event_name count_star 6686execute dump_transactions_user; 6687user event_name count_star 6688user1 transaction 0 6689user2 transaction 0 6690user3 transaction 0 6691user4 transaction 0 6692execute dump_transactions_host; 6693host event_name count_star 6694localhost transaction 0 6695execute dump_transactions_global; 6696event_name count_star 6697transaction 0 6698execute dump_transactions_history; 6699event_name count(event_name) 6700transaction 8 6701execute dump_accounts; 6702USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6703root localhost 1 1 6704execute dump_users; 6705USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6706root 1 1 6707user1 0 1 6708user2 0 1 6709user3 0 1 6710user4 0 1 6711execute dump_hosts; 6712HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6713localhost 1 5 6714truncate performance_schema.users; 6715"================== USERS truncated ==================" 6716"================== Step 35 ==================" 6717call dump_thread(); 6718username status 6719user1 not found 6720username status 6721user2 not found 6722username status 6723user3 not found 6724username status 6725user4 not found 6726execute dump_waits_account; 6727user host event_name count_star 6728execute dump_waits_user; 6729user event_name count_star 6730execute dump_waits_host; 6731host event_name count_star 6732localhost wait/io/file/sql/query_log 0 6733localhost wait/synch/rwlock/sql/LOCK_grant 0 6734execute dump_waits_global; 6735event_name count_star 6736wait/io/file/sql/query_log 0 6737wait/synch/rwlock/sql/LOCK_grant 0 6738execute dump_waits_history; 6739event_name count(event_name) 6740wait/io/file/sql/query_log 32 6741wait/synch/rwlock/sql/LOCK_grant 4 6742execute dump_stages_account; 6743user host event_name count_star 6744execute dump_stages_user; 6745user event_name count_star 6746execute dump_stages_host; 6747host event_name count_star 6748localhost stage/sql/checking permissions 0 6749localhost stage/sql/closing tables 0 6750localhost stage/sql/init 0 6751localhost stage/sql/Opening tables 0 6752localhost stage/sql/starting 0 6753execute dump_stages_global; 6754event_name count_star 6755stage/sql/checking permissions 0 6756stage/sql/closing tables 0 6757stage/sql/init 0 6758stage/sql/Opening tables 0 6759stage/sql/starting 0 6760execute dump_stages_history; 6761event_name count(event_name) 6762stage/sql/checking permissions 16 6763stage/sql/closing tables 41 6764stage/sql/init 12 6765stage/sql/Opening tables 25 6766stage/sql/starting 28 6767execute dump_statements_account; 6768user host event_name count_star 6769execute dump_statements_user; 6770user event_name count_star 6771execute dump_statements_host; 6772host event_name count_star 6773localhost statement/com/Error 0 6774localhost statement/com/Quit 0 6775localhost statement/sp/freturn 0 6776localhost statement/sql/insert 0 6777localhost statement/sql/select 0 6778execute dump_statements_global; 6779event_name count_star 6780statement/com/Error 0 6781statement/com/Quit 0 6782statement/sp/freturn 0 6783statement/sql/insert 0 6784statement/sql/select 0 6785execute dump_statements_history; 6786event_name count(event_name) 6787statement/com/Quit 4 6788statement/sp/freturn 4 6789statement/sql/insert 4 6790statement/sql/select 12 6791execute dump_transactions_account; 6792user host event_name count_star 6793execute dump_transactions_user; 6794user event_name count_star 6795execute dump_transactions_host; 6796host event_name count_star 6797localhost transaction 0 6798execute dump_transactions_global; 6799event_name count_star 6800transaction 0 6801execute dump_transactions_history; 6802event_name count(event_name) 6803transaction 8 6804execute dump_accounts; 6805USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6806root localhost 1 1 6807execute dump_users; 6808USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6809root 1 1 6810execute dump_hosts; 6811HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6812localhost 1 5 6813truncate performance_schema.hosts; 6814"================== HOSTS truncated ==================" 6815"================== Step 36 ==================" 6816call dump_thread(); 6817username status 6818user1 not found 6819username status 6820user2 not found 6821username status 6822user3 not found 6823username status 6824user4 not found 6825execute dump_waits_account; 6826user host event_name count_star 6827execute dump_waits_user; 6828user event_name count_star 6829execute dump_waits_host; 6830host event_name count_star 6831localhost wait/io/file/sql/query_log 0 6832localhost wait/synch/rwlock/sql/LOCK_grant 0 6833execute dump_waits_global; 6834event_name count_star 6835wait/io/file/sql/query_log 0 6836wait/synch/rwlock/sql/LOCK_grant 0 6837execute dump_waits_history; 6838event_name count(event_name) 6839wait/io/file/sql/query_log 32 6840wait/synch/rwlock/sql/LOCK_grant 4 6841execute dump_stages_account; 6842user host event_name count_star 6843execute dump_stages_user; 6844user event_name count_star 6845execute dump_stages_host; 6846host event_name count_star 6847localhost stage/sql/checking permissions 0 6848localhost stage/sql/closing tables 0 6849localhost stage/sql/init 0 6850localhost stage/sql/Opening tables 0 6851localhost stage/sql/starting 0 6852execute dump_stages_global; 6853event_name count_star 6854stage/sql/checking permissions 0 6855stage/sql/closing tables 0 6856stage/sql/init 0 6857stage/sql/Opening tables 0 6858stage/sql/starting 0 6859execute dump_stages_history; 6860event_name count(event_name) 6861stage/sql/checking permissions 16 6862stage/sql/closing tables 41 6863stage/sql/init 12 6864stage/sql/Opening tables 25 6865stage/sql/starting 28 6866execute dump_statements_account; 6867user host event_name count_star 6868execute dump_statements_user; 6869user event_name count_star 6870execute dump_statements_host; 6871host event_name count_star 6872localhost statement/com/Error 0 6873localhost statement/com/Quit 0 6874localhost statement/sp/freturn 0 6875localhost statement/sql/insert 0 6876localhost statement/sql/select 0 6877execute dump_statements_global; 6878event_name count_star 6879statement/com/Error 0 6880statement/com/Quit 0 6881statement/sp/freturn 0 6882statement/sql/insert 0 6883statement/sql/select 0 6884execute dump_statements_history; 6885event_name count(event_name) 6886statement/com/Quit 4 6887statement/sp/freturn 4 6888statement/sql/insert 4 6889statement/sql/select 12 6890execute dump_transactions_account; 6891user host event_name count_star 6892execute dump_transactions_user; 6893user event_name count_star 6894execute dump_transactions_host; 6895host event_name count_star 6896localhost transaction 0 6897execute dump_transactions_global; 6898event_name count_star 6899transaction 0 6900execute dump_transactions_history; 6901event_name count(event_name) 6902transaction 8 6903execute dump_accounts; 6904USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6905root localhost 1 1 6906execute dump_users; 6907USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6908root 1 1 6909execute dump_hosts; 6910HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 6911localhost 1 1 6912