1SET SESSION query_response_time_exec_time_debug=100000; 2SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 3SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1; 4Warnings: 5Warning 1292 Truncated incorrect query_response_time_range_base value: '1' 6FLUSH QUERY_RESPONSE_TIME; 7SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 8TIME COUNT TOTAL 9 0.000001 0 0.000000 10 0.000003 0 0.000000 11 0.000007 0 0.000000 12 0.000015 0 0.000000 13 0.000030 0 0.000000 14 0.000061 0 0.000000 15 0.000122 0 0.000000 16 0.000244 0 0.000000 17 0.000488 0 0.000000 18 0.000976 0 0.000000 19 0.001953 0 0.000000 20 0.003906 0 0.000000 21 0.007812 0 0.000000 22 0.015625 0 0.000000 23 0.031250 0 0.000000 24 0.062500 0 0.000000 25 0.125000 0 0.000000 26 0.250000 0 0.000000 27 0.500000 0 0.000000 28 1.000000 0 0.000000 29 2.000000 0 0.000000 30 4.000000 0 0.000000 31 8.000000 0 0.000000 32 16.000000 0 0.000000 33 32.000000 0 0.000000 34 64.000000 0 0.000000 35 128.000000 0 0.000000 36 256.000000 0 0.000000 37 512.000000 0 0.000000 38 1024.000000 0 0.000000 39 2048.000000 0 0.000000 40 4096.000000 0 0.000000 41 8192.000000 0 0.000000 42 16384.000000 0 0.000000 43 32768.000000 0 0.000000 44 65536.000000 0 0.000000 45 131072.000000 0 0.000000 46 262144.000000 0 0.000000 47 524288.000000 0 0.000000 481048576.000000 0 0.000000 492097152.000000 0 0.000000 504194304.000000 0 0.000000 518388608.000000 0 0.000000 52TOO LONG 0 TOO LONG 53SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 54SET SESSION query_response_time_exec_time_debug=310000; 55SELECT 1; 561 571 58SET SESSION query_response_time_exec_time_debug=320000; 59SELECT 1; 601 611 62SET SESSION query_response_time_exec_time_debug=330000; 63SELECT 1; 641 651 66SET SESSION query_response_time_exec_time_debug=340000; 67SELECT 1; 681 691 70SET SESSION query_response_time_exec_time_debug=350000; 71SELECT 1; 721 731 74SET SESSION query_response_time_exec_time_debug=360000; 75SELECT 1; 761 771 78SET SESSION query_response_time_exec_time_debug=370000; 79SELECT 1; 801 811 82SET SESSION query_response_time_exec_time_debug=380000; 83SELECT 1; 841 851 86SET SESSION query_response_time_exec_time_debug=390000; 87SELECT 1; 881 891 90SET SESSION query_response_time_exec_time_debug=400000; 91SELECT 1; 921 931 94SET SESSION query_response_time_exec_time_debug=1100000; 95SELECT 1; 961 971 98SET SESSION query_response_time_exec_time_debug=1200000; 99SELECT 1; 1001 1011 102SET SESSION query_response_time_exec_time_debug=1300000; 103SELECT 1; 1041 1051 106SET SESSION query_response_time_exec_time_debug=1500000; 107SELECT 1; 1081 1091 110SET SESSION query_response_time_exec_time_debug=1400000; 111SELECT 1; 1121 1131 114SET SESSION query_response_time_exec_time_debug=500000; 115SELECT 1; 1161 1171 118SET SESSION query_response_time_exec_time_debug=2100000; 119SELECT 1; 1201 1211 122SET SESSION query_response_time_exec_time_debug=2300000; 123SELECT 1; 1241 1251 126SET SESSION query_response_time_exec_time_debug=2500000; 127SELECT 1; 1281 1291 130SET SESSION query_response_time_exec_time_debug=3100000; 131SELECT 1; 1321 1331 134SET SESSION query_response_time_exec_time_debug=4100000; 135SELECT 1; 1361 1371 138SET SESSION query_response_time_exec_time_debug=5100000; 139SELECT 1; 1401 1411 142SET SESSION query_response_time_exec_time_debug=100000; 143SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 144SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 145Variable_name Value 146query_response_time_range_base 2 147SHOW QUERY_RESPONSE_TIME; 148Time Count Total 149 0.000001 24 0.000000 150 0.000003 0 0.000000 151 0.000007 0 0.000000 152 0.000015 0 0.000000 153 0.000030 0 0.000000 154 0.000061 0 0.000000 155 0.000122 0 0.000000 156 0.000244 0 0.000000 157 0.000488 0 0.000000 158 0.000976 0 0.000000 159 0.001953 0 0.000000 160 0.003906 0 0.000000 161 0.007812 0 0.000000 162 0.015625 0 0.000000 163 0.031250 0 0.000000 164 0.062500 0 0.000000 165 0.125000 0 0.000000 166 0.250000 0 0.000000 167 0.500000 10 3.550000 168 1.000000 1 0.500000 169 2.000000 5 6.500000 170 4.000000 4 10.000000 171 8.000000 2 9.200000 172 16.000000 0 0.000000 173 32.000000 0 0.000000 174 64.000000 0 0.000000 175 128.000000 0 0.000000 176 256.000000 0 0.000000 177 512.000000 0 0.000000 178 1024.000000 0 0.000000 179 2048.000000 0 0.000000 180 4096.000000 0 0.000000 181 8192.000000 0 0.000000 182 16384.000000 0 0.000000 183 32768.000000 0 0.000000 184 65536.000000 0 0.000000 185 131072.000000 0 0.000000 186 262144.000000 0 0.000000 187 524288.000000 0 0.000000 1881048576.000000 0 0.000000 1892097152.000000 0 0.000000 1904194304.000000 0 0.000000 1918388608.000000 0 0.000000 192TOO LONG 0 TOO LONG 193SET SESSION query_response_time_exec_time_debug=default; 194SET SESSION query_response_time_exec_time_debug=100000; 195SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 196SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2; 197FLUSH QUERY_RESPONSE_TIME; 198SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 199TIME COUNT TOTAL 200 0.000001 0 0.000000 201 0.000003 0 0.000000 202 0.000007 0 0.000000 203 0.000015 0 0.000000 204 0.000030 0 0.000000 205 0.000061 0 0.000000 206 0.000122 0 0.000000 207 0.000244 0 0.000000 208 0.000488 0 0.000000 209 0.000976 0 0.000000 210 0.001953 0 0.000000 211 0.003906 0 0.000000 212 0.007812 0 0.000000 213 0.015625 0 0.000000 214 0.031250 0 0.000000 215 0.062500 0 0.000000 216 0.125000 0 0.000000 217 0.250000 0 0.000000 218 0.500000 0 0.000000 219 1.000000 0 0.000000 220 2.000000 0 0.000000 221 4.000000 0 0.000000 222 8.000000 0 0.000000 223 16.000000 0 0.000000 224 32.000000 0 0.000000 225 64.000000 0 0.000000 226 128.000000 0 0.000000 227 256.000000 0 0.000000 228 512.000000 0 0.000000 229 1024.000000 0 0.000000 230 2048.000000 0 0.000000 231 4096.000000 0 0.000000 232 8192.000000 0 0.000000 233 16384.000000 0 0.000000 234 32768.000000 0 0.000000 235 65536.000000 0 0.000000 236 131072.000000 0 0.000000 237 262144.000000 0 0.000000 238 524288.000000 0 0.000000 2391048576.000000 0 0.000000 2402097152.000000 0 0.000000 2414194304.000000 0 0.000000 2428388608.000000 0 0.000000 243TOO LONG 0 TOO LONG 244SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 245SET SESSION query_response_time_exec_time_debug=310000; 246SELECT 1; 2471 2481 249SET SESSION query_response_time_exec_time_debug=320000; 250SELECT 1; 2511 2521 253SET SESSION query_response_time_exec_time_debug=330000; 254SELECT 1; 2551 2561 257SET SESSION query_response_time_exec_time_debug=340000; 258SELECT 1; 2591 2601 261SET SESSION query_response_time_exec_time_debug=350000; 262SELECT 1; 2631 2641 265SET SESSION query_response_time_exec_time_debug=360000; 266SELECT 1; 2671 2681 269SET SESSION query_response_time_exec_time_debug=370000; 270SELECT 1; 2711 2721 273SET SESSION query_response_time_exec_time_debug=380000; 274SELECT 1; 2751 2761 277SET SESSION query_response_time_exec_time_debug=390000; 278SELECT 1; 2791 2801 281SET SESSION query_response_time_exec_time_debug=400000; 282SELECT 1; 2831 2841 285SET SESSION query_response_time_exec_time_debug=1100000; 286SELECT 1; 2871 2881 289SET SESSION query_response_time_exec_time_debug=1200000; 290SELECT 1; 2911 2921 293SET SESSION query_response_time_exec_time_debug=1300000; 294SELECT 1; 2951 2961 297SET SESSION query_response_time_exec_time_debug=1500000; 298SELECT 1; 2991 3001 301SET SESSION query_response_time_exec_time_debug=1400000; 302SELECT 1; 3031 3041 305SET SESSION query_response_time_exec_time_debug=500000; 306SELECT 1; 3071 3081 309SET SESSION query_response_time_exec_time_debug=2100000; 310SELECT 1; 3111 3121 313SET SESSION query_response_time_exec_time_debug=2300000; 314SELECT 1; 3151 3161 317SET SESSION query_response_time_exec_time_debug=2500000; 318SELECT 1; 3191 3201 321SET SESSION query_response_time_exec_time_debug=3100000; 322SELECT 1; 3231 3241 325SET SESSION query_response_time_exec_time_debug=4100000; 326SELECT 1; 3271 3281 329SET SESSION query_response_time_exec_time_debug=5100000; 330SELECT 1; 3311 3321 333SET SESSION query_response_time_exec_time_debug=100000; 334SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 335SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 336Variable_name Value 337query_response_time_range_base 2 338SHOW QUERY_RESPONSE_TIME; 339Time Count Total 340 0.000001 24 0.000000 341 0.000003 0 0.000000 342 0.000007 0 0.000000 343 0.000015 0 0.000000 344 0.000030 0 0.000000 345 0.000061 0 0.000000 346 0.000122 0 0.000000 347 0.000244 0 0.000000 348 0.000488 0 0.000000 349 0.000976 0 0.000000 350 0.001953 0 0.000000 351 0.003906 0 0.000000 352 0.007812 0 0.000000 353 0.015625 0 0.000000 354 0.031250 0 0.000000 355 0.062500 0 0.000000 356 0.125000 0 0.000000 357 0.250000 0 0.000000 358 0.500000 10 3.550000 359 1.000000 1 0.500000 360 2.000000 5 6.500000 361 4.000000 4 10.000000 362 8.000000 2 9.200000 363 16.000000 0 0.000000 364 32.000000 0 0.000000 365 64.000000 0 0.000000 366 128.000000 0 0.000000 367 256.000000 0 0.000000 368 512.000000 0 0.000000 369 1024.000000 0 0.000000 370 2048.000000 0 0.000000 371 4096.000000 0 0.000000 372 8192.000000 0 0.000000 373 16384.000000 0 0.000000 374 32768.000000 0 0.000000 375 65536.000000 0 0.000000 376 131072.000000 0 0.000000 377 262144.000000 0 0.000000 378 524288.000000 0 0.000000 3791048576.000000 0 0.000000 3802097152.000000 0 0.000000 3814194304.000000 0 0.000000 3828388608.000000 0 0.000000 383TOO LONG 0 TOO LONG 384SET SESSION query_response_time_exec_time_debug=default; 385SET SESSION query_response_time_exec_time_debug=100000; 386SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 387SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10; 388FLUSH QUERY_RESPONSE_TIME; 389SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 390TIME COUNT TOTAL 391 0.000001 0 0.000000 392 0.000010 0 0.000000 393 0.000100 0 0.000000 394 0.001000 0 0.000000 395 0.010000 0 0.000000 396 0.100000 0 0.000000 397 1.000000 0 0.000000 398 10.000000 0 0.000000 399 100.000000 0 0.000000 400 1000.000000 0 0.000000 401 10000.000000 0 0.000000 402 100000.000000 0 0.000000 4031000000.000000 0 0.000000 404TOO LONG 0 TOO LONG 405SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 406SET SESSION query_response_time_exec_time_debug=310000; 407SELECT 1; 4081 4091 410SET SESSION query_response_time_exec_time_debug=320000; 411SELECT 1; 4121 4131 414SET SESSION query_response_time_exec_time_debug=330000; 415SELECT 1; 4161 4171 418SET SESSION query_response_time_exec_time_debug=340000; 419SELECT 1; 4201 4211 422SET SESSION query_response_time_exec_time_debug=350000; 423SELECT 1; 4241 4251 426SET SESSION query_response_time_exec_time_debug=360000; 427SELECT 1; 4281 4291 430SET SESSION query_response_time_exec_time_debug=370000; 431SELECT 1; 4321 4331 434SET SESSION query_response_time_exec_time_debug=380000; 435SELECT 1; 4361 4371 438SET SESSION query_response_time_exec_time_debug=390000; 439SELECT 1; 4401 4411 442SET SESSION query_response_time_exec_time_debug=400000; 443SELECT 1; 4441 4451 446SET SESSION query_response_time_exec_time_debug=1100000; 447SELECT 1; 4481 4491 450SET SESSION query_response_time_exec_time_debug=1200000; 451SELECT 1; 4521 4531 454SET SESSION query_response_time_exec_time_debug=1300000; 455SELECT 1; 4561 4571 458SET SESSION query_response_time_exec_time_debug=1500000; 459SELECT 1; 4601 4611 462SET SESSION query_response_time_exec_time_debug=1400000; 463SELECT 1; 4641 4651 466SET SESSION query_response_time_exec_time_debug=500000; 467SELECT 1; 4681 4691 470SET SESSION query_response_time_exec_time_debug=2100000; 471SELECT 1; 4721 4731 474SET SESSION query_response_time_exec_time_debug=2300000; 475SELECT 1; 4761 4771 478SET SESSION query_response_time_exec_time_debug=2500000; 479SELECT 1; 4801 4811 482SET SESSION query_response_time_exec_time_debug=3100000; 483SELECT 1; 4841 4851 486SET SESSION query_response_time_exec_time_debug=4100000; 487SELECT 1; 4881 4891 490SET SESSION query_response_time_exec_time_debug=5100000; 491SELECT 1; 4921 4931 494SET SESSION query_response_time_exec_time_debug=100000; 495SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 496SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 497Variable_name Value 498query_response_time_range_base 10 499SHOW QUERY_RESPONSE_TIME; 500Time Count Total 501 0.000001 24 0.000000 502 0.000010 0 0.000000 503 0.000100 0 0.000000 504 0.001000 0 0.000000 505 0.010000 0 0.000000 506 0.100000 0 0.000000 507 1.000000 11 4.050000 508 10.000000 11 25.700000 509 100.000000 0 0.000000 510 1000.000000 0 0.000000 511 10000.000000 0 0.000000 512 100000.000000 0 0.000000 5131000000.000000 0 0.000000 514TOO LONG 0 TOO LONG 515SET SESSION query_response_time_exec_time_debug=default; 516SET SESSION query_response_time_exec_time_debug=100000; 517SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 518SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7; 519FLUSH QUERY_RESPONSE_TIME; 520SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 521TIME COUNT TOTAL 522 0.000001 0 0.000000 523 0.000008 0 0.000000 524 0.000059 0 0.000000 525 0.000416 0 0.000000 526 0.002915 0 0.000000 527 0.020408 0 0.000000 528 0.142857 0 0.000000 529 1.000000 0 0.000000 530 7.000000 0 0.000000 531 49.000000 0 0.000000 532 343.000000 0 0.000000 533 2401.000000 0 0.000000 534 16807.000000 0 0.000000 535 117649.000000 0 0.000000 536 823543.000000 0 0.000000 5375764801.000000 0 0.000000 538TOO LONG 0 TOO LONG 539SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 540SET SESSION query_response_time_exec_time_debug=310000; 541SELECT 1; 5421 5431 544SET SESSION query_response_time_exec_time_debug=320000; 545SELECT 1; 5461 5471 548SET SESSION query_response_time_exec_time_debug=330000; 549SELECT 1; 5501 5511 552SET SESSION query_response_time_exec_time_debug=340000; 553SELECT 1; 5541 5551 556SET SESSION query_response_time_exec_time_debug=350000; 557SELECT 1; 5581 5591 560SET SESSION query_response_time_exec_time_debug=360000; 561SELECT 1; 5621 5631 564SET SESSION query_response_time_exec_time_debug=370000; 565SELECT 1; 5661 5671 568SET SESSION query_response_time_exec_time_debug=380000; 569SELECT 1; 5701 5711 572SET SESSION query_response_time_exec_time_debug=390000; 573SELECT 1; 5741 5751 576SET SESSION query_response_time_exec_time_debug=400000; 577SELECT 1; 5781 5791 580SET SESSION query_response_time_exec_time_debug=1100000; 581SELECT 1; 5821 5831 584SET SESSION query_response_time_exec_time_debug=1200000; 585SELECT 1; 5861 5871 588SET SESSION query_response_time_exec_time_debug=1300000; 589SELECT 1; 5901 5911 592SET SESSION query_response_time_exec_time_debug=1500000; 593SELECT 1; 5941 5951 596SET SESSION query_response_time_exec_time_debug=1400000; 597SELECT 1; 5981 5991 600SET SESSION query_response_time_exec_time_debug=500000; 601SELECT 1; 6021 6031 604SET SESSION query_response_time_exec_time_debug=2100000; 605SELECT 1; 6061 6071 608SET SESSION query_response_time_exec_time_debug=2300000; 609SELECT 1; 6101 6111 612SET SESSION query_response_time_exec_time_debug=2500000; 613SELECT 1; 6141 6151 616SET SESSION query_response_time_exec_time_debug=3100000; 617SELECT 1; 6181 6191 620SET SESSION query_response_time_exec_time_debug=4100000; 621SELECT 1; 6221 6231 624SET SESSION query_response_time_exec_time_debug=5100000; 625SELECT 1; 6261 6271 628SET SESSION query_response_time_exec_time_debug=100000; 629SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 630SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 631Variable_name Value 632query_response_time_range_base 7 633SHOW QUERY_RESPONSE_TIME; 634Time Count Total 635 0.000001 24 0.000000 636 0.000008 0 0.000000 637 0.000059 0 0.000000 638 0.000416 0 0.000000 639 0.002915 0 0.000000 640 0.020408 0 0.000000 641 0.142857 0 0.000000 642 1.000000 11 4.050000 643 7.000000 11 25.700000 644 49.000000 0 0.000000 645 343.000000 0 0.000000 646 2401.000000 0 0.000000 647 16807.000000 0 0.000000 648 117649.000000 0 0.000000 649 823543.000000 0 0.000000 6505764801.000000 0 0.000000 651TOO LONG 0 TOO LONG 652SET SESSION query_response_time_exec_time_debug=default; 653SET SESSION query_response_time_exec_time_debug=100000; 654SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 655SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156; 656FLUSH QUERY_RESPONSE_TIME; 657SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 658TIME COUNT TOTAL 659 0.000041 0 0.000000 660 0.006410 0 0.000000 661 1.000000 0 0.000000 662 156.000000 0 0.000000 663 24336.000000 0 0.000000 6643796416.000000 0 0.000000 665TOO LONG 0 TOO LONG 666SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 667SET SESSION query_response_time_exec_time_debug=310000; 668SELECT 1; 6691 6701 671SET SESSION query_response_time_exec_time_debug=320000; 672SELECT 1; 6731 6741 675SET SESSION query_response_time_exec_time_debug=330000; 676SELECT 1; 6771 6781 679SET SESSION query_response_time_exec_time_debug=340000; 680SELECT 1; 6811 6821 683SET SESSION query_response_time_exec_time_debug=350000; 684SELECT 1; 6851 6861 687SET SESSION query_response_time_exec_time_debug=360000; 688SELECT 1; 6891 6901 691SET SESSION query_response_time_exec_time_debug=370000; 692SELECT 1; 6931 6941 695SET SESSION query_response_time_exec_time_debug=380000; 696SELECT 1; 6971 6981 699SET SESSION query_response_time_exec_time_debug=390000; 700SELECT 1; 7011 7021 703SET SESSION query_response_time_exec_time_debug=400000; 704SELECT 1; 7051 7061 707SET SESSION query_response_time_exec_time_debug=1100000; 708SELECT 1; 7091 7101 711SET SESSION query_response_time_exec_time_debug=1200000; 712SELECT 1; 7131 7141 715SET SESSION query_response_time_exec_time_debug=1300000; 716SELECT 1; 7171 7181 719SET SESSION query_response_time_exec_time_debug=1500000; 720SELECT 1; 7211 7221 723SET SESSION query_response_time_exec_time_debug=1400000; 724SELECT 1; 7251 7261 727SET SESSION query_response_time_exec_time_debug=500000; 728SELECT 1; 7291 7301 731SET SESSION query_response_time_exec_time_debug=2100000; 732SELECT 1; 7331 7341 735SET SESSION query_response_time_exec_time_debug=2300000; 736SELECT 1; 7371 7381 739SET SESSION query_response_time_exec_time_debug=2500000; 740SELECT 1; 7411 7421 743SET SESSION query_response_time_exec_time_debug=3100000; 744SELECT 1; 7451 7461 747SET SESSION query_response_time_exec_time_debug=4100000; 748SELECT 1; 7491 7501 751SET SESSION query_response_time_exec_time_debug=5100000; 752SELECT 1; 7531 7541 755SET SESSION query_response_time_exec_time_debug=100000; 756SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 757SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 758Variable_name Value 759query_response_time_range_base 156 760SHOW QUERY_RESPONSE_TIME; 761Time Count Total 762 0.000041 24 0.000000 763 0.006410 0 0.000000 764 1.000000 11 4.050000 765 156.000000 11 25.700000 766 24336.000000 0 0.000000 7673796416.000000 0 0.000000 768TOO LONG 0 TOO LONG 769SET SESSION query_response_time_exec_time_debug=default; 770SET SESSION query_response_time_exec_time_debug=100000; 771SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 772SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000; 773FLUSH QUERY_RESPONSE_TIME; 774SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 775TIME COUNT TOTAL 776 0.000001 0 0.000000 777 0.001000 0 0.000000 778 1.000000 0 0.000000 779 1000.000000 0 0.000000 7801000000.000000 0 0.000000 781TOO LONG 0 TOO LONG 782SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 783SET SESSION query_response_time_exec_time_debug=310000; 784SELECT 1; 7851 7861 787SET SESSION query_response_time_exec_time_debug=320000; 788SELECT 1; 7891 7901 791SET SESSION query_response_time_exec_time_debug=330000; 792SELECT 1; 7931 7941 795SET SESSION query_response_time_exec_time_debug=340000; 796SELECT 1; 7971 7981 799SET SESSION query_response_time_exec_time_debug=350000; 800SELECT 1; 8011 8021 803SET SESSION query_response_time_exec_time_debug=360000; 804SELECT 1; 8051 8061 807SET SESSION query_response_time_exec_time_debug=370000; 808SELECT 1; 8091 8101 811SET SESSION query_response_time_exec_time_debug=380000; 812SELECT 1; 8131 8141 815SET SESSION query_response_time_exec_time_debug=390000; 816SELECT 1; 8171 8181 819SET SESSION query_response_time_exec_time_debug=400000; 820SELECT 1; 8211 8221 823SET SESSION query_response_time_exec_time_debug=1100000; 824SELECT 1; 8251 8261 827SET SESSION query_response_time_exec_time_debug=1200000; 828SELECT 1; 8291 8301 831SET SESSION query_response_time_exec_time_debug=1300000; 832SELECT 1; 8331 8341 835SET SESSION query_response_time_exec_time_debug=1500000; 836SELECT 1; 8371 8381 839SET SESSION query_response_time_exec_time_debug=1400000; 840SELECT 1; 8411 8421 843SET SESSION query_response_time_exec_time_debug=500000; 844SELECT 1; 8451 8461 847SET SESSION query_response_time_exec_time_debug=2100000; 848SELECT 1; 8491 8501 851SET SESSION query_response_time_exec_time_debug=2300000; 852SELECT 1; 8531 8541 855SET SESSION query_response_time_exec_time_debug=2500000; 856SELECT 1; 8571 8581 859SET SESSION query_response_time_exec_time_debug=3100000; 860SELECT 1; 8611 8621 863SET SESSION query_response_time_exec_time_debug=4100000; 864SELECT 1; 8651 8661 867SET SESSION query_response_time_exec_time_debug=5100000; 868SELECT 1; 8691 8701 871SET SESSION query_response_time_exec_time_debug=100000; 872SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 873SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 874Variable_name Value 875query_response_time_range_base 1000 876SHOW QUERY_RESPONSE_TIME; 877Time Count Total 878 0.000001 24 0.000000 879 0.001000 0 0.000000 880 1.000000 11 4.050000 881 1000.000000 11 25.700000 8821000000.000000 0 0.000000 883TOO LONG 0 TOO LONG 884SET SESSION query_response_time_exec_time_debug=default; 885SET SESSION query_response_time_exec_time_debug=100000; 886SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 887SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1001; 888Warnings: 889Warning 1292 Truncated incorrect query_response_time_range_base value: '1001' 890FLUSH QUERY_RESPONSE_TIME; 891SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; 892TIME COUNT TOTAL 893 0.000001 0 0.000000 894 0.001000 0 0.000000 895 1.000000 0 0.000000 896 1000.000000 0 0.000000 8971000000.000000 0 0.000000 898TOO LONG 0 TOO LONG 899SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; 900SET SESSION query_response_time_exec_time_debug=310000; 901SELECT 1; 9021 9031 904SET SESSION query_response_time_exec_time_debug=320000; 905SELECT 1; 9061 9071 908SET SESSION query_response_time_exec_time_debug=330000; 909SELECT 1; 9101 9111 912SET SESSION query_response_time_exec_time_debug=340000; 913SELECT 1; 9141 9151 916SET SESSION query_response_time_exec_time_debug=350000; 917SELECT 1; 9181 9191 920SET SESSION query_response_time_exec_time_debug=360000; 921SELECT 1; 9221 9231 924SET SESSION query_response_time_exec_time_debug=370000; 925SELECT 1; 9261 9271 928SET SESSION query_response_time_exec_time_debug=380000; 929SELECT 1; 9301 9311 932SET SESSION query_response_time_exec_time_debug=390000; 933SELECT 1; 9341 9351 936SET SESSION query_response_time_exec_time_debug=400000; 937SELECT 1; 9381 9391 940SET SESSION query_response_time_exec_time_debug=1100000; 941SELECT 1; 9421 9431 944SET SESSION query_response_time_exec_time_debug=1200000; 945SELECT 1; 9461 9471 948SET SESSION query_response_time_exec_time_debug=1300000; 949SELECT 1; 9501 9511 952SET SESSION query_response_time_exec_time_debug=1500000; 953SELECT 1; 9541 9551 956SET SESSION query_response_time_exec_time_debug=1400000; 957SELECT 1; 9581 9591 960SET SESSION query_response_time_exec_time_debug=500000; 961SELECT 1; 9621 9631 964SET SESSION query_response_time_exec_time_debug=2100000; 965SELECT 1; 9661 9671 968SET SESSION query_response_time_exec_time_debug=2300000; 969SELECT 1; 9701 9711 972SET SESSION query_response_time_exec_time_debug=2500000; 973SELECT 1; 9741 9751 976SET SESSION query_response_time_exec_time_debug=3100000; 977SELECT 1; 9781 9791 980SET SESSION query_response_time_exec_time_debug=4100000; 981SELECT 1; 9821 9831 984SET SESSION query_response_time_exec_time_debug=5100000; 985SELECT 1; 9861 9871 988SET SESSION query_response_time_exec_time_debug=100000; 989SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; 990SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; 991Variable_name Value 992query_response_time_range_base 1000 993SHOW QUERY_RESPONSE_TIME; 994Time Count Total 995 0.000001 24 0.000000 996 0.001000 0 0.000000 997 1.000000 11 4.050000 998 1000.000000 11 25.700000 9991000000.000000 0 0.000000 1000TOO LONG 0 TOO LONG 1001SET SESSION query_response_time_exec_time_debug=default; 1002SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; 1003SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; 1004