1# Tests for the performance schema 2 3# ======================================= 4# HELPER include/event_aggregate_load.inc 5# ======================================= 6 7echo "================== Step 1 =================="; 8call dump_thread(); 9execute dump_waits_account; 10execute dump_waits_user; 11execute dump_waits_host; 12execute dump_waits_global; 13execute dump_waits_history; 14execute dump_stages_account; 15execute dump_stages_user; 16execute dump_stages_host; 17execute dump_stages_global; 18execute dump_stages_history; 19execute dump_statements_account; 20execute dump_statements_user; 21execute dump_statements_host; 22execute dump_statements_global; 23execute dump_statements_history; 24execute dump_accounts; 25execute dump_users; 26execute dump_hosts; 27 28# Notes about this test 29# 30# Each connect causes 2 wait/synch/mutex/sql/LOCK_connection_count events: 31# - 1 in mysqld.cc, create_new_thread(), for the main thread 32# - 1 in sql_connect.cc, check_user(), for the connected thread 33# The main thread does not count for BY_ACCOUNT / BY_HOST. 34# The user thread does count for BY_ACCOUNT, BY_HOST 35# 36# Each get_lock() causes 1 wait/synch/mutex/sql/LOCK_user_locks 37# 38# To avoid noise from main, the background threads are disabled. 39 40connect (con1, localhost, user1, , ); 41 42--connection default 43 44# Wait for the connect to complete 45let $wait_condition= 46 select count(*) = 1 from performance_schema.threads 47 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; 48--source include/wait_condition.inc 49 50echo "================== Step 2 =================="; 51call dump_thread(); 52execute dump_waits_account; 53execute dump_waits_user; 54execute dump_waits_host; 55execute dump_waits_global; 56execute dump_waits_history; 57execute dump_stages_account; 58execute dump_stages_user; 59execute dump_stages_host; 60execute dump_stages_global; 61execute dump_stages_history; 62execute dump_statements_account; 63execute dump_statements_user; 64execute dump_statements_host; 65execute dump_statements_global; 66execute dump_statements_history; 67execute dump_accounts; 68execute dump_users; 69execute dump_hosts; 70 71--connection con1 72 73select get_lock("marker", 10); 74select release_lock("marker"); 75insert into test.t1 values ("marker"); 76 77--connection default 78 79# Wait for the payload to complete 80let $wait_condition= 81 select count(*) = 1 from performance_schema.events_waits_current 82 where EVENT_NAME= 'idle'; 83--source include/wait_condition.inc 84 85echo "================== Step 3 =================="; 86call dump_thread(); 87execute dump_waits_account; 88execute dump_waits_user; 89execute dump_waits_host; 90execute dump_waits_global; 91execute dump_waits_history; 92execute dump_stages_account; 93execute dump_stages_user; 94execute dump_stages_host; 95execute dump_stages_global; 96execute dump_stages_history; 97execute dump_statements_account; 98execute dump_statements_user; 99execute dump_statements_host; 100execute dump_statements_global; 101execute dump_statements_history; 102execute dump_accounts; 103execute dump_users; 104execute dump_hosts; 105 106# Debugging helpers 107# select * from performance_schema.events_waits_history_long; 108# select PROCESSLIST_USER, PROCESSLIST_HOST, INSTRUMENTED from performance_schema.threads; 109 110connect (con2, localhost, user2, , ); 111 112--connection default 113 114# Wait for the connect to complete 115let $wait_condition= 116 select count(*) = 1 from performance_schema.threads 117 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; 118--source include/wait_condition.inc 119 120echo "================== Step 4 =================="; 121call dump_thread(); 122execute dump_waits_account; 123execute dump_waits_user; 124execute dump_waits_host; 125execute dump_waits_global; 126execute dump_waits_history; 127execute dump_stages_account; 128execute dump_stages_user; 129execute dump_stages_host; 130execute dump_stages_global; 131execute dump_stages_history; 132execute dump_statements_account; 133execute dump_statements_user; 134execute dump_statements_host; 135execute dump_statements_global; 136execute dump_statements_history; 137execute dump_accounts; 138execute dump_users; 139execute dump_hosts; 140 141--connection con2 142 143select get_lock("marker", 10); 144select release_lock("marker"); 145insert into test.t1 values ("marker"); 146 147--connection default 148 149# Wait for the payload to complete 150let $wait_condition= 151 select count(*) = 2 from performance_schema.events_waits_current 152 where EVENT_NAME= 'idle'; 153--source include/wait_condition.inc 154 155echo "================== Step 5 =================="; 156call dump_thread(); 157execute dump_waits_account; 158execute dump_waits_user; 159execute dump_waits_host; 160execute dump_waits_global; 161execute dump_waits_history; 162execute dump_stages_account; 163execute dump_stages_user; 164execute dump_stages_host; 165execute dump_stages_global; 166execute dump_stages_history; 167execute dump_statements_account; 168execute dump_statements_user; 169execute dump_statements_host; 170execute dump_statements_global; 171execute dump_statements_history; 172execute dump_accounts; 173execute dump_users; 174execute dump_hosts; 175 176connect (con3, localhost, user3, , ); 177 178--connection default 179 180# Wait for the connect to complete 181let $wait_condition= 182 select count(*) = 1 from performance_schema.threads 183 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; 184--source include/wait_condition.inc 185 186echo "================== Step 6 =================="; 187call dump_thread(); 188execute dump_waits_account; 189execute dump_waits_user; 190execute dump_waits_host; 191execute dump_waits_global; 192execute dump_waits_history; 193execute dump_stages_account; 194execute dump_stages_user; 195execute dump_stages_host; 196execute dump_stages_global; 197execute dump_stages_history; 198execute dump_statements_account; 199execute dump_statements_user; 200execute dump_statements_host; 201execute dump_statements_global; 202execute dump_statements_history; 203execute dump_accounts; 204execute dump_users; 205execute dump_hosts; 206 207--connection con3 208 209select get_lock("marker", 10); 210select release_lock("marker"); 211insert into test.t1 values ("marker"); 212 213--connection default 214 215# Wait for the payload to complete 216let $wait_condition= 217 select count(*) = 3 from performance_schema.events_waits_current 218 where EVENT_NAME= 'idle'; 219--source include/wait_condition.inc 220 221echo "================== Step 7 =================="; 222call dump_thread(); 223execute dump_waits_account; 224execute dump_waits_user; 225execute dump_waits_host; 226execute dump_waits_global; 227execute dump_waits_history; 228execute dump_stages_account; 229execute dump_stages_user; 230execute dump_stages_host; 231execute dump_stages_global; 232execute dump_stages_history; 233execute dump_statements_account; 234execute dump_statements_user; 235execute dump_statements_host; 236execute dump_statements_global; 237execute dump_statements_history; 238execute dump_accounts; 239execute dump_users; 240execute dump_hosts; 241 242connect (con4, localhost, user4, , ); 243 244--connection default 245 246# Wait for the connect to complete 247let $wait_condition= 248 select count(*) = 1 from performance_schema.threads 249 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; 250--source include/wait_condition.inc 251 252echo "================== Step 8 =================="; 253call dump_thread(); 254execute dump_waits_account; 255execute dump_waits_user; 256execute dump_waits_host; 257execute dump_waits_global; 258execute dump_waits_history; 259execute dump_stages_account; 260execute dump_stages_user; 261execute dump_stages_host; 262execute dump_stages_global; 263execute dump_stages_history; 264execute dump_statements_account; 265execute dump_statements_user; 266execute dump_statements_host; 267execute dump_statements_global; 268execute dump_statements_history; 269execute dump_accounts; 270execute dump_users; 271execute dump_hosts; 272 273--connection con4 274 275select get_lock("marker", 10); 276select release_lock("marker"); 277insert into test.t1 values ("marker"); 278 279--connection default 280 281# Wait for the payload to complete 282let $wait_condition= 283 select count(*) = 4 from performance_schema.events_waits_current 284 where EVENT_NAME= 'idle'; 285--source include/wait_condition.inc 286 287echo "================== Step 9 =================="; 288call dump_thread(); 289execute dump_waits_account; 290execute dump_waits_user; 291execute dump_waits_host; 292execute dump_waits_global; 293execute dump_waits_history; 294execute dump_stages_account; 295execute dump_stages_user; 296execute dump_stages_host; 297execute dump_stages_global; 298execute dump_stages_history; 299execute dump_statements_account; 300execute dump_statements_user; 301execute dump_statements_host; 302execute dump_statements_global; 303execute dump_statements_history; 304execute dump_accounts; 305execute dump_users; 306execute dump_hosts; 307 308--disconnect con1 309 310--connection default 311 312# Wait for the disconnect to complete 313let $wait_condition= 314 select count(*) = 0 from performance_schema.threads 315 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user1'; 316--source include/wait_condition.inc 317 318echo "================== Step 10 =================="; 319call dump_thread(); 320execute dump_waits_account; 321execute dump_waits_user; 322execute dump_waits_host; 323execute dump_waits_global; 324execute dump_waits_history; 325execute dump_stages_account; 326execute dump_stages_user; 327execute dump_stages_host; 328execute dump_stages_global; 329execute dump_stages_history; 330execute dump_statements_account; 331execute dump_statements_user; 332execute dump_statements_host; 333execute dump_statements_global; 334execute dump_statements_history; 335execute dump_accounts; 336execute dump_users; 337execute dump_hosts; 338 339--disconnect con2 340 341--connection default 342 343# Wait for the disconnect to complete 344let $wait_condition= 345 select count(*) = 0 from performance_schema.threads 346 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user2'; 347--source include/wait_condition.inc 348 349echo "================== Step 11 =================="; 350call dump_thread(); 351execute dump_waits_account; 352execute dump_waits_user; 353execute dump_waits_host; 354execute dump_waits_global; 355execute dump_waits_history; 356execute dump_stages_account; 357execute dump_stages_user; 358execute dump_stages_host; 359execute dump_stages_global; 360execute dump_stages_history; 361execute dump_statements_account; 362execute dump_statements_user; 363execute dump_statements_host; 364execute dump_statements_global; 365execute dump_statements_history; 366execute dump_accounts; 367execute dump_users; 368execute dump_hosts; 369 370--disconnect con3 371 372--connection default 373 374# Wait for the disconnect to complete 375let $wait_condition= 376 select count(*) = 0 from performance_schema.threads 377 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user3'; 378--source include/wait_condition.inc 379 380echo "================== Step 12 =================="; 381call dump_thread(); 382execute dump_waits_account; 383execute dump_waits_user; 384execute dump_waits_host; 385execute dump_waits_global; 386execute dump_waits_history; 387execute dump_stages_account; 388execute dump_stages_user; 389execute dump_stages_host; 390execute dump_stages_global; 391execute dump_stages_history; 392execute dump_statements_account; 393execute dump_statements_user; 394execute dump_statements_host; 395execute dump_statements_global; 396execute dump_statements_history; 397execute dump_accounts; 398execute dump_users; 399execute dump_hosts; 400 401--disconnect con4 402 403--connection default 404 405# Wait for the disconnect to complete 406let $wait_condition= 407 select count(*) = 0 from performance_schema.threads 408 where `TYPE`='FOREGROUND' and PROCESSLIST_USER= 'user4'; 409--source include/wait_condition.inc 410 411echo "================== Step 13 =================="; 412call dump_thread(); 413execute dump_waits_account; 414execute dump_waits_user; 415execute dump_waits_host; 416execute dump_waits_global; 417execute dump_waits_history; 418execute dump_stages_account; 419execute dump_stages_user; 420execute dump_stages_host; 421execute dump_stages_global; 422execute dump_stages_history; 423execute dump_statements_account; 424execute dump_statements_user; 425execute dump_statements_host; 426execute dump_statements_global; 427execute dump_statements_history; 428execute dump_accounts; 429execute dump_users; 430execute dump_hosts; 431 432--connection default 433 434truncate performance_schema.events_waits_summary_by_thread_by_event_name; 435 436echo "================== WAITS_BY_THREAD truncated =================="; 437 438echo "================== Step 14 =================="; 439call dump_thread(); 440execute dump_waits_account; 441execute dump_waits_user; 442execute dump_waits_host; 443execute dump_waits_global; 444execute dump_waits_history; 445execute dump_stages_account; 446execute dump_stages_user; 447execute dump_stages_host; 448execute dump_stages_global; 449execute dump_stages_history; 450execute dump_statements_account; 451execute dump_statements_user; 452execute dump_statements_host; 453execute dump_statements_global; 454execute dump_statements_history; 455execute dump_accounts; 456execute dump_users; 457execute dump_hosts; 458 459truncate performance_schema.events_waits_summary_by_account_by_event_name; 460 461echo "================== WAITS_BY_ACCOUNT truncated =================="; 462 463echo "================== Step 15 =================="; 464call dump_thread(); 465execute dump_waits_account; 466execute dump_waits_user; 467execute dump_waits_host; 468execute dump_waits_global; 469execute dump_waits_history; 470execute dump_stages_account; 471execute dump_stages_user; 472execute dump_stages_host; 473execute dump_stages_global; 474execute dump_stages_history; 475execute dump_statements_account; 476execute dump_statements_user; 477execute dump_statements_host; 478execute dump_statements_global; 479execute dump_statements_history; 480execute dump_accounts; 481execute dump_users; 482execute dump_hosts; 483 484truncate performance_schema.events_waits_summary_by_user_by_event_name; 485 486echo "================== WAITS_BY_USER truncated =================="; 487 488echo "================== Step 16 =================="; 489call dump_thread(); 490execute dump_waits_account; 491execute dump_waits_user; 492execute dump_waits_host; 493execute dump_waits_global; 494execute dump_waits_history; 495execute dump_stages_account; 496execute dump_stages_user; 497execute dump_stages_host; 498execute dump_stages_global; 499execute dump_stages_history; 500execute dump_statements_account; 501execute dump_statements_user; 502execute dump_statements_host; 503execute dump_statements_global; 504execute dump_statements_history; 505execute dump_accounts; 506execute dump_users; 507execute dump_hosts; 508 509truncate performance_schema.events_waits_summary_by_host_by_event_name; 510 511echo "================== WAITS_BY_HOST truncated =================="; 512 513echo "================== Step 17 =================="; 514call dump_thread(); 515execute dump_waits_account; 516execute dump_waits_user; 517execute dump_waits_host; 518execute dump_waits_global; 519execute dump_waits_history; 520execute dump_stages_account; 521execute dump_stages_user; 522execute dump_stages_host; 523execute dump_stages_global; 524execute dump_stages_history; 525execute dump_statements_account; 526execute dump_statements_user; 527execute dump_statements_host; 528execute dump_statements_global; 529execute dump_statements_history; 530execute dump_accounts; 531execute dump_users; 532execute dump_hosts; 533 534truncate performance_schema.events_waits_summary_global_by_event_name; 535 536echo "================== WAITS_GLOBAL truncated =================="; 537 538echo "================== Step 18 =================="; 539call dump_thread(); 540execute dump_waits_account; 541execute dump_waits_user; 542execute dump_waits_host; 543execute dump_waits_global; 544execute dump_waits_history; 545execute dump_stages_account; 546execute dump_stages_user; 547execute dump_stages_host; 548execute dump_stages_global; 549execute dump_stages_history; 550execute dump_statements_account; 551execute dump_statements_user; 552execute dump_statements_host; 553execute dump_statements_global; 554execute dump_statements_history; 555execute dump_accounts; 556execute dump_users; 557execute dump_hosts; 558 559truncate performance_schema.events_stages_summary_by_thread_by_event_name; 560 561echo "================== STAGES_BY_THREAD truncated =================="; 562 563echo "================== Step 19 =================="; 564call dump_thread(); 565execute dump_waits_account; 566execute dump_waits_user; 567execute dump_waits_host; 568execute dump_waits_global; 569execute dump_waits_history; 570execute dump_stages_account; 571execute dump_stages_user; 572execute dump_stages_host; 573execute dump_stages_global; 574execute dump_stages_history; 575execute dump_statements_account; 576execute dump_statements_user; 577execute dump_statements_host; 578execute dump_statements_global; 579execute dump_statements_history; 580execute dump_accounts; 581execute dump_users; 582execute dump_hosts; 583 584truncate performance_schema.events_stages_summary_by_account_by_event_name; 585 586echo "================== STAGES_BY_ACCOUNT truncated =================="; 587 588echo "================== Step 20 =================="; 589call dump_thread(); 590execute dump_waits_account; 591execute dump_waits_user; 592execute dump_waits_host; 593execute dump_waits_global; 594execute dump_waits_history; 595execute dump_stages_account; 596execute dump_stages_user; 597execute dump_stages_host; 598execute dump_stages_global; 599execute dump_stages_history; 600execute dump_statements_account; 601execute dump_statements_user; 602execute dump_statements_host; 603execute dump_statements_global; 604execute dump_statements_history; 605execute dump_accounts; 606execute dump_users; 607execute dump_hosts; 608 609truncate performance_schema.events_stages_summary_by_user_by_event_name; 610 611echo "================== STAGES_BY_USER truncated =================="; 612 613echo "================== Step 21 =================="; 614call dump_thread(); 615execute dump_waits_account; 616execute dump_waits_user; 617execute dump_waits_host; 618execute dump_waits_global; 619execute dump_waits_history; 620execute dump_stages_account; 621execute dump_stages_user; 622execute dump_stages_host; 623execute dump_stages_global; 624execute dump_stages_history; 625execute dump_statements_account; 626execute dump_statements_user; 627execute dump_statements_host; 628execute dump_statements_global; 629execute dump_statements_history; 630execute dump_accounts; 631execute dump_users; 632execute dump_hosts; 633 634truncate performance_schema.events_stages_summary_by_host_by_event_name; 635 636echo "================== STAGES_BY_HOST truncated =================="; 637 638echo "================== Step 22 =================="; 639call dump_thread(); 640execute dump_waits_account; 641execute dump_waits_user; 642execute dump_waits_host; 643execute dump_waits_global; 644execute dump_waits_history; 645execute dump_stages_account; 646execute dump_stages_user; 647execute dump_stages_host; 648execute dump_stages_global; 649execute dump_stages_history; 650execute dump_statements_account; 651execute dump_statements_user; 652execute dump_statements_host; 653execute dump_statements_global; 654execute dump_statements_history; 655execute dump_accounts; 656execute dump_users; 657execute dump_hosts; 658 659truncate performance_schema.events_stages_summary_global_by_event_name; 660 661echo "================== STAGES_GLOBAL truncated =================="; 662 663echo "================== Step 23 =================="; 664call dump_thread(); 665execute dump_waits_account; 666execute dump_waits_user; 667execute dump_waits_host; 668execute dump_waits_global; 669execute dump_waits_history; 670execute dump_stages_account; 671execute dump_stages_user; 672execute dump_stages_host; 673execute dump_stages_global; 674execute dump_stages_history; 675execute dump_statements_account; 676execute dump_statements_user; 677execute dump_statements_host; 678execute dump_statements_global; 679execute dump_statements_history; 680execute dump_accounts; 681execute dump_users; 682execute dump_hosts; 683 684truncate performance_schema.events_statements_summary_by_thread_by_event_name; 685 686echo "================== STATEMENTS_BY_THREAD truncated =================="; 687 688echo "================== Step 24 =================="; 689call dump_thread(); 690execute dump_waits_account; 691execute dump_waits_user; 692execute dump_waits_host; 693execute dump_waits_global; 694execute dump_waits_history; 695execute dump_stages_account; 696execute dump_stages_user; 697execute dump_stages_host; 698execute dump_stages_global; 699execute dump_stages_history; 700execute dump_statements_account; 701execute dump_statements_user; 702execute dump_statements_host; 703execute dump_statements_global; 704execute dump_statements_history; 705execute dump_accounts; 706execute dump_users; 707execute dump_hosts; 708 709truncate performance_schema.events_statements_summary_by_account_by_event_name; 710 711echo "================== STATEMENTS_BY_ACCOUNT truncated =================="; 712 713echo "================== Step 25 =================="; 714call dump_thread(); 715execute dump_waits_account; 716execute dump_waits_user; 717execute dump_waits_host; 718execute dump_waits_global; 719execute dump_waits_history; 720execute dump_stages_account; 721execute dump_stages_user; 722execute dump_stages_host; 723execute dump_stages_global; 724execute dump_stages_history; 725execute dump_statements_account; 726execute dump_statements_user; 727execute dump_statements_host; 728execute dump_statements_global; 729execute dump_statements_history; 730execute dump_accounts; 731execute dump_users; 732execute dump_hosts; 733 734truncate performance_schema.events_statements_summary_by_user_by_event_name; 735 736echo "================== STATEMENTS_BY_USER truncated =================="; 737 738echo "================== Step 26 =================="; 739call dump_thread(); 740execute dump_waits_account; 741execute dump_waits_user; 742execute dump_waits_host; 743execute dump_waits_global; 744execute dump_waits_history; 745execute dump_stages_account; 746execute dump_stages_user; 747execute dump_stages_host; 748execute dump_stages_global; 749execute dump_stages_history; 750execute dump_statements_account; 751execute dump_statements_user; 752execute dump_statements_host; 753execute dump_statements_global; 754execute dump_statements_history; 755execute dump_accounts; 756execute dump_users; 757execute dump_hosts; 758 759truncate performance_schema.events_statements_summary_by_host_by_event_name; 760 761echo "================== STATEMENTS_BY_HOST truncated =================="; 762 763echo "================== Step 27 =================="; 764call dump_thread(); 765execute dump_waits_account; 766execute dump_waits_user; 767execute dump_waits_host; 768execute dump_waits_global; 769execute dump_waits_history; 770execute dump_stages_account; 771execute dump_stages_user; 772execute dump_stages_host; 773execute dump_stages_global; 774execute dump_stages_history; 775execute dump_statements_account; 776execute dump_statements_user; 777execute dump_statements_host; 778execute dump_statements_global; 779execute dump_statements_history; 780execute dump_accounts; 781execute dump_users; 782execute dump_hosts; 783 784truncate performance_schema.events_statements_summary_global_by_event_name; 785 786echo "================== STATEMENTS_GLOBAL truncated =================="; 787 788echo "================== Step 28 =================="; 789call dump_thread(); 790execute dump_waits_account; 791execute dump_waits_user; 792execute dump_waits_host; 793execute dump_waits_global; 794execute dump_waits_history; 795execute dump_stages_account; 796execute dump_stages_user; 797execute dump_stages_host; 798execute dump_stages_global; 799execute dump_stages_history; 800execute dump_statements_account; 801execute dump_statements_user; 802execute dump_statements_host; 803execute dump_statements_global; 804execute dump_statements_history; 805execute dump_accounts; 806execute dump_users; 807execute dump_hosts; 808 809truncate performance_schema.accounts; 810 811echo "================== ACCOUNTS truncated =================="; 812 813echo "================== Step 29 =================="; 814call dump_thread(); 815execute dump_waits_account; 816execute dump_waits_user; 817execute dump_waits_host; 818execute dump_waits_global; 819execute dump_waits_history; 820execute dump_stages_account; 821execute dump_stages_user; 822execute dump_stages_host; 823execute dump_stages_global; 824execute dump_stages_history; 825execute dump_statements_account; 826execute dump_statements_user; 827execute dump_statements_host; 828execute dump_statements_global; 829execute dump_statements_history; 830execute dump_accounts; 831execute dump_users; 832execute dump_hosts; 833 834truncate performance_schema.users; 835 836echo "================== USERS truncated =================="; 837 838echo "================== Step 30 =================="; 839call dump_thread(); 840execute dump_waits_account; 841execute dump_waits_user; 842execute dump_waits_host; 843execute dump_waits_global; 844execute dump_waits_history; 845execute dump_stages_account; 846execute dump_stages_user; 847execute dump_stages_host; 848execute dump_stages_global; 849execute dump_stages_history; 850execute dump_statements_account; 851execute dump_statements_user; 852execute dump_statements_host; 853execute dump_statements_global; 854execute dump_statements_history; 855execute dump_accounts; 856execute dump_users; 857execute dump_hosts; 858 859truncate performance_schema.hosts; 860 861echo "================== HOSTS truncated =================="; 862 863echo "================== Step 31 =================="; 864call dump_thread(); 865execute dump_waits_account; 866execute dump_waits_user; 867execute dump_waits_host; 868execute dump_waits_global; 869execute dump_waits_history; 870execute dump_stages_account; 871execute dump_stages_user; 872execute dump_stages_host; 873execute dump_stages_global; 874execute dump_stages_history; 875execute dump_statements_account; 876execute dump_statements_user; 877execute dump_statements_host; 878execute dump_statements_global; 879execute dump_statements_history; 880execute dump_accounts; 881execute dump_users; 882execute dump_hosts; 883 884