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