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 67execute dump_users; 68USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 69root 1 1 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 89execute dump_waits_user; 90user event_name count_star 91user1 wait/io/file/sql/query_log 1 92user1 wait/synch/mutex/sql/LOCK_connection_count 0 93user1 wait/synch/mutex/sql/LOCK_user_locks 0 94user1 wait/synch/rwlock/sql/LOCK_grant 0 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 112execute dump_stages_user; 113user event_name count_star 114user1 stage/sql/checking permissions 0 115user1 stage/sql/closing tables 0 116user1 stage/sql/init 0 117user1 stage/sql/Opening tables 0 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 134execute dump_statements_user; 135user event_name count_star 136user1 statement/com/Error 0 137user1 statement/com/Quit 0 138user1 statement/sql/insert 0 139user1 statement/sql/select 0 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 156execute dump_users; 157USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 158root 1 1 159user1 1 1 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 186execute dump_waits_user; 187user event_name count_star 188user1 wait/io/file/sql/query_log 4 189user1 wait/synch/mutex/sql/LOCK_connection_count 0 190user1 wait/synch/mutex/sql/LOCK_user_locks 2 191user1 wait/synch/rwlock/sql/LOCK_grant 2 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 211execute dump_stages_user; 212user event_name count_star 213user1 stage/sql/checking permissions 3 214user1 stage/sql/closing tables 3 215user1 stage/sql/init 6 216user1 stage/sql/Opening tables 3 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 237execute dump_statements_user; 238user event_name count_star 239user1 statement/com/Error 0 240user1 statement/com/Quit 0 241user1 statement/sql/insert 1 242user1 statement/sql/select 2 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 261execute dump_users; 262USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 263root 1 1 264user1 1 1 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 287execute dump_waits_user; 288user event_name count_star 289user1 wait/io/file/sql/query_log 4 290user1 wait/synch/mutex/sql/LOCK_connection_count 0 291user1 wait/synch/mutex/sql/LOCK_user_locks 2 292user1 wait/synch/rwlock/sql/LOCK_grant 2 293user2 wait/io/file/sql/query_log 1 294user2 wait/synch/mutex/sql/LOCK_connection_count 0 295user2 wait/synch/mutex/sql/LOCK_user_locks 0 296user2 wait/synch/rwlock/sql/LOCK_grant 0 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 316execute dump_stages_user; 317user event_name count_star 318user1 stage/sql/checking permissions 3 319user1 stage/sql/closing tables 3 320user1 stage/sql/init 6 321user1 stage/sql/Opening tables 3 322user2 stage/sql/checking permissions 0 323user2 stage/sql/closing tables 0 324user2 stage/sql/init 0 325user2 stage/sql/Opening tables 0 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 346execute dump_statements_user; 347user event_name count_star 348user1 statement/com/Error 0 349user1 statement/com/Quit 0 350user1 statement/sql/insert 1 351user1 statement/sql/select 2 352user2 statement/com/Error 0 353user2 statement/com/Quit 0 354user2 statement/sql/insert 0 355user2 statement/sql/select 0 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 374execute dump_users; 375USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 376root 1 1 377user1 1 1 378user2 1 1 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 408execute dump_waits_user; 409user event_name count_star 410user1 wait/io/file/sql/query_log 4 411user1 wait/synch/mutex/sql/LOCK_connection_count 0 412user1 wait/synch/mutex/sql/LOCK_user_locks 2 413user1 wait/synch/rwlock/sql/LOCK_grant 2 414user2 wait/io/file/sql/query_log 4 415user2 wait/synch/mutex/sql/LOCK_connection_count 0 416user2 wait/synch/mutex/sql/LOCK_user_locks 2 417user2 wait/synch/rwlock/sql/LOCK_grant 2 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 437execute dump_stages_user; 438user event_name count_star 439user1 stage/sql/checking permissions 3 440user1 stage/sql/closing tables 3 441user1 stage/sql/init 6 442user1 stage/sql/Opening tables 3 443user2 stage/sql/checking permissions 3 444user2 stage/sql/closing tables 3 445user2 stage/sql/init 6 446user2 stage/sql/Opening tables 3 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 467execute dump_statements_user; 468user event_name count_star 469user1 statement/com/Error 0 470user1 statement/com/Quit 0 471user1 statement/sql/insert 1 472user1 statement/sql/select 2 473user2 statement/com/Error 0 474user2 statement/com/Quit 0 475user2 statement/sql/insert 1 476user2 statement/sql/select 2 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 495execute dump_users; 496USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 497root 1 1 498user1 1 1 499user2 1 1 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 525execute dump_waits_user; 526user event_name count_star 527user1 wait/io/file/sql/query_log 4 528user1 wait/synch/mutex/sql/LOCK_connection_count 0 529user1 wait/synch/mutex/sql/LOCK_user_locks 2 530user1 wait/synch/rwlock/sql/LOCK_grant 2 531user2 wait/io/file/sql/query_log 4 532user2 wait/synch/mutex/sql/LOCK_connection_count 0 533user2 wait/synch/mutex/sql/LOCK_user_locks 2 534user2 wait/synch/rwlock/sql/LOCK_grant 2 535user3 wait/io/file/sql/query_log 1 536user3 wait/synch/mutex/sql/LOCK_connection_count 0 537user3 wait/synch/mutex/sql/LOCK_user_locks 0 538user3 wait/synch/rwlock/sql/LOCK_grant 0 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 558execute dump_stages_user; 559user event_name count_star 560user1 stage/sql/checking permissions 3 561user1 stage/sql/closing tables 3 562user1 stage/sql/init 6 563user1 stage/sql/Opening tables 3 564user2 stage/sql/checking permissions 3 565user2 stage/sql/closing tables 3 566user2 stage/sql/init 6 567user2 stage/sql/Opening tables 3 568user3 stage/sql/checking permissions 0 569user3 stage/sql/closing tables 0 570user3 stage/sql/init 0 571user3 stage/sql/Opening tables 0 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 592execute dump_statements_user; 593user event_name count_star 594user1 statement/com/Error 0 595user1 statement/com/Quit 0 596user1 statement/sql/insert 1 597user1 statement/sql/select 2 598user2 statement/com/Error 0 599user2 statement/com/Quit 0 600user2 statement/sql/insert 1 601user2 statement/sql/select 2 602user3 statement/com/Error 0 603user3 statement/com/Quit 0 604user3 statement/sql/insert 0 605user3 statement/sql/select 0 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 624execute dump_users; 625USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 626root 1 1 627user1 1 1 628user2 1 1 629user3 1 1 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 662execute dump_waits_user; 663user event_name count_star 664user1 wait/io/file/sql/query_log 4 665user1 wait/synch/mutex/sql/LOCK_connection_count 0 666user1 wait/synch/mutex/sql/LOCK_user_locks 2 667user1 wait/synch/rwlock/sql/LOCK_grant 2 668user2 wait/io/file/sql/query_log 4 669user2 wait/synch/mutex/sql/LOCK_connection_count 0 670user2 wait/synch/mutex/sql/LOCK_user_locks 2 671user2 wait/synch/rwlock/sql/LOCK_grant 2 672user3 wait/io/file/sql/query_log 4 673user3 wait/synch/mutex/sql/LOCK_connection_count 0 674user3 wait/synch/mutex/sql/LOCK_user_locks 2 675user3 wait/synch/rwlock/sql/LOCK_grant 2 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 695execute dump_stages_user; 696user event_name count_star 697user1 stage/sql/checking permissions 3 698user1 stage/sql/closing tables 3 699user1 stage/sql/init 6 700user1 stage/sql/Opening tables 3 701user2 stage/sql/checking permissions 3 702user2 stage/sql/closing tables 3 703user2 stage/sql/init 6 704user2 stage/sql/Opening tables 3 705user3 stage/sql/checking permissions 3 706user3 stage/sql/closing tables 3 707user3 stage/sql/init 6 708user3 stage/sql/Opening tables 3 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 729execute dump_statements_user; 730user event_name count_star 731user1 statement/com/Error 0 732user1 statement/com/Quit 0 733user1 statement/sql/insert 1 734user1 statement/sql/select 2 735user2 statement/com/Error 0 736user2 statement/com/Quit 0 737user2 statement/sql/insert 1 738user2 statement/sql/select 2 739user3 statement/com/Error 0 740user3 statement/com/Quit 0 741user3 statement/sql/insert 1 742user3 statement/sql/select 2 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 761execute dump_users; 762USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 763root 1 1 764user1 1 1 765user2 1 1 766user3 1 1 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 795execute dump_waits_user; 796user event_name count_star 797user1 wait/io/file/sql/query_log 4 798user1 wait/synch/mutex/sql/LOCK_connection_count 0 799user1 wait/synch/mutex/sql/LOCK_user_locks 2 800user1 wait/synch/rwlock/sql/LOCK_grant 2 801user2 wait/io/file/sql/query_log 4 802user2 wait/synch/mutex/sql/LOCK_connection_count 0 803user2 wait/synch/mutex/sql/LOCK_user_locks 2 804user2 wait/synch/rwlock/sql/LOCK_grant 2 805user3 wait/io/file/sql/query_log 4 806user3 wait/synch/mutex/sql/LOCK_connection_count 0 807user3 wait/synch/mutex/sql/LOCK_user_locks 2 808user3 wait/synch/rwlock/sql/LOCK_grant 2 809user4 wait/io/file/sql/query_log 1 810user4 wait/synch/mutex/sql/LOCK_connection_count 0 811user4 wait/synch/mutex/sql/LOCK_user_locks 0 812user4 wait/synch/rwlock/sql/LOCK_grant 0 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 832execute dump_stages_user; 833user event_name count_star 834user1 stage/sql/checking permissions 3 835user1 stage/sql/closing tables 3 836user1 stage/sql/init 6 837user1 stage/sql/Opening tables 3 838user2 stage/sql/checking permissions 3 839user2 stage/sql/closing tables 3 840user2 stage/sql/init 6 841user2 stage/sql/Opening tables 3 842user3 stage/sql/checking permissions 3 843user3 stage/sql/closing tables 3 844user3 stage/sql/init 6 845user3 stage/sql/Opening tables 3 846user4 stage/sql/checking permissions 0 847user4 stage/sql/closing tables 0 848user4 stage/sql/init 0 849user4 stage/sql/Opening tables 0 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 870execute dump_statements_user; 871user event_name count_star 872user1 statement/com/Error 0 873user1 statement/com/Quit 0 874user1 statement/sql/insert 1 875user1 statement/sql/select 2 876user2 statement/com/Error 0 877user2 statement/com/Quit 0 878user2 statement/sql/insert 1 879user2 statement/sql/select 2 880user3 statement/com/Error 0 881user3 statement/com/Quit 0 882user3 statement/sql/insert 1 883user3 statement/sql/select 2 884user4 statement/com/Error 0 885user4 statement/com/Quit 0 886user4 statement/sql/insert 0 887user4 statement/sql/select 0 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 906execute dump_users; 907USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 908root 1 1 909user1 1 1 910user2 1 1 911user3 1 1 912user4 1 1 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 948execute dump_waits_user; 949user event_name count_star 950user1 wait/io/file/sql/query_log 4 951user1 wait/synch/mutex/sql/LOCK_connection_count 0 952user1 wait/synch/mutex/sql/LOCK_user_locks 2 953user1 wait/synch/rwlock/sql/LOCK_grant 2 954user2 wait/io/file/sql/query_log 4 955user2 wait/synch/mutex/sql/LOCK_connection_count 0 956user2 wait/synch/mutex/sql/LOCK_user_locks 2 957user2 wait/synch/rwlock/sql/LOCK_grant 2 958user3 wait/io/file/sql/query_log 4 959user3 wait/synch/mutex/sql/LOCK_connection_count 0 960user3 wait/synch/mutex/sql/LOCK_user_locks 2 961user3 wait/synch/rwlock/sql/LOCK_grant 2 962user4 wait/io/file/sql/query_log 4 963user4 wait/synch/mutex/sql/LOCK_connection_count 0 964user4 wait/synch/mutex/sql/LOCK_user_locks 2 965user4 wait/synch/rwlock/sql/LOCK_grant 2 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 985execute dump_stages_user; 986user event_name count_star 987user1 stage/sql/checking permissions 3 988user1 stage/sql/closing tables 3 989user1 stage/sql/init 6 990user1 stage/sql/Opening tables 3 991user2 stage/sql/checking permissions 3 992user2 stage/sql/closing tables 3 993user2 stage/sql/init 6 994user2 stage/sql/Opening tables 3 995user3 stage/sql/checking permissions 3 996user3 stage/sql/closing tables 3 997user3 stage/sql/init 6 998user3 stage/sql/Opening tables 3 999user4 stage/sql/checking permissions 3 1000user4 stage/sql/closing tables 3 1001user4 stage/sql/init 6 1002user4 stage/sql/Opening tables 3 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 1023execute dump_statements_user; 1024user event_name count_star 1025user1 statement/com/Error 0 1026user1 statement/com/Quit 0 1027user1 statement/sql/insert 1 1028user1 statement/sql/select 2 1029user2 statement/com/Error 0 1030user2 statement/com/Quit 0 1031user2 statement/sql/insert 1 1032user2 statement/sql/select 2 1033user3 statement/com/Error 0 1034user3 statement/com/Quit 0 1035user3 statement/sql/insert 1 1036user3 statement/sql/select 2 1037user4 statement/com/Error 0 1038user4 statement/com/Quit 0 1039user4 statement/sql/insert 1 1040user4 statement/sql/select 2 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 1059execute dump_users; 1060USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1061root 1 1 1062user1 1 1 1063user2 1 1 1064user3 1 1 1065user4 1 1 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 1091execute dump_waits_user; 1092user event_name count_star 1093user1 wait/io/file/sql/query_log 5 1094user1 wait/synch/mutex/sql/LOCK_connection_count 1 1095user1 wait/synch/mutex/sql/LOCK_user_locks 2 1096user1 wait/synch/rwlock/sql/LOCK_grant 2 1097user2 wait/io/file/sql/query_log 4 1098user2 wait/synch/mutex/sql/LOCK_connection_count 0 1099user2 wait/synch/mutex/sql/LOCK_user_locks 2 1100user2 wait/synch/rwlock/sql/LOCK_grant 2 1101user3 wait/io/file/sql/query_log 4 1102user3 wait/synch/mutex/sql/LOCK_connection_count 0 1103user3 wait/synch/mutex/sql/LOCK_user_locks 2 1104user3 wait/synch/rwlock/sql/LOCK_grant 2 1105user4 wait/io/file/sql/query_log 4 1106user4 wait/synch/mutex/sql/LOCK_connection_count 0 1107user4 wait/synch/mutex/sql/LOCK_user_locks 2 1108user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1129execute dump_stages_user; 1130user event_name count_star 1131user1 stage/sql/checking permissions 3 1132user1 stage/sql/closing tables 3 1133user1 stage/sql/init 7 1134user1 stage/sql/Opening tables 3 1135user2 stage/sql/checking permissions 3 1136user2 stage/sql/closing tables 3 1137user2 stage/sql/init 6 1138user2 stage/sql/Opening tables 3 1139user3 stage/sql/checking permissions 3 1140user3 stage/sql/closing tables 3 1141user3 stage/sql/init 6 1142user3 stage/sql/Opening tables 3 1143user4 stage/sql/checking permissions 3 1144user4 stage/sql/closing tables 3 1145user4 stage/sql/init 6 1146user4 stage/sql/Opening tables 3 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 1167execute dump_statements_user; 1168user event_name count_star 1169user1 statement/com/Error 0 1170user1 statement/com/Quit 1 1171user1 statement/sql/insert 1 1172user1 statement/sql/select 2 1173user2 statement/com/Error 0 1174user2 statement/com/Quit 0 1175user2 statement/sql/insert 1 1176user2 statement/sql/select 2 1177user3 statement/com/Error 0 1178user3 statement/com/Quit 0 1179user3 statement/sql/insert 1 1180user3 statement/sql/select 2 1181user4 statement/com/Error 0 1182user4 statement/com/Quit 0 1183user4 statement/sql/insert 1 1184user4 statement/sql/select 2 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 1204execute dump_users; 1205USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1206root 1 1 1207user1 0 1 1208user2 1 1 1209user3 1 1 1210user4 1 1 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 1233execute dump_waits_user; 1234user event_name count_star 1235user1 wait/io/file/sql/query_log 5 1236user1 wait/synch/mutex/sql/LOCK_connection_count 1 1237user1 wait/synch/mutex/sql/LOCK_user_locks 2 1238user1 wait/synch/rwlock/sql/LOCK_grant 2 1239user2 wait/io/file/sql/query_log 5 1240user2 wait/synch/mutex/sql/LOCK_connection_count 1 1241user2 wait/synch/mutex/sql/LOCK_user_locks 2 1242user2 wait/synch/rwlock/sql/LOCK_grant 2 1243user3 wait/io/file/sql/query_log 4 1244user3 wait/synch/mutex/sql/LOCK_connection_count 0 1245user3 wait/synch/mutex/sql/LOCK_user_locks 2 1246user3 wait/synch/rwlock/sql/LOCK_grant 2 1247user4 wait/io/file/sql/query_log 4 1248user4 wait/synch/mutex/sql/LOCK_connection_count 0 1249user4 wait/synch/mutex/sql/LOCK_user_locks 2 1250user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1271execute dump_stages_user; 1272user event_name count_star 1273user1 stage/sql/checking permissions 3 1274user1 stage/sql/closing tables 3 1275user1 stage/sql/init 7 1276user1 stage/sql/Opening tables 3 1277user2 stage/sql/checking permissions 3 1278user2 stage/sql/closing tables 3 1279user2 stage/sql/init 7 1280user2 stage/sql/Opening tables 3 1281user3 stage/sql/checking permissions 3 1282user3 stage/sql/closing tables 3 1283user3 stage/sql/init 6 1284user3 stage/sql/Opening tables 3 1285user4 stage/sql/checking permissions 3 1286user4 stage/sql/closing tables 3 1287user4 stage/sql/init 6 1288user4 stage/sql/Opening tables 3 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 1309execute dump_statements_user; 1310user event_name count_star 1311user1 statement/com/Error 0 1312user1 statement/com/Quit 1 1313user1 statement/sql/insert 1 1314user1 statement/sql/select 2 1315user2 statement/com/Error 0 1316user2 statement/com/Quit 1 1317user2 statement/sql/insert 1 1318user2 statement/sql/select 2 1319user3 statement/com/Error 0 1320user3 statement/com/Quit 0 1321user3 statement/sql/insert 1 1322user3 statement/sql/select 2 1323user4 statement/com/Error 0 1324user4 statement/com/Quit 0 1325user4 statement/sql/insert 1 1326user4 statement/sql/select 2 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 1346execute dump_users; 1347USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1348root 1 1 1349user1 0 1 1350user2 0 1 1351user3 1 1 1352user4 1 1 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 1372execute dump_waits_user; 1373user event_name count_star 1374user1 wait/io/file/sql/query_log 5 1375user1 wait/synch/mutex/sql/LOCK_connection_count 1 1376user1 wait/synch/mutex/sql/LOCK_user_locks 2 1377user1 wait/synch/rwlock/sql/LOCK_grant 2 1378user2 wait/io/file/sql/query_log 5 1379user2 wait/synch/mutex/sql/LOCK_connection_count 1 1380user2 wait/synch/mutex/sql/LOCK_user_locks 2 1381user2 wait/synch/rwlock/sql/LOCK_grant 2 1382user3 wait/io/file/sql/query_log 5 1383user3 wait/synch/mutex/sql/LOCK_connection_count 1 1384user3 wait/synch/mutex/sql/LOCK_user_locks 2 1385user3 wait/synch/rwlock/sql/LOCK_grant 2 1386user4 wait/io/file/sql/query_log 4 1387user4 wait/synch/mutex/sql/LOCK_connection_count 0 1388user4 wait/synch/mutex/sql/LOCK_user_locks 2 1389user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1410execute dump_stages_user; 1411user event_name count_star 1412user1 stage/sql/checking permissions 3 1413user1 stage/sql/closing tables 3 1414user1 stage/sql/init 7 1415user1 stage/sql/Opening tables 3 1416user2 stage/sql/checking permissions 3 1417user2 stage/sql/closing tables 3 1418user2 stage/sql/init 7 1419user2 stage/sql/Opening tables 3 1420user3 stage/sql/checking permissions 3 1421user3 stage/sql/closing tables 3 1422user3 stage/sql/init 7 1423user3 stage/sql/Opening tables 3 1424user4 stage/sql/checking permissions 3 1425user4 stage/sql/closing tables 3 1426user4 stage/sql/init 6 1427user4 stage/sql/Opening tables 3 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 1448execute dump_statements_user; 1449user event_name count_star 1450user1 statement/com/Error 0 1451user1 statement/com/Quit 1 1452user1 statement/sql/insert 1 1453user1 statement/sql/select 2 1454user2 statement/com/Error 0 1455user2 statement/com/Quit 1 1456user2 statement/sql/insert 1 1457user2 statement/sql/select 2 1458user3 statement/com/Error 0 1459user3 statement/com/Quit 1 1460user3 statement/sql/insert 1 1461user3 statement/sql/select 2 1462user4 statement/com/Error 0 1463user4 statement/com/Quit 0 1464user4 statement/sql/insert 1 1465user4 statement/sql/select 2 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 1485execute dump_users; 1486USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1487root 1 1 1488user1 0 1 1489user2 0 1 1490user3 0 1 1491user4 1 1 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 1508execute dump_waits_user; 1509user event_name count_star 1510user1 wait/io/file/sql/query_log 5 1511user1 wait/synch/mutex/sql/LOCK_connection_count 1 1512user1 wait/synch/mutex/sql/LOCK_user_locks 2 1513user1 wait/synch/rwlock/sql/LOCK_grant 2 1514user2 wait/io/file/sql/query_log 5 1515user2 wait/synch/mutex/sql/LOCK_connection_count 1 1516user2 wait/synch/mutex/sql/LOCK_user_locks 2 1517user2 wait/synch/rwlock/sql/LOCK_grant 2 1518user3 wait/io/file/sql/query_log 5 1519user3 wait/synch/mutex/sql/LOCK_connection_count 1 1520user3 wait/synch/mutex/sql/LOCK_user_locks 2 1521user3 wait/synch/rwlock/sql/LOCK_grant 2 1522user4 wait/io/file/sql/query_log 5 1523user4 wait/synch/mutex/sql/LOCK_connection_count 1 1524user4 wait/synch/mutex/sql/LOCK_user_locks 2 1525user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1546execute dump_stages_user; 1547user event_name count_star 1548user1 stage/sql/checking permissions 3 1549user1 stage/sql/closing tables 3 1550user1 stage/sql/init 7 1551user1 stage/sql/Opening tables 3 1552user2 stage/sql/checking permissions 3 1553user2 stage/sql/closing tables 3 1554user2 stage/sql/init 7 1555user2 stage/sql/Opening tables 3 1556user3 stage/sql/checking permissions 3 1557user3 stage/sql/closing tables 3 1558user3 stage/sql/init 7 1559user3 stage/sql/Opening tables 3 1560user4 stage/sql/checking permissions 3 1561user4 stage/sql/closing tables 3 1562user4 stage/sql/init 7 1563user4 stage/sql/Opening tables 3 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 1584execute dump_statements_user; 1585user event_name count_star 1586user1 statement/com/Error 0 1587user1 statement/com/Quit 1 1588user1 statement/sql/insert 1 1589user1 statement/sql/select 2 1590user2 statement/com/Error 0 1591user2 statement/com/Quit 1 1592user2 statement/sql/insert 1 1593user2 statement/sql/select 2 1594user3 statement/com/Error 0 1595user3 statement/com/Quit 1 1596user3 statement/sql/insert 1 1597user3 statement/sql/select 2 1598user4 statement/com/Error 0 1599user4 statement/com/Quit 1 1600user4 statement/sql/insert 1 1601user4 statement/sql/select 2 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 1621execute dump_users; 1622USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1623root 1 1 1624user1 0 1 1625user2 0 1 1626user3 0 1 1627user4 0 1 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 1645execute dump_waits_user; 1646user event_name count_star 1647user1 wait/io/file/sql/query_log 5 1648user1 wait/synch/mutex/sql/LOCK_connection_count 1 1649user1 wait/synch/mutex/sql/LOCK_user_locks 2 1650user1 wait/synch/rwlock/sql/LOCK_grant 2 1651user2 wait/io/file/sql/query_log 5 1652user2 wait/synch/mutex/sql/LOCK_connection_count 1 1653user2 wait/synch/mutex/sql/LOCK_user_locks 2 1654user2 wait/synch/rwlock/sql/LOCK_grant 2 1655user3 wait/io/file/sql/query_log 5 1656user3 wait/synch/mutex/sql/LOCK_connection_count 1 1657user3 wait/synch/mutex/sql/LOCK_user_locks 2 1658user3 wait/synch/rwlock/sql/LOCK_grant 2 1659user4 wait/io/file/sql/query_log 5 1660user4 wait/synch/mutex/sql/LOCK_connection_count 1 1661user4 wait/synch/mutex/sql/LOCK_user_locks 2 1662user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1683execute dump_stages_user; 1684user event_name count_star 1685user1 stage/sql/checking permissions 3 1686user1 stage/sql/closing tables 3 1687user1 stage/sql/init 7 1688user1 stage/sql/Opening tables 3 1689user2 stage/sql/checking permissions 3 1690user2 stage/sql/closing tables 3 1691user2 stage/sql/init 7 1692user2 stage/sql/Opening tables 3 1693user3 stage/sql/checking permissions 3 1694user3 stage/sql/closing tables 3 1695user3 stage/sql/init 7 1696user3 stage/sql/Opening tables 3 1697user4 stage/sql/checking permissions 3 1698user4 stage/sql/closing tables 3 1699user4 stage/sql/init 7 1700user4 stage/sql/Opening tables 3 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 1721execute dump_statements_user; 1722user event_name count_star 1723user1 statement/com/Error 0 1724user1 statement/com/Quit 1 1725user1 statement/sql/insert 1 1726user1 statement/sql/select 2 1727user2 statement/com/Error 0 1728user2 statement/com/Quit 1 1729user2 statement/sql/insert 1 1730user2 statement/sql/select 2 1731user3 statement/com/Error 0 1732user3 statement/com/Quit 1 1733user3 statement/sql/insert 1 1734user3 statement/sql/select 2 1735user4 statement/com/Error 0 1736user4 statement/com/Quit 1 1737user4 statement/sql/insert 1 1738user4 statement/sql/select 2 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 1758execute dump_users; 1759USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1760root 1 1 1761user1 0 1 1762user2 0 1 1763user3 0 1 1764user4 0 1 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 1782execute dump_waits_user; 1783user event_name count_star 1784user1 wait/io/file/sql/query_log 5 1785user1 wait/synch/mutex/sql/LOCK_connection_count 1 1786user1 wait/synch/mutex/sql/LOCK_user_locks 2 1787user1 wait/synch/rwlock/sql/LOCK_grant 2 1788user2 wait/io/file/sql/query_log 5 1789user2 wait/synch/mutex/sql/LOCK_connection_count 1 1790user2 wait/synch/mutex/sql/LOCK_user_locks 2 1791user2 wait/synch/rwlock/sql/LOCK_grant 2 1792user3 wait/io/file/sql/query_log 5 1793user3 wait/synch/mutex/sql/LOCK_connection_count 1 1794user3 wait/synch/mutex/sql/LOCK_user_locks 2 1795user3 wait/synch/rwlock/sql/LOCK_grant 2 1796user4 wait/io/file/sql/query_log 5 1797user4 wait/synch/mutex/sql/LOCK_connection_count 1 1798user4 wait/synch/mutex/sql/LOCK_user_locks 2 1799user4 wait/synch/rwlock/sql/LOCK_grant 2 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 1820execute dump_stages_user; 1821user event_name count_star 1822user1 stage/sql/checking permissions 3 1823user1 stage/sql/closing tables 3 1824user1 stage/sql/init 7 1825user1 stage/sql/Opening tables 3 1826user2 stage/sql/checking permissions 3 1827user2 stage/sql/closing tables 3 1828user2 stage/sql/init 7 1829user2 stage/sql/Opening tables 3 1830user3 stage/sql/checking permissions 3 1831user3 stage/sql/closing tables 3 1832user3 stage/sql/init 7 1833user3 stage/sql/Opening tables 3 1834user4 stage/sql/checking permissions 3 1835user4 stage/sql/closing tables 3 1836user4 stage/sql/init 7 1837user4 stage/sql/Opening tables 3 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 1858execute dump_statements_user; 1859user event_name count_star 1860user1 statement/com/Error 0 1861user1 statement/com/Quit 1 1862user1 statement/sql/insert 1 1863user1 statement/sql/select 2 1864user2 statement/com/Error 0 1865user2 statement/com/Quit 1 1866user2 statement/sql/insert 1 1867user2 statement/sql/select 2 1868user3 statement/com/Error 0 1869user3 statement/com/Quit 1 1870user3 statement/sql/insert 1 1871user3 statement/sql/select 2 1872user4 statement/com/Error 0 1873user4 statement/com/Quit 1 1874user4 statement/sql/insert 1 1875user4 statement/sql/select 2 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 1895execute dump_users; 1896USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 1897root 1 1 1898user1 0 1 1899user2 0 1 1900user3 0 1 1901user4 0 1 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 1919execute dump_waits_user; 1920user event_name count_star 1921user1 wait/io/file/sql/query_log 0 1922user1 wait/synch/mutex/sql/LOCK_connection_count 0 1923user1 wait/synch/mutex/sql/LOCK_user_locks 0 1924user1 wait/synch/rwlock/sql/LOCK_grant 0 1925user2 wait/io/file/sql/query_log 0 1926user2 wait/synch/mutex/sql/LOCK_connection_count 0 1927user2 wait/synch/mutex/sql/LOCK_user_locks 0 1928user2 wait/synch/rwlock/sql/LOCK_grant 0 1929user3 wait/io/file/sql/query_log 0 1930user3 wait/synch/mutex/sql/LOCK_connection_count 0 1931user3 wait/synch/mutex/sql/LOCK_user_locks 0 1932user3 wait/synch/rwlock/sql/LOCK_grant 0 1933user4 wait/io/file/sql/query_log 0 1934user4 wait/synch/mutex/sql/LOCK_connection_count 0 1935user4 wait/synch/mutex/sql/LOCK_user_locks 0 1936user4 wait/synch/rwlock/sql/LOCK_grant 0 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 1957execute dump_stages_user; 1958user event_name count_star 1959user1 stage/sql/checking permissions 3 1960user1 stage/sql/closing tables 3 1961user1 stage/sql/init 7 1962user1 stage/sql/Opening tables 3 1963user2 stage/sql/checking permissions 3 1964user2 stage/sql/closing tables 3 1965user2 stage/sql/init 7 1966user2 stage/sql/Opening tables 3 1967user3 stage/sql/checking permissions 3 1968user3 stage/sql/closing tables 3 1969user3 stage/sql/init 7 1970user3 stage/sql/Opening tables 3 1971user4 stage/sql/checking permissions 3 1972user4 stage/sql/closing tables 3 1973user4 stage/sql/init 7 1974user4 stage/sql/Opening tables 3 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 1995execute dump_statements_user; 1996user event_name count_star 1997user1 statement/com/Error 0 1998user1 statement/com/Quit 1 1999user1 statement/sql/insert 1 2000user1 statement/sql/select 2 2001user2 statement/com/Error 0 2002user2 statement/com/Quit 1 2003user2 statement/sql/insert 1 2004user2 statement/sql/select 2 2005user3 statement/com/Error 0 2006user3 statement/com/Quit 1 2007user3 statement/sql/insert 1 2008user3 statement/sql/select 2 2009user4 statement/com/Error 0 2010user4 statement/com/Quit 1 2011user4 statement/sql/insert 1 2012user4 statement/sql/select 2 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 2032execute dump_users; 2033USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2034root 1 1 2035user1 0 1 2036user2 0 1 2037user3 0 1 2038user4 0 1 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 2056execute dump_waits_user; 2057user event_name count_star 2058user1 wait/io/file/sql/query_log 0 2059user1 wait/synch/mutex/sql/LOCK_connection_count 0 2060user1 wait/synch/mutex/sql/LOCK_user_locks 0 2061user1 wait/synch/rwlock/sql/LOCK_grant 0 2062user2 wait/io/file/sql/query_log 0 2063user2 wait/synch/mutex/sql/LOCK_connection_count 0 2064user2 wait/synch/mutex/sql/LOCK_user_locks 0 2065user2 wait/synch/rwlock/sql/LOCK_grant 0 2066user3 wait/io/file/sql/query_log 0 2067user3 wait/synch/mutex/sql/LOCK_connection_count 0 2068user3 wait/synch/mutex/sql/LOCK_user_locks 0 2069user3 wait/synch/rwlock/sql/LOCK_grant 0 2070user4 wait/io/file/sql/query_log 0 2071user4 wait/synch/mutex/sql/LOCK_connection_count 0 2072user4 wait/synch/mutex/sql/LOCK_user_locks 0 2073user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2094execute dump_stages_user; 2095user event_name count_star 2096user1 stage/sql/checking permissions 3 2097user1 stage/sql/closing tables 3 2098user1 stage/sql/init 7 2099user1 stage/sql/Opening tables 3 2100user2 stage/sql/checking permissions 3 2101user2 stage/sql/closing tables 3 2102user2 stage/sql/init 7 2103user2 stage/sql/Opening tables 3 2104user3 stage/sql/checking permissions 3 2105user3 stage/sql/closing tables 3 2106user3 stage/sql/init 7 2107user3 stage/sql/Opening tables 3 2108user4 stage/sql/checking permissions 3 2109user4 stage/sql/closing tables 3 2110user4 stage/sql/init 7 2111user4 stage/sql/Opening tables 3 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 2132execute dump_statements_user; 2133user event_name count_star 2134user1 statement/com/Error 0 2135user1 statement/com/Quit 1 2136user1 statement/sql/insert 1 2137user1 statement/sql/select 2 2138user2 statement/com/Error 0 2139user2 statement/com/Quit 1 2140user2 statement/sql/insert 1 2141user2 statement/sql/select 2 2142user3 statement/com/Error 0 2143user3 statement/com/Quit 1 2144user3 statement/sql/insert 1 2145user3 statement/sql/select 2 2146user4 statement/com/Error 0 2147user4 statement/com/Quit 1 2148user4 statement/sql/insert 1 2149user4 statement/sql/select 2 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 2169execute dump_users; 2170USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2171root 1 1 2172user1 0 1 2173user2 0 1 2174user3 0 1 2175user4 0 1 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 2193execute dump_waits_user; 2194user event_name count_star 2195user1 wait/io/file/sql/query_log 0 2196user1 wait/synch/mutex/sql/LOCK_connection_count 0 2197user1 wait/synch/mutex/sql/LOCK_user_locks 0 2198user1 wait/synch/rwlock/sql/LOCK_grant 0 2199user2 wait/io/file/sql/query_log 0 2200user2 wait/synch/mutex/sql/LOCK_connection_count 0 2201user2 wait/synch/mutex/sql/LOCK_user_locks 0 2202user2 wait/synch/rwlock/sql/LOCK_grant 0 2203user3 wait/io/file/sql/query_log 0 2204user3 wait/synch/mutex/sql/LOCK_connection_count 0 2205user3 wait/synch/mutex/sql/LOCK_user_locks 0 2206user3 wait/synch/rwlock/sql/LOCK_grant 0 2207user4 wait/io/file/sql/query_log 0 2208user4 wait/synch/mutex/sql/LOCK_connection_count 0 2209user4 wait/synch/mutex/sql/LOCK_user_locks 0 2210user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2231execute dump_stages_user; 2232user event_name count_star 2233user1 stage/sql/checking permissions 3 2234user1 stage/sql/closing tables 3 2235user1 stage/sql/init 7 2236user1 stage/sql/Opening tables 3 2237user2 stage/sql/checking permissions 3 2238user2 stage/sql/closing tables 3 2239user2 stage/sql/init 7 2240user2 stage/sql/Opening tables 3 2241user3 stage/sql/checking permissions 3 2242user3 stage/sql/closing tables 3 2243user3 stage/sql/init 7 2244user3 stage/sql/Opening tables 3 2245user4 stage/sql/checking permissions 3 2246user4 stage/sql/closing tables 3 2247user4 stage/sql/init 7 2248user4 stage/sql/Opening tables 3 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 2269execute dump_statements_user; 2270user event_name count_star 2271user1 statement/com/Error 0 2272user1 statement/com/Quit 1 2273user1 statement/sql/insert 1 2274user1 statement/sql/select 2 2275user2 statement/com/Error 0 2276user2 statement/com/Quit 1 2277user2 statement/sql/insert 1 2278user2 statement/sql/select 2 2279user3 statement/com/Error 0 2280user3 statement/com/Quit 1 2281user3 statement/sql/insert 1 2282user3 statement/sql/select 2 2283user4 statement/com/Error 0 2284user4 statement/com/Quit 1 2285user4 statement/sql/insert 1 2286user4 statement/sql/select 2 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 2306execute dump_users; 2307USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2308root 1 1 2309user1 0 1 2310user2 0 1 2311user3 0 1 2312user4 0 1 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 2330execute dump_waits_user; 2331user event_name count_star 2332user1 wait/io/file/sql/query_log 0 2333user1 wait/synch/mutex/sql/LOCK_connection_count 0 2334user1 wait/synch/mutex/sql/LOCK_user_locks 0 2335user1 wait/synch/rwlock/sql/LOCK_grant 0 2336user2 wait/io/file/sql/query_log 0 2337user2 wait/synch/mutex/sql/LOCK_connection_count 0 2338user2 wait/synch/mutex/sql/LOCK_user_locks 0 2339user2 wait/synch/rwlock/sql/LOCK_grant 0 2340user3 wait/io/file/sql/query_log 0 2341user3 wait/synch/mutex/sql/LOCK_connection_count 0 2342user3 wait/synch/mutex/sql/LOCK_user_locks 0 2343user3 wait/synch/rwlock/sql/LOCK_grant 0 2344user4 wait/io/file/sql/query_log 0 2345user4 wait/synch/mutex/sql/LOCK_connection_count 0 2346user4 wait/synch/mutex/sql/LOCK_user_locks 0 2347user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2368execute dump_stages_user; 2369user event_name count_star 2370user1 stage/sql/checking permissions 3 2371user1 stage/sql/closing tables 3 2372user1 stage/sql/init 7 2373user1 stage/sql/Opening tables 3 2374user2 stage/sql/checking permissions 3 2375user2 stage/sql/closing tables 3 2376user2 stage/sql/init 7 2377user2 stage/sql/Opening tables 3 2378user3 stage/sql/checking permissions 3 2379user3 stage/sql/closing tables 3 2380user3 stage/sql/init 7 2381user3 stage/sql/Opening tables 3 2382user4 stage/sql/checking permissions 3 2383user4 stage/sql/closing tables 3 2384user4 stage/sql/init 7 2385user4 stage/sql/Opening tables 3 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 2406execute dump_statements_user; 2407user event_name count_star 2408user1 statement/com/Error 0 2409user1 statement/com/Quit 1 2410user1 statement/sql/insert 1 2411user1 statement/sql/select 2 2412user2 statement/com/Error 0 2413user2 statement/com/Quit 1 2414user2 statement/sql/insert 1 2415user2 statement/sql/select 2 2416user3 statement/com/Error 0 2417user3 statement/com/Quit 1 2418user3 statement/sql/insert 1 2419user3 statement/sql/select 2 2420user4 statement/com/Error 0 2421user4 statement/com/Quit 1 2422user4 statement/sql/insert 1 2423user4 statement/sql/select 2 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 2443execute dump_users; 2444USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2445root 1 1 2446user1 0 1 2447user2 0 1 2448user3 0 1 2449user4 0 1 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 2467execute dump_waits_user; 2468user event_name count_star 2469user1 wait/io/file/sql/query_log 0 2470user1 wait/synch/mutex/sql/LOCK_connection_count 0 2471user1 wait/synch/mutex/sql/LOCK_user_locks 0 2472user1 wait/synch/rwlock/sql/LOCK_grant 0 2473user2 wait/io/file/sql/query_log 0 2474user2 wait/synch/mutex/sql/LOCK_connection_count 0 2475user2 wait/synch/mutex/sql/LOCK_user_locks 0 2476user2 wait/synch/rwlock/sql/LOCK_grant 0 2477user3 wait/io/file/sql/query_log 0 2478user3 wait/synch/mutex/sql/LOCK_connection_count 0 2479user3 wait/synch/mutex/sql/LOCK_user_locks 0 2480user3 wait/synch/rwlock/sql/LOCK_grant 0 2481user4 wait/io/file/sql/query_log 0 2482user4 wait/synch/mutex/sql/LOCK_connection_count 0 2483user4 wait/synch/mutex/sql/LOCK_user_locks 0 2484user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2505execute dump_stages_user; 2506user event_name count_star 2507user1 stage/sql/checking permissions 3 2508user1 stage/sql/closing tables 3 2509user1 stage/sql/init 7 2510user1 stage/sql/Opening tables 3 2511user2 stage/sql/checking permissions 3 2512user2 stage/sql/closing tables 3 2513user2 stage/sql/init 7 2514user2 stage/sql/Opening tables 3 2515user3 stage/sql/checking permissions 3 2516user3 stage/sql/closing tables 3 2517user3 stage/sql/init 7 2518user3 stage/sql/Opening tables 3 2519user4 stage/sql/checking permissions 3 2520user4 stage/sql/closing tables 3 2521user4 stage/sql/init 7 2522user4 stage/sql/Opening tables 3 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 2543execute dump_statements_user; 2544user event_name count_star 2545user1 statement/com/Error 0 2546user1 statement/com/Quit 1 2547user1 statement/sql/insert 1 2548user1 statement/sql/select 2 2549user2 statement/com/Error 0 2550user2 statement/com/Quit 1 2551user2 statement/sql/insert 1 2552user2 statement/sql/select 2 2553user3 statement/com/Error 0 2554user3 statement/com/Quit 1 2555user3 statement/sql/insert 1 2556user3 statement/sql/select 2 2557user4 statement/com/Error 0 2558user4 statement/com/Quit 1 2559user4 statement/sql/insert 1 2560user4 statement/sql/select 2 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 2580execute dump_users; 2581USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2582root 1 1 2583user1 0 1 2584user2 0 1 2585user3 0 1 2586user4 0 1 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 2604execute dump_waits_user; 2605user event_name count_star 2606user1 wait/io/file/sql/query_log 0 2607user1 wait/synch/mutex/sql/LOCK_connection_count 0 2608user1 wait/synch/mutex/sql/LOCK_user_locks 0 2609user1 wait/synch/rwlock/sql/LOCK_grant 0 2610user2 wait/io/file/sql/query_log 0 2611user2 wait/synch/mutex/sql/LOCK_connection_count 0 2612user2 wait/synch/mutex/sql/LOCK_user_locks 0 2613user2 wait/synch/rwlock/sql/LOCK_grant 0 2614user3 wait/io/file/sql/query_log 0 2615user3 wait/synch/mutex/sql/LOCK_connection_count 0 2616user3 wait/synch/mutex/sql/LOCK_user_locks 0 2617user3 wait/synch/rwlock/sql/LOCK_grant 0 2618user4 wait/io/file/sql/query_log 0 2619user4 wait/synch/mutex/sql/LOCK_connection_count 0 2620user4 wait/synch/mutex/sql/LOCK_user_locks 0 2621user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2642execute dump_stages_user; 2643user event_name count_star 2644user1 stage/sql/checking permissions 0 2645user1 stage/sql/closing tables 0 2646user1 stage/sql/init 0 2647user1 stage/sql/Opening tables 0 2648user2 stage/sql/checking permissions 0 2649user2 stage/sql/closing tables 0 2650user2 stage/sql/init 0 2651user2 stage/sql/Opening tables 0 2652user3 stage/sql/checking permissions 0 2653user3 stage/sql/closing tables 0 2654user3 stage/sql/init 0 2655user3 stage/sql/Opening tables 0 2656user4 stage/sql/checking permissions 0 2657user4 stage/sql/closing tables 0 2658user4 stage/sql/init 0 2659user4 stage/sql/Opening tables 0 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 2680execute dump_statements_user; 2681user event_name count_star 2682user1 statement/com/Error 0 2683user1 statement/com/Quit 1 2684user1 statement/sql/insert 1 2685user1 statement/sql/select 2 2686user2 statement/com/Error 0 2687user2 statement/com/Quit 1 2688user2 statement/sql/insert 1 2689user2 statement/sql/select 2 2690user3 statement/com/Error 0 2691user3 statement/com/Quit 1 2692user3 statement/sql/insert 1 2693user3 statement/sql/select 2 2694user4 statement/com/Error 0 2695user4 statement/com/Quit 1 2696user4 statement/sql/insert 1 2697user4 statement/sql/select 2 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 2717execute dump_users; 2718USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2719root 1 1 2720user1 0 1 2721user2 0 1 2722user3 0 1 2723user4 0 1 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 2741execute dump_waits_user; 2742user event_name count_star 2743user1 wait/io/file/sql/query_log 0 2744user1 wait/synch/mutex/sql/LOCK_connection_count 0 2745user1 wait/synch/mutex/sql/LOCK_user_locks 0 2746user1 wait/synch/rwlock/sql/LOCK_grant 0 2747user2 wait/io/file/sql/query_log 0 2748user2 wait/synch/mutex/sql/LOCK_connection_count 0 2749user2 wait/synch/mutex/sql/LOCK_user_locks 0 2750user2 wait/synch/rwlock/sql/LOCK_grant 0 2751user3 wait/io/file/sql/query_log 0 2752user3 wait/synch/mutex/sql/LOCK_connection_count 0 2753user3 wait/synch/mutex/sql/LOCK_user_locks 0 2754user3 wait/synch/rwlock/sql/LOCK_grant 0 2755user4 wait/io/file/sql/query_log 0 2756user4 wait/synch/mutex/sql/LOCK_connection_count 0 2757user4 wait/synch/mutex/sql/LOCK_user_locks 0 2758user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2779execute dump_stages_user; 2780user event_name count_star 2781user1 stage/sql/checking permissions 0 2782user1 stage/sql/closing tables 0 2783user1 stage/sql/init 0 2784user1 stage/sql/Opening tables 0 2785user2 stage/sql/checking permissions 0 2786user2 stage/sql/closing tables 0 2787user2 stage/sql/init 0 2788user2 stage/sql/Opening tables 0 2789user3 stage/sql/checking permissions 0 2790user3 stage/sql/closing tables 0 2791user3 stage/sql/init 0 2792user3 stage/sql/Opening tables 0 2793user4 stage/sql/checking permissions 0 2794user4 stage/sql/closing tables 0 2795user4 stage/sql/init 0 2796user4 stage/sql/Opening tables 0 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 2817execute dump_statements_user; 2818user event_name count_star 2819user1 statement/com/Error 0 2820user1 statement/com/Quit 1 2821user1 statement/sql/insert 1 2822user1 statement/sql/select 2 2823user2 statement/com/Error 0 2824user2 statement/com/Quit 1 2825user2 statement/sql/insert 1 2826user2 statement/sql/select 2 2827user3 statement/com/Error 0 2828user3 statement/com/Quit 1 2829user3 statement/sql/insert 1 2830user3 statement/sql/select 2 2831user4 statement/com/Error 0 2832user4 statement/com/Quit 1 2833user4 statement/sql/insert 1 2834user4 statement/sql/select 2 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 2854execute dump_users; 2855USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2856root 1 1 2857user1 0 1 2858user2 0 1 2859user3 0 1 2860user4 0 1 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 2878execute dump_waits_user; 2879user event_name count_star 2880user1 wait/io/file/sql/query_log 0 2881user1 wait/synch/mutex/sql/LOCK_connection_count 0 2882user1 wait/synch/mutex/sql/LOCK_user_locks 0 2883user1 wait/synch/rwlock/sql/LOCK_grant 0 2884user2 wait/io/file/sql/query_log 0 2885user2 wait/synch/mutex/sql/LOCK_connection_count 0 2886user2 wait/synch/mutex/sql/LOCK_user_locks 0 2887user2 wait/synch/rwlock/sql/LOCK_grant 0 2888user3 wait/io/file/sql/query_log 0 2889user3 wait/synch/mutex/sql/LOCK_connection_count 0 2890user3 wait/synch/mutex/sql/LOCK_user_locks 0 2891user3 wait/synch/rwlock/sql/LOCK_grant 0 2892user4 wait/io/file/sql/query_log 0 2893user4 wait/synch/mutex/sql/LOCK_connection_count 0 2894user4 wait/synch/mutex/sql/LOCK_user_locks 0 2895user4 wait/synch/rwlock/sql/LOCK_grant 0 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 2916execute dump_stages_user; 2917user event_name count_star 2918user1 stage/sql/checking permissions 0 2919user1 stage/sql/closing tables 0 2920user1 stage/sql/init 0 2921user1 stage/sql/Opening tables 0 2922user2 stage/sql/checking permissions 0 2923user2 stage/sql/closing tables 0 2924user2 stage/sql/init 0 2925user2 stage/sql/Opening tables 0 2926user3 stage/sql/checking permissions 0 2927user3 stage/sql/closing tables 0 2928user3 stage/sql/init 0 2929user3 stage/sql/Opening tables 0 2930user4 stage/sql/checking permissions 0 2931user4 stage/sql/closing tables 0 2932user4 stage/sql/init 0 2933user4 stage/sql/Opening tables 0 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 2954execute dump_statements_user; 2955user event_name count_star 2956user1 statement/com/Error 0 2957user1 statement/com/Quit 1 2958user1 statement/sql/insert 1 2959user1 statement/sql/select 2 2960user2 statement/com/Error 0 2961user2 statement/com/Quit 1 2962user2 statement/sql/insert 1 2963user2 statement/sql/select 2 2964user3 statement/com/Error 0 2965user3 statement/com/Quit 1 2966user3 statement/sql/insert 1 2967user3 statement/sql/select 2 2968user4 statement/com/Error 0 2969user4 statement/com/Quit 1 2970user4 statement/sql/insert 1 2971user4 statement/sql/select 2 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 2991execute dump_users; 2992USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 2993root 1 1 2994user1 0 1 2995user2 0 1 2996user3 0 1 2997user4 0 1 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 3015execute dump_waits_user; 3016user event_name count_star 3017user1 wait/io/file/sql/query_log 0 3018user1 wait/synch/mutex/sql/LOCK_connection_count 0 3019user1 wait/synch/mutex/sql/LOCK_user_locks 0 3020user1 wait/synch/rwlock/sql/LOCK_grant 0 3021user2 wait/io/file/sql/query_log 0 3022user2 wait/synch/mutex/sql/LOCK_connection_count 0 3023user2 wait/synch/mutex/sql/LOCK_user_locks 0 3024user2 wait/synch/rwlock/sql/LOCK_grant 0 3025user3 wait/io/file/sql/query_log 0 3026user3 wait/synch/mutex/sql/LOCK_connection_count 0 3027user3 wait/synch/mutex/sql/LOCK_user_locks 0 3028user3 wait/synch/rwlock/sql/LOCK_grant 0 3029user4 wait/io/file/sql/query_log 0 3030user4 wait/synch/mutex/sql/LOCK_connection_count 0 3031user4 wait/synch/mutex/sql/LOCK_user_locks 0 3032user4 wait/synch/rwlock/sql/LOCK_grant 0 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 3053execute dump_stages_user; 3054user event_name count_star 3055user1 stage/sql/checking permissions 0 3056user1 stage/sql/closing tables 0 3057user1 stage/sql/init 0 3058user1 stage/sql/Opening tables 0 3059user2 stage/sql/checking permissions 0 3060user2 stage/sql/closing tables 0 3061user2 stage/sql/init 0 3062user2 stage/sql/Opening tables 0 3063user3 stage/sql/checking permissions 0 3064user3 stage/sql/closing tables 0 3065user3 stage/sql/init 0 3066user3 stage/sql/Opening tables 0 3067user4 stage/sql/checking permissions 0 3068user4 stage/sql/closing tables 0 3069user4 stage/sql/init 0 3070user4 stage/sql/Opening tables 0 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 3091execute dump_statements_user; 3092user event_name count_star 3093user1 statement/com/Error 0 3094user1 statement/com/Quit 1 3095user1 statement/sql/insert 1 3096user1 statement/sql/select 2 3097user2 statement/com/Error 0 3098user2 statement/com/Quit 1 3099user2 statement/sql/insert 1 3100user2 statement/sql/select 2 3101user3 statement/com/Error 0 3102user3 statement/com/Quit 1 3103user3 statement/sql/insert 1 3104user3 statement/sql/select 2 3105user4 statement/com/Error 0 3106user4 statement/com/Quit 1 3107user4 statement/sql/insert 1 3108user4 statement/sql/select 2 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 3128execute dump_users; 3129USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3130root 1 1 3131user1 0 1 3132user2 0 1 3133user3 0 1 3134user4 0 1 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 3152execute dump_waits_user; 3153user event_name count_star 3154user1 wait/io/file/sql/query_log 0 3155user1 wait/synch/mutex/sql/LOCK_connection_count 0 3156user1 wait/synch/mutex/sql/LOCK_user_locks 0 3157user1 wait/synch/rwlock/sql/LOCK_grant 0 3158user2 wait/io/file/sql/query_log 0 3159user2 wait/synch/mutex/sql/LOCK_connection_count 0 3160user2 wait/synch/mutex/sql/LOCK_user_locks 0 3161user2 wait/synch/rwlock/sql/LOCK_grant 0 3162user3 wait/io/file/sql/query_log 0 3163user3 wait/synch/mutex/sql/LOCK_connection_count 0 3164user3 wait/synch/mutex/sql/LOCK_user_locks 0 3165user3 wait/synch/rwlock/sql/LOCK_grant 0 3166user4 wait/io/file/sql/query_log 0 3167user4 wait/synch/mutex/sql/LOCK_connection_count 0 3168user4 wait/synch/mutex/sql/LOCK_user_locks 0 3169user4 wait/synch/rwlock/sql/LOCK_grant 0 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 3190execute dump_stages_user; 3191user event_name count_star 3192user1 stage/sql/checking permissions 0 3193user1 stage/sql/closing tables 0 3194user1 stage/sql/init 0 3195user1 stage/sql/Opening tables 0 3196user2 stage/sql/checking permissions 0 3197user2 stage/sql/closing tables 0 3198user2 stage/sql/init 0 3199user2 stage/sql/Opening tables 0 3200user3 stage/sql/checking permissions 0 3201user3 stage/sql/closing tables 0 3202user3 stage/sql/init 0 3203user3 stage/sql/Opening tables 0 3204user4 stage/sql/checking permissions 0 3205user4 stage/sql/closing tables 0 3206user4 stage/sql/init 0 3207user4 stage/sql/Opening tables 0 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 3228execute dump_statements_user; 3229user event_name count_star 3230user1 statement/com/Error 0 3231user1 statement/com/Quit 1 3232user1 statement/sql/insert 1 3233user1 statement/sql/select 2 3234user2 statement/com/Error 0 3235user2 statement/com/Quit 1 3236user2 statement/sql/insert 1 3237user2 statement/sql/select 2 3238user3 statement/com/Error 0 3239user3 statement/com/Quit 1 3240user3 statement/sql/insert 1 3241user3 statement/sql/select 2 3242user4 statement/com/Error 0 3243user4 statement/com/Quit 1 3244user4 statement/sql/insert 1 3245user4 statement/sql/select 2 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 3265execute dump_users; 3266USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3267root 1 1 3268user1 0 1 3269user2 0 1 3270user3 0 1 3271user4 0 1 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 3289execute dump_waits_user; 3290user event_name count_star 3291user1 wait/io/file/sql/query_log 0 3292user1 wait/synch/mutex/sql/LOCK_connection_count 0 3293user1 wait/synch/mutex/sql/LOCK_user_locks 0 3294user1 wait/synch/rwlock/sql/LOCK_grant 0 3295user2 wait/io/file/sql/query_log 0 3296user2 wait/synch/mutex/sql/LOCK_connection_count 0 3297user2 wait/synch/mutex/sql/LOCK_user_locks 0 3298user2 wait/synch/rwlock/sql/LOCK_grant 0 3299user3 wait/io/file/sql/query_log 0 3300user3 wait/synch/mutex/sql/LOCK_connection_count 0 3301user3 wait/synch/mutex/sql/LOCK_user_locks 0 3302user3 wait/synch/rwlock/sql/LOCK_grant 0 3303user4 wait/io/file/sql/query_log 0 3304user4 wait/synch/mutex/sql/LOCK_connection_count 0 3305user4 wait/synch/mutex/sql/LOCK_user_locks 0 3306user4 wait/synch/rwlock/sql/LOCK_grant 0 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 3327execute dump_stages_user; 3328user event_name count_star 3329user1 stage/sql/checking permissions 0 3330user1 stage/sql/closing tables 0 3331user1 stage/sql/init 0 3332user1 stage/sql/Opening tables 0 3333user2 stage/sql/checking permissions 0 3334user2 stage/sql/closing tables 0 3335user2 stage/sql/init 0 3336user2 stage/sql/Opening tables 0 3337user3 stage/sql/checking permissions 0 3338user3 stage/sql/closing tables 0 3339user3 stage/sql/init 0 3340user3 stage/sql/Opening tables 0 3341user4 stage/sql/checking permissions 0 3342user4 stage/sql/closing tables 0 3343user4 stage/sql/init 0 3344user4 stage/sql/Opening tables 0 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 3365execute dump_statements_user; 3366user event_name count_star 3367user1 statement/com/Error 0 3368user1 statement/com/Quit 0 3369user1 statement/sql/insert 0 3370user1 statement/sql/select 0 3371user2 statement/com/Error 0 3372user2 statement/com/Quit 0 3373user2 statement/sql/insert 0 3374user2 statement/sql/select 0 3375user3 statement/com/Error 0 3376user3 statement/com/Quit 0 3377user3 statement/sql/insert 0 3378user3 statement/sql/select 0 3379user4 statement/com/Error 0 3380user4 statement/com/Quit 0 3381user4 statement/sql/insert 0 3382user4 statement/sql/select 0 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 3402execute dump_users; 3403USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3404root 1 1 3405user1 0 1 3406user2 0 1 3407user3 0 1 3408user4 0 1 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 3426execute dump_waits_user; 3427user event_name count_star 3428user1 wait/io/file/sql/query_log 0 3429user1 wait/synch/mutex/sql/LOCK_connection_count 0 3430user1 wait/synch/mutex/sql/LOCK_user_locks 0 3431user1 wait/synch/rwlock/sql/LOCK_grant 0 3432user2 wait/io/file/sql/query_log 0 3433user2 wait/synch/mutex/sql/LOCK_connection_count 0 3434user2 wait/synch/mutex/sql/LOCK_user_locks 0 3435user2 wait/synch/rwlock/sql/LOCK_grant 0 3436user3 wait/io/file/sql/query_log 0 3437user3 wait/synch/mutex/sql/LOCK_connection_count 0 3438user3 wait/synch/mutex/sql/LOCK_user_locks 0 3439user3 wait/synch/rwlock/sql/LOCK_grant 0 3440user4 wait/io/file/sql/query_log 0 3441user4 wait/synch/mutex/sql/LOCK_connection_count 0 3442user4 wait/synch/mutex/sql/LOCK_user_locks 0 3443user4 wait/synch/rwlock/sql/LOCK_grant 0 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 3464execute dump_stages_user; 3465user event_name count_star 3466user1 stage/sql/checking permissions 0 3467user1 stage/sql/closing tables 0 3468user1 stage/sql/init 0 3469user1 stage/sql/Opening tables 0 3470user2 stage/sql/checking permissions 0 3471user2 stage/sql/closing tables 0 3472user2 stage/sql/init 0 3473user2 stage/sql/Opening tables 0 3474user3 stage/sql/checking permissions 0 3475user3 stage/sql/closing tables 0 3476user3 stage/sql/init 0 3477user3 stage/sql/Opening tables 0 3478user4 stage/sql/checking permissions 0 3479user4 stage/sql/closing tables 0 3480user4 stage/sql/init 0 3481user4 stage/sql/Opening tables 0 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 3502execute dump_statements_user; 3503user event_name count_star 3504user1 statement/com/Error 0 3505user1 statement/com/Quit 0 3506user1 statement/sql/insert 0 3507user1 statement/sql/select 0 3508user2 statement/com/Error 0 3509user2 statement/com/Quit 0 3510user2 statement/sql/insert 0 3511user2 statement/sql/select 0 3512user3 statement/com/Error 0 3513user3 statement/com/Quit 0 3514user3 statement/sql/insert 0 3515user3 statement/sql/select 0 3516user4 statement/com/Error 0 3517user4 statement/com/Quit 0 3518user4 statement/sql/insert 0 3519user4 statement/sql/select 0 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 3539execute dump_users; 3540USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3541root 1 1 3542user1 0 1 3543user2 0 1 3544user3 0 1 3545user4 0 1 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 3563execute dump_waits_user; 3564user event_name count_star 3565user1 wait/io/file/sql/query_log 0 3566user1 wait/synch/mutex/sql/LOCK_connection_count 0 3567user1 wait/synch/mutex/sql/LOCK_user_locks 0 3568user1 wait/synch/rwlock/sql/LOCK_grant 0 3569user2 wait/io/file/sql/query_log 0 3570user2 wait/synch/mutex/sql/LOCK_connection_count 0 3571user2 wait/synch/mutex/sql/LOCK_user_locks 0 3572user2 wait/synch/rwlock/sql/LOCK_grant 0 3573user3 wait/io/file/sql/query_log 0 3574user3 wait/synch/mutex/sql/LOCK_connection_count 0 3575user3 wait/synch/mutex/sql/LOCK_user_locks 0 3576user3 wait/synch/rwlock/sql/LOCK_grant 0 3577user4 wait/io/file/sql/query_log 0 3578user4 wait/synch/mutex/sql/LOCK_connection_count 0 3579user4 wait/synch/mutex/sql/LOCK_user_locks 0 3580user4 wait/synch/rwlock/sql/LOCK_grant 0 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 3601execute dump_stages_user; 3602user event_name count_star 3603user1 stage/sql/checking permissions 0 3604user1 stage/sql/closing tables 0 3605user1 stage/sql/init 0 3606user1 stage/sql/Opening tables 0 3607user2 stage/sql/checking permissions 0 3608user2 stage/sql/closing tables 0 3609user2 stage/sql/init 0 3610user2 stage/sql/Opening tables 0 3611user3 stage/sql/checking permissions 0 3612user3 stage/sql/closing tables 0 3613user3 stage/sql/init 0 3614user3 stage/sql/Opening tables 0 3615user4 stage/sql/checking permissions 0 3616user4 stage/sql/closing tables 0 3617user4 stage/sql/init 0 3618user4 stage/sql/Opening tables 0 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 3639execute dump_statements_user; 3640user event_name count_star 3641user1 statement/com/Error 0 3642user1 statement/com/Quit 0 3643user1 statement/sql/insert 0 3644user1 statement/sql/select 0 3645user2 statement/com/Error 0 3646user2 statement/com/Quit 0 3647user2 statement/sql/insert 0 3648user2 statement/sql/select 0 3649user3 statement/com/Error 0 3650user3 statement/com/Quit 0 3651user3 statement/sql/insert 0 3652user3 statement/sql/select 0 3653user4 statement/com/Error 0 3654user4 statement/com/Quit 0 3655user4 statement/sql/insert 0 3656user4 statement/sql/select 0 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 3676execute dump_users; 3677USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3678root 1 1 3679user1 0 1 3680user2 0 1 3681user3 0 1 3682user4 0 1 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 3702user1 wait/io/file/sql/query_log 0 3703user1 wait/synch/mutex/sql/LOCK_connection_count 0 3704user1 wait/synch/mutex/sql/LOCK_user_locks 0 3705user1 wait/synch/rwlock/sql/LOCK_grant 0 3706user2 wait/io/file/sql/query_log 0 3707user2 wait/synch/mutex/sql/LOCK_connection_count 0 3708user2 wait/synch/mutex/sql/LOCK_user_locks 0 3709user2 wait/synch/rwlock/sql/LOCK_grant 0 3710user3 wait/io/file/sql/query_log 0 3711user3 wait/synch/mutex/sql/LOCK_connection_count 0 3712user3 wait/synch/mutex/sql/LOCK_user_locks 0 3713user3 wait/synch/rwlock/sql/LOCK_grant 0 3714user4 wait/io/file/sql/query_log 0 3715user4 wait/synch/mutex/sql/LOCK_connection_count 0 3716user4 wait/synch/mutex/sql/LOCK_user_locks 0 3717user4 wait/synch/rwlock/sql/LOCK_grant 0 3718execute dump_waits_host; 3719host event_name count_star 3720localhost wait/io/file/sql/query_log 0 3721localhost wait/synch/mutex/sql/LOCK_connection_count 0 3722localhost wait/synch/mutex/sql/LOCK_user_locks 0 3723localhost wait/synch/rwlock/sql/LOCK_grant 0 3724execute dump_waits_global; 3725event_name count_star 3726wait/io/file/sql/query_log 0 3727wait/synch/mutex/sql/LOCK_connection_count 0 3728wait/synch/mutex/sql/LOCK_user_locks 0 3729wait/synch/rwlock/sql/LOCK_grant 0 3730execute dump_waits_history; 3731event_name count(event_name) 3732wait/io/file/sql/query_log 20 3733wait/synch/mutex/sql/LOCK_connection_count 4 3734wait/synch/mutex/sql/LOCK_user_locks 8 3735wait/synch/rwlock/sql/LOCK_grant 8 3736execute dump_stages_account; 3737user host event_name count_star 3738execute dump_stages_user; 3739user event_name count_star 3740user1 stage/sql/checking permissions 0 3741user1 stage/sql/closing tables 0 3742user1 stage/sql/init 0 3743user1 stage/sql/Opening tables 0 3744user2 stage/sql/checking permissions 0 3745user2 stage/sql/closing tables 0 3746user2 stage/sql/init 0 3747user2 stage/sql/Opening tables 0 3748user3 stage/sql/checking permissions 0 3749user3 stage/sql/closing tables 0 3750user3 stage/sql/init 0 3751user3 stage/sql/Opening tables 0 3752user4 stage/sql/checking permissions 0 3753user4 stage/sql/closing tables 0 3754user4 stage/sql/init 0 3755user4 stage/sql/Opening tables 0 3756execute dump_stages_host; 3757host event_name count_star 3758localhost stage/sql/checking permissions 0 3759localhost stage/sql/closing tables 0 3760localhost stage/sql/init 0 3761localhost stage/sql/Opening tables 0 3762execute dump_stages_global; 3763event_name count_star 3764stage/sql/checking permissions 0 3765stage/sql/closing tables 0 3766stage/sql/init 0 3767stage/sql/Opening tables 0 3768execute dump_stages_history; 3769event_name count(event_name) 3770stage/sql/checking permissions 12 3771stage/sql/closing tables 12 3772stage/sql/init 28 3773stage/sql/Opening tables 12 3774execute dump_statements_account; 3775user host event_name count_star 3776execute dump_statements_user; 3777user event_name count_star 3778user1 statement/com/Error 0 3779user1 statement/com/Quit 0 3780user1 statement/sql/insert 0 3781user1 statement/sql/select 0 3782user2 statement/com/Error 0 3783user2 statement/com/Quit 0 3784user2 statement/sql/insert 0 3785user2 statement/sql/select 0 3786user3 statement/com/Error 0 3787user3 statement/com/Quit 0 3788user3 statement/sql/insert 0 3789user3 statement/sql/select 0 3790user4 statement/com/Error 0 3791user4 statement/com/Quit 0 3792user4 statement/sql/insert 0 3793user4 statement/sql/select 0 3794execute dump_statements_host; 3795host event_name count_star 3796localhost statement/com/Error 0 3797localhost statement/com/Quit 0 3798localhost statement/sql/insert 0 3799localhost statement/sql/select 0 3800execute dump_statements_global; 3801event_name count_star 3802statement/com/Error 0 3803statement/com/Quit 0 3804statement/sql/insert 0 3805statement/sql/select 0 3806execute dump_statements_history; 3807event_name count(event_name) 3808statement/com/Quit 4 3809statement/sql/insert 4 3810statement/sql/select 8 3811execute dump_accounts; 3812USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3813execute dump_users; 3814USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3815root 1 1 3816user1 0 1 3817user2 0 1 3818user3 0 1 3819user4 0 1 3820execute dump_hosts; 3821HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3822localhost 1 5 3823truncate performance_schema.users; 3824"================== USERS truncated ==================" 3825"================== Step 30 ==================" 3826call dump_thread(); 3827username status 3828user1 not found 3829username status 3830user2 not found 3831username status 3832user3 not found 3833username status 3834user4 not found 3835execute dump_waits_account; 3836user host event_name count_star 3837execute dump_waits_user; 3838user event_name count_star 3839execute dump_waits_host; 3840host event_name count_star 3841localhost wait/io/file/sql/query_log 0 3842localhost wait/synch/mutex/sql/LOCK_connection_count 0 3843localhost wait/synch/mutex/sql/LOCK_user_locks 0 3844localhost wait/synch/rwlock/sql/LOCK_grant 0 3845execute dump_waits_global; 3846event_name count_star 3847wait/io/file/sql/query_log 0 3848wait/synch/mutex/sql/LOCK_connection_count 0 3849wait/synch/mutex/sql/LOCK_user_locks 0 3850wait/synch/rwlock/sql/LOCK_grant 0 3851execute dump_waits_history; 3852event_name count(event_name) 3853wait/io/file/sql/query_log 20 3854wait/synch/mutex/sql/LOCK_connection_count 4 3855wait/synch/mutex/sql/LOCK_user_locks 8 3856wait/synch/rwlock/sql/LOCK_grant 8 3857execute dump_stages_account; 3858user host event_name count_star 3859execute dump_stages_user; 3860user event_name count_star 3861execute dump_stages_host; 3862host event_name count_star 3863localhost stage/sql/checking permissions 0 3864localhost stage/sql/closing tables 0 3865localhost stage/sql/init 0 3866localhost stage/sql/Opening tables 0 3867execute dump_stages_global; 3868event_name count_star 3869stage/sql/checking permissions 0 3870stage/sql/closing tables 0 3871stage/sql/init 0 3872stage/sql/Opening tables 0 3873execute dump_stages_history; 3874event_name count(event_name) 3875stage/sql/checking permissions 12 3876stage/sql/closing tables 12 3877stage/sql/init 28 3878stage/sql/Opening tables 12 3879execute dump_statements_account; 3880user host event_name count_star 3881execute dump_statements_user; 3882user event_name count_star 3883execute dump_statements_host; 3884host event_name count_star 3885localhost statement/com/Error 0 3886localhost statement/com/Quit 0 3887localhost statement/sql/insert 0 3888localhost statement/sql/select 0 3889execute dump_statements_global; 3890event_name count_star 3891statement/com/Error 0 3892statement/com/Quit 0 3893statement/sql/insert 0 3894statement/sql/select 0 3895execute dump_statements_history; 3896event_name count(event_name) 3897statement/com/Quit 4 3898statement/sql/insert 4 3899statement/sql/select 8 3900execute dump_accounts; 3901USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3902execute dump_users; 3903USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3904root 1 1 3905execute dump_hosts; 3906HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3907localhost 1 5 3908truncate performance_schema.hosts; 3909"================== HOSTS truncated ==================" 3910"================== Step 31 ==================" 3911call dump_thread(); 3912username status 3913user1 not found 3914username status 3915user2 not found 3916username status 3917user3 not found 3918username status 3919user4 not found 3920execute dump_waits_account; 3921user host event_name count_star 3922execute dump_waits_user; 3923user event_name count_star 3924execute dump_waits_host; 3925host event_name count_star 3926localhost wait/io/file/sql/query_log 0 3927localhost wait/synch/mutex/sql/LOCK_connection_count 0 3928localhost wait/synch/mutex/sql/LOCK_user_locks 0 3929localhost wait/synch/rwlock/sql/LOCK_grant 0 3930execute dump_waits_global; 3931event_name count_star 3932wait/io/file/sql/query_log 0 3933wait/synch/mutex/sql/LOCK_connection_count 0 3934wait/synch/mutex/sql/LOCK_user_locks 0 3935wait/synch/rwlock/sql/LOCK_grant 0 3936execute dump_waits_history; 3937event_name count(event_name) 3938wait/io/file/sql/query_log 20 3939wait/synch/mutex/sql/LOCK_connection_count 4 3940wait/synch/mutex/sql/LOCK_user_locks 8 3941wait/synch/rwlock/sql/LOCK_grant 8 3942execute dump_stages_account; 3943user host event_name count_star 3944execute dump_stages_user; 3945user event_name count_star 3946execute dump_stages_host; 3947host event_name count_star 3948localhost stage/sql/checking permissions 0 3949localhost stage/sql/closing tables 0 3950localhost stage/sql/init 0 3951localhost stage/sql/Opening tables 0 3952execute dump_stages_global; 3953event_name count_star 3954stage/sql/checking permissions 0 3955stage/sql/closing tables 0 3956stage/sql/init 0 3957stage/sql/Opening tables 0 3958execute dump_stages_history; 3959event_name count(event_name) 3960stage/sql/checking permissions 12 3961stage/sql/closing tables 12 3962stage/sql/init 28 3963stage/sql/Opening tables 12 3964execute dump_statements_account; 3965user host event_name count_star 3966execute dump_statements_user; 3967user event_name count_star 3968execute dump_statements_host; 3969host event_name count_star 3970localhost statement/com/Error 0 3971localhost statement/com/Quit 0 3972localhost statement/sql/insert 0 3973localhost statement/sql/select 0 3974execute dump_statements_global; 3975event_name count_star 3976statement/com/Error 0 3977statement/com/Quit 0 3978statement/sql/insert 0 3979statement/sql/select 0 3980execute dump_statements_history; 3981event_name count(event_name) 3982statement/com/Quit 4 3983statement/sql/insert 4 3984statement/sql/select 8 3985execute dump_accounts; 3986USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3987execute dump_users; 3988USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3989root 1 1 3990execute dump_hosts; 3991HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS 3992localhost 1 1 3993