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