-- Env # System Summary Report ###################################### Date | 2025-07-07 13:58:00 UTC (local TZ: CEST +0200) Hostname | bug118403 Uptime | 3 days, 2:15, 4 users, load average: 14.79, 11.52, 7.07 Platform | Linux Release | Red Hat Enterprise Linux release 9.6 (Plow) Kernel | 5.15.0-309.180.4.el9uek.x86_64 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.34 Compiler | GNU CC version 11.5.0 20240719 (Red Hat 11.5.0-5.0.1). SELinux | Disabled Virtualized | No virtualization detected # Processor ################################################## Processors | physical = 1, cores = 8, virtual = 16, hyperthreading = yes Speeds | 16x2445.404 Models | 16xAMD EPYC 7J13 64-Core Processor Caches | 16x512 KB # Memory ##################################################### Total | 251.2G Free | 226.8G Used | physical = 15.2G, swap allocated = 4.0G, swap used = 0.0, virtual = 15.2G Shared | 166.9M Buffers | 11.5G Caches | 236.0G Dirty | 568 kB UsedRSS | 13.2G Swappiness | 60 DirtyPolicy | 20, 10 DirtyStatus | 0, 0 Locator Size Speed Form Factor Type Type Detail ========= ======== ================= ============= ============= =========== -- file system [umshastr@bug118403:~/work/binaries/utils]$ df -Th Filesystem Type Size Used Avail Use% Mounted on devtmpfs devtmpfs 4.0M 0 4.0M 0% /dev tmpfs tmpfs 126G 0 126G 0% /dev/shm tmpfs tmpfs 51G 167M 51G 1% /run /dev/mapper/ocivolume-root xfs 98G 22G 77G 22% / /dev/sda2 xfs 2.0G 921M 1.1G 47% /boot /dev/sda1 vfat 100M 7.2M 93M 8% /boot/efi /dev/sdb1 xfs 500G 15G 486G 3% /bv/ushastry tmpfs tmpfs 26G 4.0K 26G 1% /run/user/984 100.103.18.75:/fss/fs01/home/umshastr nfs 100T 15T 86T 15% /home/umshastr tmpfs tmpfs 26G 4.0K 26G 1% /run/user/10919 /dev/sdc1 xfs 1000G 686G 314G 69% /bv/bug118335 [umshastr@bug118403:~/work/binaries/utils]$ -- Build used [umshastr@bug118403:/bv/ushastry/Work/Binaries/mysql-9.3.0]$ cat docs/INFO_SRC commit: b899b56aff00009abcd57baed8c2241fe4b4599b date: 2025-03-31 09:42:56 +0200 build-date: 2025-03-31 08:02:20 +0000 short: b899b56aff00 branch: mysql-9.3.0-release MySQL source 9.3.0 MySQL release maturity INNOVATION ## Have datadir on a very large partition ( it took 8-10hrs to generate huge tables ## Start up command BugNumber=118335 rm -rf $BugNumber/ bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx=0 --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 --innodb-file-per-table=OFF --innodb-adaptive-hash-index=OFF --innodb-buffer-pool-size=8G --table-open-cache=4000 --table-open-cache-instances=16 --table-open-cache-triggers=524288 --skip-log-bin 2>&1 & umshastr@bug118403:/bv/ushastry/Work/Binaries/mysql-9.3.0]$ bin/mysql -uroot -S/tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 9.3.0 MySQL Community Server - GPL Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like "%file_per_table%"; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | innodb_file_per_table | OFF | +-----------------------+-------+ 1 row in set (0.003 sec) mysql> show variables like "innodb_adaptive_hash_index%"; +----------------------------------+-------+ | Variable_name | Value | +----------------------------------+-------+ | innodb_adaptive_hash_index | OFF | | innodb_adaptive_hash_index_parts | 8 | +----------------------------------+-------+ 2 rows in set (0.001 sec) mysql> show variables like "innodb_buffer_pool_size"; +-------------------------+------------+ | Variable_name | Value | +-------------------------+------------+ | innodb_buffer_pool_size | 8589934592 | +-------------------------+------------+ 1 row in set (0.001 sec) mysql> show variables like "%open_cache%"; +----------------------------+--------+ | Variable_name | Value | +----------------------------+--------+ | table_open_cache | 4000 | | table_open_cache_instances | 16 | | table_open_cache_triggers | 524288 | +----------------------------+--------+ 3 rows in set (0.001 sec) mysql> create database sbtest; Query OK, 1 row affected (0.005 sec) mysql> create database mytest; Query OK, 1 row affected (0.009 sec) mysql> -- Follow steps from report step 1. prepare two big tables in database sbtest: [umshastr@bug118403:/bv/ushastry/Work/Utilities/sysbench]$ bin/sysbench share/sysbench/oltp_write_only --db-driver=mysql --mysql-host=localhost --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbtest --tables=2 --table-size=1500000000 --threads=16 prepare sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Initializing worker threads... Creating table 'sbtest1'... Creating table 'sbtest2'... Inserting 1500000000 records into 'sbtest1' Inserting 1500000000 records into 'sbtest2' Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest1'... [umshastr@bug118403:/bv/ushastry/Work/Utilities/sysbench]$ -- file system /dev/sdc1 xfs 1000G 686G 314G 69% /bv/bug118335 Every 2.0s: du -h ibdata1 bug118403: Mon Jul 7 15:51:02 2025 679G ibdata1 2. prepare a lot of tables in database mytest, the number of tables should bigger than table open cache. ``` bin/sysbench share/sysbench/oltp_write_only --db-driver=mysql --mysql-host=localhost --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=mytest --tables=4000 --table-size=100 --threads=32 prepare ``` 3. sysbench execute read only DML ``` [umshastr@bug118403:/bv/ushastry/Work/Utilities/sysbench]$ bin/sysbench share/sysbench/oltp_read_only --db-driver=mysql --mysql-host=localhost --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=mytest --tables=4000 --table-size=100 --threads=32 --time=600 --report-interval=1 --db-ps-mode=disable run sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 32 Report intermediate results every 1 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 1s ] thds: 32 tps: 3170.68 qps: 51025.60 (r/w/o: 44652.27/0.00/6373.33) lat (ms,95%): 13.95 err/s: 0.00 reconn/s: 0.00 [ 2s ] thds: 32 tps: 3309.15 qps: 52978.37 (r/w/o: 46361.07/0.00/6617.30) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 3s ] thds: 32 tps: 3334.95 qps: 53367.25 (r/w/o: 46696.35/0.00/6670.91) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 4s ] thds: 32 tps: 3326.00 qps: 53193.95 (r/w/o: 46542.95/0.00/6650.99) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 5s ] thds: 32 tps: 3335.00 qps: 53384.02 (r/w/o: 46714.02/0.00/6670.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 6s ] thds: 32 tps: 3314.21 qps: 52997.28 (r/w/o: 46368.87/0.00/6628.41) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 7s ] thds: 32 tps: 3147.00 qps: 50353.06 (r/w/o: 44058.05/0.00/6295.01) lat (ms,95%): 13.95 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 32 tps: 2928.83 qps: 46836.28 (r/w/o: 40978.62/0.00/5857.66) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 32 tps: 2860.19 qps: 45791.04 (r/w/o: 40070.66/0.00/5720.38) lat (ms,95%): 15.27 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 32 tps: 2994.83 qps: 47915.27 (r/w/o: 41926.61/0.00/5988.66) lat (ms,95%): 15.00 err/s: 0.00 reconn/s: 0.00 [ 11s ] thds: 32 tps: 3209.88 qps: 51342.06 (r/w/o: 44921.31/0.00/6420.76) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 12s ] thds: 32 tps: 3339.06 qps: 53417.91 (r/w/o: 46741.80/0.00/6676.11) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 13s ] thds: 32 tps: 3344.07 qps: 53524.15 (r/w/o: 46835.01/0.00/6689.14) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 14s ] thds: 32 tps: 3311.98 qps: 53011.75 (r/w/o: 46386.78/0.00/6624.97) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 32 tps: 3325.96 qps: 53245.35 (r/w/o: 46594.43/0.00/6650.92) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 16s ] thds: 32 tps: 3314.01 qps: 52954.15 (r/w/o: 46325.13/0.00/6629.02) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 17s ] thds: 32 tps: 3302.96 qps: 52882.33 (r/w/o: 46277.42/0.00/6604.92) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 18s ] thds: 32 tps: 3315.09 qps: 52976.40 (r/w/o: 46348.23/0.00/6628.18) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 19s ] thds: 32 tps: 3337.96 qps: 53490.41 (r/w/o: 46812.48/0.00/6677.93) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 32 tps: 3320.55 qps: 53136.88 (r/w/o: 46495.77/0.00/6641.11) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 21s ] thds: 32 tps: 3339.69 qps: 53375.05 (r/w/o: 46694.67/0.00/6680.38) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 22s ] thds: 32 tps: 3243.81 qps: 51941.96 (r/w/o: 45454.34/0.00/6487.62) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 23s ] thds: 32 tps: 3333.92 qps: 53337.77 (r/w/o: 46669.93/0.00/6667.85) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 24s ] thds: 32 tps: 3322.03 qps: 53166.52 (r/w/o: 46522.45/0.00/6644.06) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 32 tps: 3318.97 qps: 53049.50 (r/w/o: 46412.56/0.00/6636.94) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 26s ] thds: 32 tps: 3286.95 qps: 52561.24 (r/w/o: 45987.33/0.00/6573.90) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 27s ] thds: 32 tps: 3332.38 qps: 53337.01 (r/w/o: 46671.26/0.00/6665.75) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 28s ] thds: 32 tps: 3349.20 qps: 53603.25 (r/w/o: 46904.84/0.00/6698.41) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 29s ] thds: 32 tps: 3320.46 qps: 53122.43 (r/w/o: 46482.50/0.00/6639.93) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 32 tps: 3296.59 qps: 52775.48 (r/w/o: 46182.30/0.00/6593.18) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 31s ] thds: 32 tps: 3329.42 qps: 53250.66 (r/w/o: 46590.83/0.00/6659.83) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 32s ] thds: 32 tps: 3307.00 qps: 52914.02 (r/w/o: 46300.02/0.00/6614.00) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 33s ] thds: 32 tps: 3287.00 qps: 52593.04 (r/w/o: 46019.03/0.00/6574.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 34s ] thds: 32 tps: 2905.01 qps: 46524.23 (r/w/o: 40714.20/0.00/5810.03) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 32 tps: 3098.01 qps: 49564.09 (r/w/o: 43370.08/0.00/6194.01) lat (ms,95%): 15.00 err/s: 0.00 reconn/s: 0.00 [ 36s ] thds: 32 tps: 3139.23 qps: 50167.66 (r/w/o: 43888.21/0.00/6279.46) lat (ms,95%): 15.00 err/s: 0.00 reconn/s: 0.00 [ 37s ] thds: 32 tps: 3125.38 qps: 50107.04 (r/w/o: 43855.29/0.00/6251.76) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00 [ 38s ] thds: 32 tps: 3067.31 qps: 49036.00 (r/w/o: 42901.38/0.00/6134.63) lat (ms,95%): 15.55 err/s: 0.00 reconn/s: 0.00 [ 39s ] thds: 32 tps: 3249.10 qps: 51929.54 (r/w/o: 45431.35/0.00/6498.19) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 32 tps: 3276.98 qps: 52370.76 (r/w/o: 45816.79/0.00/6553.97) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00 [ 41s ] thds: 32 tps: 3275.99 qps: 52472.88 (r/w/o: 45921.89/0.00/6550.98) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 42s ] thds: 32 tps: 3302.00 qps: 52815.99 (r/w/o: 46212.99/0.00/6603.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 43s ] thds: 32 tps: 3304.97 qps: 52934.48 (r/w/o: 46322.54/0.00/6611.93) lat (ms,95%): 13.46 err/s: 0.00 reconn/s: 0.00 [ 44s ] thds: 32 tps: 3225.25 qps: 51593.00 (r/w/o: 45142.50/0.00/6450.50) lat (ms,95%): 14.21 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 32 tps: 3335.78 qps: 53353.41 (r/w/o: 46681.86/0.00/6671.55) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 46s ] thds: 32 tps: 3305.97 qps: 52916.47 (r/w/o: 46304.54/0.00/6611.93) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 47s ] thds: 32 tps: 3326.00 qps: 53237.93 (r/w/o: 46585.93/0.00/6651.99) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 48s ] thds: 32 tps: 3315.00 qps: 52990.04 (r/w/o: 46360.04/0.00/6630.01) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 49s ] thds: 32 tps: 3292.01 qps: 52712.13 (r/w/o: 46128.12/0.00/6584.02) lat (ms,95%): 13.46 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 32 tps: 3310.01 qps: 52939.19 (r/w/o: 46319.17/0.00/6620.02) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 51s ] thds: 32 tps: 3277.98 qps: 52460.62 (r/w/o: 45905.66/0.00/6554.95) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 52s ] thds: 32 tps: 3318.01 qps: 53048.11 (r/w/o: 46412.09/0.00/6636.01) lat (ms,95%): 13.46 err/s: 0.00 reconn/s: 0.00 [ 53s ] thds: 32 tps: 3309.01 qps: 52970.16 (r/w/o: 46352.14/0.00/6618.02) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 54s ] thds: 32 tps: 3284.00 qps: 52548.05 (r/w/o: 45979.04/0.00/6569.01) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 32 tps: 3300.04 qps: 52860.59 (r/w/o: 46260.51/0.00/6600.07) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 56s ] thds: 32 tps: 3305.98 qps: 52818.73 (r/w/o: 46207.76/0.00/6610.97) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 57s ] thds: 32 tps: 3295.99 qps: 52752.80 (r/w/o: 46159.83/0.00/6592.98) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 58s ] thds: 32 tps: 3326.97 qps: 53295.58 (r/w/o: 46641.63/0.00/6653.95) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 59s ] thds: 32 tps: 3347.99 qps: 53472.89 (r/w/o: 46777.90/0.00/6694.99) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 32 tps: 3285.02 qps: 52608.40 (r/w/o: 46037.35/0.00/6571.05) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 61s ] thds: 32 tps: 3277.95 qps: 52477.21 (r/w/o: 45922.31/0.00/6554.90) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 62s ] thds: 32 tps: 3302.04 qps: 52737.67 (r/w/o: 46132.59/0.00/6605.08) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 63s ] thds: 32 tps: 3302.99 qps: 52902.92 (r/w/o: 46296.93/0.00/6605.99) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 64s ] thds: 32 tps: 3292.00 qps: 52665.08 (r/w/o: 46083.07/0.00/6582.01) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 32 tps: 3345.00 qps: 53502.02 (r/w/o: 46810.02/0.00/6692.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 66s ] thds: 32 tps: 3298.00 qps: 52833.98 (r/w/o: 46237.99/0.00/6596.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 67s ] thds: 32 tps: 3281.03 qps: 52504.43 (r/w/o: 45942.38/0.00/6562.05) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 68s ] thds: 32 tps: 3284.48 qps: 52521.60 (r/w/o: 45952.65/0.00/6568.95) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 69s ] thds: 32 tps: 3280.50 qps: 52478.93 (r/w/o: 45917.94/0.00/6560.99) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 32 tps: 3308.41 qps: 52937.62 (r/w/o: 46320.79/0.00/6616.83) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 71s ] thds: 32 tps: 3327.61 qps: 53276.73 (r/w/o: 46621.51/0.00/6655.22) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 72s ] thds: 32 tps: 3286.92 qps: 52559.74 (r/w/o: 45985.90/0.00/6573.84) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 73s ] thds: 32 tps: 3313.09 qps: 53009.41 (r/w/o: 46385.23/0.00/6624.18) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 74s ] thds: 32 tps: 3304.92 qps: 52858.65 (r/w/o: 46247.82/0.00/6610.83) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 32 tps: 3305.07 qps: 52888.05 (r/w/o: 46276.92/0.00/6611.13) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 76s ] thds: 32 tps: 3298.03 qps: 52757.45 (r/w/o: 46162.39/0.00/6595.06) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 77s ] thds: 32 tps: 3310.12 qps: 52953.94 (r/w/o: 46332.70/0.00/6621.24) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 78s ] thds: 32 tps: 3293.83 qps: 52731.21 (r/w/o: 46143.56/0.00/6587.65) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 79s ] thds: 32 tps: 3297.01 qps: 52748.16 (r/w/o: 46154.14/0.00/6594.02) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 32 tps: 3314.02 qps: 53005.29 (r/w/o: 46377.25/0.00/6628.04) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 81s ] thds: 32 tps: 3343.99 qps: 53507.88 (r/w/o: 46819.89/0.00/6687.98) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 82s ] thds: 32 tps: 3268.00 qps: 52268.04 (r/w/o: 45733.03/0.00/6535.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 83s ] thds: 32 tps: 3304.04 qps: 52926.71 (r/w/o: 46317.62/0.00/6609.09) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 84s ] thds: 32 tps: 3299.96 qps: 52808.34 (r/w/o: 46208.42/0.00/6599.92) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 32 tps: 3306.00 qps: 52804.97 (r/w/o: 46194.97/0.00/6610.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 86s ] thds: 32 tps: 3232.00 qps: 51794.07 (r/w/o: 45328.06/0.00/6466.01) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 87s ] thds: 32 tps: 3311.00 qps: 52949.96 (r/w/o: 46327.97/0.00/6622.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 88s ] thds: 32 tps: 3312.01 qps: 52996.23 (r/w/o: 46372.20/0.00/6624.03) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 89s ] thds: 32 tps: 3294.97 qps: 52735.45 (r/w/o: 46145.52/0.00/6589.93) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 32 tps: 3284.00 qps: 52538.95 (r/w/o: 45970.96/0.00/6567.99) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 91s ] thds: 32 tps: 3330.03 qps: 53255.52 (r/w/o: 46595.45/0.00/6660.06) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 92s ] thds: 32 tps: 3248.02 qps: 51910.30 (r/w/o: 45416.26/0.00/6494.04) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 93s ] thds: 32 tps: 3273.98 qps: 52426.72 (r/w/o: 45877.76/0.00/6548.97) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 94s ] thds: 32 tps: 3310.97 qps: 53003.48 (r/w/o: 46381.54/0.00/6621.93) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 32 tps: 3315.00 qps: 53063.06 (r/w/o: 46432.05/0.00/6631.01) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 96s ] thds: 32 tps: 3334.01 qps: 53252.11 (r/w/o: 46586.09/0.00/6666.01) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00 [ 97s ] thds: 32 tps: 3248.02 qps: 52030.40 (r/w/o: 45532.35/0.00/6498.05) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 98s ] thds: 32 tps: 3308.03 qps: 52943.50 (r/w/o: 46327.44/0.00/6616.06) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 99s ] thds: 32 tps: 1433.08 qps: 22867.21 (r/w/o: 20001.06/0.00/2866.15) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 32 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 101s ] thds: 32 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 102s ] thds: 32 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 103s ] thds: 32 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 104s ] thds: 32 tps: 2336.85 qps: 37434.54 (r/w/o: 32763.84/0.00/4670.69) lat (ms,95%): 15.27 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 32 tps: 3113.99 qps: 49835.89 (r/w/o: 43604.91/0.00/6230.99) lat (ms,95%): 15.83 err/s: 0.00 reconn/s: 0.00 [ 106s ] thds: 32 tps: 3291.98 qps: 52626.73 (r/w/o: 46044.77/0.00/6581.97) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 107s ] thds: 32 tps: 3299.25 qps: 52755.02 (r/w/o: 46154.52/0.00/6600.50) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 108s ] thds: 32 tps: 3278.77 qps: 52504.31 (r/w/o: 45947.77/0.00/6556.54) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 109s ] thds: 32 tps: 3271.98 qps: 52372.76 (r/w/o: 45827.79/0.00/6544.97) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 32 tps: 3280.03 qps: 52455.46 (r/w/o: 45895.40/0.00/6560.06) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 111s ] thds: 32 tps: 3273.04 qps: 52343.67 (r/w/o: 45798.59/0.00/6545.08) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00 [ 112s ] thds: 32 tps: 3287.88 qps: 52674.14 (r/w/o: 46097.37/0.00/6576.77) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 113s ] thds: 32 tps: 3304.05 qps: 52857.87 (r/w/o: 46249.76/0.00/6608.11) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 114s ] thds: 32 tps: 3281.06 qps: 52470.89 (r/w/o: 45909.77/0.00/6561.11) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 32 tps: 3221.39 qps: 51553.23 (r/w/o: 45110.45/0.00/6442.78) lat (ms,95%): 14.73 err/s: 0.00 reconn/s: 0.00 [ 116s ] thds: 32 tps: 3246.61 qps: 51972.73 (r/w/o: 45478.51/0.00/6494.22) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00 [ 117s ] thds: 32 tps: 3292.10 qps: 52646.57 (r/w/o: 46062.37/0.00/6584.20) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 [ 118s ] thds: 32 tps: 3324.83 qps: 53224.29 (r/w/o: 46576.63/0.00/6647.66) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00 [ 119s ] thds: 32 tps: 3279.01 qps: 52448.21 (r/w/o: 45888.18/0.00/6560.03) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00 ``` 4. drop big table ``` mysql> use sbtest Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> drop table sbtest1; Query OK, 0 rows affected (4.816 sec) mysql> ```