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/mutex/sql/LOCK_connection_count 0 19localhost wait/synch/mutex/sql/LOCK_user_locks 0 20localhost wait/synch/rwlock/sql/LOCK_grant 0 21execute dump_waits_global; 22event_name count_star 23wait/io/file/sql/query_log 0 24wait/synch/mutex/sql/LOCK_connection_count 0 25wait/synch/mutex/sql/LOCK_user_locks 0 26wait/synch/rwlock/sql/LOCK_grant 0 27execute dump_waits_history; 28event_name count(event_name) 29execute dump_stages_account; 30user host event_name count_star 31execute dump_stages_user; 32user event_name count_star 33execute dump_stages_host; 34host event_name count_star 35localhost stage/sql/checking permissions 0 36localhost stage/sql/closing tables 0 37localhost stage/sql/init 0 38localhost stage/sql/Opening tables 0 39execute dump_stages_global; 40event_name count_star 41stage/sql/checking permissions 0 42stage/sql/closing tables 0 43stage/sql/init 0 44stage/sql/Opening tables 0 45execute dump_stages_history; 46event_name count(event_name) 47execute dump_statements_account; 48user host event_name count_star 49execute dump_statements_user; 50user event_name count_star 51execute dump_statements_host; 52host event_name count_star 53localhost statement/com/Error 0 54localhost statement/com/Quit 0 55localhost statement/sql/insert 0 56localhost statement/sql/select 0 57execute dump_statements_global; 58event_name count_star 59statement/com/Error 0 60statement/com/Quit 0 61statement/sql/insert 0 62statement/sql/select 0 63execute dump_statements_history; 64event_name count(event_name) 65execute dump_accounts; 66USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 67root localhost 1 1 68execute dump_users; 69USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 70execute dump_hosts; 71HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 72localhost 1 1 73"================== con1 connected ==================" 74"================== Step 2 ==================" 75call dump_thread(); 76username event_name count_star 77user1 wait/io/file/sql/query_log 1 78user1 wait/synch/mutex/sql/LOCK_connection_count 0 79user1 wait/synch/mutex/sql/LOCK_user_locks 0 80user1 wait/synch/rwlock/sql/LOCK_grant 0 81username status 82user2 not found 83username status 84user3 not found 85username status 86user4 not found 87execute dump_waits_account; 88user host event_name count_star 89user1 localhost wait/io/file/sql/query_log 1 90user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 91user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 92user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 93execute dump_waits_user; 94user event_name count_star 95execute dump_waits_host; 96host event_name count_star 97localhost wait/io/file/sql/query_log 1 98localhost wait/synch/mutex/sql/LOCK_connection_count 0 99localhost wait/synch/mutex/sql/LOCK_user_locks 0 100localhost wait/synch/rwlock/sql/LOCK_grant 0 101execute dump_waits_global; 102event_name count_star 103wait/io/file/sql/query_log 1 104wait/synch/mutex/sql/LOCK_connection_count 0 105wait/synch/mutex/sql/LOCK_user_locks 0 106wait/synch/rwlock/sql/LOCK_grant 0 107execute dump_waits_history; 108event_name count(event_name) 109wait/io/file/sql/query_log 1 110execute dump_stages_account; 111user host event_name count_star 112user1 localhost stage/sql/checking permissions 0 113user1 localhost stage/sql/closing tables 0 114user1 localhost stage/sql/init 0 115user1 localhost stage/sql/Opening tables 0 116execute dump_stages_user; 117user event_name count_star 118execute dump_stages_host; 119host event_name count_star 120localhost stage/sql/checking permissions 0 121localhost stage/sql/closing tables 0 122localhost stage/sql/init 0 123localhost stage/sql/Opening tables 0 124execute dump_stages_global; 125event_name count_star 126stage/sql/checking permissions 0 127stage/sql/closing tables 0 128stage/sql/init 0 129stage/sql/Opening tables 0 130execute dump_stages_history; 131event_name count(event_name) 132execute dump_statements_account; 133user host event_name count_star 134user1 localhost statement/com/Error 0 135user1 localhost statement/com/Quit 0 136user1 localhost statement/sql/insert 0 137user1 localhost statement/sql/select 0 138execute dump_statements_user; 139user event_name count_star 140execute dump_statements_host; 141host event_name count_star 142localhost statement/com/Error 0 143localhost statement/com/Quit 0 144localhost statement/sql/insert 0 145localhost statement/sql/select 0 146execute dump_statements_global; 147event_name count_star 148statement/com/Error 0 149statement/com/Quit 0 150statement/sql/insert 0 151statement/sql/select 0 152execute dump_statements_history; 153event_name count(event_name) 154execute dump_accounts; 155USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 156root localhost 1 1 157user1 localhost 1 1 158execute dump_users; 159USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 160execute dump_hosts; 161HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 162localhost 2 2 163select get_lock("marker", 10); 164get_lock("marker", 10) 1651 166select release_lock("marker"); 167release_lock("marker") 1681 169insert into test.t1 values ("marker"); 170"================== con1 marker ==================" 171"================== Step 3 ==================" 172call dump_thread(); 173username event_name count_star 174user1 wait/io/file/sql/query_log 4 175user1 wait/synch/mutex/sql/LOCK_connection_count 0 176user1 wait/synch/mutex/sql/LOCK_user_locks 2 177user1 wait/synch/rwlock/sql/LOCK_grant 2 178username status 179user2 not found 180username status 181user3 not found 182username status 183user4 not found 184execute dump_waits_account; 185user host event_name count_star 186user1 localhost wait/io/file/sql/query_log 4 187user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 188user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 189user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 190execute dump_waits_user; 191user event_name count_star 192execute dump_waits_host; 193host event_name count_star 194localhost wait/io/file/sql/query_log 4 195localhost wait/synch/mutex/sql/LOCK_connection_count 0 196localhost wait/synch/mutex/sql/LOCK_user_locks 2 197localhost wait/synch/rwlock/sql/LOCK_grant 2 198execute dump_waits_global; 199event_name count_star 200wait/io/file/sql/query_log 4 201wait/synch/mutex/sql/LOCK_connection_count 0 202wait/synch/mutex/sql/LOCK_user_locks 2 203wait/synch/rwlock/sql/LOCK_grant 2 204execute dump_waits_history; 205event_name count(event_name) 206wait/io/file/sql/query_log 4 207wait/synch/mutex/sql/LOCK_user_locks 2 208wait/synch/rwlock/sql/LOCK_grant 2 209execute dump_stages_account; 210user host event_name count_star 211user1 localhost stage/sql/checking permissions 3 212user1 localhost stage/sql/closing tables 3 213user1 localhost stage/sql/init 6 214user1 localhost stage/sql/Opening tables 3 215execute dump_stages_user; 216user event_name count_star 217execute dump_stages_host; 218host event_name count_star 219localhost stage/sql/checking permissions 3 220localhost stage/sql/closing tables 3 221localhost stage/sql/init 6 222localhost stage/sql/Opening tables 3 223execute dump_stages_global; 224event_name count_star 225stage/sql/checking permissions 3 226stage/sql/closing tables 3 227stage/sql/init 6 228stage/sql/Opening tables 3 229execute dump_stages_history; 230event_name count(event_name) 231stage/sql/checking permissions 3 232stage/sql/closing tables 3 233stage/sql/init 6 234stage/sql/Opening tables 3 235execute dump_statements_account; 236user host event_name count_star 237user1 localhost statement/com/Error 0 238user1 localhost statement/com/Quit 0 239user1 localhost statement/sql/insert 1 240user1 localhost statement/sql/select 2 241execute dump_statements_user; 242user event_name count_star 243execute dump_statements_host; 244host event_name count_star 245localhost statement/com/Error 0 246localhost statement/com/Quit 0 247localhost statement/sql/insert 1 248localhost statement/sql/select 2 249execute dump_statements_global; 250event_name count_star 251statement/com/Error 0 252statement/com/Quit 0 253statement/sql/insert 1 254statement/sql/select 2 255execute dump_statements_history; 256event_name count(event_name) 257statement/sql/insert 1 258statement/sql/select 2 259execute dump_accounts; 260USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 261root localhost 1 1 262user1 localhost 1 1 263execute dump_users; 264USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 265execute dump_hosts; 266HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 267localhost 2 2 268"================== con2 connected ==================" 269"================== Step 4 ==================" 270call dump_thread(); 271username event_name count_star 272user1 wait/io/file/sql/query_log 4 273user1 wait/synch/mutex/sql/LOCK_connection_count 0 274user1 wait/synch/mutex/sql/LOCK_user_locks 2 275user1 wait/synch/rwlock/sql/LOCK_grant 2 276username event_name count_star 277user2 wait/io/file/sql/query_log 1 278user2 wait/synch/mutex/sql/LOCK_connection_count 0 279user2 wait/synch/mutex/sql/LOCK_user_locks 0 280user2 wait/synch/rwlock/sql/LOCK_grant 0 281username status 282user3 not found 283username status 284user4 not found 285execute dump_waits_account; 286user host event_name count_star 287user1 localhost wait/io/file/sql/query_log 4 288user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 289user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 290user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 291user2 localhost wait/io/file/sql/query_log 1 292user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 293user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 294user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 295execute dump_waits_user; 296user event_name count_star 297execute dump_waits_host; 298host event_name count_star 299localhost wait/io/file/sql/query_log 5 300localhost wait/synch/mutex/sql/LOCK_connection_count 0 301localhost wait/synch/mutex/sql/LOCK_user_locks 2 302localhost wait/synch/rwlock/sql/LOCK_grant 2 303execute dump_waits_global; 304event_name count_star 305wait/io/file/sql/query_log 5 306wait/synch/mutex/sql/LOCK_connection_count 0 307wait/synch/mutex/sql/LOCK_user_locks 2 308wait/synch/rwlock/sql/LOCK_grant 2 309execute dump_waits_history; 310event_name count(event_name) 311wait/io/file/sql/query_log 5 312wait/synch/mutex/sql/LOCK_user_locks 2 313wait/synch/rwlock/sql/LOCK_grant 2 314execute dump_stages_account; 315user host event_name count_star 316user1 localhost stage/sql/checking permissions 3 317user1 localhost stage/sql/closing tables 3 318user1 localhost stage/sql/init 6 319user1 localhost stage/sql/Opening tables 3 320user2 localhost stage/sql/checking permissions 0 321user2 localhost stage/sql/closing tables 0 322user2 localhost stage/sql/init 0 323user2 localhost stage/sql/Opening tables 0 324execute dump_stages_user; 325user event_name count_star 326execute dump_stages_host; 327host event_name count_star 328localhost stage/sql/checking permissions 3 329localhost stage/sql/closing tables 3 330localhost stage/sql/init 6 331localhost stage/sql/Opening tables 3 332execute dump_stages_global; 333event_name count_star 334stage/sql/checking permissions 3 335stage/sql/closing tables 3 336stage/sql/init 6 337stage/sql/Opening tables 3 338execute dump_stages_history; 339event_name count(event_name) 340stage/sql/checking permissions 3 341stage/sql/closing tables 3 342stage/sql/init 6 343stage/sql/Opening tables 3 344execute dump_statements_account; 345user host event_name count_star 346user1 localhost statement/com/Error 0 347user1 localhost statement/com/Quit 0 348user1 localhost statement/sql/insert 1 349user1 localhost statement/sql/select 2 350user2 localhost statement/com/Error 0 351user2 localhost statement/com/Quit 0 352user2 localhost statement/sql/insert 0 353user2 localhost statement/sql/select 0 354execute dump_statements_user; 355user event_name count_star 356execute dump_statements_host; 357host event_name count_star 358localhost statement/com/Error 0 359localhost statement/com/Quit 0 360localhost statement/sql/insert 1 361localhost statement/sql/select 2 362execute dump_statements_global; 363event_name count_star 364statement/com/Error 0 365statement/com/Quit 0 366statement/sql/insert 1 367statement/sql/select 2 368execute dump_statements_history; 369event_name count(event_name) 370statement/sql/insert 1 371statement/sql/select 2 372execute dump_accounts; 373USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 374root localhost 1 1 375user1 localhost 1 1 376user2 localhost 1 1 377execute dump_users; 378USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 379execute dump_hosts; 380HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 381localhost 3 3 382select get_lock("marker", 10); 383get_lock("marker", 10) 3841 385select release_lock("marker"); 386release_lock("marker") 3871 388insert into test.t1 values ("marker"); 389"================== con2 marker ==================" 390"================== Step 5 ==================" 391call dump_thread(); 392username event_name count_star 393user1 wait/io/file/sql/query_log 4 394user1 wait/synch/mutex/sql/LOCK_connection_count 0 395user1 wait/synch/mutex/sql/LOCK_user_locks 2 396user1 wait/synch/rwlock/sql/LOCK_grant 2 397username event_name count_star 398user2 wait/io/file/sql/query_log 4 399user2 wait/synch/mutex/sql/LOCK_connection_count 0 400user2 wait/synch/mutex/sql/LOCK_user_locks 2 401user2 wait/synch/rwlock/sql/LOCK_grant 2 402username status 403user3 not found 404username status 405user4 not found 406execute dump_waits_account; 407user host event_name count_star 408user1 localhost wait/io/file/sql/query_log 4 409user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 410user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 411user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 412user2 localhost wait/io/file/sql/query_log 4 413user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 414user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 415user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 416execute dump_waits_user; 417user event_name count_star 418execute dump_waits_host; 419host event_name count_star 420localhost wait/io/file/sql/query_log 8 421localhost wait/synch/mutex/sql/LOCK_connection_count 0 422localhost wait/synch/mutex/sql/LOCK_user_locks 4 423localhost wait/synch/rwlock/sql/LOCK_grant 4 424execute dump_waits_global; 425event_name count_star 426wait/io/file/sql/query_log 8 427wait/synch/mutex/sql/LOCK_connection_count 0 428wait/synch/mutex/sql/LOCK_user_locks 4 429wait/synch/rwlock/sql/LOCK_grant 4 430execute dump_waits_history; 431event_name count(event_name) 432wait/io/file/sql/query_log 8 433wait/synch/mutex/sql/LOCK_user_locks 4 434wait/synch/rwlock/sql/LOCK_grant 4 435execute dump_stages_account; 436user host event_name count_star 437user1 localhost stage/sql/checking permissions 3 438user1 localhost stage/sql/closing tables 3 439user1 localhost stage/sql/init 6 440user1 localhost stage/sql/Opening tables 3 441user2 localhost stage/sql/checking permissions 3 442user2 localhost stage/sql/closing tables 3 443user2 localhost stage/sql/init 6 444user2 localhost stage/sql/Opening tables 3 445execute dump_stages_user; 446user event_name count_star 447execute dump_stages_host; 448host event_name count_star 449localhost stage/sql/checking permissions 6 450localhost stage/sql/closing tables 6 451localhost stage/sql/init 12 452localhost stage/sql/Opening tables 6 453execute dump_stages_global; 454event_name count_star 455stage/sql/checking permissions 6 456stage/sql/closing tables 6 457stage/sql/init 12 458stage/sql/Opening tables 6 459execute dump_stages_history; 460event_name count(event_name) 461stage/sql/checking permissions 6 462stage/sql/closing tables 6 463stage/sql/init 12 464stage/sql/Opening tables 6 465execute dump_statements_account; 466user host event_name count_star 467user1 localhost statement/com/Error 0 468user1 localhost statement/com/Quit 0 469user1 localhost statement/sql/insert 1 470user1 localhost statement/sql/select 2 471user2 localhost statement/com/Error 0 472user2 localhost statement/com/Quit 0 473user2 localhost statement/sql/insert 1 474user2 localhost statement/sql/select 2 475execute dump_statements_user; 476user event_name count_star 477execute dump_statements_host; 478host event_name count_star 479localhost statement/com/Error 0 480localhost statement/com/Quit 0 481localhost statement/sql/insert 2 482localhost statement/sql/select 4 483execute dump_statements_global; 484event_name count_star 485statement/com/Error 0 486statement/com/Quit 0 487statement/sql/insert 2 488statement/sql/select 4 489execute dump_statements_history; 490event_name count(event_name) 491statement/sql/insert 2 492statement/sql/select 4 493execute dump_accounts; 494USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 495root localhost 1 1 496user1 localhost 1 1 497user2 localhost 1 1 498execute dump_users; 499USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 500execute dump_hosts; 501HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 502localhost 3 3 503"================== con3 connected ==================" 504"================== Step 6 ==================" 505call dump_thread(); 506username event_name count_star 507user1 wait/io/file/sql/query_log 4 508user1 wait/synch/mutex/sql/LOCK_connection_count 0 509user1 wait/synch/mutex/sql/LOCK_user_locks 2 510user1 wait/synch/rwlock/sql/LOCK_grant 2 511username event_name count_star 512user2 wait/io/file/sql/query_log 4 513user2 wait/synch/mutex/sql/LOCK_connection_count 0 514user2 wait/synch/mutex/sql/LOCK_user_locks 2 515user2 wait/synch/rwlock/sql/LOCK_grant 2 516username event_name count_star 517user3 wait/io/file/sql/query_log 1 518user3 wait/synch/mutex/sql/LOCK_connection_count 0 519user3 wait/synch/mutex/sql/LOCK_user_locks 0 520user3 wait/synch/rwlock/sql/LOCK_grant 0 521username status 522user4 not found 523execute dump_waits_account; 524user host event_name count_star 525user1 localhost wait/io/file/sql/query_log 4 526user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 527user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 528user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 529user2 localhost wait/io/file/sql/query_log 4 530user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 531user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 532user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 533user3 localhost wait/io/file/sql/query_log 1 534user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 535user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 536user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 537execute dump_waits_user; 538user event_name count_star 539execute dump_waits_host; 540host event_name count_star 541localhost wait/io/file/sql/query_log 9 542localhost wait/synch/mutex/sql/LOCK_connection_count 0 543localhost wait/synch/mutex/sql/LOCK_user_locks 4 544localhost wait/synch/rwlock/sql/LOCK_grant 4 545execute dump_waits_global; 546event_name count_star 547wait/io/file/sql/query_log 9 548wait/synch/mutex/sql/LOCK_connection_count 0 549wait/synch/mutex/sql/LOCK_user_locks 4 550wait/synch/rwlock/sql/LOCK_grant 4 551execute dump_waits_history; 552event_name count(event_name) 553wait/io/file/sql/query_log 9 554wait/synch/mutex/sql/LOCK_user_locks 4 555wait/synch/rwlock/sql/LOCK_grant 4 556execute dump_stages_account; 557user host event_name count_star 558user1 localhost stage/sql/checking permissions 3 559user1 localhost stage/sql/closing tables 3 560user1 localhost stage/sql/init 6 561user1 localhost stage/sql/Opening tables 3 562user2 localhost stage/sql/checking permissions 3 563user2 localhost stage/sql/closing tables 3 564user2 localhost stage/sql/init 6 565user2 localhost stage/sql/Opening tables 3 566user3 localhost stage/sql/checking permissions 0 567user3 localhost stage/sql/closing tables 0 568user3 localhost stage/sql/init 0 569user3 localhost stage/sql/Opening tables 0 570execute dump_stages_user; 571user event_name count_star 572execute dump_stages_host; 573host event_name count_star 574localhost stage/sql/checking permissions 6 575localhost stage/sql/closing tables 6 576localhost stage/sql/init 12 577localhost stage/sql/Opening tables 6 578execute dump_stages_global; 579event_name count_star 580stage/sql/checking permissions 6 581stage/sql/closing tables 6 582stage/sql/init 12 583stage/sql/Opening tables 6 584execute dump_stages_history; 585event_name count(event_name) 586stage/sql/checking permissions 6 587stage/sql/closing tables 6 588stage/sql/init 12 589stage/sql/Opening tables 6 590execute dump_statements_account; 591user host event_name count_star 592user1 localhost statement/com/Error 0 593user1 localhost statement/com/Quit 0 594user1 localhost statement/sql/insert 1 595user1 localhost statement/sql/select 2 596user2 localhost statement/com/Error 0 597user2 localhost statement/com/Quit 0 598user2 localhost statement/sql/insert 1 599user2 localhost statement/sql/select 2 600user3 localhost statement/com/Error 0 601user3 localhost statement/com/Quit 0 602user3 localhost statement/sql/insert 0 603user3 localhost statement/sql/select 0 604execute dump_statements_user; 605user event_name count_star 606execute dump_statements_host; 607host event_name count_star 608localhost statement/com/Error 0 609localhost statement/com/Quit 0 610localhost statement/sql/insert 2 611localhost statement/sql/select 4 612execute dump_statements_global; 613event_name count_star 614statement/com/Error 0 615statement/com/Quit 0 616statement/sql/insert 2 617statement/sql/select 4 618execute dump_statements_history; 619event_name count(event_name) 620statement/sql/insert 2 621statement/sql/select 4 622execute dump_accounts; 623USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 624root localhost 1 1 625user1 localhost 1 1 626user2 localhost 1 1 627user3 localhost 1 1 628execute dump_users; 629USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 630execute dump_hosts; 631HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 632localhost 4 4 633select get_lock("marker", 10); 634get_lock("marker", 10) 6351 636select release_lock("marker"); 637release_lock("marker") 6381 639insert into test.t1 values ("marker"); 640"================== con3 marker ==================" 641"================== Step 7 ==================" 642call dump_thread(); 643username event_name count_star 644user1 wait/io/file/sql/query_log 4 645user1 wait/synch/mutex/sql/LOCK_connection_count 0 646user1 wait/synch/mutex/sql/LOCK_user_locks 2 647user1 wait/synch/rwlock/sql/LOCK_grant 2 648username event_name count_star 649user2 wait/io/file/sql/query_log 4 650user2 wait/synch/mutex/sql/LOCK_connection_count 0 651user2 wait/synch/mutex/sql/LOCK_user_locks 2 652user2 wait/synch/rwlock/sql/LOCK_grant 2 653username event_name count_star 654user3 wait/io/file/sql/query_log 4 655user3 wait/synch/mutex/sql/LOCK_connection_count 0 656user3 wait/synch/mutex/sql/LOCK_user_locks 2 657user3 wait/synch/rwlock/sql/LOCK_grant 2 658username status 659user4 not found 660execute dump_waits_account; 661user host event_name count_star 662user1 localhost wait/io/file/sql/query_log 4 663user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 664user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 665user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 666user2 localhost wait/io/file/sql/query_log 4 667user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 668user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 669user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 670user3 localhost wait/io/file/sql/query_log 4 671user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 672user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 673user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 674execute dump_waits_user; 675user event_name count_star 676execute dump_waits_host; 677host event_name count_star 678localhost wait/io/file/sql/query_log 12 679localhost wait/synch/mutex/sql/LOCK_connection_count 0 680localhost wait/synch/mutex/sql/LOCK_user_locks 6 681localhost wait/synch/rwlock/sql/LOCK_grant 6 682execute dump_waits_global; 683event_name count_star 684wait/io/file/sql/query_log 12 685wait/synch/mutex/sql/LOCK_connection_count 0 686wait/synch/mutex/sql/LOCK_user_locks 6 687wait/synch/rwlock/sql/LOCK_grant 6 688execute dump_waits_history; 689event_name count(event_name) 690wait/io/file/sql/query_log 12 691wait/synch/mutex/sql/LOCK_user_locks 6 692wait/synch/rwlock/sql/LOCK_grant 6 693execute dump_stages_account; 694user host event_name count_star 695user1 localhost stage/sql/checking permissions 3 696user1 localhost stage/sql/closing tables 3 697user1 localhost stage/sql/init 6 698user1 localhost stage/sql/Opening tables 3 699user2 localhost stage/sql/checking permissions 3 700user2 localhost stage/sql/closing tables 3 701user2 localhost stage/sql/init 6 702user2 localhost stage/sql/Opening tables 3 703user3 localhost stage/sql/checking permissions 3 704user3 localhost stage/sql/closing tables 3 705user3 localhost stage/sql/init 6 706user3 localhost stage/sql/Opening tables 3 707execute dump_stages_user; 708user event_name count_star 709execute dump_stages_host; 710host event_name count_star 711localhost stage/sql/checking permissions 9 712localhost stage/sql/closing tables 9 713localhost stage/sql/init 18 714localhost stage/sql/Opening tables 9 715execute dump_stages_global; 716event_name count_star 717stage/sql/checking permissions 9 718stage/sql/closing tables 9 719stage/sql/init 18 720stage/sql/Opening tables 9 721execute dump_stages_history; 722event_name count(event_name) 723stage/sql/checking permissions 9 724stage/sql/closing tables 9 725stage/sql/init 18 726stage/sql/Opening tables 9 727execute dump_statements_account; 728user host event_name count_star 729user1 localhost statement/com/Error 0 730user1 localhost statement/com/Quit 0 731user1 localhost statement/sql/insert 1 732user1 localhost statement/sql/select 2 733user2 localhost statement/com/Error 0 734user2 localhost statement/com/Quit 0 735user2 localhost statement/sql/insert 1 736user2 localhost statement/sql/select 2 737user3 localhost statement/com/Error 0 738user3 localhost statement/com/Quit 0 739user3 localhost statement/sql/insert 1 740user3 localhost statement/sql/select 2 741execute dump_statements_user; 742user event_name count_star 743execute dump_statements_host; 744host event_name count_star 745localhost statement/com/Error 0 746localhost statement/com/Quit 0 747localhost statement/sql/insert 3 748localhost statement/sql/select 6 749execute dump_statements_global; 750event_name count_star 751statement/com/Error 0 752statement/com/Quit 0 753statement/sql/insert 3 754statement/sql/select 6 755execute dump_statements_history; 756event_name count(event_name) 757statement/sql/insert 3 758statement/sql/select 6 759execute dump_accounts; 760USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 761root localhost 1 1 762user1 localhost 1 1 763user2 localhost 1 1 764user3 localhost 1 1 765execute dump_users; 766USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 767execute dump_hosts; 768HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 769localhost 4 4 770"================== con4 connected ==================" 771"================== Step 8 ==================" 772call dump_thread(); 773username event_name count_star 774user1 wait/io/file/sql/query_log 4 775user1 wait/synch/mutex/sql/LOCK_connection_count 0 776user1 wait/synch/mutex/sql/LOCK_user_locks 2 777user1 wait/synch/rwlock/sql/LOCK_grant 2 778username event_name count_star 779user2 wait/io/file/sql/query_log 4 780user2 wait/synch/mutex/sql/LOCK_connection_count 0 781user2 wait/synch/mutex/sql/LOCK_user_locks 2 782user2 wait/synch/rwlock/sql/LOCK_grant 2 783username event_name count_star 784user3 wait/io/file/sql/query_log 4 785user3 wait/synch/mutex/sql/LOCK_connection_count 0 786user3 wait/synch/mutex/sql/LOCK_user_locks 2 787user3 wait/synch/rwlock/sql/LOCK_grant 2 788username event_name count_star 789user4 wait/io/file/sql/query_log 1 790user4 wait/synch/mutex/sql/LOCK_connection_count 0 791user4 wait/synch/mutex/sql/LOCK_user_locks 0 792user4 wait/synch/rwlock/sql/LOCK_grant 0 793execute dump_waits_account; 794user host event_name count_star 795user1 localhost wait/io/file/sql/query_log 4 796user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 797user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 798user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 799user2 localhost wait/io/file/sql/query_log 4 800user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 801user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 802user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 803user3 localhost wait/io/file/sql/query_log 4 804user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 805user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 806user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 807user4 localhost wait/io/file/sql/query_log 1 808user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 809user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 810user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 811execute dump_waits_user; 812user event_name count_star 813execute dump_waits_host; 814host event_name count_star 815localhost wait/io/file/sql/query_log 13 816localhost wait/synch/mutex/sql/LOCK_connection_count 0 817localhost wait/synch/mutex/sql/LOCK_user_locks 6 818localhost wait/synch/rwlock/sql/LOCK_grant 6 819execute dump_waits_global; 820event_name count_star 821wait/io/file/sql/query_log 13 822wait/synch/mutex/sql/LOCK_connection_count 0 823wait/synch/mutex/sql/LOCK_user_locks 6 824wait/synch/rwlock/sql/LOCK_grant 6 825execute dump_waits_history; 826event_name count(event_name) 827wait/io/file/sql/query_log 13 828wait/synch/mutex/sql/LOCK_user_locks 6 829wait/synch/rwlock/sql/LOCK_grant 6 830execute dump_stages_account; 831user host event_name count_star 832user1 localhost stage/sql/checking permissions 3 833user1 localhost stage/sql/closing tables 3 834user1 localhost stage/sql/init 6 835user1 localhost stage/sql/Opening tables 3 836user2 localhost stage/sql/checking permissions 3 837user2 localhost stage/sql/closing tables 3 838user2 localhost stage/sql/init 6 839user2 localhost stage/sql/Opening tables 3 840user3 localhost stage/sql/checking permissions 3 841user3 localhost stage/sql/closing tables 3 842user3 localhost stage/sql/init 6 843user3 localhost stage/sql/Opening tables 3 844user4 localhost stage/sql/checking permissions 0 845user4 localhost stage/sql/closing tables 0 846user4 localhost stage/sql/init 0 847user4 localhost stage/sql/Opening tables 0 848execute dump_stages_user; 849user event_name count_star 850execute dump_stages_host; 851host event_name count_star 852localhost stage/sql/checking permissions 9 853localhost stage/sql/closing tables 9 854localhost stage/sql/init 18 855localhost stage/sql/Opening tables 9 856execute dump_stages_global; 857event_name count_star 858stage/sql/checking permissions 9 859stage/sql/closing tables 9 860stage/sql/init 18 861stage/sql/Opening tables 9 862execute dump_stages_history; 863event_name count(event_name) 864stage/sql/checking permissions 9 865stage/sql/closing tables 9 866stage/sql/init 18 867stage/sql/Opening tables 9 868execute dump_statements_account; 869user host event_name count_star 870user1 localhost statement/com/Error 0 871user1 localhost statement/com/Quit 0 872user1 localhost statement/sql/insert 1 873user1 localhost statement/sql/select 2 874user2 localhost statement/com/Error 0 875user2 localhost statement/com/Quit 0 876user2 localhost statement/sql/insert 1 877user2 localhost statement/sql/select 2 878user3 localhost statement/com/Error 0 879user3 localhost statement/com/Quit 0 880user3 localhost statement/sql/insert 1 881user3 localhost statement/sql/select 2 882user4 localhost statement/com/Error 0 883user4 localhost statement/com/Quit 0 884user4 localhost statement/sql/insert 0 885user4 localhost statement/sql/select 0 886execute dump_statements_user; 887user event_name count_star 888execute dump_statements_host; 889host event_name count_star 890localhost statement/com/Error 0 891localhost statement/com/Quit 0 892localhost statement/sql/insert 3 893localhost statement/sql/select 6 894execute dump_statements_global; 895event_name count_star 896statement/com/Error 0 897statement/com/Quit 0 898statement/sql/insert 3 899statement/sql/select 6 900execute dump_statements_history; 901event_name count(event_name) 902statement/sql/insert 3 903statement/sql/select 6 904execute dump_accounts; 905USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 906root localhost 1 1 907user1 localhost 1 1 908user2 localhost 1 1 909user3 localhost 1 1 910user4 localhost 1 1 911execute dump_users; 912USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 913execute dump_hosts; 914HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 915localhost 5 5 916select get_lock("marker", 10); 917get_lock("marker", 10) 9181 919select release_lock("marker"); 920release_lock("marker") 9211 922insert into test.t1 values ("marker"); 923"================== con4 marker ==================" 924"================== Step 9 ==================" 925call dump_thread(); 926username event_name count_star 927user1 wait/io/file/sql/query_log 4 928user1 wait/synch/mutex/sql/LOCK_connection_count 0 929user1 wait/synch/mutex/sql/LOCK_user_locks 2 930user1 wait/synch/rwlock/sql/LOCK_grant 2 931username event_name count_star 932user2 wait/io/file/sql/query_log 4 933user2 wait/synch/mutex/sql/LOCK_connection_count 0 934user2 wait/synch/mutex/sql/LOCK_user_locks 2 935user2 wait/synch/rwlock/sql/LOCK_grant 2 936username event_name count_star 937user3 wait/io/file/sql/query_log 4 938user3 wait/synch/mutex/sql/LOCK_connection_count 0 939user3 wait/synch/mutex/sql/LOCK_user_locks 2 940user3 wait/synch/rwlock/sql/LOCK_grant 2 941username event_name count_star 942user4 wait/io/file/sql/query_log 4 943user4 wait/synch/mutex/sql/LOCK_connection_count 0 944user4 wait/synch/mutex/sql/LOCK_user_locks 2 945user4 wait/synch/rwlock/sql/LOCK_grant 2 946execute dump_waits_account; 947user host event_name count_star 948user1 localhost wait/io/file/sql/query_log 4 949user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 950user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 951user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 952user2 localhost wait/io/file/sql/query_log 4 953user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 954user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 955user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 956user3 localhost wait/io/file/sql/query_log 4 957user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 958user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 959user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 960user4 localhost wait/io/file/sql/query_log 4 961user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 962user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 963user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 964execute dump_waits_user; 965user event_name count_star 966execute dump_waits_host; 967host event_name count_star 968localhost wait/io/file/sql/query_log 16 969localhost wait/synch/mutex/sql/LOCK_connection_count 0 970localhost wait/synch/mutex/sql/LOCK_user_locks 8 971localhost wait/synch/rwlock/sql/LOCK_grant 8 972execute dump_waits_global; 973event_name count_star 974wait/io/file/sql/query_log 16 975wait/synch/mutex/sql/LOCK_connection_count 0 976wait/synch/mutex/sql/LOCK_user_locks 8 977wait/synch/rwlock/sql/LOCK_grant 8 978execute dump_waits_history; 979event_name count(event_name) 980wait/io/file/sql/query_log 16 981wait/synch/mutex/sql/LOCK_user_locks 8 982wait/synch/rwlock/sql/LOCK_grant 8 983execute dump_stages_account; 984user host event_name count_star 985user1 localhost stage/sql/checking permissions 3 986user1 localhost stage/sql/closing tables 3 987user1 localhost stage/sql/init 6 988user1 localhost stage/sql/Opening tables 3 989user2 localhost stage/sql/checking permissions 3 990user2 localhost stage/sql/closing tables 3 991user2 localhost stage/sql/init 6 992user2 localhost stage/sql/Opening tables 3 993user3 localhost stage/sql/checking permissions 3 994user3 localhost stage/sql/closing tables 3 995user3 localhost stage/sql/init 6 996user3 localhost stage/sql/Opening tables 3 997user4 localhost stage/sql/checking permissions 3 998user4 localhost stage/sql/closing tables 3 999user4 localhost stage/sql/init 6 1000user4 localhost stage/sql/Opening tables 3 1001execute dump_stages_user; 1002user event_name count_star 1003execute dump_stages_host; 1004host event_name count_star 1005localhost stage/sql/checking permissions 12 1006localhost stage/sql/closing tables 12 1007localhost stage/sql/init 24 1008localhost stage/sql/Opening tables 12 1009execute dump_stages_global; 1010event_name count_star 1011stage/sql/checking permissions 12 1012stage/sql/closing tables 12 1013stage/sql/init 24 1014stage/sql/Opening tables 12 1015execute dump_stages_history; 1016event_name count(event_name) 1017stage/sql/checking permissions 12 1018stage/sql/closing tables 12 1019stage/sql/init 24 1020stage/sql/Opening tables 12 1021execute dump_statements_account; 1022user host event_name count_star 1023user1 localhost statement/com/Error 0 1024user1 localhost statement/com/Quit 0 1025user1 localhost statement/sql/insert 1 1026user1 localhost statement/sql/select 2 1027user2 localhost statement/com/Error 0 1028user2 localhost statement/com/Quit 0 1029user2 localhost statement/sql/insert 1 1030user2 localhost statement/sql/select 2 1031user3 localhost statement/com/Error 0 1032user3 localhost statement/com/Quit 0 1033user3 localhost statement/sql/insert 1 1034user3 localhost statement/sql/select 2 1035user4 localhost statement/com/Error 0 1036user4 localhost statement/com/Quit 0 1037user4 localhost statement/sql/insert 1 1038user4 localhost statement/sql/select 2 1039execute dump_statements_user; 1040user event_name count_star 1041execute dump_statements_host; 1042host event_name count_star 1043localhost statement/com/Error 0 1044localhost statement/com/Quit 0 1045localhost statement/sql/insert 4 1046localhost statement/sql/select 8 1047execute dump_statements_global; 1048event_name count_star 1049statement/com/Error 0 1050statement/com/Quit 0 1051statement/sql/insert 4 1052statement/sql/select 8 1053execute dump_statements_history; 1054event_name count(event_name) 1055statement/sql/insert 4 1056statement/sql/select 8 1057execute dump_accounts; 1058USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1059root localhost 1 1 1060user1 localhost 1 1 1061user2 localhost 1 1 1062user3 localhost 1 1 1063user4 localhost 1 1 1064execute dump_users; 1065USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1066execute dump_hosts; 1067HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1068localhost 5 5 1069"================== con1 disconnected ==================" 1070"================== Step 10 ==================" 1071call dump_thread(); 1072username status 1073user1 not found 1074username event_name count_star 1075user2 wait/io/file/sql/query_log 4 1076user2 wait/synch/mutex/sql/LOCK_connection_count 0 1077user2 wait/synch/mutex/sql/LOCK_user_locks 2 1078user2 wait/synch/rwlock/sql/LOCK_grant 2 1079username event_name count_star 1080user3 wait/io/file/sql/query_log 4 1081user3 wait/synch/mutex/sql/LOCK_connection_count 0 1082user3 wait/synch/mutex/sql/LOCK_user_locks 2 1083user3 wait/synch/rwlock/sql/LOCK_grant 2 1084username event_name count_star 1085user4 wait/io/file/sql/query_log 4 1086user4 wait/synch/mutex/sql/LOCK_connection_count 0 1087user4 wait/synch/mutex/sql/LOCK_user_locks 2 1088user4 wait/synch/rwlock/sql/LOCK_grant 2 1089execute dump_waits_account; 1090user host event_name count_star 1091user1 localhost wait/io/file/sql/query_log 5 1092user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1093user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1094user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 1095user2 localhost wait/io/file/sql/query_log 4 1096user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1097user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1098user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 1099user3 localhost wait/io/file/sql/query_log 4 1100user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1101user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1102user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 1103user4 localhost wait/io/file/sql/query_log 4 1104user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1105user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1106user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 1107execute dump_waits_user; 1108user event_name count_star 1109execute dump_waits_host; 1110host event_name count_star 1111localhost wait/io/file/sql/query_log 17 1112localhost wait/synch/mutex/sql/LOCK_connection_count 1 1113localhost wait/synch/mutex/sql/LOCK_user_locks 8 1114localhost wait/synch/rwlock/sql/LOCK_grant 8 1115execute dump_waits_global; 1116event_name count_star 1117wait/io/file/sql/query_log 17 1118wait/synch/mutex/sql/LOCK_connection_count 1 1119wait/synch/mutex/sql/LOCK_user_locks 8 1120wait/synch/rwlock/sql/LOCK_grant 8 1121execute dump_waits_history; 1122event_name count(event_name) 1123wait/io/file/sql/query_log 17 1124wait/synch/mutex/sql/LOCK_connection_count 1 1125wait/synch/mutex/sql/LOCK_user_locks 8 1126wait/synch/rwlock/sql/LOCK_grant 8 1127execute dump_stages_account; 1128user host event_name count_star 1129user1 localhost stage/sql/checking permissions 3 1130user1 localhost stage/sql/closing tables 3 1131user1 localhost stage/sql/init 7 1132user1 localhost stage/sql/Opening tables 3 1133user2 localhost stage/sql/checking permissions 3 1134user2 localhost stage/sql/closing tables 3 1135user2 localhost stage/sql/init 6 1136user2 localhost stage/sql/Opening tables 3 1137user3 localhost stage/sql/checking permissions 3 1138user3 localhost stage/sql/closing tables 3 1139user3 localhost stage/sql/init 6 1140user3 localhost stage/sql/Opening tables 3 1141user4 localhost stage/sql/checking permissions 3 1142user4 localhost stage/sql/closing tables 3 1143user4 localhost stage/sql/init 6 1144user4 localhost stage/sql/Opening tables 3 1145execute dump_stages_user; 1146user event_name count_star 1147execute dump_stages_host; 1148host event_name count_star 1149localhost stage/sql/checking permissions 12 1150localhost stage/sql/closing tables 12 1151localhost stage/sql/init 25 1152localhost stage/sql/Opening tables 12 1153execute dump_stages_global; 1154event_name count_star 1155stage/sql/checking permissions 12 1156stage/sql/closing tables 12 1157stage/sql/init 25 1158stage/sql/Opening tables 12 1159execute dump_stages_history; 1160event_name count(event_name) 1161stage/sql/checking permissions 12 1162stage/sql/closing tables 12 1163stage/sql/init 25 1164stage/sql/Opening tables 12 1165execute dump_statements_account; 1166user host event_name count_star 1167user1 localhost statement/com/Error 0 1168user1 localhost statement/com/Quit 1 1169user1 localhost statement/sql/insert 1 1170user1 localhost statement/sql/select 2 1171user2 localhost statement/com/Error 0 1172user2 localhost statement/com/Quit 0 1173user2 localhost statement/sql/insert 1 1174user2 localhost statement/sql/select 2 1175user3 localhost statement/com/Error 0 1176user3 localhost statement/com/Quit 0 1177user3 localhost statement/sql/insert 1 1178user3 localhost statement/sql/select 2 1179user4 localhost statement/com/Error 0 1180user4 localhost statement/com/Quit 0 1181user4 localhost statement/sql/insert 1 1182user4 localhost statement/sql/select 2 1183execute dump_statements_user; 1184user event_name count_star 1185execute dump_statements_host; 1186host event_name count_star 1187localhost statement/com/Error 0 1188localhost statement/com/Quit 1 1189localhost statement/sql/insert 4 1190localhost statement/sql/select 8 1191execute dump_statements_global; 1192event_name count_star 1193statement/com/Error 0 1194statement/com/Quit 1 1195statement/sql/insert 4 1196statement/sql/select 8 1197execute dump_statements_history; 1198event_name count(event_name) 1199statement/com/Quit 1 1200statement/sql/insert 4 1201statement/sql/select 8 1202execute dump_accounts; 1203USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1204root localhost 1 1 1205user1 localhost 0 1 1206user2 localhost 1 1 1207user3 localhost 1 1 1208user4 localhost 1 1 1209execute dump_users; 1210USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1211execute dump_hosts; 1212HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1213localhost 4 5 1214"================== con2 disconnected ==================" 1215"================== Step 11 ==================" 1216call dump_thread(); 1217username status 1218user1 not found 1219username status 1220user2 not found 1221username event_name count_star 1222user3 wait/io/file/sql/query_log 4 1223user3 wait/synch/mutex/sql/LOCK_connection_count 0 1224user3 wait/synch/mutex/sql/LOCK_user_locks 2 1225user3 wait/synch/rwlock/sql/LOCK_grant 2 1226username event_name count_star 1227user4 wait/io/file/sql/query_log 4 1228user4 wait/synch/mutex/sql/LOCK_connection_count 0 1229user4 wait/synch/mutex/sql/LOCK_user_locks 2 1230user4 wait/synch/rwlock/sql/LOCK_grant 2 1231execute dump_waits_account; 1232user host event_name count_star 1233user1 localhost wait/io/file/sql/query_log 5 1234user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1235user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1236user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 1237user2 localhost wait/io/file/sql/query_log 5 1238user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1239user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1240user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 1241user3 localhost wait/io/file/sql/query_log 4 1242user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1243user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1244user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 1245user4 localhost wait/io/file/sql/query_log 4 1246user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1247user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1248user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 1249execute dump_waits_user; 1250user event_name count_star 1251execute dump_waits_host; 1252host event_name count_star 1253localhost wait/io/file/sql/query_log 18 1254localhost wait/synch/mutex/sql/LOCK_connection_count 2 1255localhost wait/synch/mutex/sql/LOCK_user_locks 8 1256localhost wait/synch/rwlock/sql/LOCK_grant 8 1257execute dump_waits_global; 1258event_name count_star 1259wait/io/file/sql/query_log 18 1260wait/synch/mutex/sql/LOCK_connection_count 2 1261wait/synch/mutex/sql/LOCK_user_locks 8 1262wait/synch/rwlock/sql/LOCK_grant 8 1263execute dump_waits_history; 1264event_name count(event_name) 1265wait/io/file/sql/query_log 18 1266wait/synch/mutex/sql/LOCK_connection_count 2 1267wait/synch/mutex/sql/LOCK_user_locks 8 1268wait/synch/rwlock/sql/LOCK_grant 8 1269execute dump_stages_account; 1270user host event_name count_star 1271user1 localhost stage/sql/checking permissions 3 1272user1 localhost stage/sql/closing tables 3 1273user1 localhost stage/sql/init 7 1274user1 localhost stage/sql/Opening tables 3 1275user2 localhost stage/sql/checking permissions 3 1276user2 localhost stage/sql/closing tables 3 1277user2 localhost stage/sql/init 7 1278user2 localhost stage/sql/Opening tables 3 1279user3 localhost stage/sql/checking permissions 3 1280user3 localhost stage/sql/closing tables 3 1281user3 localhost stage/sql/init 6 1282user3 localhost stage/sql/Opening tables 3 1283user4 localhost stage/sql/checking permissions 3 1284user4 localhost stage/sql/closing tables 3 1285user4 localhost stage/sql/init 6 1286user4 localhost stage/sql/Opening tables 3 1287execute dump_stages_user; 1288user event_name count_star 1289execute dump_stages_host; 1290host event_name count_star 1291localhost stage/sql/checking permissions 12 1292localhost stage/sql/closing tables 12 1293localhost stage/sql/init 26 1294localhost stage/sql/Opening tables 12 1295execute dump_stages_global; 1296event_name count_star 1297stage/sql/checking permissions 12 1298stage/sql/closing tables 12 1299stage/sql/init 26 1300stage/sql/Opening tables 12 1301execute dump_stages_history; 1302event_name count(event_name) 1303stage/sql/checking permissions 12 1304stage/sql/closing tables 12 1305stage/sql/init 26 1306stage/sql/Opening tables 12 1307execute dump_statements_account; 1308user host event_name count_star 1309user1 localhost statement/com/Error 0 1310user1 localhost statement/com/Quit 1 1311user1 localhost statement/sql/insert 1 1312user1 localhost statement/sql/select 2 1313user2 localhost statement/com/Error 0 1314user2 localhost statement/com/Quit 1 1315user2 localhost statement/sql/insert 1 1316user2 localhost statement/sql/select 2 1317user3 localhost statement/com/Error 0 1318user3 localhost statement/com/Quit 0 1319user3 localhost statement/sql/insert 1 1320user3 localhost statement/sql/select 2 1321user4 localhost statement/com/Error 0 1322user4 localhost statement/com/Quit 0 1323user4 localhost statement/sql/insert 1 1324user4 localhost statement/sql/select 2 1325execute dump_statements_user; 1326user event_name count_star 1327execute dump_statements_host; 1328host event_name count_star 1329localhost statement/com/Error 0 1330localhost statement/com/Quit 2 1331localhost statement/sql/insert 4 1332localhost statement/sql/select 8 1333execute dump_statements_global; 1334event_name count_star 1335statement/com/Error 0 1336statement/com/Quit 2 1337statement/sql/insert 4 1338statement/sql/select 8 1339execute dump_statements_history; 1340event_name count(event_name) 1341statement/com/Quit 2 1342statement/sql/insert 4 1343statement/sql/select 8 1344execute dump_accounts; 1345USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1346root localhost 1 1 1347user1 localhost 0 1 1348user2 localhost 0 1 1349user3 localhost 1 1 1350user4 localhost 1 1 1351execute dump_users; 1352USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1353execute dump_hosts; 1354HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1355localhost 3 5 1356"================== con3 disconnected ==================" 1357"================== Step 12 ==================" 1358call dump_thread(); 1359username status 1360user1 not found 1361username status 1362user2 not found 1363username status 1364user3 not found 1365username event_name count_star 1366user4 wait/io/file/sql/query_log 4 1367user4 wait/synch/mutex/sql/LOCK_connection_count 0 1368user4 wait/synch/mutex/sql/LOCK_user_locks 2 1369user4 wait/synch/rwlock/sql/LOCK_grant 2 1370execute dump_waits_account; 1371user host event_name count_star 1372user1 localhost wait/io/file/sql/query_log 5 1373user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1374user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1375user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 1376user2 localhost wait/io/file/sql/query_log 5 1377user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1378user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1379user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 1380user3 localhost wait/io/file/sql/query_log 5 1381user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1382user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1383user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 1384user4 localhost wait/io/file/sql/query_log 4 1385user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1386user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1387user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 1388execute dump_waits_user; 1389user event_name count_star 1390execute dump_waits_host; 1391host event_name count_star 1392localhost wait/io/file/sql/query_log 19 1393localhost wait/synch/mutex/sql/LOCK_connection_count 3 1394localhost wait/synch/mutex/sql/LOCK_user_locks 8 1395localhost wait/synch/rwlock/sql/LOCK_grant 8 1396execute dump_waits_global; 1397event_name count_star 1398wait/io/file/sql/query_log 19 1399wait/synch/mutex/sql/LOCK_connection_count 3 1400wait/synch/mutex/sql/LOCK_user_locks 8 1401wait/synch/rwlock/sql/LOCK_grant 8 1402execute dump_waits_history; 1403event_name count(event_name) 1404wait/io/file/sql/query_log 19 1405wait/synch/mutex/sql/LOCK_connection_count 3 1406wait/synch/mutex/sql/LOCK_user_locks 8 1407wait/synch/rwlock/sql/LOCK_grant 8 1408execute dump_stages_account; 1409user host event_name count_star 1410user1 localhost stage/sql/checking permissions 3 1411user1 localhost stage/sql/closing tables 3 1412user1 localhost stage/sql/init 7 1413user1 localhost stage/sql/Opening tables 3 1414user2 localhost stage/sql/checking permissions 3 1415user2 localhost stage/sql/closing tables 3 1416user2 localhost stage/sql/init 7 1417user2 localhost stage/sql/Opening tables 3 1418user3 localhost stage/sql/checking permissions 3 1419user3 localhost stage/sql/closing tables 3 1420user3 localhost stage/sql/init 7 1421user3 localhost stage/sql/Opening tables 3 1422user4 localhost stage/sql/checking permissions 3 1423user4 localhost stage/sql/closing tables 3 1424user4 localhost stage/sql/init 6 1425user4 localhost stage/sql/Opening tables 3 1426execute dump_stages_user; 1427user event_name count_star 1428execute dump_stages_host; 1429host event_name count_star 1430localhost stage/sql/checking permissions 12 1431localhost stage/sql/closing tables 12 1432localhost stage/sql/init 27 1433localhost stage/sql/Opening tables 12 1434execute dump_stages_global; 1435event_name count_star 1436stage/sql/checking permissions 12 1437stage/sql/closing tables 12 1438stage/sql/init 27 1439stage/sql/Opening tables 12 1440execute dump_stages_history; 1441event_name count(event_name) 1442stage/sql/checking permissions 12 1443stage/sql/closing tables 12 1444stage/sql/init 27 1445stage/sql/Opening tables 12 1446execute dump_statements_account; 1447user host event_name count_star 1448user1 localhost statement/com/Error 0 1449user1 localhost statement/com/Quit 1 1450user1 localhost statement/sql/insert 1 1451user1 localhost statement/sql/select 2 1452user2 localhost statement/com/Error 0 1453user2 localhost statement/com/Quit 1 1454user2 localhost statement/sql/insert 1 1455user2 localhost statement/sql/select 2 1456user3 localhost statement/com/Error 0 1457user3 localhost statement/com/Quit 1 1458user3 localhost statement/sql/insert 1 1459user3 localhost statement/sql/select 2 1460user4 localhost statement/com/Error 0 1461user4 localhost statement/com/Quit 0 1462user4 localhost statement/sql/insert 1 1463user4 localhost statement/sql/select 2 1464execute dump_statements_user; 1465user event_name count_star 1466execute dump_statements_host; 1467host event_name count_star 1468localhost statement/com/Error 0 1469localhost statement/com/Quit 3 1470localhost statement/sql/insert 4 1471localhost statement/sql/select 8 1472execute dump_statements_global; 1473event_name count_star 1474statement/com/Error 0 1475statement/com/Quit 3 1476statement/sql/insert 4 1477statement/sql/select 8 1478execute dump_statements_history; 1479event_name count(event_name) 1480statement/com/Quit 3 1481statement/sql/insert 4 1482statement/sql/select 8 1483execute dump_accounts; 1484USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1485root localhost 1 1 1486user1 localhost 0 1 1487user2 localhost 0 1 1488user3 localhost 0 1 1489user4 localhost 1 1 1490execute dump_users; 1491USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1492execute dump_hosts; 1493HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1494localhost 2 5 1495"================== con4 disconnected ==================" 1496"================== Step 13 ==================" 1497call dump_thread(); 1498username status 1499user1 not found 1500username status 1501user2 not found 1502username status 1503user3 not found 1504username status 1505user4 not found 1506execute dump_waits_account; 1507user host event_name count_star 1508user1 localhost wait/io/file/sql/query_log 5 1509user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1510user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1511user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 1512user2 localhost wait/io/file/sql/query_log 5 1513user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1514user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1515user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 1516user3 localhost wait/io/file/sql/query_log 5 1517user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1518user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1519user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 1520user4 localhost wait/io/file/sql/query_log 5 1521user4 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1522user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1523user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 1524execute dump_waits_user; 1525user event_name count_star 1526execute dump_waits_host; 1527host event_name count_star 1528localhost wait/io/file/sql/query_log 20 1529localhost wait/synch/mutex/sql/LOCK_connection_count 4 1530localhost wait/synch/mutex/sql/LOCK_user_locks 8 1531localhost wait/synch/rwlock/sql/LOCK_grant 8 1532execute dump_waits_global; 1533event_name count_star 1534wait/io/file/sql/query_log 20 1535wait/synch/mutex/sql/LOCK_connection_count 4 1536wait/synch/mutex/sql/LOCK_user_locks 8 1537wait/synch/rwlock/sql/LOCK_grant 8 1538execute dump_waits_history; 1539event_name count(event_name) 1540wait/io/file/sql/query_log 20 1541wait/synch/mutex/sql/LOCK_connection_count 4 1542wait/synch/mutex/sql/LOCK_user_locks 8 1543wait/synch/rwlock/sql/LOCK_grant 8 1544execute dump_stages_account; 1545user host event_name count_star 1546user1 localhost stage/sql/checking permissions 3 1547user1 localhost stage/sql/closing tables 3 1548user1 localhost stage/sql/init 7 1549user1 localhost stage/sql/Opening tables 3 1550user2 localhost stage/sql/checking permissions 3 1551user2 localhost stage/sql/closing tables 3 1552user2 localhost stage/sql/init 7 1553user2 localhost stage/sql/Opening tables 3 1554user3 localhost stage/sql/checking permissions 3 1555user3 localhost stage/sql/closing tables 3 1556user3 localhost stage/sql/init 7 1557user3 localhost stage/sql/Opening tables 3 1558user4 localhost stage/sql/checking permissions 3 1559user4 localhost stage/sql/closing tables 3 1560user4 localhost stage/sql/init 7 1561user4 localhost stage/sql/Opening tables 3 1562execute dump_stages_user; 1563user event_name count_star 1564execute dump_stages_host; 1565host event_name count_star 1566localhost stage/sql/checking permissions 12 1567localhost stage/sql/closing tables 12 1568localhost stage/sql/init 28 1569localhost stage/sql/Opening tables 12 1570execute dump_stages_global; 1571event_name count_star 1572stage/sql/checking permissions 12 1573stage/sql/closing tables 12 1574stage/sql/init 28 1575stage/sql/Opening tables 12 1576execute dump_stages_history; 1577event_name count(event_name) 1578stage/sql/checking permissions 12 1579stage/sql/closing tables 12 1580stage/sql/init 28 1581stage/sql/Opening tables 12 1582execute dump_statements_account; 1583user host event_name count_star 1584user1 localhost statement/com/Error 0 1585user1 localhost statement/com/Quit 1 1586user1 localhost statement/sql/insert 1 1587user1 localhost statement/sql/select 2 1588user2 localhost statement/com/Error 0 1589user2 localhost statement/com/Quit 1 1590user2 localhost statement/sql/insert 1 1591user2 localhost statement/sql/select 2 1592user3 localhost statement/com/Error 0 1593user3 localhost statement/com/Quit 1 1594user3 localhost statement/sql/insert 1 1595user3 localhost statement/sql/select 2 1596user4 localhost statement/com/Error 0 1597user4 localhost statement/com/Quit 1 1598user4 localhost statement/sql/insert 1 1599user4 localhost statement/sql/select 2 1600execute dump_statements_user; 1601user event_name count_star 1602execute dump_statements_host; 1603host event_name count_star 1604localhost statement/com/Error 0 1605localhost statement/com/Quit 4 1606localhost statement/sql/insert 4 1607localhost statement/sql/select 8 1608execute dump_statements_global; 1609event_name count_star 1610statement/com/Error 0 1611statement/com/Quit 4 1612statement/sql/insert 4 1613statement/sql/select 8 1614execute dump_statements_history; 1615event_name count(event_name) 1616statement/com/Quit 4 1617statement/sql/insert 4 1618statement/sql/select 8 1619execute dump_accounts; 1620USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1621root localhost 1 1 1622user1 localhost 0 1 1623user2 localhost 0 1 1624user3 localhost 0 1 1625user4 localhost 0 1 1626execute dump_users; 1627USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1628execute dump_hosts; 1629HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1630localhost 1 5 1631truncate performance_schema.events_waits_summary_by_thread_by_event_name; 1632"================== WAITS_BY_THREAD truncated ==================" 1633"================== Step 14 ==================" 1634call dump_thread(); 1635username status 1636user1 not found 1637username status 1638user2 not found 1639username status 1640user3 not found 1641username status 1642user4 not found 1643execute dump_waits_account; 1644user host event_name count_star 1645user1 localhost wait/io/file/sql/query_log 5 1646user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1647user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1648user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 1649user2 localhost wait/io/file/sql/query_log 5 1650user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1651user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1652user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 1653user3 localhost wait/io/file/sql/query_log 5 1654user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1655user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1656user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 1657user4 localhost wait/io/file/sql/query_log 5 1658user4 localhost wait/synch/mutex/sql/LOCK_connection_count 1 1659user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 1660user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 1661execute dump_waits_user; 1662user event_name count_star 1663execute dump_waits_host; 1664host event_name count_star 1665localhost wait/io/file/sql/query_log 20 1666localhost wait/synch/mutex/sql/LOCK_connection_count 4 1667localhost wait/synch/mutex/sql/LOCK_user_locks 8 1668localhost wait/synch/rwlock/sql/LOCK_grant 8 1669execute dump_waits_global; 1670event_name count_star 1671wait/io/file/sql/query_log 20 1672wait/synch/mutex/sql/LOCK_connection_count 4 1673wait/synch/mutex/sql/LOCK_user_locks 8 1674wait/synch/rwlock/sql/LOCK_grant 8 1675execute dump_waits_history; 1676event_name count(event_name) 1677wait/io/file/sql/query_log 20 1678wait/synch/mutex/sql/LOCK_connection_count 4 1679wait/synch/mutex/sql/LOCK_user_locks 8 1680wait/synch/rwlock/sql/LOCK_grant 8 1681execute dump_stages_account; 1682user host event_name count_star 1683user1 localhost stage/sql/checking permissions 3 1684user1 localhost stage/sql/closing tables 3 1685user1 localhost stage/sql/init 7 1686user1 localhost stage/sql/Opening tables 3 1687user2 localhost stage/sql/checking permissions 3 1688user2 localhost stage/sql/closing tables 3 1689user2 localhost stage/sql/init 7 1690user2 localhost stage/sql/Opening tables 3 1691user3 localhost stage/sql/checking permissions 3 1692user3 localhost stage/sql/closing tables 3 1693user3 localhost stage/sql/init 7 1694user3 localhost stage/sql/Opening tables 3 1695user4 localhost stage/sql/checking permissions 3 1696user4 localhost stage/sql/closing tables 3 1697user4 localhost stage/sql/init 7 1698user4 localhost stage/sql/Opening tables 3 1699execute dump_stages_user; 1700user event_name count_star 1701execute dump_stages_host; 1702host event_name count_star 1703localhost stage/sql/checking permissions 12 1704localhost stage/sql/closing tables 12 1705localhost stage/sql/init 28 1706localhost stage/sql/Opening tables 12 1707execute dump_stages_global; 1708event_name count_star 1709stage/sql/checking permissions 12 1710stage/sql/closing tables 12 1711stage/sql/init 28 1712stage/sql/Opening tables 12 1713execute dump_stages_history; 1714event_name count(event_name) 1715stage/sql/checking permissions 12 1716stage/sql/closing tables 12 1717stage/sql/init 28 1718stage/sql/Opening tables 12 1719execute dump_statements_account; 1720user host event_name count_star 1721user1 localhost statement/com/Error 0 1722user1 localhost statement/com/Quit 1 1723user1 localhost statement/sql/insert 1 1724user1 localhost statement/sql/select 2 1725user2 localhost statement/com/Error 0 1726user2 localhost statement/com/Quit 1 1727user2 localhost statement/sql/insert 1 1728user2 localhost statement/sql/select 2 1729user3 localhost statement/com/Error 0 1730user3 localhost statement/com/Quit 1 1731user3 localhost statement/sql/insert 1 1732user3 localhost statement/sql/select 2 1733user4 localhost statement/com/Error 0 1734user4 localhost statement/com/Quit 1 1735user4 localhost statement/sql/insert 1 1736user4 localhost statement/sql/select 2 1737execute dump_statements_user; 1738user event_name count_star 1739execute dump_statements_host; 1740host event_name count_star 1741localhost statement/com/Error 0 1742localhost statement/com/Quit 4 1743localhost statement/sql/insert 4 1744localhost statement/sql/select 8 1745execute dump_statements_global; 1746event_name count_star 1747statement/com/Error 0 1748statement/com/Quit 4 1749statement/sql/insert 4 1750statement/sql/select 8 1751execute dump_statements_history; 1752event_name count(event_name) 1753statement/com/Quit 4 1754statement/sql/insert 4 1755statement/sql/select 8 1756execute dump_accounts; 1757USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1758root localhost 1 1 1759user1 localhost 0 1 1760user2 localhost 0 1 1761user3 localhost 0 1 1762user4 localhost 0 1 1763execute dump_users; 1764USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1765execute dump_hosts; 1766HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1767localhost 1 5 1768truncate performance_schema.events_waits_summary_by_account_by_event_name; 1769"================== WAITS_BY_ACCOUNT truncated ==================" 1770"================== Step 15 ==================" 1771call dump_thread(); 1772username status 1773user1 not found 1774username status 1775user2 not found 1776username status 1777user3 not found 1778username status 1779user4 not found 1780execute dump_waits_account; 1781user host event_name count_star 1782user1 localhost wait/io/file/sql/query_log 0 1783user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1784user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1785user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 1786user2 localhost wait/io/file/sql/query_log 0 1787user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1788user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1789user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 1790user3 localhost wait/io/file/sql/query_log 0 1791user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1792user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1793user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 1794user4 localhost wait/io/file/sql/query_log 0 1795user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1796user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1797user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 1798execute dump_waits_user; 1799user event_name count_star 1800execute dump_waits_host; 1801host event_name count_star 1802localhost wait/io/file/sql/query_log 20 1803localhost wait/synch/mutex/sql/LOCK_connection_count 4 1804localhost wait/synch/mutex/sql/LOCK_user_locks 8 1805localhost wait/synch/rwlock/sql/LOCK_grant 8 1806execute dump_waits_global; 1807event_name count_star 1808wait/io/file/sql/query_log 20 1809wait/synch/mutex/sql/LOCK_connection_count 4 1810wait/synch/mutex/sql/LOCK_user_locks 8 1811wait/synch/rwlock/sql/LOCK_grant 8 1812execute dump_waits_history; 1813event_name count(event_name) 1814wait/io/file/sql/query_log 20 1815wait/synch/mutex/sql/LOCK_connection_count 4 1816wait/synch/mutex/sql/LOCK_user_locks 8 1817wait/synch/rwlock/sql/LOCK_grant 8 1818execute dump_stages_account; 1819user host event_name count_star 1820user1 localhost stage/sql/checking permissions 3 1821user1 localhost stage/sql/closing tables 3 1822user1 localhost stage/sql/init 7 1823user1 localhost stage/sql/Opening tables 3 1824user2 localhost stage/sql/checking permissions 3 1825user2 localhost stage/sql/closing tables 3 1826user2 localhost stage/sql/init 7 1827user2 localhost stage/sql/Opening tables 3 1828user3 localhost stage/sql/checking permissions 3 1829user3 localhost stage/sql/closing tables 3 1830user3 localhost stage/sql/init 7 1831user3 localhost stage/sql/Opening tables 3 1832user4 localhost stage/sql/checking permissions 3 1833user4 localhost stage/sql/closing tables 3 1834user4 localhost stage/sql/init 7 1835user4 localhost stage/sql/Opening tables 3 1836execute dump_stages_user; 1837user event_name count_star 1838execute dump_stages_host; 1839host event_name count_star 1840localhost stage/sql/checking permissions 12 1841localhost stage/sql/closing tables 12 1842localhost stage/sql/init 28 1843localhost stage/sql/Opening tables 12 1844execute dump_stages_global; 1845event_name count_star 1846stage/sql/checking permissions 12 1847stage/sql/closing tables 12 1848stage/sql/init 28 1849stage/sql/Opening tables 12 1850execute dump_stages_history; 1851event_name count(event_name) 1852stage/sql/checking permissions 12 1853stage/sql/closing tables 12 1854stage/sql/init 28 1855stage/sql/Opening tables 12 1856execute dump_statements_account; 1857user host event_name count_star 1858user1 localhost statement/com/Error 0 1859user1 localhost statement/com/Quit 1 1860user1 localhost statement/sql/insert 1 1861user1 localhost statement/sql/select 2 1862user2 localhost statement/com/Error 0 1863user2 localhost statement/com/Quit 1 1864user2 localhost statement/sql/insert 1 1865user2 localhost statement/sql/select 2 1866user3 localhost statement/com/Error 0 1867user3 localhost statement/com/Quit 1 1868user3 localhost statement/sql/insert 1 1869user3 localhost statement/sql/select 2 1870user4 localhost statement/com/Error 0 1871user4 localhost statement/com/Quit 1 1872user4 localhost statement/sql/insert 1 1873user4 localhost statement/sql/select 2 1874execute dump_statements_user; 1875user event_name count_star 1876execute dump_statements_host; 1877host event_name count_star 1878localhost statement/com/Error 0 1879localhost statement/com/Quit 4 1880localhost statement/sql/insert 4 1881localhost statement/sql/select 8 1882execute dump_statements_global; 1883event_name count_star 1884statement/com/Error 0 1885statement/com/Quit 4 1886statement/sql/insert 4 1887statement/sql/select 8 1888execute dump_statements_history; 1889event_name count(event_name) 1890statement/com/Quit 4 1891statement/sql/insert 4 1892statement/sql/select 8 1893execute dump_accounts; 1894USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1895root localhost 1 1 1896user1 localhost 0 1 1897user2 localhost 0 1 1898user3 localhost 0 1 1899user4 localhost 0 1 1900execute dump_users; 1901USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1902execute dump_hosts; 1903HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1904localhost 1 5 1905truncate performance_schema.events_waits_summary_by_user_by_event_name; 1906"================== WAITS_BY_USER truncated ==================" 1907"================== Step 16 ==================" 1908call dump_thread(); 1909username status 1910user1 not found 1911username status 1912user2 not found 1913username status 1914user3 not found 1915username status 1916user4 not found 1917execute dump_waits_account; 1918user host event_name count_star 1919user1 localhost wait/io/file/sql/query_log 0 1920user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1921user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1922user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 1923user2 localhost wait/io/file/sql/query_log 0 1924user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1925user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1926user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 1927user3 localhost wait/io/file/sql/query_log 0 1928user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1929user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1930user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 1931user4 localhost wait/io/file/sql/query_log 0 1932user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 1933user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 1934user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 1935execute dump_waits_user; 1936user event_name count_star 1937execute dump_waits_host; 1938host event_name count_star 1939localhost wait/io/file/sql/query_log 20 1940localhost wait/synch/mutex/sql/LOCK_connection_count 4 1941localhost wait/synch/mutex/sql/LOCK_user_locks 8 1942localhost wait/synch/rwlock/sql/LOCK_grant 8 1943execute dump_waits_global; 1944event_name count_star 1945wait/io/file/sql/query_log 20 1946wait/synch/mutex/sql/LOCK_connection_count 4 1947wait/synch/mutex/sql/LOCK_user_locks 8 1948wait/synch/rwlock/sql/LOCK_grant 8 1949execute dump_waits_history; 1950event_name count(event_name) 1951wait/io/file/sql/query_log 20 1952wait/synch/mutex/sql/LOCK_connection_count 4 1953wait/synch/mutex/sql/LOCK_user_locks 8 1954wait/synch/rwlock/sql/LOCK_grant 8 1955execute dump_stages_account; 1956user host event_name count_star 1957user1 localhost stage/sql/checking permissions 3 1958user1 localhost stage/sql/closing tables 3 1959user1 localhost stage/sql/init 7 1960user1 localhost stage/sql/Opening tables 3 1961user2 localhost stage/sql/checking permissions 3 1962user2 localhost stage/sql/closing tables 3 1963user2 localhost stage/sql/init 7 1964user2 localhost stage/sql/Opening tables 3 1965user3 localhost stage/sql/checking permissions 3 1966user3 localhost stage/sql/closing tables 3 1967user3 localhost stage/sql/init 7 1968user3 localhost stage/sql/Opening tables 3 1969user4 localhost stage/sql/checking permissions 3 1970user4 localhost stage/sql/closing tables 3 1971user4 localhost stage/sql/init 7 1972user4 localhost stage/sql/Opening tables 3 1973execute dump_stages_user; 1974user event_name count_star 1975execute dump_stages_host; 1976host event_name count_star 1977localhost stage/sql/checking permissions 12 1978localhost stage/sql/closing tables 12 1979localhost stage/sql/init 28 1980localhost stage/sql/Opening tables 12 1981execute dump_stages_global; 1982event_name count_star 1983stage/sql/checking permissions 12 1984stage/sql/closing tables 12 1985stage/sql/init 28 1986stage/sql/Opening tables 12 1987execute dump_stages_history; 1988event_name count(event_name) 1989stage/sql/checking permissions 12 1990stage/sql/closing tables 12 1991stage/sql/init 28 1992stage/sql/Opening tables 12 1993execute dump_statements_account; 1994user host event_name count_star 1995user1 localhost statement/com/Error 0 1996user1 localhost statement/com/Quit 1 1997user1 localhost statement/sql/insert 1 1998user1 localhost statement/sql/select 2 1999user2 localhost statement/com/Error 0 2000user2 localhost statement/com/Quit 1 2001user2 localhost statement/sql/insert 1 2002user2 localhost statement/sql/select 2 2003user3 localhost statement/com/Error 0 2004user3 localhost statement/com/Quit 1 2005user3 localhost statement/sql/insert 1 2006user3 localhost statement/sql/select 2 2007user4 localhost statement/com/Error 0 2008user4 localhost statement/com/Quit 1 2009user4 localhost statement/sql/insert 1 2010user4 localhost statement/sql/select 2 2011execute dump_statements_user; 2012user event_name count_star 2013execute dump_statements_host; 2014host event_name count_star 2015localhost statement/com/Error 0 2016localhost statement/com/Quit 4 2017localhost statement/sql/insert 4 2018localhost statement/sql/select 8 2019execute dump_statements_global; 2020event_name count_star 2021statement/com/Error 0 2022statement/com/Quit 4 2023statement/sql/insert 4 2024statement/sql/select 8 2025execute dump_statements_history; 2026event_name count(event_name) 2027statement/com/Quit 4 2028statement/sql/insert 4 2029statement/sql/select 8 2030execute dump_accounts; 2031USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2032root localhost 1 1 2033user1 localhost 0 1 2034user2 localhost 0 1 2035user3 localhost 0 1 2036user4 localhost 0 1 2037execute dump_users; 2038USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2039execute dump_hosts; 2040HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2041localhost 1 5 2042truncate performance_schema.events_waits_summary_by_host_by_event_name; 2043"================== WAITS_BY_HOST truncated ==================" 2044"================== Step 17 ==================" 2045call dump_thread(); 2046username status 2047user1 not found 2048username status 2049user2 not found 2050username status 2051user3 not found 2052username status 2053user4 not found 2054execute dump_waits_account; 2055user host event_name count_star 2056user1 localhost wait/io/file/sql/query_log 0 2057user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2058user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2059user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2060user2 localhost wait/io/file/sql/query_log 0 2061user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2062user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2063user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2064user3 localhost wait/io/file/sql/query_log 0 2065user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2066user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2067user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2068user4 localhost wait/io/file/sql/query_log 0 2069user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2070user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2071user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2072execute dump_waits_user; 2073user event_name count_star 2074execute dump_waits_host; 2075host event_name count_star 2076localhost wait/io/file/sql/query_log 0 2077localhost wait/synch/mutex/sql/LOCK_connection_count 0 2078localhost wait/synch/mutex/sql/LOCK_user_locks 0 2079localhost wait/synch/rwlock/sql/LOCK_grant 0 2080execute dump_waits_global; 2081event_name count_star 2082wait/io/file/sql/query_log 20 2083wait/synch/mutex/sql/LOCK_connection_count 4 2084wait/synch/mutex/sql/LOCK_user_locks 8 2085wait/synch/rwlock/sql/LOCK_grant 8 2086execute dump_waits_history; 2087event_name count(event_name) 2088wait/io/file/sql/query_log 20 2089wait/synch/mutex/sql/LOCK_connection_count 4 2090wait/synch/mutex/sql/LOCK_user_locks 8 2091wait/synch/rwlock/sql/LOCK_grant 8 2092execute dump_stages_account; 2093user host event_name count_star 2094user1 localhost stage/sql/checking permissions 3 2095user1 localhost stage/sql/closing tables 3 2096user1 localhost stage/sql/init 7 2097user1 localhost stage/sql/Opening tables 3 2098user2 localhost stage/sql/checking permissions 3 2099user2 localhost stage/sql/closing tables 3 2100user2 localhost stage/sql/init 7 2101user2 localhost stage/sql/Opening tables 3 2102user3 localhost stage/sql/checking permissions 3 2103user3 localhost stage/sql/closing tables 3 2104user3 localhost stage/sql/init 7 2105user3 localhost stage/sql/Opening tables 3 2106user4 localhost stage/sql/checking permissions 3 2107user4 localhost stage/sql/closing tables 3 2108user4 localhost stage/sql/init 7 2109user4 localhost stage/sql/Opening tables 3 2110execute dump_stages_user; 2111user event_name count_star 2112execute dump_stages_host; 2113host event_name count_star 2114localhost stage/sql/checking permissions 12 2115localhost stage/sql/closing tables 12 2116localhost stage/sql/init 28 2117localhost stage/sql/Opening tables 12 2118execute dump_stages_global; 2119event_name count_star 2120stage/sql/checking permissions 12 2121stage/sql/closing tables 12 2122stage/sql/init 28 2123stage/sql/Opening tables 12 2124execute dump_stages_history; 2125event_name count(event_name) 2126stage/sql/checking permissions 12 2127stage/sql/closing tables 12 2128stage/sql/init 28 2129stage/sql/Opening tables 12 2130execute dump_statements_account; 2131user host event_name count_star 2132user1 localhost statement/com/Error 0 2133user1 localhost statement/com/Quit 1 2134user1 localhost statement/sql/insert 1 2135user1 localhost statement/sql/select 2 2136user2 localhost statement/com/Error 0 2137user2 localhost statement/com/Quit 1 2138user2 localhost statement/sql/insert 1 2139user2 localhost statement/sql/select 2 2140user3 localhost statement/com/Error 0 2141user3 localhost statement/com/Quit 1 2142user3 localhost statement/sql/insert 1 2143user3 localhost statement/sql/select 2 2144user4 localhost statement/com/Error 0 2145user4 localhost statement/com/Quit 1 2146user4 localhost statement/sql/insert 1 2147user4 localhost statement/sql/select 2 2148execute dump_statements_user; 2149user event_name count_star 2150execute dump_statements_host; 2151host event_name count_star 2152localhost statement/com/Error 0 2153localhost statement/com/Quit 4 2154localhost statement/sql/insert 4 2155localhost statement/sql/select 8 2156execute dump_statements_global; 2157event_name count_star 2158statement/com/Error 0 2159statement/com/Quit 4 2160statement/sql/insert 4 2161statement/sql/select 8 2162execute dump_statements_history; 2163event_name count(event_name) 2164statement/com/Quit 4 2165statement/sql/insert 4 2166statement/sql/select 8 2167execute dump_accounts; 2168USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2169root localhost 1 1 2170user1 localhost 0 1 2171user2 localhost 0 1 2172user3 localhost 0 1 2173user4 localhost 0 1 2174execute dump_users; 2175USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2176execute dump_hosts; 2177HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2178localhost 1 5 2179truncate performance_schema.events_waits_summary_global_by_event_name; 2180"================== WAITS_GLOBAL truncated ==================" 2181"================== Step 18 ==================" 2182call dump_thread(); 2183username status 2184user1 not found 2185username status 2186user2 not found 2187username status 2188user3 not found 2189username status 2190user4 not found 2191execute dump_waits_account; 2192user host event_name count_star 2193user1 localhost wait/io/file/sql/query_log 0 2194user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2195user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2196user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2197user2 localhost wait/io/file/sql/query_log 0 2198user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2199user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2200user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2201user3 localhost wait/io/file/sql/query_log 0 2202user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2203user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2204user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2205user4 localhost wait/io/file/sql/query_log 0 2206user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2207user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2208user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2209execute dump_waits_user; 2210user event_name count_star 2211execute dump_waits_host; 2212host event_name count_star 2213localhost wait/io/file/sql/query_log 0 2214localhost wait/synch/mutex/sql/LOCK_connection_count 0 2215localhost wait/synch/mutex/sql/LOCK_user_locks 0 2216localhost wait/synch/rwlock/sql/LOCK_grant 0 2217execute dump_waits_global; 2218event_name count_star 2219wait/io/file/sql/query_log 0 2220wait/synch/mutex/sql/LOCK_connection_count 0 2221wait/synch/mutex/sql/LOCK_user_locks 0 2222wait/synch/rwlock/sql/LOCK_grant 0 2223execute dump_waits_history; 2224event_name count(event_name) 2225wait/io/file/sql/query_log 20 2226wait/synch/mutex/sql/LOCK_connection_count 4 2227wait/synch/mutex/sql/LOCK_user_locks 8 2228wait/synch/rwlock/sql/LOCK_grant 8 2229execute dump_stages_account; 2230user host event_name count_star 2231user1 localhost stage/sql/checking permissions 3 2232user1 localhost stage/sql/closing tables 3 2233user1 localhost stage/sql/init 7 2234user1 localhost stage/sql/Opening tables 3 2235user2 localhost stage/sql/checking permissions 3 2236user2 localhost stage/sql/closing tables 3 2237user2 localhost stage/sql/init 7 2238user2 localhost stage/sql/Opening tables 3 2239user3 localhost stage/sql/checking permissions 3 2240user3 localhost stage/sql/closing tables 3 2241user3 localhost stage/sql/init 7 2242user3 localhost stage/sql/Opening tables 3 2243user4 localhost stage/sql/checking permissions 3 2244user4 localhost stage/sql/closing tables 3 2245user4 localhost stage/sql/init 7 2246user4 localhost stage/sql/Opening tables 3 2247execute dump_stages_user; 2248user event_name count_star 2249execute dump_stages_host; 2250host event_name count_star 2251localhost stage/sql/checking permissions 12 2252localhost stage/sql/closing tables 12 2253localhost stage/sql/init 28 2254localhost stage/sql/Opening tables 12 2255execute dump_stages_global; 2256event_name count_star 2257stage/sql/checking permissions 12 2258stage/sql/closing tables 12 2259stage/sql/init 28 2260stage/sql/Opening tables 12 2261execute dump_stages_history; 2262event_name count(event_name) 2263stage/sql/checking permissions 12 2264stage/sql/closing tables 12 2265stage/sql/init 28 2266stage/sql/Opening tables 12 2267execute dump_statements_account; 2268user host event_name count_star 2269user1 localhost statement/com/Error 0 2270user1 localhost statement/com/Quit 1 2271user1 localhost statement/sql/insert 1 2272user1 localhost statement/sql/select 2 2273user2 localhost statement/com/Error 0 2274user2 localhost statement/com/Quit 1 2275user2 localhost statement/sql/insert 1 2276user2 localhost statement/sql/select 2 2277user3 localhost statement/com/Error 0 2278user3 localhost statement/com/Quit 1 2279user3 localhost statement/sql/insert 1 2280user3 localhost statement/sql/select 2 2281user4 localhost statement/com/Error 0 2282user4 localhost statement/com/Quit 1 2283user4 localhost statement/sql/insert 1 2284user4 localhost statement/sql/select 2 2285execute dump_statements_user; 2286user event_name count_star 2287execute dump_statements_host; 2288host event_name count_star 2289localhost statement/com/Error 0 2290localhost statement/com/Quit 4 2291localhost statement/sql/insert 4 2292localhost statement/sql/select 8 2293execute dump_statements_global; 2294event_name count_star 2295statement/com/Error 0 2296statement/com/Quit 4 2297statement/sql/insert 4 2298statement/sql/select 8 2299execute dump_statements_history; 2300event_name count(event_name) 2301statement/com/Quit 4 2302statement/sql/insert 4 2303statement/sql/select 8 2304execute dump_accounts; 2305USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2306root localhost 1 1 2307user1 localhost 0 1 2308user2 localhost 0 1 2309user3 localhost 0 1 2310user4 localhost 0 1 2311execute dump_users; 2312USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2313execute dump_hosts; 2314HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2315localhost 1 5 2316truncate performance_schema.events_stages_summary_by_thread_by_event_name; 2317"================== STAGES_BY_THREAD truncated ==================" 2318"================== Step 19 ==================" 2319call dump_thread(); 2320username status 2321user1 not found 2322username status 2323user2 not found 2324username status 2325user3 not found 2326username status 2327user4 not found 2328execute dump_waits_account; 2329user host event_name count_star 2330user1 localhost wait/io/file/sql/query_log 0 2331user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2332user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2333user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2334user2 localhost wait/io/file/sql/query_log 0 2335user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2336user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2337user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2338user3 localhost wait/io/file/sql/query_log 0 2339user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2340user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2341user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2342user4 localhost wait/io/file/sql/query_log 0 2343user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2344user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2345user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2346execute dump_waits_user; 2347user event_name count_star 2348execute dump_waits_host; 2349host event_name count_star 2350localhost wait/io/file/sql/query_log 0 2351localhost wait/synch/mutex/sql/LOCK_connection_count 0 2352localhost wait/synch/mutex/sql/LOCK_user_locks 0 2353localhost wait/synch/rwlock/sql/LOCK_grant 0 2354execute dump_waits_global; 2355event_name count_star 2356wait/io/file/sql/query_log 0 2357wait/synch/mutex/sql/LOCK_connection_count 0 2358wait/synch/mutex/sql/LOCK_user_locks 0 2359wait/synch/rwlock/sql/LOCK_grant 0 2360execute dump_waits_history; 2361event_name count(event_name) 2362wait/io/file/sql/query_log 20 2363wait/synch/mutex/sql/LOCK_connection_count 4 2364wait/synch/mutex/sql/LOCK_user_locks 8 2365wait/synch/rwlock/sql/LOCK_grant 8 2366execute dump_stages_account; 2367user host event_name count_star 2368user1 localhost stage/sql/checking permissions 3 2369user1 localhost stage/sql/closing tables 3 2370user1 localhost stage/sql/init 7 2371user1 localhost stage/sql/Opening tables 3 2372user2 localhost stage/sql/checking permissions 3 2373user2 localhost stage/sql/closing tables 3 2374user2 localhost stage/sql/init 7 2375user2 localhost stage/sql/Opening tables 3 2376user3 localhost stage/sql/checking permissions 3 2377user3 localhost stage/sql/closing tables 3 2378user3 localhost stage/sql/init 7 2379user3 localhost stage/sql/Opening tables 3 2380user4 localhost stage/sql/checking permissions 3 2381user4 localhost stage/sql/closing tables 3 2382user4 localhost stage/sql/init 7 2383user4 localhost stage/sql/Opening tables 3 2384execute dump_stages_user; 2385user event_name count_star 2386execute dump_stages_host; 2387host event_name count_star 2388localhost stage/sql/checking permissions 12 2389localhost stage/sql/closing tables 12 2390localhost stage/sql/init 28 2391localhost stage/sql/Opening tables 12 2392execute dump_stages_global; 2393event_name count_star 2394stage/sql/checking permissions 12 2395stage/sql/closing tables 12 2396stage/sql/init 28 2397stage/sql/Opening tables 12 2398execute dump_stages_history; 2399event_name count(event_name) 2400stage/sql/checking permissions 12 2401stage/sql/closing tables 12 2402stage/sql/init 28 2403stage/sql/Opening tables 12 2404execute dump_statements_account; 2405user host event_name count_star 2406user1 localhost statement/com/Error 0 2407user1 localhost statement/com/Quit 1 2408user1 localhost statement/sql/insert 1 2409user1 localhost statement/sql/select 2 2410user2 localhost statement/com/Error 0 2411user2 localhost statement/com/Quit 1 2412user2 localhost statement/sql/insert 1 2413user2 localhost statement/sql/select 2 2414user3 localhost statement/com/Error 0 2415user3 localhost statement/com/Quit 1 2416user3 localhost statement/sql/insert 1 2417user3 localhost statement/sql/select 2 2418user4 localhost statement/com/Error 0 2419user4 localhost statement/com/Quit 1 2420user4 localhost statement/sql/insert 1 2421user4 localhost statement/sql/select 2 2422execute dump_statements_user; 2423user event_name count_star 2424execute dump_statements_host; 2425host event_name count_star 2426localhost statement/com/Error 0 2427localhost statement/com/Quit 4 2428localhost statement/sql/insert 4 2429localhost statement/sql/select 8 2430execute dump_statements_global; 2431event_name count_star 2432statement/com/Error 0 2433statement/com/Quit 4 2434statement/sql/insert 4 2435statement/sql/select 8 2436execute dump_statements_history; 2437event_name count(event_name) 2438statement/com/Quit 4 2439statement/sql/insert 4 2440statement/sql/select 8 2441execute dump_accounts; 2442USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2443root localhost 1 1 2444user1 localhost 0 1 2445user2 localhost 0 1 2446user3 localhost 0 1 2447user4 localhost 0 1 2448execute dump_users; 2449USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2450execute dump_hosts; 2451HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2452localhost 1 5 2453truncate performance_schema.events_stages_summary_by_account_by_event_name; 2454"================== STAGES_BY_ACCOUNT truncated ==================" 2455"================== Step 20 ==================" 2456call dump_thread(); 2457username status 2458user1 not found 2459username status 2460user2 not found 2461username status 2462user3 not found 2463username status 2464user4 not found 2465execute dump_waits_account; 2466user host event_name count_star 2467user1 localhost wait/io/file/sql/query_log 0 2468user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2469user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2470user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2471user2 localhost wait/io/file/sql/query_log 0 2472user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2473user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2474user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2475user3 localhost wait/io/file/sql/query_log 0 2476user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2477user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2478user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2479user4 localhost wait/io/file/sql/query_log 0 2480user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2481user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2482user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2483execute dump_waits_user; 2484user event_name count_star 2485execute dump_waits_host; 2486host event_name count_star 2487localhost wait/io/file/sql/query_log 0 2488localhost wait/synch/mutex/sql/LOCK_connection_count 0 2489localhost wait/synch/mutex/sql/LOCK_user_locks 0 2490localhost wait/synch/rwlock/sql/LOCK_grant 0 2491execute dump_waits_global; 2492event_name count_star 2493wait/io/file/sql/query_log 0 2494wait/synch/mutex/sql/LOCK_connection_count 0 2495wait/synch/mutex/sql/LOCK_user_locks 0 2496wait/synch/rwlock/sql/LOCK_grant 0 2497execute dump_waits_history; 2498event_name count(event_name) 2499wait/io/file/sql/query_log 20 2500wait/synch/mutex/sql/LOCK_connection_count 4 2501wait/synch/mutex/sql/LOCK_user_locks 8 2502wait/synch/rwlock/sql/LOCK_grant 8 2503execute dump_stages_account; 2504user host event_name count_star 2505user1 localhost stage/sql/checking permissions 0 2506user1 localhost stage/sql/closing tables 0 2507user1 localhost stage/sql/init 0 2508user1 localhost stage/sql/Opening tables 0 2509user2 localhost stage/sql/checking permissions 0 2510user2 localhost stage/sql/closing tables 0 2511user2 localhost stage/sql/init 0 2512user2 localhost stage/sql/Opening tables 0 2513user3 localhost stage/sql/checking permissions 0 2514user3 localhost stage/sql/closing tables 0 2515user3 localhost stage/sql/init 0 2516user3 localhost stage/sql/Opening tables 0 2517user4 localhost stage/sql/checking permissions 0 2518user4 localhost stage/sql/closing tables 0 2519user4 localhost stage/sql/init 0 2520user4 localhost stage/sql/Opening tables 0 2521execute dump_stages_user; 2522user event_name count_star 2523execute dump_stages_host; 2524host event_name count_star 2525localhost stage/sql/checking permissions 12 2526localhost stage/sql/closing tables 12 2527localhost stage/sql/init 28 2528localhost stage/sql/Opening tables 12 2529execute dump_stages_global; 2530event_name count_star 2531stage/sql/checking permissions 12 2532stage/sql/closing tables 12 2533stage/sql/init 28 2534stage/sql/Opening tables 12 2535execute dump_stages_history; 2536event_name count(event_name) 2537stage/sql/checking permissions 12 2538stage/sql/closing tables 12 2539stage/sql/init 28 2540stage/sql/Opening tables 12 2541execute dump_statements_account; 2542user host event_name count_star 2543user1 localhost statement/com/Error 0 2544user1 localhost statement/com/Quit 1 2545user1 localhost statement/sql/insert 1 2546user1 localhost statement/sql/select 2 2547user2 localhost statement/com/Error 0 2548user2 localhost statement/com/Quit 1 2549user2 localhost statement/sql/insert 1 2550user2 localhost statement/sql/select 2 2551user3 localhost statement/com/Error 0 2552user3 localhost statement/com/Quit 1 2553user3 localhost statement/sql/insert 1 2554user3 localhost statement/sql/select 2 2555user4 localhost statement/com/Error 0 2556user4 localhost statement/com/Quit 1 2557user4 localhost statement/sql/insert 1 2558user4 localhost statement/sql/select 2 2559execute dump_statements_user; 2560user event_name count_star 2561execute dump_statements_host; 2562host event_name count_star 2563localhost statement/com/Error 0 2564localhost statement/com/Quit 4 2565localhost statement/sql/insert 4 2566localhost statement/sql/select 8 2567execute dump_statements_global; 2568event_name count_star 2569statement/com/Error 0 2570statement/com/Quit 4 2571statement/sql/insert 4 2572statement/sql/select 8 2573execute dump_statements_history; 2574event_name count(event_name) 2575statement/com/Quit 4 2576statement/sql/insert 4 2577statement/sql/select 8 2578execute dump_accounts; 2579USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2580root localhost 1 1 2581user1 localhost 0 1 2582user2 localhost 0 1 2583user3 localhost 0 1 2584user4 localhost 0 1 2585execute dump_users; 2586USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2587execute dump_hosts; 2588HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2589localhost 1 5 2590truncate performance_schema.events_stages_summary_by_user_by_event_name; 2591"================== STAGES_BY_USER truncated ==================" 2592"================== Step 21 ==================" 2593call dump_thread(); 2594username status 2595user1 not found 2596username status 2597user2 not found 2598username status 2599user3 not found 2600username status 2601user4 not found 2602execute dump_waits_account; 2603user host event_name count_star 2604user1 localhost wait/io/file/sql/query_log 0 2605user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2606user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2607user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2608user2 localhost wait/io/file/sql/query_log 0 2609user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2610user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2611user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2612user3 localhost wait/io/file/sql/query_log 0 2613user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2614user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2615user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2616user4 localhost wait/io/file/sql/query_log 0 2617user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2618user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2619user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2620execute dump_waits_user; 2621user event_name count_star 2622execute dump_waits_host; 2623host event_name count_star 2624localhost wait/io/file/sql/query_log 0 2625localhost wait/synch/mutex/sql/LOCK_connection_count 0 2626localhost wait/synch/mutex/sql/LOCK_user_locks 0 2627localhost wait/synch/rwlock/sql/LOCK_grant 0 2628execute dump_waits_global; 2629event_name count_star 2630wait/io/file/sql/query_log 0 2631wait/synch/mutex/sql/LOCK_connection_count 0 2632wait/synch/mutex/sql/LOCK_user_locks 0 2633wait/synch/rwlock/sql/LOCK_grant 0 2634execute dump_waits_history; 2635event_name count(event_name) 2636wait/io/file/sql/query_log 20 2637wait/synch/mutex/sql/LOCK_connection_count 4 2638wait/synch/mutex/sql/LOCK_user_locks 8 2639wait/synch/rwlock/sql/LOCK_grant 8 2640execute dump_stages_account; 2641user host event_name count_star 2642user1 localhost stage/sql/checking permissions 0 2643user1 localhost stage/sql/closing tables 0 2644user1 localhost stage/sql/init 0 2645user1 localhost stage/sql/Opening tables 0 2646user2 localhost stage/sql/checking permissions 0 2647user2 localhost stage/sql/closing tables 0 2648user2 localhost stage/sql/init 0 2649user2 localhost stage/sql/Opening tables 0 2650user3 localhost stage/sql/checking permissions 0 2651user3 localhost stage/sql/closing tables 0 2652user3 localhost stage/sql/init 0 2653user3 localhost stage/sql/Opening tables 0 2654user4 localhost stage/sql/checking permissions 0 2655user4 localhost stage/sql/closing tables 0 2656user4 localhost stage/sql/init 0 2657user4 localhost stage/sql/Opening tables 0 2658execute dump_stages_user; 2659user event_name count_star 2660execute dump_stages_host; 2661host event_name count_star 2662localhost stage/sql/checking permissions 12 2663localhost stage/sql/closing tables 12 2664localhost stage/sql/init 28 2665localhost stage/sql/Opening tables 12 2666execute dump_stages_global; 2667event_name count_star 2668stage/sql/checking permissions 12 2669stage/sql/closing tables 12 2670stage/sql/init 28 2671stage/sql/Opening tables 12 2672execute dump_stages_history; 2673event_name count(event_name) 2674stage/sql/checking permissions 12 2675stage/sql/closing tables 12 2676stage/sql/init 28 2677stage/sql/Opening tables 12 2678execute dump_statements_account; 2679user host event_name count_star 2680user1 localhost statement/com/Error 0 2681user1 localhost statement/com/Quit 1 2682user1 localhost statement/sql/insert 1 2683user1 localhost statement/sql/select 2 2684user2 localhost statement/com/Error 0 2685user2 localhost statement/com/Quit 1 2686user2 localhost statement/sql/insert 1 2687user2 localhost statement/sql/select 2 2688user3 localhost statement/com/Error 0 2689user3 localhost statement/com/Quit 1 2690user3 localhost statement/sql/insert 1 2691user3 localhost statement/sql/select 2 2692user4 localhost statement/com/Error 0 2693user4 localhost statement/com/Quit 1 2694user4 localhost statement/sql/insert 1 2695user4 localhost statement/sql/select 2 2696execute dump_statements_user; 2697user event_name count_star 2698execute dump_statements_host; 2699host event_name count_star 2700localhost statement/com/Error 0 2701localhost statement/com/Quit 4 2702localhost statement/sql/insert 4 2703localhost statement/sql/select 8 2704execute dump_statements_global; 2705event_name count_star 2706statement/com/Error 0 2707statement/com/Quit 4 2708statement/sql/insert 4 2709statement/sql/select 8 2710execute dump_statements_history; 2711event_name count(event_name) 2712statement/com/Quit 4 2713statement/sql/insert 4 2714statement/sql/select 8 2715execute dump_accounts; 2716USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2717root localhost 1 1 2718user1 localhost 0 1 2719user2 localhost 0 1 2720user3 localhost 0 1 2721user4 localhost 0 1 2722execute dump_users; 2723USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2724execute dump_hosts; 2725HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2726localhost 1 5 2727truncate performance_schema.events_stages_summary_by_host_by_event_name; 2728"================== STAGES_BY_HOST truncated ==================" 2729"================== Step 22 ==================" 2730call dump_thread(); 2731username status 2732user1 not found 2733username status 2734user2 not found 2735username status 2736user3 not found 2737username status 2738user4 not found 2739execute dump_waits_account; 2740user host event_name count_star 2741user1 localhost wait/io/file/sql/query_log 0 2742user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2743user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2744user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2745user2 localhost wait/io/file/sql/query_log 0 2746user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2747user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2748user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2749user3 localhost wait/io/file/sql/query_log 0 2750user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2751user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2752user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2753user4 localhost wait/io/file/sql/query_log 0 2754user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2755user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2756user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2757execute dump_waits_user; 2758user event_name count_star 2759execute dump_waits_host; 2760host event_name count_star 2761localhost wait/io/file/sql/query_log 0 2762localhost wait/synch/mutex/sql/LOCK_connection_count 0 2763localhost wait/synch/mutex/sql/LOCK_user_locks 0 2764localhost wait/synch/rwlock/sql/LOCK_grant 0 2765execute dump_waits_global; 2766event_name count_star 2767wait/io/file/sql/query_log 0 2768wait/synch/mutex/sql/LOCK_connection_count 0 2769wait/synch/mutex/sql/LOCK_user_locks 0 2770wait/synch/rwlock/sql/LOCK_grant 0 2771execute dump_waits_history; 2772event_name count(event_name) 2773wait/io/file/sql/query_log 20 2774wait/synch/mutex/sql/LOCK_connection_count 4 2775wait/synch/mutex/sql/LOCK_user_locks 8 2776wait/synch/rwlock/sql/LOCK_grant 8 2777execute dump_stages_account; 2778user host event_name count_star 2779user1 localhost stage/sql/checking permissions 0 2780user1 localhost stage/sql/closing tables 0 2781user1 localhost stage/sql/init 0 2782user1 localhost stage/sql/Opening tables 0 2783user2 localhost stage/sql/checking permissions 0 2784user2 localhost stage/sql/closing tables 0 2785user2 localhost stage/sql/init 0 2786user2 localhost stage/sql/Opening tables 0 2787user3 localhost stage/sql/checking permissions 0 2788user3 localhost stage/sql/closing tables 0 2789user3 localhost stage/sql/init 0 2790user3 localhost stage/sql/Opening tables 0 2791user4 localhost stage/sql/checking permissions 0 2792user4 localhost stage/sql/closing tables 0 2793user4 localhost stage/sql/init 0 2794user4 localhost stage/sql/Opening tables 0 2795execute dump_stages_user; 2796user event_name count_star 2797execute dump_stages_host; 2798host event_name count_star 2799localhost stage/sql/checking permissions 0 2800localhost stage/sql/closing tables 0 2801localhost stage/sql/init 0 2802localhost stage/sql/Opening tables 0 2803execute dump_stages_global; 2804event_name count_star 2805stage/sql/checking permissions 12 2806stage/sql/closing tables 12 2807stage/sql/init 28 2808stage/sql/Opening tables 12 2809execute dump_stages_history; 2810event_name count(event_name) 2811stage/sql/checking permissions 12 2812stage/sql/closing tables 12 2813stage/sql/init 28 2814stage/sql/Opening tables 12 2815execute dump_statements_account; 2816user host event_name count_star 2817user1 localhost statement/com/Error 0 2818user1 localhost statement/com/Quit 1 2819user1 localhost statement/sql/insert 1 2820user1 localhost statement/sql/select 2 2821user2 localhost statement/com/Error 0 2822user2 localhost statement/com/Quit 1 2823user2 localhost statement/sql/insert 1 2824user2 localhost statement/sql/select 2 2825user3 localhost statement/com/Error 0 2826user3 localhost statement/com/Quit 1 2827user3 localhost statement/sql/insert 1 2828user3 localhost statement/sql/select 2 2829user4 localhost statement/com/Error 0 2830user4 localhost statement/com/Quit 1 2831user4 localhost statement/sql/insert 1 2832user4 localhost statement/sql/select 2 2833execute dump_statements_user; 2834user event_name count_star 2835execute dump_statements_host; 2836host event_name count_star 2837localhost statement/com/Error 0 2838localhost statement/com/Quit 4 2839localhost statement/sql/insert 4 2840localhost statement/sql/select 8 2841execute dump_statements_global; 2842event_name count_star 2843statement/com/Error 0 2844statement/com/Quit 4 2845statement/sql/insert 4 2846statement/sql/select 8 2847execute dump_statements_history; 2848event_name count(event_name) 2849statement/com/Quit 4 2850statement/sql/insert 4 2851statement/sql/select 8 2852execute dump_accounts; 2853USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2854root localhost 1 1 2855user1 localhost 0 1 2856user2 localhost 0 1 2857user3 localhost 0 1 2858user4 localhost 0 1 2859execute dump_users; 2860USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2861execute dump_hosts; 2862HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2863localhost 1 5 2864truncate performance_schema.events_stages_summary_global_by_event_name; 2865"================== STAGES_GLOBAL truncated ==================" 2866"================== Step 23 ==================" 2867call dump_thread(); 2868username status 2869user1 not found 2870username status 2871user2 not found 2872username status 2873user3 not found 2874username status 2875user4 not found 2876execute dump_waits_account; 2877user host event_name count_star 2878user1 localhost wait/io/file/sql/query_log 0 2879user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2880user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2881user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 2882user2 localhost wait/io/file/sql/query_log 0 2883user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2884user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2885user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 2886user3 localhost wait/io/file/sql/query_log 0 2887user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2888user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2889user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 2890user4 localhost wait/io/file/sql/query_log 0 2891user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 2892user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 2893user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 2894execute dump_waits_user; 2895user event_name count_star 2896execute dump_waits_host; 2897host event_name count_star 2898localhost wait/io/file/sql/query_log 0 2899localhost wait/synch/mutex/sql/LOCK_connection_count 0 2900localhost wait/synch/mutex/sql/LOCK_user_locks 0 2901localhost wait/synch/rwlock/sql/LOCK_grant 0 2902execute dump_waits_global; 2903event_name count_star 2904wait/io/file/sql/query_log 0 2905wait/synch/mutex/sql/LOCK_connection_count 0 2906wait/synch/mutex/sql/LOCK_user_locks 0 2907wait/synch/rwlock/sql/LOCK_grant 0 2908execute dump_waits_history; 2909event_name count(event_name) 2910wait/io/file/sql/query_log 20 2911wait/synch/mutex/sql/LOCK_connection_count 4 2912wait/synch/mutex/sql/LOCK_user_locks 8 2913wait/synch/rwlock/sql/LOCK_grant 8 2914execute dump_stages_account; 2915user host event_name count_star 2916user1 localhost stage/sql/checking permissions 0 2917user1 localhost stage/sql/closing tables 0 2918user1 localhost stage/sql/init 0 2919user1 localhost stage/sql/Opening tables 0 2920user2 localhost stage/sql/checking permissions 0 2921user2 localhost stage/sql/closing tables 0 2922user2 localhost stage/sql/init 0 2923user2 localhost stage/sql/Opening tables 0 2924user3 localhost stage/sql/checking permissions 0 2925user3 localhost stage/sql/closing tables 0 2926user3 localhost stage/sql/init 0 2927user3 localhost stage/sql/Opening tables 0 2928user4 localhost stage/sql/checking permissions 0 2929user4 localhost stage/sql/closing tables 0 2930user4 localhost stage/sql/init 0 2931user4 localhost stage/sql/Opening tables 0 2932execute dump_stages_user; 2933user event_name count_star 2934execute dump_stages_host; 2935host event_name count_star 2936localhost stage/sql/checking permissions 0 2937localhost stage/sql/closing tables 0 2938localhost stage/sql/init 0 2939localhost stage/sql/Opening tables 0 2940execute dump_stages_global; 2941event_name count_star 2942stage/sql/checking permissions 0 2943stage/sql/closing tables 0 2944stage/sql/init 0 2945stage/sql/Opening tables 0 2946execute dump_stages_history; 2947event_name count(event_name) 2948stage/sql/checking permissions 12 2949stage/sql/closing tables 12 2950stage/sql/init 28 2951stage/sql/Opening tables 12 2952execute dump_statements_account; 2953user host event_name count_star 2954user1 localhost statement/com/Error 0 2955user1 localhost statement/com/Quit 1 2956user1 localhost statement/sql/insert 1 2957user1 localhost statement/sql/select 2 2958user2 localhost statement/com/Error 0 2959user2 localhost statement/com/Quit 1 2960user2 localhost statement/sql/insert 1 2961user2 localhost statement/sql/select 2 2962user3 localhost statement/com/Error 0 2963user3 localhost statement/com/Quit 1 2964user3 localhost statement/sql/insert 1 2965user3 localhost statement/sql/select 2 2966user4 localhost statement/com/Error 0 2967user4 localhost statement/com/Quit 1 2968user4 localhost statement/sql/insert 1 2969user4 localhost statement/sql/select 2 2970execute dump_statements_user; 2971user event_name count_star 2972execute dump_statements_host; 2973host event_name count_star 2974localhost statement/com/Error 0 2975localhost statement/com/Quit 4 2976localhost statement/sql/insert 4 2977localhost statement/sql/select 8 2978execute dump_statements_global; 2979event_name count_star 2980statement/com/Error 0 2981statement/com/Quit 4 2982statement/sql/insert 4 2983statement/sql/select 8 2984execute dump_statements_history; 2985event_name count(event_name) 2986statement/com/Quit 4 2987statement/sql/insert 4 2988statement/sql/select 8 2989execute dump_accounts; 2990USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2991root localhost 1 1 2992user1 localhost 0 1 2993user2 localhost 0 1 2994user3 localhost 0 1 2995user4 localhost 0 1 2996execute dump_users; 2997USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2998execute dump_hosts; 2999HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3000localhost 1 5 3001truncate performance_schema.events_statements_summary_by_thread_by_event_name; 3002"================== STATEMENTS_BY_THREAD truncated ==================" 3003"================== Step 24 ==================" 3004call dump_thread(); 3005username status 3006user1 not found 3007username status 3008user2 not found 3009username status 3010user3 not found 3011username status 3012user4 not found 3013execute dump_waits_account; 3014user host event_name count_star 3015user1 localhost wait/io/file/sql/query_log 0 3016user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3017user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3018user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3019user2 localhost wait/io/file/sql/query_log 0 3020user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3021user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3022user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3023user3 localhost wait/io/file/sql/query_log 0 3024user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3025user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3026user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3027user4 localhost wait/io/file/sql/query_log 0 3028user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3029user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3030user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3031execute dump_waits_user; 3032user event_name count_star 3033execute dump_waits_host; 3034host event_name count_star 3035localhost wait/io/file/sql/query_log 0 3036localhost wait/synch/mutex/sql/LOCK_connection_count 0 3037localhost wait/synch/mutex/sql/LOCK_user_locks 0 3038localhost wait/synch/rwlock/sql/LOCK_grant 0 3039execute dump_waits_global; 3040event_name count_star 3041wait/io/file/sql/query_log 0 3042wait/synch/mutex/sql/LOCK_connection_count 0 3043wait/synch/mutex/sql/LOCK_user_locks 0 3044wait/synch/rwlock/sql/LOCK_grant 0 3045execute dump_waits_history; 3046event_name count(event_name) 3047wait/io/file/sql/query_log 20 3048wait/synch/mutex/sql/LOCK_connection_count 4 3049wait/synch/mutex/sql/LOCK_user_locks 8 3050wait/synch/rwlock/sql/LOCK_grant 8 3051execute dump_stages_account; 3052user host event_name count_star 3053user1 localhost stage/sql/checking permissions 0 3054user1 localhost stage/sql/closing tables 0 3055user1 localhost stage/sql/init 0 3056user1 localhost stage/sql/Opening tables 0 3057user2 localhost stage/sql/checking permissions 0 3058user2 localhost stage/sql/closing tables 0 3059user2 localhost stage/sql/init 0 3060user2 localhost stage/sql/Opening tables 0 3061user3 localhost stage/sql/checking permissions 0 3062user3 localhost stage/sql/closing tables 0 3063user3 localhost stage/sql/init 0 3064user3 localhost stage/sql/Opening tables 0 3065user4 localhost stage/sql/checking permissions 0 3066user4 localhost stage/sql/closing tables 0 3067user4 localhost stage/sql/init 0 3068user4 localhost stage/sql/Opening tables 0 3069execute dump_stages_user; 3070user event_name count_star 3071execute dump_stages_host; 3072host event_name count_star 3073localhost stage/sql/checking permissions 0 3074localhost stage/sql/closing tables 0 3075localhost stage/sql/init 0 3076localhost stage/sql/Opening tables 0 3077execute dump_stages_global; 3078event_name count_star 3079stage/sql/checking permissions 0 3080stage/sql/closing tables 0 3081stage/sql/init 0 3082stage/sql/Opening tables 0 3083execute dump_stages_history; 3084event_name count(event_name) 3085stage/sql/checking permissions 12 3086stage/sql/closing tables 12 3087stage/sql/init 28 3088stage/sql/Opening tables 12 3089execute dump_statements_account; 3090user host event_name count_star 3091user1 localhost statement/com/Error 0 3092user1 localhost statement/com/Quit 1 3093user1 localhost statement/sql/insert 1 3094user1 localhost statement/sql/select 2 3095user2 localhost statement/com/Error 0 3096user2 localhost statement/com/Quit 1 3097user2 localhost statement/sql/insert 1 3098user2 localhost statement/sql/select 2 3099user3 localhost statement/com/Error 0 3100user3 localhost statement/com/Quit 1 3101user3 localhost statement/sql/insert 1 3102user3 localhost statement/sql/select 2 3103user4 localhost statement/com/Error 0 3104user4 localhost statement/com/Quit 1 3105user4 localhost statement/sql/insert 1 3106user4 localhost statement/sql/select 2 3107execute dump_statements_user; 3108user event_name count_star 3109execute dump_statements_host; 3110host event_name count_star 3111localhost statement/com/Error 0 3112localhost statement/com/Quit 4 3113localhost statement/sql/insert 4 3114localhost statement/sql/select 8 3115execute dump_statements_global; 3116event_name count_star 3117statement/com/Error 0 3118statement/com/Quit 4 3119statement/sql/insert 4 3120statement/sql/select 8 3121execute dump_statements_history; 3122event_name count(event_name) 3123statement/com/Quit 4 3124statement/sql/insert 4 3125statement/sql/select 8 3126execute dump_accounts; 3127USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3128root localhost 1 1 3129user1 localhost 0 1 3130user2 localhost 0 1 3131user3 localhost 0 1 3132user4 localhost 0 1 3133execute dump_users; 3134USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3135execute dump_hosts; 3136HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3137localhost 1 5 3138truncate performance_schema.events_statements_summary_by_account_by_event_name; 3139"================== STATEMENTS_BY_ACCOUNT truncated ==================" 3140"================== Step 25 ==================" 3141call dump_thread(); 3142username status 3143user1 not found 3144username status 3145user2 not found 3146username status 3147user3 not found 3148username status 3149user4 not found 3150execute dump_waits_account; 3151user host event_name count_star 3152user1 localhost wait/io/file/sql/query_log 0 3153user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3154user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3155user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3156user2 localhost wait/io/file/sql/query_log 0 3157user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3158user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3159user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3160user3 localhost wait/io/file/sql/query_log 0 3161user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3162user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3163user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3164user4 localhost wait/io/file/sql/query_log 0 3165user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3166user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3167user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3168execute dump_waits_user; 3169user event_name count_star 3170execute dump_waits_host; 3171host event_name count_star 3172localhost wait/io/file/sql/query_log 0 3173localhost wait/synch/mutex/sql/LOCK_connection_count 0 3174localhost wait/synch/mutex/sql/LOCK_user_locks 0 3175localhost wait/synch/rwlock/sql/LOCK_grant 0 3176execute dump_waits_global; 3177event_name count_star 3178wait/io/file/sql/query_log 0 3179wait/synch/mutex/sql/LOCK_connection_count 0 3180wait/synch/mutex/sql/LOCK_user_locks 0 3181wait/synch/rwlock/sql/LOCK_grant 0 3182execute dump_waits_history; 3183event_name count(event_name) 3184wait/io/file/sql/query_log 20 3185wait/synch/mutex/sql/LOCK_connection_count 4 3186wait/synch/mutex/sql/LOCK_user_locks 8 3187wait/synch/rwlock/sql/LOCK_grant 8 3188execute dump_stages_account; 3189user host event_name count_star 3190user1 localhost stage/sql/checking permissions 0 3191user1 localhost stage/sql/closing tables 0 3192user1 localhost stage/sql/init 0 3193user1 localhost stage/sql/Opening tables 0 3194user2 localhost stage/sql/checking permissions 0 3195user2 localhost stage/sql/closing tables 0 3196user2 localhost stage/sql/init 0 3197user2 localhost stage/sql/Opening tables 0 3198user3 localhost stage/sql/checking permissions 0 3199user3 localhost stage/sql/closing tables 0 3200user3 localhost stage/sql/init 0 3201user3 localhost stage/sql/Opening tables 0 3202user4 localhost stage/sql/checking permissions 0 3203user4 localhost stage/sql/closing tables 0 3204user4 localhost stage/sql/init 0 3205user4 localhost stage/sql/Opening tables 0 3206execute dump_stages_user; 3207user event_name count_star 3208execute dump_stages_host; 3209host event_name count_star 3210localhost stage/sql/checking permissions 0 3211localhost stage/sql/closing tables 0 3212localhost stage/sql/init 0 3213localhost stage/sql/Opening tables 0 3214execute dump_stages_global; 3215event_name count_star 3216stage/sql/checking permissions 0 3217stage/sql/closing tables 0 3218stage/sql/init 0 3219stage/sql/Opening tables 0 3220execute dump_stages_history; 3221event_name count(event_name) 3222stage/sql/checking permissions 12 3223stage/sql/closing tables 12 3224stage/sql/init 28 3225stage/sql/Opening tables 12 3226execute dump_statements_account; 3227user host event_name count_star 3228user1 localhost statement/com/Error 0 3229user1 localhost statement/com/Quit 0 3230user1 localhost statement/sql/insert 0 3231user1 localhost statement/sql/select 0 3232user2 localhost statement/com/Error 0 3233user2 localhost statement/com/Quit 0 3234user2 localhost statement/sql/insert 0 3235user2 localhost statement/sql/select 0 3236user3 localhost statement/com/Error 0 3237user3 localhost statement/com/Quit 0 3238user3 localhost statement/sql/insert 0 3239user3 localhost statement/sql/select 0 3240user4 localhost statement/com/Error 0 3241user4 localhost statement/com/Quit 0 3242user4 localhost statement/sql/insert 0 3243user4 localhost statement/sql/select 0 3244execute dump_statements_user; 3245user event_name count_star 3246execute dump_statements_host; 3247host event_name count_star 3248localhost statement/com/Error 0 3249localhost statement/com/Quit 4 3250localhost statement/sql/insert 4 3251localhost statement/sql/select 8 3252execute dump_statements_global; 3253event_name count_star 3254statement/com/Error 0 3255statement/com/Quit 4 3256statement/sql/insert 4 3257statement/sql/select 8 3258execute dump_statements_history; 3259event_name count(event_name) 3260statement/com/Quit 4 3261statement/sql/insert 4 3262statement/sql/select 8 3263execute dump_accounts; 3264USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3265root localhost 1 1 3266user1 localhost 0 1 3267user2 localhost 0 1 3268user3 localhost 0 1 3269user4 localhost 0 1 3270execute dump_users; 3271USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3272execute dump_hosts; 3273HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3274localhost 1 5 3275truncate performance_schema.events_statements_summary_by_user_by_event_name; 3276"================== STATEMENTS_BY_USER truncated ==================" 3277"================== Step 26 ==================" 3278call dump_thread(); 3279username status 3280user1 not found 3281username status 3282user2 not found 3283username status 3284user3 not found 3285username status 3286user4 not found 3287execute dump_waits_account; 3288user host event_name count_star 3289user1 localhost wait/io/file/sql/query_log 0 3290user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3291user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3292user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3293user2 localhost wait/io/file/sql/query_log 0 3294user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3295user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3296user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3297user3 localhost wait/io/file/sql/query_log 0 3298user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3299user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3300user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3301user4 localhost wait/io/file/sql/query_log 0 3302user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3303user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3304user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3305execute dump_waits_user; 3306user event_name count_star 3307execute dump_waits_host; 3308host event_name count_star 3309localhost wait/io/file/sql/query_log 0 3310localhost wait/synch/mutex/sql/LOCK_connection_count 0 3311localhost wait/synch/mutex/sql/LOCK_user_locks 0 3312localhost wait/synch/rwlock/sql/LOCK_grant 0 3313execute dump_waits_global; 3314event_name count_star 3315wait/io/file/sql/query_log 0 3316wait/synch/mutex/sql/LOCK_connection_count 0 3317wait/synch/mutex/sql/LOCK_user_locks 0 3318wait/synch/rwlock/sql/LOCK_grant 0 3319execute dump_waits_history; 3320event_name count(event_name) 3321wait/io/file/sql/query_log 20 3322wait/synch/mutex/sql/LOCK_connection_count 4 3323wait/synch/mutex/sql/LOCK_user_locks 8 3324wait/synch/rwlock/sql/LOCK_grant 8 3325execute dump_stages_account; 3326user host event_name count_star 3327user1 localhost stage/sql/checking permissions 0 3328user1 localhost stage/sql/closing tables 0 3329user1 localhost stage/sql/init 0 3330user1 localhost stage/sql/Opening tables 0 3331user2 localhost stage/sql/checking permissions 0 3332user2 localhost stage/sql/closing tables 0 3333user2 localhost stage/sql/init 0 3334user2 localhost stage/sql/Opening tables 0 3335user3 localhost stage/sql/checking permissions 0 3336user3 localhost stage/sql/closing tables 0 3337user3 localhost stage/sql/init 0 3338user3 localhost stage/sql/Opening tables 0 3339user4 localhost stage/sql/checking permissions 0 3340user4 localhost stage/sql/closing tables 0 3341user4 localhost stage/sql/init 0 3342user4 localhost stage/sql/Opening tables 0 3343execute dump_stages_user; 3344user event_name count_star 3345execute dump_stages_host; 3346host event_name count_star 3347localhost stage/sql/checking permissions 0 3348localhost stage/sql/closing tables 0 3349localhost stage/sql/init 0 3350localhost stage/sql/Opening tables 0 3351execute dump_stages_global; 3352event_name count_star 3353stage/sql/checking permissions 0 3354stage/sql/closing tables 0 3355stage/sql/init 0 3356stage/sql/Opening tables 0 3357execute dump_stages_history; 3358event_name count(event_name) 3359stage/sql/checking permissions 12 3360stage/sql/closing tables 12 3361stage/sql/init 28 3362stage/sql/Opening tables 12 3363execute dump_statements_account; 3364user host event_name count_star 3365user1 localhost statement/com/Error 0 3366user1 localhost statement/com/Quit 0 3367user1 localhost statement/sql/insert 0 3368user1 localhost statement/sql/select 0 3369user2 localhost statement/com/Error 0 3370user2 localhost statement/com/Quit 0 3371user2 localhost statement/sql/insert 0 3372user2 localhost statement/sql/select 0 3373user3 localhost statement/com/Error 0 3374user3 localhost statement/com/Quit 0 3375user3 localhost statement/sql/insert 0 3376user3 localhost statement/sql/select 0 3377user4 localhost statement/com/Error 0 3378user4 localhost statement/com/Quit 0 3379user4 localhost statement/sql/insert 0 3380user4 localhost statement/sql/select 0 3381execute dump_statements_user; 3382user event_name count_star 3383execute dump_statements_host; 3384host event_name count_star 3385localhost statement/com/Error 0 3386localhost statement/com/Quit 4 3387localhost statement/sql/insert 4 3388localhost statement/sql/select 8 3389execute dump_statements_global; 3390event_name count_star 3391statement/com/Error 0 3392statement/com/Quit 4 3393statement/sql/insert 4 3394statement/sql/select 8 3395execute dump_statements_history; 3396event_name count(event_name) 3397statement/com/Quit 4 3398statement/sql/insert 4 3399statement/sql/select 8 3400execute dump_accounts; 3401USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3402root localhost 1 1 3403user1 localhost 0 1 3404user2 localhost 0 1 3405user3 localhost 0 1 3406user4 localhost 0 1 3407execute dump_users; 3408USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3409execute dump_hosts; 3410HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3411localhost 1 5 3412truncate performance_schema.events_statements_summary_by_host_by_event_name; 3413"================== STATEMENTS_BY_HOST truncated ==================" 3414"================== Step 27 ==================" 3415call dump_thread(); 3416username status 3417user1 not found 3418username status 3419user2 not found 3420username status 3421user3 not found 3422username status 3423user4 not found 3424execute dump_waits_account; 3425user host event_name count_star 3426user1 localhost wait/io/file/sql/query_log 0 3427user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3428user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3429user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3430user2 localhost wait/io/file/sql/query_log 0 3431user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3432user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3433user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3434user3 localhost wait/io/file/sql/query_log 0 3435user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3436user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3437user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3438user4 localhost wait/io/file/sql/query_log 0 3439user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3440user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3441user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3442execute dump_waits_user; 3443user event_name count_star 3444execute dump_waits_host; 3445host event_name count_star 3446localhost wait/io/file/sql/query_log 0 3447localhost wait/synch/mutex/sql/LOCK_connection_count 0 3448localhost wait/synch/mutex/sql/LOCK_user_locks 0 3449localhost wait/synch/rwlock/sql/LOCK_grant 0 3450execute dump_waits_global; 3451event_name count_star 3452wait/io/file/sql/query_log 0 3453wait/synch/mutex/sql/LOCK_connection_count 0 3454wait/synch/mutex/sql/LOCK_user_locks 0 3455wait/synch/rwlock/sql/LOCK_grant 0 3456execute dump_waits_history; 3457event_name count(event_name) 3458wait/io/file/sql/query_log 20 3459wait/synch/mutex/sql/LOCK_connection_count 4 3460wait/synch/mutex/sql/LOCK_user_locks 8 3461wait/synch/rwlock/sql/LOCK_grant 8 3462execute dump_stages_account; 3463user host event_name count_star 3464user1 localhost stage/sql/checking permissions 0 3465user1 localhost stage/sql/closing tables 0 3466user1 localhost stage/sql/init 0 3467user1 localhost stage/sql/Opening tables 0 3468user2 localhost stage/sql/checking permissions 0 3469user2 localhost stage/sql/closing tables 0 3470user2 localhost stage/sql/init 0 3471user2 localhost stage/sql/Opening tables 0 3472user3 localhost stage/sql/checking permissions 0 3473user3 localhost stage/sql/closing tables 0 3474user3 localhost stage/sql/init 0 3475user3 localhost stage/sql/Opening tables 0 3476user4 localhost stage/sql/checking permissions 0 3477user4 localhost stage/sql/closing tables 0 3478user4 localhost stage/sql/init 0 3479user4 localhost stage/sql/Opening tables 0 3480execute dump_stages_user; 3481user event_name count_star 3482execute dump_stages_host; 3483host event_name count_star 3484localhost stage/sql/checking permissions 0 3485localhost stage/sql/closing tables 0 3486localhost stage/sql/init 0 3487localhost stage/sql/Opening tables 0 3488execute dump_stages_global; 3489event_name count_star 3490stage/sql/checking permissions 0 3491stage/sql/closing tables 0 3492stage/sql/init 0 3493stage/sql/Opening tables 0 3494execute dump_stages_history; 3495event_name count(event_name) 3496stage/sql/checking permissions 12 3497stage/sql/closing tables 12 3498stage/sql/init 28 3499stage/sql/Opening tables 12 3500execute dump_statements_account; 3501user host event_name count_star 3502user1 localhost statement/com/Error 0 3503user1 localhost statement/com/Quit 0 3504user1 localhost statement/sql/insert 0 3505user1 localhost statement/sql/select 0 3506user2 localhost statement/com/Error 0 3507user2 localhost statement/com/Quit 0 3508user2 localhost statement/sql/insert 0 3509user2 localhost statement/sql/select 0 3510user3 localhost statement/com/Error 0 3511user3 localhost statement/com/Quit 0 3512user3 localhost statement/sql/insert 0 3513user3 localhost statement/sql/select 0 3514user4 localhost statement/com/Error 0 3515user4 localhost statement/com/Quit 0 3516user4 localhost statement/sql/insert 0 3517user4 localhost statement/sql/select 0 3518execute dump_statements_user; 3519user event_name count_star 3520execute dump_statements_host; 3521host event_name count_star 3522localhost statement/com/Error 0 3523localhost statement/com/Quit 0 3524localhost statement/sql/insert 0 3525localhost statement/sql/select 0 3526execute dump_statements_global; 3527event_name count_star 3528statement/com/Error 0 3529statement/com/Quit 4 3530statement/sql/insert 4 3531statement/sql/select 8 3532execute dump_statements_history; 3533event_name count(event_name) 3534statement/com/Quit 4 3535statement/sql/insert 4 3536statement/sql/select 8 3537execute dump_accounts; 3538USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3539root localhost 1 1 3540user1 localhost 0 1 3541user2 localhost 0 1 3542user3 localhost 0 1 3543user4 localhost 0 1 3544execute dump_users; 3545USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3546execute dump_hosts; 3547HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3548localhost 1 5 3549truncate performance_schema.events_statements_summary_global_by_event_name; 3550"================== STATEMENTS_GLOBAL truncated ==================" 3551"================== Step 28 ==================" 3552call dump_thread(); 3553username status 3554user1 not found 3555username status 3556user2 not found 3557username status 3558user3 not found 3559username status 3560user4 not found 3561execute dump_waits_account; 3562user host event_name count_star 3563user1 localhost wait/io/file/sql/query_log 0 3564user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3565user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3566user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 3567user2 localhost wait/io/file/sql/query_log 0 3568user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3569user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3570user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 3571user3 localhost wait/io/file/sql/query_log 0 3572user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3573user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3574user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 3575user4 localhost wait/io/file/sql/query_log 0 3576user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 3577user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 3578user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 3579execute dump_waits_user; 3580user event_name count_star 3581execute dump_waits_host; 3582host event_name count_star 3583localhost wait/io/file/sql/query_log 0 3584localhost wait/synch/mutex/sql/LOCK_connection_count 0 3585localhost wait/synch/mutex/sql/LOCK_user_locks 0 3586localhost wait/synch/rwlock/sql/LOCK_grant 0 3587execute dump_waits_global; 3588event_name count_star 3589wait/io/file/sql/query_log 0 3590wait/synch/mutex/sql/LOCK_connection_count 0 3591wait/synch/mutex/sql/LOCK_user_locks 0 3592wait/synch/rwlock/sql/LOCK_grant 0 3593execute dump_waits_history; 3594event_name count(event_name) 3595wait/io/file/sql/query_log 20 3596wait/synch/mutex/sql/LOCK_connection_count 4 3597wait/synch/mutex/sql/LOCK_user_locks 8 3598wait/synch/rwlock/sql/LOCK_grant 8 3599execute dump_stages_account; 3600user host event_name count_star 3601user1 localhost stage/sql/checking permissions 0 3602user1 localhost stage/sql/closing tables 0 3603user1 localhost stage/sql/init 0 3604user1 localhost stage/sql/Opening tables 0 3605user2 localhost stage/sql/checking permissions 0 3606user2 localhost stage/sql/closing tables 0 3607user2 localhost stage/sql/init 0 3608user2 localhost stage/sql/Opening tables 0 3609user3 localhost stage/sql/checking permissions 0 3610user3 localhost stage/sql/closing tables 0 3611user3 localhost stage/sql/init 0 3612user3 localhost stage/sql/Opening tables 0 3613user4 localhost stage/sql/checking permissions 0 3614user4 localhost stage/sql/closing tables 0 3615user4 localhost stage/sql/init 0 3616user4 localhost stage/sql/Opening tables 0 3617execute dump_stages_user; 3618user event_name count_star 3619execute dump_stages_host; 3620host event_name count_star 3621localhost stage/sql/checking permissions 0 3622localhost stage/sql/closing tables 0 3623localhost stage/sql/init 0 3624localhost stage/sql/Opening tables 0 3625execute dump_stages_global; 3626event_name count_star 3627stage/sql/checking permissions 0 3628stage/sql/closing tables 0 3629stage/sql/init 0 3630stage/sql/Opening tables 0 3631execute dump_stages_history; 3632event_name count(event_name) 3633stage/sql/checking permissions 12 3634stage/sql/closing tables 12 3635stage/sql/init 28 3636stage/sql/Opening tables 12 3637execute dump_statements_account; 3638user host event_name count_star 3639user1 localhost statement/com/Error 0 3640user1 localhost statement/com/Quit 0 3641user1 localhost statement/sql/insert 0 3642user1 localhost statement/sql/select 0 3643user2 localhost statement/com/Error 0 3644user2 localhost statement/com/Quit 0 3645user2 localhost statement/sql/insert 0 3646user2 localhost statement/sql/select 0 3647user3 localhost statement/com/Error 0 3648user3 localhost statement/com/Quit 0 3649user3 localhost statement/sql/insert 0 3650user3 localhost statement/sql/select 0 3651user4 localhost statement/com/Error 0 3652user4 localhost statement/com/Quit 0 3653user4 localhost statement/sql/insert 0 3654user4 localhost statement/sql/select 0 3655execute dump_statements_user; 3656user event_name count_star 3657execute dump_statements_host; 3658host event_name count_star 3659localhost statement/com/Error 0 3660localhost statement/com/Quit 0 3661localhost statement/sql/insert 0 3662localhost statement/sql/select 0 3663execute dump_statements_global; 3664event_name count_star 3665statement/com/Error 0 3666statement/com/Quit 0 3667statement/sql/insert 0 3668statement/sql/select 0 3669execute dump_statements_history; 3670event_name count(event_name) 3671statement/com/Quit 4 3672statement/sql/insert 4 3673statement/sql/select 8 3674execute dump_accounts; 3675USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3676root localhost 1 1 3677user1 localhost 0 1 3678user2 localhost 0 1 3679user3 localhost 0 1 3680user4 localhost 0 1 3681execute dump_users; 3682USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3683execute dump_hosts; 3684HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3685localhost 1 5 3686truncate performance_schema.accounts; 3687"================== ACCOUNTS truncated ==================" 3688"================== Step 29 ==================" 3689call dump_thread(); 3690username status 3691user1 not found 3692username status 3693user2 not found 3694username status 3695user3 not found 3696username status 3697user4 not found 3698execute dump_waits_account; 3699user host event_name count_star 3700execute dump_waits_user; 3701user event_name count_star 3702execute dump_waits_host; 3703host event_name count_star 3704localhost wait/io/file/sql/query_log 0 3705localhost wait/synch/mutex/sql/LOCK_connection_count 0 3706localhost wait/synch/mutex/sql/LOCK_user_locks 0 3707localhost wait/synch/rwlock/sql/LOCK_grant 0 3708execute dump_waits_global; 3709event_name count_star 3710wait/io/file/sql/query_log 0 3711wait/synch/mutex/sql/LOCK_connection_count 0 3712wait/synch/mutex/sql/LOCK_user_locks 0 3713wait/synch/rwlock/sql/LOCK_grant 0 3714execute dump_waits_history; 3715event_name count(event_name) 3716wait/io/file/sql/query_log 20 3717wait/synch/mutex/sql/LOCK_connection_count 4 3718wait/synch/mutex/sql/LOCK_user_locks 8 3719wait/synch/rwlock/sql/LOCK_grant 8 3720execute dump_stages_account; 3721user host event_name count_star 3722execute dump_stages_user; 3723user event_name count_star 3724execute dump_stages_host; 3725host event_name count_star 3726localhost stage/sql/checking permissions 0 3727localhost stage/sql/closing tables 0 3728localhost stage/sql/init 0 3729localhost stage/sql/Opening tables 0 3730execute dump_stages_global; 3731event_name count_star 3732stage/sql/checking permissions 0 3733stage/sql/closing tables 0 3734stage/sql/init 0 3735stage/sql/Opening tables 0 3736execute dump_stages_history; 3737event_name count(event_name) 3738stage/sql/checking permissions 12 3739stage/sql/closing tables 12 3740stage/sql/init 28 3741stage/sql/Opening tables 12 3742execute dump_statements_account; 3743user host event_name count_star 3744execute dump_statements_user; 3745user event_name count_star 3746execute dump_statements_host; 3747host event_name count_star 3748localhost statement/com/Error 0 3749localhost statement/com/Quit 0 3750localhost statement/sql/insert 0 3751localhost statement/sql/select 0 3752execute dump_statements_global; 3753event_name count_star 3754statement/com/Error 0 3755statement/com/Quit 0 3756statement/sql/insert 0 3757statement/sql/select 0 3758execute dump_statements_history; 3759event_name count(event_name) 3760statement/com/Quit 4 3761statement/sql/insert 4 3762statement/sql/select 8 3763execute dump_accounts; 3764USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3765root localhost 1 1 3766execute dump_users; 3767USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3768execute dump_hosts; 3769HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3770localhost 1 5 3771truncate performance_schema.users; 3772"================== USERS truncated ==================" 3773"================== Step 30 ==================" 3774call dump_thread(); 3775username status 3776user1 not found 3777username status 3778user2 not found 3779username status 3780user3 not found 3781username status 3782user4 not found 3783execute dump_waits_account; 3784user host event_name count_star 3785execute dump_waits_user; 3786user event_name count_star 3787execute dump_waits_host; 3788host event_name count_star 3789localhost wait/io/file/sql/query_log 0 3790localhost wait/synch/mutex/sql/LOCK_connection_count 0 3791localhost wait/synch/mutex/sql/LOCK_user_locks 0 3792localhost wait/synch/rwlock/sql/LOCK_grant 0 3793execute dump_waits_global; 3794event_name count_star 3795wait/io/file/sql/query_log 0 3796wait/synch/mutex/sql/LOCK_connection_count 0 3797wait/synch/mutex/sql/LOCK_user_locks 0 3798wait/synch/rwlock/sql/LOCK_grant 0 3799execute dump_waits_history; 3800event_name count(event_name) 3801wait/io/file/sql/query_log 20 3802wait/synch/mutex/sql/LOCK_connection_count 4 3803wait/synch/mutex/sql/LOCK_user_locks 8 3804wait/synch/rwlock/sql/LOCK_grant 8 3805execute dump_stages_account; 3806user host event_name count_star 3807execute dump_stages_user; 3808user event_name count_star 3809execute dump_stages_host; 3810host event_name count_star 3811localhost stage/sql/checking permissions 0 3812localhost stage/sql/closing tables 0 3813localhost stage/sql/init 0 3814localhost stage/sql/Opening tables 0 3815execute dump_stages_global; 3816event_name count_star 3817stage/sql/checking permissions 0 3818stage/sql/closing tables 0 3819stage/sql/init 0 3820stage/sql/Opening tables 0 3821execute dump_stages_history; 3822event_name count(event_name) 3823stage/sql/checking permissions 12 3824stage/sql/closing tables 12 3825stage/sql/init 28 3826stage/sql/Opening tables 12 3827execute dump_statements_account; 3828user host event_name count_star 3829execute dump_statements_user; 3830user event_name count_star 3831execute dump_statements_host; 3832host event_name count_star 3833localhost statement/com/Error 0 3834localhost statement/com/Quit 0 3835localhost statement/sql/insert 0 3836localhost statement/sql/select 0 3837execute dump_statements_global; 3838event_name count_star 3839statement/com/Error 0 3840statement/com/Quit 0 3841statement/sql/insert 0 3842statement/sql/select 0 3843execute dump_statements_history; 3844event_name count(event_name) 3845statement/com/Quit 4 3846statement/sql/insert 4 3847statement/sql/select 8 3848execute dump_accounts; 3849USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3850root localhost 1 1 3851execute dump_users; 3852USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3853execute dump_hosts; 3854HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3855localhost 1 5 3856truncate performance_schema.hosts; 3857"================== HOSTS truncated ==================" 3858"================== Step 31 ==================" 3859call dump_thread(); 3860username status 3861user1 not found 3862username status 3863user2 not found 3864username status 3865user3 not found 3866username status 3867user4 not found 3868execute dump_waits_account; 3869user host event_name count_star 3870execute dump_waits_user; 3871user event_name count_star 3872execute dump_waits_host; 3873host event_name count_star 3874localhost wait/io/file/sql/query_log 0 3875localhost wait/synch/mutex/sql/LOCK_connection_count 0 3876localhost wait/synch/mutex/sql/LOCK_user_locks 0 3877localhost wait/synch/rwlock/sql/LOCK_grant 0 3878execute dump_waits_global; 3879event_name count_star 3880wait/io/file/sql/query_log 0 3881wait/synch/mutex/sql/LOCK_connection_count 0 3882wait/synch/mutex/sql/LOCK_user_locks 0 3883wait/synch/rwlock/sql/LOCK_grant 0 3884execute dump_waits_history; 3885event_name count(event_name) 3886wait/io/file/sql/query_log 20 3887wait/synch/mutex/sql/LOCK_connection_count 4 3888wait/synch/mutex/sql/LOCK_user_locks 8 3889wait/synch/rwlock/sql/LOCK_grant 8 3890execute dump_stages_account; 3891user host event_name count_star 3892execute dump_stages_user; 3893user event_name count_star 3894execute dump_stages_host; 3895host event_name count_star 3896localhost stage/sql/checking permissions 0 3897localhost stage/sql/closing tables 0 3898localhost stage/sql/init 0 3899localhost stage/sql/Opening tables 0 3900execute dump_stages_global; 3901event_name count_star 3902stage/sql/checking permissions 0 3903stage/sql/closing tables 0 3904stage/sql/init 0 3905stage/sql/Opening tables 0 3906execute dump_stages_history; 3907event_name count(event_name) 3908stage/sql/checking permissions 12 3909stage/sql/closing tables 12 3910stage/sql/init 28 3911stage/sql/Opening tables 12 3912execute dump_statements_account; 3913user host event_name count_star 3914execute dump_statements_user; 3915user event_name count_star 3916execute dump_statements_host; 3917host event_name count_star 3918localhost statement/com/Error 0 3919localhost statement/com/Quit 0 3920localhost statement/sql/insert 0 3921localhost statement/sql/select 0 3922execute dump_statements_global; 3923event_name count_star 3924statement/com/Error 0 3925statement/com/Quit 0 3926statement/sql/insert 0 3927statement/sql/select 0 3928execute dump_statements_history; 3929event_name count(event_name) 3930statement/com/Quit 4 3931statement/sql/insert 4 3932statement/sql/select 8 3933execute dump_accounts; 3934USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3935root localhost 1 1 3936execute dump_users; 3937USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3938execute dump_hosts; 3939HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3940localhost 1 1 3941