mysql优化工具mysqltuner

  |   0 评论   |   0 浏览

  

01. 介绍

  https://github.com/major/MySQLTuner-perl
MySQLTuner 是用 Perl 编写的脚本,可让您快速查看 MySQL 安装并进行调整以提高性能和稳定性。 检索当前配置变量和状态数据,并以简短的格式提供一些基本的性能建议。

  在此最新版本中,MySQLTuner 支持 MySQL / MariaDB / Percona Server 的约 300 个指标。

  MySQLTuner 持续更新,并且指标收集逐周增加,以支持许多配置,例如 Galera Cluster,TokuDB,Performance 模式,Linux OS 指标,InnoDB,MyISAM,Aria 等。

02. 环境初始化

  服务器环境:

1CentOS Linux release 7.7.1908 (Core)
2
3model name	: Intel(R) Xeon(R) CPU @ 2.00GHz
4model name	: Intel(R) Xeon(R) CPU @ 2.00GHz
5physical id	: 0
6physical id	: 0
7
8MemTotal:        1882032 kB

  数据库:

1docker run -d -p 3306:3306 --env MYSQL_ROOT_PASSWORD=123456 mysql

03. 安装 mysqltuner

1wget http://mysqltuner.pl/ -O mysqltuner.pl
2wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt
3wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv

04. 使用 mysqltuner

1perl mysqltuner.pl   --forcemem 1024 --host  10.170.0.6 --user root --pass root --buffers --dbstat --idxstat --sysstat --pfstat --tbstat --cvefile=./vulnerabilities.csv

  如果执行报错

1Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at ./mysqltuner.pl line 52

  则需要安装 perl 依赖

1 yum install 'perl(Data::Dumper)'
   1 >>  MySQLTuner 1.7.19 - Major Hayden <[email protected]>
   2 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
   3 >>  Run with '--help' for additional options and output filtering
   4
   5[--] Skipped version check for MySQLTuner script
   6[--] Performing tests on 10.170.0.6:3306
   7[OK] Logged in using credentials passed on the command line
   8[--] Assuming 1024 MB of physical memory
   9[!!] Assuming 0 MB of swap space (use --forceswap to specify)
  10[OK] Currently running supported MySQL version 8.0.19
  11
  12-------- System Linux Recommendations --------------------------------------------------------------
  13Look for related Linux system recommendations
  14[--] CentOS Linux release 7.7.1908 (Core)
  15[--] Machine type          : Virtual machine
  16[--] Internet              : Connected
  17[--] Number of Core CPU : 1
  18
  19[--] Operating System Type : GNU/Linux
  20[--] Kernel Release        : 3.10.0-1062.12.1.el7.x86_64
  21[--] Hostname              : centos75
  22[--] Network Cards         :
  23[--] 	docker0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
  24[--] 	        inet 172.17.0.1  netmask 255.255.0.0  broadcast 172.17.255.255
  25[--] 	--
  26[--] 	eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1460
  27[--] 	        inet 10.170.0.6  netmask 255.255.255.255  broadcast 10.170.0.6
  28[--] 	--
  29[--] 	lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
  30[--] 	        inet 127.0.0.1  netmask 255.0.0.0
  31[--] 	--
  32[--] 	veth281034b: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
  33[--] 	        inet6 fe80::ccdd:79ff:fe3b:1fae  prefixlen 64  scopeid 0x20<link>
  34[--] Internal IP           : 10.170.0.6 172.17.0.1
  35[--] HTTP client found: /usr/bin/curl
  36[--] External IP           :   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current,                                  Dload  Upload   Total   Spent    Le100    14  100    14    0     0     36      0 --:--:-- --:--:-- --:--:--    35, 35.220.214.171
  37[--] Name Servers          : 169.254.169.254
  38[--] Logged In users       :
  39[--] 	mac      pts/0        2020-04-10 12:32 (114.221.177.194)
  40[--] Ram Usages in Mb      :
  41[--] 	              total        used        free      shared  buff/cache   available
  42[--] 	Mem:           1837         665          90          16        1081         975
  43[--] 	Swap:             0           0           0
  44[--] Load Average          :
  45[--] 	top - 12:59:33 up 3 days,  3:10,  1 user,  load average: 0.02, 0.06, 0.06
  46[--] System Uptime         :
  47[--] 	 12:59:33 up 3 days,  3:10,  1 user,  load average: 0.02, 0.06, 0.06
  48[--] User process except mysqld used 144M RAM.
  49[--] Other user process except mysqld used less than 15% of total physical memory 14.16% (144M / 1G)
  50[--] mount point / is using 57 % of total space
  51[--] mount point /var/lib/docker/overlay2/03182f264b9db783d41706b288fdb9efd79541ec370b16948380b255fd05b1ce/merged is using 57 % of total space
  52[--] mount point / is using 2 % of max allowed inodes
  53[--] mount point /var/lib/docker/overlay2/03182f264b9db783d41706b288fdb9efd79541ec370b16948380b255fd05b1ce/merged is using 2 % of max allowed inodes
  54[--] Information about kernel tuning:
  55[--] 	fs.aio-max-nr = 65536
  56[--] 	fs.aio-nr = 2661
  57[--] 	fs.file-max = 184428
  58[--] 	vm.swappiness = 30
  59[!!] Swappiness is > 10, please consider having a value lower than 10
  60[--] TCP slot entries is > 100.
  61[!!] Max running total of the number of events is < 1M, please consider having a value greater than 1M
  62
  63-------- Log file Recommendations ------------------------------------------------------------------
  64[!!] log_error is set to stderr MT can't read stderr
  65
  66-------- Storage Engine Statistics -----------------------------------------------------------------
  67[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  68[--] Data in InnoDB tables: 16.0K (Tables: 1)
  69[OK] Total fragmented tables: 0
  70
  71-------- Analysis Performance Metrics --------------------------------------------------------------
  72[--] innodb_stats_on_metadata: OFF
  73[OK] No stat updates during querying INFORMATION_SCHEMA.
  74
  75-------- Database Metrics --------------------------------------------------------------------------
  76[--] There is 0 Database(s).
  77[--] All User Databases:
  78[--]  +-- TABLE : 0
  79[--]  +-- ROWS  : 0
  80[--]  +-- DATA  : 0B(0%)
  81[--]  +-- INDEX : 0B(0%)
  82[--]  +-- SIZE  : 0B
  83[--]  +-- COLLA : 0 (NULL, utf8_bin, utf8_general_ci, utf8mb4_0900_ai_ci, utf8mb4_bin)
  84[--]  +-- ENGIN : 0 (NULL, InnoDB, CSV, PERFORMANCE_SCHEMA)
  85
  86
  87-------- Table Column Metrics ----------------------------------------------------------------------
  88[--] MySQL and Percona version 8 and greater have remove PROCEDURE ANALYSE feature
  89
  90-------- Indexes Metrics ---------------------------------------------------------------------------
  91[--] Worst selectivity indexes:
  92[--] Unused indexes:
  93
  94-------- Security Recommendations ------------------------------------------------------------------
  95[--] Skipped due to unsupported feature for MySQL 8
  96
  97-------- CVE Security Recommendations --------------------------------------------------------------
  98[OK] NO SECURITY CVE FOUND FOR YOUR VERSION
  99
 100-------- Performance Metrics -----------------------------------------------------------------------
 101[--] Up for: 23m 24s (24 q [0.017 qps], 19 conn, TX: 54K, RX: 1K)
 102[--] Reads / Writes: 100% / 0%
 103[--] Binary logging is enabled (GTID MODE: OFF)
 104[--] Physical Memory     : 1.0G
 105[--] Max MySQL memory    : 9.8G
 106[--] Other process memory: 145.0M
 107[--] Total buffers: 168.0M global + 65.1M per thread (151 max threads)
 108[--] P_S Max memory usage: 72B
 109[--] Galera GCache Max memory usage: 0B
 110[--] Global Buffers
 111[--]  +-- Key Buffer: 8.0M
 112[--]  +-- Max Tmp Table: 16.0M
 113[--] Per Thread Buffers
 114[--]  +-- Read Buffer: 128.0K
 115[--]  +-- Read RND Buffer: 256.0K
 116[--]  +-- Sort Buffer: 256.0K
 117[--]  +-- Thread stack: 280.0K
 118[--]  +-- Join Buffer: 256.0K
 119[--] Binlog Cache Buffers
 120[--]  +-- Binlog Cache: 32.0K
 121[OK] Maximum reached memory usage: 233.1M (22.77% of installed RAM)
 122[!!] Maximum possible memory usage: 9.8G (977.09% of installed RAM)
 123[!!] Overall possible memory usage with other process exceeded memory
 124[OK] Slow queries: 0% (0/24)
 125[OK] Highest usage of available connections: 0% (1/151)
 126[!!] Aborted connections: 21.05%  (4/19)
 127[--] Query cache have been removed in MySQL 8
 128[OK] No Sort requiring temporary tables
 129[OK] No joins without indexes
 130[OK] Temporary tables created on disk: 0% (0 on disk / 4 total)
 131[OK] Thread cache hit rate: 94% (1 created / 19 connections)
 132[OK] Table cache hit rate: 55% (99 open / 179 opened)
 133[OK] table_definition_cache(2000) is upper than number of tables(310)
 134[OK] Open file limit used: 0% (2/1M)
 135[OK] Table locks acquired immediately: 100% (4 immediate / 4 locks)
 136[OK] Binlog cache memory access: 100.00% (3 Memory / 3 Total)
 137
 138-------- Performance schema ------------------------------------------------------------------------
 139[--] Memory used by P_S: 72B
 140[--] Sys schema is installed.
 141[--] Sys schema Version: 2.1.1
 142
 143-------- Performance schema: Top 5 user per connection ---------------------------------------------
 144[--]  +-- 1: background	51 conn(s)
 145[--]  +-- 2: root	39 conn(s)
 146
 147-------- Performance schema: Top 5 user per statement ----------------------------------------------
 148[--]  +-- 1: root	242 stmt(s)
 149[--]  +-- 2: background	1 stmt(s)
 150
 151-------- Performance schema: Top 5 user per statement latency --------------------------------------
 152[--]  +-- 1: root	5543505451.6129
 153[--]  +-- 2: background	333773000.0000
 154
 155-------- Performance schema: Top 5 user per lock latency -------------------------------------------
 156[--]  +-- 1: root	23120000000
 157[--]  +-- 2: background	0
 158
 159-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
 160[--]  +-- 1: root	14
 161[--]  +-- 2: background	0
 162
 163-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
 164[--]  +-- 1: root	2398
 165[--]  +-- 2: background	1
 166
 167-------- Performance schema: Top 5 user per rows modified ------------------------------------------
 168[--]  +-- 1: root	0
 169[--]  +-- 2: background	0
 170
 171-------- Performance schema: Top 5 user per io -----------------------------------------------------
 172[--]  +-- 1: background	1891
 173[--]  +-- 2: root	176
 174
 175-------- Performance schema: Top 5 user per io latency ---------------------------------------------
 176[--]  +-- 1: background	567053922156
 177[--]  +-- 2: root	21365954616
 178
 179-------- Performance schema: Top 5 host per connection ---------------------------------------------
 180[--]  +-- 1: 10.170.0.6	47 conn(s)
 181[--]  +-- 2: localhost	1 conn(s)
 182
 183-------- Performance schema: Top 5 host per statement ----------------------------------------------
 184[--]  +-- 1: 10.170.0.6	142 stmt(s)
 185[--]  +-- 2: localhost	6 stmt(s)
 186
 187-------- Performance schema: Top 5 host per statement latency --------------------------------------
 188[--]  +-- 1: localhost	5123038166.6667
 189[--]  +-- 2: 10.170.0.6	4909615206.8966
 190
 191-------- Performance schema: Top 5 host per lock latency -------------------------------------------
 192[--]  +-- 1: 10.170.0.6	25278000000
 193[--]  +-- 2: localhost	3084000000
 194[--]  +-- 3: background	0
 195
 196-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
 197[--]  +-- 1: 10.170.0.6	23
 198[--]  +-- 2: localhost	0
 199[--]  +-- 3: background	0
 200
 201-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
 202[--]  +-- 1: 10.170.0.6	2426
 203[--]  +-- 2: localhost	1
 204[--]  +-- 3: background	1
 205
 206-------- Performance schema: Top 5 host per rows modified ------------------------------------------
 207[--]  +-- 1: 10.170.0.6	0
 208[--]  +-- 2: localhost	0
 209[--]  +-- 3: background	0
 210
 211-------- Performance schema: Top 5 host per io -----------------------------------------------------
 212[--]  +-- 1: 10.170.0.6	80
 213[--]  +-- 2: localhost	8
 214
 215-------- Performance schema: Top 5 host per io latency ---------------------------------------------
 216[--]  +-- 1: localhost	8112703020
 217[--]  +-- 2: 10.170.0.6	2570274288
 218
 219-------- Performance schema: Top IO type order by total io -----------------------------------------
 220[--]  +-- 1: innodb/innodb_data_file	1287 i/o
 221[--]  +-- 2: sql/binlog	402 i/o
 222[--]  +-- 3: innodb/innodb_log_file	160 i/o
 223[--]  +-- 4: innodb/innodb_temp_file	70 i/o
 224[--]  +-- 5: sql/binlog_index	21 i/o
 225[--]  +-- 6: sql/casetest	10 i/o
 226[--]  +-- 7: csv/metadata	8 i/o
 227[--]  +-- 8: sql/ERRMSG	5 i/o
 228[--]  +-- 9: mysys/cnf	5 i/o
 229[--]  +-- 10: csv/data	4 i/o
 230[--]  +-- 11: sql/pid	3 i/o
 231[--]  +-- 12: mysys/charset	3 i/o
 232[--]  +-- 13: sql/misc	1 i/o
 233
 234-------- Performance schema: Top IO type order by total latency ------------------------------------
 235[--]  +-- 1: innodb/innodb_data_file	385416811032.0
 236[--]  +-- 2: innodb/innodb_log_file	128894712876.0
 237[--]  +-- 3: innodb/innodb_temp_file	44303011164.0
 238[--]  +-- 4: sql/binlog	14091306360.0
 239[--]  +-- 5: sql/ERRMSG	2443618482.0
 240[--]  +-- 6: sql/binlog_index	1012155270.0
 241[--]  +-- 7: csv/data	638847144.0
 242[--]  +-- 8: csv/metadata	439258764.0
 243[--]  +-- 9: sql/casetest	234047160.0
 244[--]  +-- 10: sql/pid	146735886.0
 245[--]  +-- 11: mysys/cnf	56504784.0
 246[--]  +-- 12: mysys/charset	51275346.0
 247[--]  +-- 13: sql/misc	8615196.0
 248
 249-------- Performance schema: Top IO type order by max latency --------------------------------------
 250[--]  +-- 1: innodb/innodb_data_file	303207928446
 251[--]  +-- 2: innodb/innodb_log_file	12346552818
 252[--]  +-- 3: innodb/innodb_temp_file	2956493184
 253[--]  +-- 4: sql/binlog	2642930310
 254[--]  +-- 5: sql/ERRMSG	2217455058
 255[--]  +-- 6: sql/binlog_index	669078486
 256[--]  +-- 7: csv/data	535190244
 257[--]  +-- 8: csv/metadata	192331896
 258[--]  +-- 9: sql/casetest	116812158
 259[--]  +-- 10: sql/pid	101995584
 260[--]  +-- 11: mysys/cnf	33992850
 261[--]  +-- 12: mysys/charset	32925720
 262[--]  +-- 13: sql/misc	8615196
 263
 264-------- Performance schema: Top Stages order by total io ------------------------------------------
 265[--]  +-- 1: innodb/buffer pool load	1 i/o
 266
 267-------- Performance schema: Top Stages order by total latency -------------------------------------
 268[--]  +-- 1: innodb/buffer pool load	2528269000.0
 269
 270-------- Performance schema: Top Stages order by avg latency ---------------------------------------
 271[--]  +-- 1: innodb/buffer pool load	2528269000
 272
 273-------- Performance schema: Top 5 host per table scans --------------------------------------------
 274[--]  +-- 1: 10.170.0.6	34
 275[--]  +-- 2: localhost	0
 276
 277-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
 278[--]  +-- 1: mysql	5931008	3309765	362 page(s)
 279
 280-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
 281[--]  +-- 1: mysql	columns	1359872	1017938	83 page(s)
 282[--]  +-- 2: mysql	time_zone_transition	1097728	984008	67 page(s)
 283[--]  +-- 3: mysql	tables	704512	519069	43 page(s)
 284[--]  +-- 4: mysql	help_topic	245760	133558	15 page(s)
 285[--]  +-- 5: mysql	time_zone_transition_type	212992	172459	13 page(s)
 286[--]  +-- 6: mysql	index_column_usage	212992	105381	13 page(s)
 287[--]  +-- 7: mysql	help_keyword	163840	95159	10 page(s)
 288[--]  +-- 8: mysql	time_zone_name	131072	46698	8 page(s)
 289[--]  +-- 9: mysql	table_partitions	114688	0	7 page(s)
 290[--]  +-- 10: mysql	indexes	98304	42612	6 page(s)
 291[--]  +-- 11: mysql	triggers	98304	1076	6 page(s)
 292[--]  +-- 12: mysql	collations	81920	29916	5 page(s)
 293[--]  +-- 13: mysql	events	81920	0	5 page(s)
 294[--]  +-- 14: mysql	foreign_keys	65536	10554	4 page(s)
 295[--]  +-- 15: mysql	column_type_elements	65536	33755	4 page(s)
 296[--]  +-- 16: mysql	global_grants	49152	18680	3 page(s)
 297[--]  +-- 17: mysql	index_partitions	49152	0	3 page(s)
 298[--]  +-- 18: mysql	check_constraints	49152	0	3 page(s)
 299[--]  +-- 19: mysql	help_relation	49152	20946	3 page(s)
 300[--]  +-- 20: mysql	time_zone	49152	19625	3 page(s)
 301[--]  +-- 21: mysql	schemata	49152	472	3 page(s)
 302[--]  +-- 22: mysql	column_statistics	49152	0	3 page(s)
 303[--]  +-- 23: mysql	foreign_key_column_usage	49152	4794	3 page(s)
 304[--]  +-- 24: mysql	character_sets	49152	4296	3 page(s)
 305[--]  +-- 25: mysql	procs_priv	32768	0	2 page(s)
 306[--]  +-- 26: mysql	view_routine_usage	32768	1626	2 page(s)
 307[--]  +-- 27: mysql	proxies_priv	32768	1192	2 page(s)
 308[--]  +-- 28: mysql	view_table_usage	32768	23905	2 page(s)
 309[--]  +-- 29: mysql	tablespace_files	32768	475	2 page(s)
 310[--]  +-- 30: mysql	help_category	32768	7084	2 page(s)
 311[--]  +-- 31: mysql	tables_priv	32768	1774	2 page(s)
 312[--]  +-- 32: mysql	resource_groups	32768	2192	2 page(s)
 313[--]  +-- 33: mysql	catalogs	32768	56	2 page(s)
 314[--]  +-- 34: mysql	tablespaces	32768	975	2 page(s)
 315[--]  +-- 35: mysql	db	32768	1496	2 page(s)
 316[--]  +-- 36: mysql	innodb_index_stats	16384	951	1 page(s)
 317[--]  +-- 37: mysql	slave_master_info	16384	0	1 page(s)
 318[--]  +-- 38: mysql	slave_worker_info	16384	0	1 page(s)
 319[--]  +-- 39: mysql	innodb_table_stats	16384	189	1 page(s)
 320[--]  +-- 40: mysql	table_partition_values	16384	0	1 page(s)
 321
 322-------- Performance schema: Process per time ------------------------------------------------------
 323[--]  +-- 1: innodb/clone_gtid_thread	NULL	1407
 324[--]  +-- 2: innodb/dict_stats_thread	NULL	1407
 325[--]  +-- 3: innodb/srv_worker_thread	NULL	1407
 326[--]  +-- 4: sql/compress_gtid_table	Daemon	1407
 327[--]  +-- 5: innodb/page_flush_coordinator_thread	NULL	1407
 328[--]  +-- 6: innodb/srv_master_thread	NULL	1407
 329[--]  +-- 7: innodb/srv_purge_thread	NULL	1407
 330[--]  +-- 8: sql/main	NULL	1407
 331[--]  +-- 9: innodb/fts_optimize_thread	NULL	1407
 332[--]  +-- 10: innodb/srv_worker_thread	NULL	1407
 333[--]  +-- 11: innodb/srv_worker_thread	NULL	1407
 334[--]  +-- 12: mysqlx/acceptor_network	NULL	1406
 335[--]  +-- 13: [email protected]	Query	0
 336[--]  +-- 14: innodb/buf_dump_thread	NULL	NULL
 337[--]  +-- 15: innodb/buf_resize_thread	NULL	NULL
 338[--]  +-- 16: innodb/io_write_thread	NULL	NULL
 339[--]  +-- 17: innodb/log_write_notifier_thread	NULL	NULL
 340[--]  +-- 18: mysqlx/acceptor_network	NULL	NULL
 341[--]  +-- 19: innodb/io_write_thread	NULL	NULL
 342[--]  +-- 20: innodb/io_write_thread	NULL	NULL
 343[--]  +-- 21: innodb/log_writer_thread	NULL	NULL
 344[--]  +-- 22: innodb/srv_worker_thread	NULL	NULL
 345[--]  +-- 23: innodb/io_ibuf_thread	NULL	NULL
 346[--]  +-- 24: innodb/io_write_thread	NULL	NULL
 347[--]  +-- 25: innodb/srv_lock_timeout_thread	NULL	NULL
 348[--]  +-- 26: mysqlx/worker	NULL	NULL
 349[--]  +-- 27: innodb/io_log_thread	NULL	NULL
 350[--]  +-- 28: innodb/srv_monitor_thread	NULL	NULL
 351[--]  +-- 29: innodb/srv_error_monitor_thread	NULL	NULL
 352[--]  +-- 30: mysqlx/worker	NULL	NULL
 353[--]  +-- 31: innodb/io_read_thread	NULL	NULL
 354[--]  +-- 32: innodb/log_checkpointer_thread	NULL	NULL
 355[--]  +-- 33: innodb/srv_worker_thread	NULL	NULL
 356[--]  +-- 34: innodb/io_read_thread	NULL	NULL
 357[--]  +-- 35: innodb/log_closer_thread	NULL	NULL
 358[--]  +-- 36: innodb/srv_purge_thread	NULL	NULL
 359[--]  +-- 37: sql/event_scheduler	Sleep	NULL
 360[--]  +-- 38: innodb/io_read_thread	NULL	NULL
 361[--]  +-- 39: innodb/log_flush_notifier_thread	NULL	NULL
 362[--]  +-- 40: innodb/srv_worker_thread	NULL	NULL
 363[--]  +-- 41: sql/signal_handler	NULL	NULL
 364[--]  +-- 42: innodb/io_read_thread	NULL	NULL
 365[--]  +-- 43: innodb/log_flusher_thread	NULL	NULL
 366
 367-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
 368[--] No information found or indicators deactivated.
 369
 370-------- Performance schema: Thread IO Latency -----------------------------------------------------
 371[--]  +-- 1: log_flusher_thread	105171298752	12346552818
 372[--]  +-- 2: page_flush_coordinator_thread	25729644576	4666420212
 373[--]  +-- 3: io_write_thread	19404733002	2551872558
 374[--]  +-- 4: main	10870938480	2353891386
 375[--]  +-- 5: log_checkpointer_thread	9120101796	2373966456
 376[--]  +-- 6: io_write_thread	7479784710	2892239934
 377[--]  +-- 7: buf_dump_thread	1703120442	39872586
 378[--]  +-- 8: log_writer_thread	1517317578	57119010
 379[--]  +-- 9: clone_gtid_thread	72625962	23992890
 380
 381-------- Performance schema: Top 15 Most latency statements ----------------------------------------
 382[--]  +-- 1: SHOW VARIABLES	222356550000
 383[--]  +-- 2: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
 384[--]  +-- 3: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	47908832000
 385[--]  +-- 4: SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	44909821000
 386[--]  +-- 5: SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	43674802000
 387[--]  +-- 6: SHOW SLAVE STATUS	39744918000
 388[--]  +-- 7: SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta	38254594000
 389[--]  +-- 8: SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	21709623000
 390[--]  +-- 9: SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	17214886000
 391[--]  +-- 10: SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	11673571000
 392[--]  +-- 11: SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	10819511000
 393[--]  +-- 12: SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	10189354000
 394[--]  +-- 13: ALTER SYSTEM_USER ? @? IDENTIFIED BY ? PASSWORD EXPIRE NEVER	9133951000
 395[--]  +-- 14: SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	7211658000
 396[--]  +-- 15: ALTER SYSTEM_USER ? @? IDENTIFIED WITH `mysql_native_password` BY ?	6803889000
 397
 398-------- Performance schema: Top 15 slower queries -------------------------------------------------
 399[--]  +-- 1: SHOW VARIABLES	1 s
 400[--]  +-- 2: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1 s
 401
 402-------- Performance schema: Top 15 nb statement type ----------------------------------------------
 403[--]  +-- 1: select	127
 404[--]  +-- 2: Quit	70
 405[--]  +-- 3: show_engine_status	6
 406[--]  +-- 4: Init DB	6
 407[--]  +-- 5: alter_user	3
 408[--]  +-- 6: show_table_status	3
 409[--]  +-- 7: show_databases	2
 410[--]  +-- 8: show_variables	2
 411[--]  +-- 9: show_status	2
 412[--]  +-- 10: flush	1
 413[--]  +-- 11: show_slave_status	1
 414[--]  +-- 12: show_slave_hosts	1
 415[--]  +-- 13: show_storage_engines	1
 416[--]  +-- 14: Statistics	1
 417[--]  +-- 15: Ping	1
 418
 419-------- Performance schema: Top 15 statement by total latency -------------------------------------
 420[--]  +-- 1: select	488768450000
 421[--]  +-- 2: show_variables	226693623000
 422[--]  +-- 3: show_table_status	198410624000
 423[--]  +-- 4: show_databases	43419246000
 424[--]  +-- 5: show_slave_status	39744918000
 425[--]  +-- 6: alter_user	25071792000
 426[--]  +-- 7: show_status	5091934000
 427[--]  +-- 8: flush	4420957000
 428[--]  +-- 9: show_engine_status	926904000
 429[--]  +-- 10: Quit	726310000
 430[--]  +-- 11: Init DB	576690000
 431[--]  +-- 12: show_storage_engines	214300000
 432[--]  +-- 13: show_slave_hosts	63682000
 433[--]  +-- 14: Statistics	44348000
 434[--]  +-- 15: Ping	39665000
 435
 436-------- Performance schema: Top 15 statement by lock latency --------------------------------------
 437[--]  +-- 1: select	27807000000
 438[--]  +-- 2: alter_user	2796000000
 439[--]  +-- 3: show_table_status	2281000000
 440[--]  +-- 4: show_status	1881000000
 441[--]  +-- 5: show_variables	1835000000
 442[--]  +-- 6: show_databases	1400000000
 443[--]  +-- 7: flush	288000000
 444[--]  +-- 8: show_storage_engines	116000000
 445[--]  +-- 9: Quit	0
 446[--]  +-- 10: show_engine_status	0
 447[--]  +-- 11: show_slave_status	0
 448[--]  +-- 12: show_slave_hosts	0
 449[--]  +-- 13: Init DB	0
 450[--]  +-- 14: Statistics	0
 451[--]  +-- 15: Ping	0
 452
 453-------- Performance schema: Top 15 statement by full scans ----------------------------------------
 454[--]  +-- 1: select	38
 455[--]  +-- 2: show_databases	2
 456[--]  +-- 3: show_variables	2
 457[--]  +-- 4: show_status	2
 458[--]  +-- 5: show_storage_engines	1
 459[--]  +-- 6: flush	0
 460[--]  +-- 7: alter_user	0
 461[--]  +-- 8: Quit	0
 462[--]  +-- 9: show_engine_status	0
 463[--]  +-- 10: show_slave_status	0
 464[--]  +-- 11: show_table_status	0
 465[--]  +-- 12: show_slave_hosts	0
 466[--]  +-- 13: Init DB	0
 467[--]  +-- 14: Statistics	0
 468[--]  +-- 15: Ping	0
 469
 470-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
 471[--]  +-- 1: show_variables	1132
 472[--]  +-- 2: show_status	931
 473[--]  +-- 3: select	367
 474[--]  +-- 4: show_table_status	237
 475[--]  +-- 5: show_storage_engines	9
 476[--]  +-- 6: show_databases	8
 477[--]  +-- 7: flush	0
 478[--]  +-- 8: alter_user	0
 479[--]  +-- 9: Quit	0
 480[--]  +-- 10: show_engine_status	0
 481[--]  +-- 11: show_slave_status	0
 482[--]  +-- 12: show_slave_hosts	0
 483[--]  +-- 13: Init DB	0
 484[--]  +-- 14: Statistics	0
 485[--]  +-- 15: Ping	0
 486
 487-------- Performance schema: Top 15 statement by rows modified -------------------------------------
 488[--]  +-- 1: select	0
 489[--]  +-- 2: flush	0
 490[--]  +-- 3: alter_user	0
 491[--]  +-- 4: Quit	0
 492[--]  +-- 5: show_databases	0
 493[--]  +-- 6: show_variables	0
 494[--]  +-- 7: show_status	0
 495[--]  +-- 8: show_engine_status	0
 496[--]  +-- 9: show_slave_status	0
 497[--]  +-- 10: show_table_status	0
 498[--]  +-- 11: show_slave_hosts	0
 499[--]  +-- 12: show_storage_engines	0
 500[--]  +-- 13: Init DB	0
 501[--]  +-- 14: Statistics	0
 502[--]  +-- 15: Ping	0
 503
 504-------- Performance schema: 15 sample queries using temp table ------------------------------------
 505[--]  +-- 1: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,
 506[--]  +-- 2: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,
 507[--]  +-- 3: SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema
 508[--]  +-- 4: SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema
 509[--]  +-- 5: SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `
 510[--]  +-- 6: SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform
 511[--]  +-- 7: SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform
 512[--]  +-- 8: SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`
 513[--]  +-- 9: SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform
 514[--]  +-- 10: SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT
 515[--]  +-- 11: SELECT `r` . `trx_wait_started` AS `wait_started` , `timediff` ( NOW ( ) , `r` . `trx_wait_started` ) AS `wait_age` , TI
 516[--]  +-- 12: SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance
 517[--]  +-- 13: SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( (
 518[--]  +-- 14: SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_
 519[--]  +-- 15: SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .
 520
 521-------- Performance schema: Unused indexes --------------------------------------------------------
 522[--] No information found or indicators deactivated.
 523
 524-------- Performance schema: Tables with full table scans ------------------------------------------
 525[--] No information found or indicators deactivated.
 526
 527-------- Performance schema: Latest FILE IO by latency ---------------------------------------------
 528[--] No information found or indicators deactivated.
 529
 530-------- Performance schema: FILE by IO read bytes -------------------------------------------------
 531[--]  +-- 1: /var/lib/mysql/mysql.ibd	6897664
 532[--]  +-- 2: /var/lib/mysql/undo_001	5242880
 533[--]  +-- 3: /var/lib/mysql/undo_002	4603904
 534[--]  +-- 4: /var/lib/mysql/binlog.000001	3109443
 535[--]  +-- 5: /var/lib/mysql/ibdata1	2310144
 536[--]  +-- 6: /usr/share/mysql-8.0/english/errmsg.sys	308724
 537[--]  +-- 7: /var/lib/mysql/ib_logfile0	70656
 538[--]  +-- 8: /usr/share/mysql-8.0/charsets/Index.xml	19495
 539[--]  +-- 9: /var/lib/mysql/auto.cnf	56
 540[--]  +-- 10: /var/lib/mysql/mysql/slow_log.CSM	35
 541[--]  +-- 11: /var/lib/mysql/mysql/general_log.CSM	35
 542[--]  +-- 12: /var/lib/mysql/binlog.index	32
 543[--]  +-- 13: /var/lib/mysql/#innodb_temp/temp_3.ibt	0
 544[--]  +-- 14: /var/lib/mysql/#innodb_temp/temp_4.ibt	0
 545[--]  +-- 15: /var/lib/mysql/#innodb_temp/temp_5.ibt	0
 546
 547-------- Performance schema: FILE by IO written bytes ----------------------------------------------
 548[--]  +-- 1: /var/lib/mysql/ibtmp1	14729216
 549[--]  +-- 2: /var/lib/mysql/ibdata1	1310720
 550[--]  +-- 3: /var/lib/mysql/undo_002	524288
 551[--]  +-- 4: /var/lib/mysql/undo_001	491520
 552[--]  +-- 5: /var/lib/mysql/#innodb_temp/temp_10.ibt	376832
 553[--]  +-- 6: /var/lib/mysql/mysql.ibd	131072
 554[--]  +-- 7: /var/lib/mysql/ib_logfile0	118784
 555[--]  +-- 8: /var/lib/mysql/#innodb_temp/temp_9.ibt	114688
 556[--]  +-- 9: /var/lib/mysql/#innodb_temp/temp_1.ibt	114688
 557[--]  +-- 10: /var/lib/mysql/#innodb_temp/temp_2.ibt	114688
 558[--]  +-- 11: /var/lib/mysql/#innodb_temp/temp_3.ibt	114688
 559[--]  +-- 12: /var/lib/mysql/#innodb_temp/temp_4.ibt	114688
 560[--]  +-- 13: /var/lib/mysql/#innodb_temp/temp_5.ibt	114688
 561[--]  +-- 14: /var/lib/mysql/#innodb_temp/temp_6.ibt	114688
 562[--]  +-- 15: /var/lib/mysql/#innodb_temp/temp_7.ibt	114688
 563
 564-------- Performance schema: file per IO total latency ---------------------------------------------
 565[--]  +-- 1: /var/lib/mysql/ibtmp1	312621423858
 566[--]  +-- 2: /var/lib/mysql/ib_logfile0	128865756078
 567[--]  +-- 3: /var/lib/mysql/ibdata1	33225099564
 568[--]  +-- 4: /var/lib/mysql/#innodb_temp/temp_10.ibt	18065415714
 569[--]  +-- 5: /var/lib/mysql/undo_002	14738626416
 570[--]  +-- 6: /var/lib/mysql/mysql.ibd	13285319604
 571[--]  +-- 7: /var/lib/mysql/binlog.000002	12179822022
 572[--]  +-- 8: /var/lib/mysql/undo_001	11377638858
 573[--]  +-- 9: /var/lib/mysql/#innodb_temp/temp_1.ibt	4943425116
 574[--]  +-- 10: /var/lib/mysql/#innodb_temp/temp_3.ibt	4726685502
 575[--]  +-- 11: /var/lib/mysql/#innodb_temp/temp_5.ibt	4652774976
 576[--]  +-- 12: /var/lib/mysql/#innodb_temp/temp_8.ibt	4497305658
 577[--]  +-- 13: /var/lib/mysql/#innodb_temp/temp_6.ibt	4491348768
 578[--]  +-- 14: /var/lib/mysql/#innodb_temp/temp_7.ibt	4470359874
 579[--]  +-- 15: /var/lib/mysql/#innodb_temp/temp_4.ibt	4380243000
 580[--]  +-- 16: /var/lib/mysql/#innodb_temp/temp_2.ibt	4340530734
 581[--]  +-- 17: /var/lib/mysql/#innodb_temp/temp_9.ibt	4004619252
 582[--]  +-- 18: /usr/share/mysql-8.0/english/errmsg.sys	2443618482
 583[--]  +-- 19: /var/lib/mysql/binlog.000001	1906212816
 584[--]  +-- 20: /var/lib/mysql/binlog.index	701909016
 585
 586-------- Performance schema: file per IO read latency ----------------------------------------------
 587[--]  +-- 1: /var/lib/mysql/mysql.ibd	7948974216
 588[--]  +-- 2: /var/lib/mysql/undo_002	7150204866
 589[--]  +-- 3: /var/lib/mysql/undo_001	5686260822
 590[--]  +-- 4: /var/lib/mysql/ib_logfile0	3286406694
 591[--]  +-- 5: /var/lib/mysql/binlog.000001	1822442610
 592[--]  +-- 6: /var/lib/mysql/ibdata1	1804646088
 593[--]  +-- 7: /usr/share/mysql-8.0/english/errmsg.sys	215202546
 594[--]  +-- 8: /usr/share/mysql-8.0/charsets/Index.xml	14358660
 595[--]  +-- 9: /var/lib/mysql/auto.cnf	12430812
 596[--]  +-- 10: /var/lib/mysql/mysql/general_log.CSM	11148252
 597[--]  +-- 11: /var/lib/mysql/mysql/slow_log.CSM	9656274
 598[--]  +-- 12: /var/lib/mysql/binlog.index	6202380
 599[--]  +-- 13: /var/lib/mysql/#innodb_temp/temp_1.ibt	0
 600[--]  +-- 14: /var/lib/mysql/#innodb_temp/temp_3.ibt	0
 601[--]  +-- 15: /var/lib/mysql/#innodb_temp/temp_4.ibt	0
 602[--]  +-- 16: /var/lib/mysql/#innodb_temp/temp_5.ibt	0
 603[--]  +-- 17: /var/lib/mysql/#innodb_temp/temp_6.ibt	0
 604[--]  +-- 18: /var/lib/mysql/#innodb_temp/temp_7.ibt	0
 605[--]  +-- 19: /var/lib/mysql/#innodb_temp/temp_9.ibt	0
 606[--]  +-- 20: /var/lib/mysql/ibtmp1	0
 607
 608-------- Performance schema: file per IO write latency ---------------------------------------------
 609[--]  +-- 1: /var/lib/mysql/ibtmp1	9132555654
 610[--]  +-- 2: /var/lib/mysql/ib_logfile0	1680851994
 611[--]  +-- 3: /var/lib/mysql/ibdata1	1174978266
 612[--]  +-- 4: /var/lib/mysql/undo_002	671388096
 613[--]  +-- 5: /var/lib/mysql/undo_001	613750050
 614[--]  +-- 6: /var/lib/mysql/#innodb_temp/temp_10.ibt	363565680
 615[--]  +-- 7: /var/lib/mysql/mysql.ibd	190912062
 616[--]  +-- 8: /var/lib/mysql/#innodb_temp/temp_1.ibt	140955348
 617[--]  +-- 9: /var/lib/mysql/binlog.000002	137673798
 618[--]  +-- 10: /var/lib/mysql/#innodb_temp/temp_5.ibt	133612692
 619[--]  +-- 11: /var/lib/mysql/#innodb_temp/temp_2.ibt	123812130
 620[--]  +-- 12: /var/lib/mysql/#innodb_temp/temp_4.ibt	119781084
 621[--]  +-- 13: /var/lib/mysql/#innodb_temp/temp_6.ibt	118945416
 622[--]  +-- 14: /var/lib/mysql/#innodb_temp/temp_3.ibt	113923392
 623[--]  +-- 15: /var/lib/mysql/#innodb_temp/temp_7.ibt	113351250
 624[--]  +-- 16: /var/lib/mysql/#innodb_temp/temp_9.ibt	107924418
 625[--]  +-- 17: /var/lib/mysql/#innodb_temp/temp_8.ibt	107432436
 626[--]  +-- 18: /run/mysqld/mysqld.pid	26353602
 627[--]  +-- 19: /usr/share/mysql-8.0/english/errmsg.sys	0
 628[--]  +-- 20: /var/lib/mysql/mysql/slow_log.CSV	0
 629
 630-------- Performance schema: Event Wait by read bytes ----------------------------------------------
 631[--]  +-- 1: innodb/innodb_data_file	19070976
 632[--]  +-- 2: sql/binlog	3109443
 633[--]  +-- 3: sql/io_cache	1121838
 634[--]  +-- 4: sql/ERRMSG	308724
 635[--]  +-- 5: innodb/innodb_log_file	70656
 636[--]  +-- 6: mysys/charset	19495
 637[--]  +-- 7: csv/metadata	70
 638[--]  +-- 8: sql/binlog_index	64
 639[--]  +-- 9: mysys/cnf	56
 640[--]  +-- 10: sql/casetest	0
 641[--]  +-- 11: sql/misc	0
 642[--]  +-- 12: sql/pid	0
 643[--]  +-- 13: csv/data	0
 644[--]  +-- 14: innodb/innodb_temp_file	0
 645
 646-------- Performance schema: Event Wait written bytes ----------------------------------------------
 647[--]  +-- 1: innodb/innodb_data_file	17186816
 648[--]  +-- 2: innodb/innodb_temp_file	1409024
 649[--]  +-- 3: sql/io_cache	1121838
 650[--]  +-- 4: innodb/innodb_log_file	118784
 651[--]  +-- 5: sql/binlog	1280
 652[--]  +-- 6: sql/pid	2
 653[--]  +-- 7: sql/binlog_index	0
 654[--]  +-- 8: sql/casetest	0
 655[--]  +-- 9: sql/ERRMSG	0
 656[--]  +-- 10: sql/misc	0
 657[--]  +-- 11: mysys/charset	0
 658[--]  +-- 12: mysys/cnf	0
 659[--]  +-- 13: csv/metadata	0
 660[--]  +-- 14: csv/data	0
 661
 662-------- Performance schema: event per wait total latency ------------------------------------------
 663[--]  +-- 1: innodb/innodb_data_file	385306573998
 664[--]  +-- 2: innodb/innodb_log_file	128894712876
 665[--]  +-- 3: innodb/innodb_temp_file	58572708594
 666[--]  +-- 4: sql/binlog	14091306360
 667[--]  +-- 5: sql/io_cache	5819708184
 668[--]  +-- 6: sql/ERRMSG	2443618482
 669[--]  +-- 7: sql/binlog_index	1012155270
 670[--]  +-- 8: csv/data	638847144
 671[--]  +-- 9: csv/metadata	439258764
 672[--]  +-- 10: sql/casetest	234047160
 673[--]  +-- 11: sql/pid	146735886
 674[--]  +-- 12: mysys/cnf	56504784
 675[--]  +-- 13: mysys/charset	51275346
 676[--]  +-- 14: sql/misc	8615196
 677
 678-------- Performance schema: event per wait read latency -------------------------------------------
 679[--]  +-- 1: innodb/innodb_data_file	22606054866
 680[--]  +-- 2: innodb/innodb_log_file	3286406694
 681[--]  +-- 3: sql/binlog	1822442610
 682[--]  +-- 4: sql/io_cache	285116094
 683[--]  +-- 5: sql/ERRMSG	215202546
 684[--]  +-- 6: csv/metadata	20804526
 685[--]  +-- 7: sql/binlog_index	19016958
 686[--]  +-- 8: mysys/charset	14358660
 687[--]  +-- 9: mysys/cnf	12430812
 688[--]  +-- 10: sql/casetest	0
 689[--]  +-- 11: sql/misc	0
 690[--]  +-- 12: sql/pid	0
 691[--]  +-- 13: csv/data	0
 692[--]  +-- 14: innodb/innodb_temp_file	0
 693
 694-------- Performance schema: event per wait write latency ------------------------------------------
 695[--]  +-- 1: innodb/innodb_data_file	11783584128
 696[--]  +-- 2: sql/io_cache	4119678912
 697[--]  +-- 3: innodb/innodb_log_file	1680851994
 698[--]  +-- 4: innodb/innodb_temp_file	1443303846
 699[--]  +-- 5: sql/binlog	137673798
 700[--]  +-- 6: sql/pid	26353602
 701[--]  +-- 7: sql/binlog_index	0
 702[--]  +-- 8: sql/casetest	0
 703[--]  +-- 9: sql/ERRMSG	0
 704[--]  +-- 10: sql/misc	0
 705[--]  +-- 11: mysys/charset	0
 706[--]  +-- 12: mysys/cnf	0
 707[--]  +-- 13: csv/metadata	0
 708[--]  +-- 14: csv/data	0
 709
 710-------- Performance schema: TOP 15 most read indexes ----------------------------------------------
 711[--]  +-- 1: mysql	schemata	PRIMARY	0
 712[--]  +-- 2: mysql	schemata	catalog_id	0
 713[--]  +-- 3: mysql	schemata	default_collation_id	0
 714[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 715[--]  +-- 5: mysql	tablespace_files	file_name	0
 716[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 717[--]  +-- 7: mysql	tablespaces	name	0
 718[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 719[--]  +-- 9: mysql	check_constraints	schema_id	0
 720[--]  +-- 10: mysql	check_constraints	table_id	0
 721[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 722[--]  +-- 12: mysql	columns	PRIMARY	0
 723[--]  +-- 13: mysql	columns	table_id	0
 724[--]  +-- 14: mysql	columns	table_id_2	0
 725[--]  +-- 15: mysql	columns	collation_id	0
 726
 727-------- Performance schema: TOP 15 most modified indexes ------------------------------------------
 728[--]  +-- 1: mysql	schemata	PRIMARY	0
 729[--]  +-- 2: mysql	schemata	catalog_id	0
 730[--]  +-- 3: mysql	schemata	default_collation_id	0
 731[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 732[--]  +-- 5: mysql	tablespace_files	file_name	0
 733[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 734[--]  +-- 7: mysql	tablespaces	name	0
 735[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 736[--]  +-- 9: mysql	check_constraints	schema_id	0
 737[--]  +-- 10: mysql	check_constraints	table_id	0
 738[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 739[--]  +-- 12: mysql	columns	PRIMARY	0
 740[--]  +-- 13: mysql	columns	table_id	0
 741[--]  +-- 14: mysql	columns	table_id_2	0
 742[--]  +-- 15: mysql	columns	collation_id	0
 743
 744-------- Performance schema: TOP 15 high read latency index ----------------------------------------
 745[--]  +-- 1: mysql	schemata	PRIMARY	0
 746[--]  +-- 2: mysql	schemata	catalog_id	0
 747[--]  +-- 3: mysql	schemata	default_collation_id	0
 748[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 749[--]  +-- 5: mysql	tablespace_files	file_name	0
 750[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 751[--]  +-- 7: mysql	tablespaces	name	0
 752[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 753[--]  +-- 9: mysql	check_constraints	schema_id	0
 754[--]  +-- 10: mysql	check_constraints	table_id	0
 755[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 756[--]  +-- 12: mysql	columns	PRIMARY	0
 757[--]  +-- 13: mysql	columns	table_id	0
 758[--]  +-- 14: mysql	columns	table_id_2	0
 759[--]  +-- 15: mysql	columns	collation_id	0
 760
 761-------- Performance schema: TOP 15 most modified indexes ------------------------------------------
 762[--]  +-- 1: mysql	schemata	PRIMARY	0
 763[--]  +-- 2: mysql	schemata	catalog_id	0
 764[--]  +-- 3: mysql	schemata	default_collation_id	0
 765[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 766[--]  +-- 5: mysql	tablespace_files	file_name	0
 767[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 768[--]  +-- 7: mysql	tablespaces	name	0
 769[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 770[--]  +-- 9: mysql	check_constraints	schema_id	0
 771[--]  +-- 10: mysql	check_constraints	table_id	0
 772[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 773[--]  +-- 12: mysql	columns	PRIMARY	0
 774[--]  +-- 13: mysql	columns	table_id	0
 775[--]  +-- 14: mysql	columns	table_id_2	0
 776[--]  +-- 15: mysql	columns	collation_id	0
 777
 778-------- Performance schema: TOP 15 high update latency index --------------------------------------
 779[--]  +-- 1: mysql	schemata	PRIMARY	0
 780[--]  +-- 2: mysql	schemata	catalog_id	0
 781[--]  +-- 3: mysql	schemata	default_collation_id	0
 782[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 783[--]  +-- 5: mysql	tablespace_files	file_name	0
 784[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 785[--]  +-- 7: mysql	tablespaces	name	0
 786[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 787[--]  +-- 9: mysql	check_constraints	schema_id	0
 788[--]  +-- 10: mysql	check_constraints	table_id	0
 789[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 790[--]  +-- 12: mysql	columns	PRIMARY	0
 791[--]  +-- 13: mysql	columns	table_id	0
 792[--]  +-- 14: mysql	columns	table_id_2	0
 793[--]  +-- 15: mysql	columns	collation_id	0
 794
 795-------- Performance schema: TOP 15 high delete latency index --------------------------------------
 796[--]  +-- 1: mysql	schemata	PRIMARY	0
 797[--]  +-- 2: mysql	schemata	catalog_id	0
 798[--]  +-- 3: mysql	schemata	default_collation_id	0
 799[--]  +-- 4: mysql	tablespace_files	tablespace_id	0
 800[--]  +-- 5: mysql	tablespace_files	file_name	0
 801[--]  +-- 6: mysql	tablespaces	PRIMARY	0
 802[--]  +-- 7: mysql	tablespaces	name	0
 803[--]  +-- 8: mysql	check_constraints	PRIMARY	0
 804[--]  +-- 9: mysql	check_constraints	schema_id	0
 805[--]  +-- 10: mysql	check_constraints	table_id	0
 806[--]  +-- 11: mysql	column_type_elements	PRIMARY	0
 807[--]  +-- 12: mysql	columns	PRIMARY	0
 808[--]  +-- 13: mysql	columns	table_id	0
 809[--]  +-- 14: mysql	columns	table_id_2	0
 810[--]  +-- 15: mysql	columns	collation_id	0
 811
 812-------- Performance schema: TOP 15 most read tables -----------------------------------------------
 813[--]  +-- 1: mysql	dd_properties	0
 814[--]  +-- 2: mysql	schemata	0
 815[--]  +-- 3: mysql	tablespace_files	0
 816[--]  +-- 4: mysql	tablespaces	0
 817[--]  +-- 5: mysql	check_constraints	0
 818[--]  +-- 6: mysql	column_type_elements	0
 819[--]  +-- 7: mysql	columns	0
 820[--]  +-- 8: mysql	foreign_key_column_usage	0
 821[--]  +-- 9: mysql	foreign_keys	0
 822[--]  +-- 10: mysql	index_column_usage	0
 823[--]  +-- 11: mysql	index_partitions	0
 824[--]  +-- 12: mysql	indexes	0
 825[--]  +-- 13: mysql	table_partition_values	0
 826[--]  +-- 14: mysql	table_partitions	0
 827[--]  +-- 15: mysql	tables	0
 828
 829-------- Performance schema: TOP 15 most modified tables -------------------------------------------
 830[--]  +-- 1: mysql	dd_properties	0
 831[--]  +-- 2: mysql	schemata	0
 832[--]  +-- 3: mysql	tablespace_files	0
 833[--]  +-- 4: mysql	tablespaces	0
 834[--]  +-- 5: mysql	check_constraints	0
 835[--]  +-- 6: mysql	column_type_elements	0
 836[--]  +-- 7: mysql	columns	0
 837[--]  +-- 8: mysql	foreign_key_column_usage	0
 838[--]  +-- 9: mysql	foreign_keys	0
 839[--]  +-- 10: mysql	index_column_usage	0
 840[--]  +-- 11: mysql	index_partitions	0
 841[--]  +-- 12: mysql	indexes	0
 842[--]  +-- 13: mysql	table_partition_values	0
 843[--]  +-- 14: mysql	table_partitions	0
 844[--]  +-- 15: mysql	tables	0
 845
 846-------- Performance schema: TOP 15 high read latency tables ---------------------------------------
 847[--]  +-- 1: mysql	dd_properties	0
 848[--]  +-- 2: mysql	schemata	0
 849[--]  +-- 3: mysql	tablespace_files	0
 850[--]  +-- 4: mysql	tablespaces	0
 851[--]  +-- 5: mysql	check_constraints	0
 852[--]  +-- 6: mysql	column_type_elements	0
 853[--]  +-- 7: mysql	columns	0
 854[--]  +-- 8: mysql	foreign_key_column_usage	0
 855[--]  +-- 9: mysql	foreign_keys	0
 856[--]  +-- 10: mysql	index_column_usage	0
 857[--]  +-- 11: mysql	index_partitions	0
 858[--]  +-- 12: mysql	indexes	0
 859[--]  +-- 13: mysql	table_partition_values	0
 860[--]  +-- 14: mysql	table_partitions	0
 861[--]  +-- 15: mysql	tables	0
 862
 863-------- Performance schema: TOP 15 high insert latency tables -------------------------------------
 864[--]  +-- 1: mysql	dd_properties	0
 865[--]  +-- 2: mysql	schemata	0
 866[--]  +-- 3: mysql	tablespace_files	0
 867[--]  +-- 4: mysql	tablespaces	0
 868[--]  +-- 5: mysql	check_constraints	0
 869[--]  +-- 6: mysql	column_type_elements	0
 870[--]  +-- 7: mysql	columns	0
 871[--]  +-- 8: mysql	foreign_key_column_usage	0
 872[--]  +-- 9: mysql	foreign_keys	0
 873[--]  +-- 10: mysql	index_column_usage	0
 874[--]  +-- 11: mysql	index_partitions	0
 875[--]  +-- 12: mysql	indexes	0
 876[--]  +-- 13: mysql	table_partition_values	0
 877[--]  +-- 14: mysql	table_partitions	0
 878[--]  +-- 15: mysql	tables	0
 879
 880-------- Performance schema: TOP 15 high update latency tables -------------------------------------
 881[--]  +-- 1: mysql	dd_properties	0
 882[--]  +-- 2: mysql	schemata	0
 883[--]  +-- 3: mysql	tablespace_files	0
 884[--]  +-- 4: mysql	tablespaces	0
 885[--]  +-- 5: mysql	check_constraints	0
 886[--]  +-- 6: mysql	column_type_elements	0
 887[--]  +-- 7: mysql	columns	0
 888[--]  +-- 8: mysql	foreign_key_column_usage	0
 889[--]  +-- 9: mysql	foreign_keys	0
 890[--]  +-- 10: mysql	index_column_usage	0
 891[--]  +-- 11: mysql	index_partitions	0
 892[--]  +-- 12: mysql	indexes	0
 893[--]  +-- 13: mysql	table_partition_values	0
 894[--]  +-- 14: mysql	table_partitions	0
 895[--]  +-- 15: mysql	tables	0
 896
 897-------- Performance schema: TOP 15 high delete latency tables -------------------------------------
 898[--]  +-- 1: mysql	dd_properties	0
 899[--]  +-- 2: mysql	schemata	0
 900[--]  +-- 3: mysql	tablespace_files	0
 901[--]  +-- 4: mysql	tablespaces	0
 902[--]  +-- 5: mysql	check_constraints	0
 903[--]  +-- 6: mysql	column_type_elements	0
 904[--]  +-- 7: mysql	columns	0
 905[--]  +-- 8: mysql	foreign_key_column_usage	0
 906[--]  +-- 9: mysql	foreign_keys	0
 907[--]  +-- 10: mysql	index_column_usage	0
 908[--]  +-- 11: mysql	index_partitions	0
 909[--]  +-- 12: mysql	indexes	0
 910[--]  +-- 13: mysql	table_partition_values	0
 911[--]  +-- 14: mysql	table_partitions	0
 912[--]  +-- 15: mysql	tables	0
 913
 914-------- Performance schema: Redundant indexes -----------------------------------------------------
 915[--] No information found or indicators deactivated.
 916
 917-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
 918[--]  +-- 1: performance_schema	session_variables
 919[--]  +-- 2: performance_schema	global_variables
 920[--]  +-- 3: performance_schema	session_status
 921[--]  +-- 4: performance_schema	global_status
 922[--]  +-- 5: mysql	general_log
 923[--]  +-- 6: mysql	slow_log
 924[--]  +-- 7: performance_schema	accounts
 925[--]  +-- 8: performance_schema	cond_instances
 926[--]  +-- 9: performance_schema	data_lock_waits
 927[--]  +-- 10: performance_schema	data_locks
 928[--]  +-- 11: performance_schema	events_errors_summary_by_account_by_error
 929[--]  +-- 12: performance_schema	events_errors_summary_by_host_by_error
 930[--]  +-- 13: performance_schema	events_errors_summary_by_thread_by_error
 931[--]  +-- 14: performance_schema	events_errors_summary_by_user_by_error
 932[--]  +-- 15: performance_schema	events_errors_summary_global_by_error
 933[--]  +-- 16: performance_schema	events_stages_current
 934[--]  +-- 17: performance_schema	events_stages_history
 935[--]  +-- 18: performance_schema	events_stages_history_long
 936[--]  +-- 19: performance_schema	events_stages_summary_by_account_by_event_name
 937[--]  +-- 20: performance_schema	events_stages_summary_by_host_by_event_name
 938[--]  +-- 21: performance_schema	events_stages_summary_by_thread_by_event_name
 939[--]  +-- 22: performance_schema	events_stages_summary_by_user_by_event_name
 940[--]  +-- 23: performance_schema	events_stages_summary_global_by_event_name
 941[--]  +-- 24: performance_schema	events_statements_current
 942[--]  +-- 25: performance_schema	events_statements_histogram_by_digest
 943[--]  +-- 26: performance_schema	events_statements_histogram_global
 944[--]  +-- 27: performance_schema	events_statements_history
 945[--]  +-- 28: performance_schema	events_statements_history_long
 946[--]  +-- 29: performance_schema	events_statements_summary_by_account_by_event_name
 947[--]  +-- 30: performance_schema	events_statements_summary_by_digest
 948[--]  +-- 31: performance_schema	events_statements_summary_by_host_by_event_name
 949[--]  +-- 32: performance_schema	events_statements_summary_by_program
 950[--]  +-- 33: performance_schema	events_statements_summary_by_thread_by_event_name
 951[--]  +-- 34: performance_schema	events_statements_summary_by_user_by_event_name
 952[--]  +-- 35: performance_schema	events_statements_summary_global_by_event_name
 953[--]  +-- 36: performance_schema	events_transactions_current
 954[--]  +-- 37: performance_schema	events_transactions_history
 955[--]  +-- 38: performance_schema	events_transactions_history_long
 956[--]  +-- 39: performance_schema	events_transactions_summary_by_account_by_event_name
 957[--]  +-- 40: performance_schema	events_transactions_summary_by_host_by_event_name
 958[--]  +-- 41: performance_schema	events_transactions_summary_by_thread_by_event_name
 959[--]  +-- 42: performance_schema	events_transactions_summary_by_user_by_event_name
 960[--]  +-- 43: performance_schema	events_transactions_summary_global_by_event_name
 961[--]  +-- 44: performance_schema	events_waits_current
 962[--]  +-- 45: performance_schema	events_waits_history
 963[--]  +-- 46: performance_schema	events_waits_history_long
 964[--]  +-- 47: performance_schema	events_waits_summary_by_account_by_event_name
 965[--]  +-- 48: performance_schema	events_waits_summary_by_host_by_event_name
 966[--]  +-- 49: performance_schema	events_waits_summary_by_instance
 967[--]  +-- 50: performance_schema	events_waits_summary_by_thread_by_event_name
 968[--]  +-- 51: performance_schema	events_waits_summary_by_user_by_event_name
 969[--]  +-- 52: performance_schema	events_waits_summary_global_by_event_name
 970[--]  +-- 53: performance_schema	file_instances
 971[--]  +-- 54: performance_schema	file_summary_by_event_name
 972[--]  +-- 55: performance_schema	file_summary_by_instance
 973[--]  +-- 56: performance_schema	host_cache
 974[--]  +-- 57: performance_schema	hosts
 975[--]  +-- 58: performance_schema	keyring_keys
 976[--]  +-- 59: performance_schema	log_status
 977[--]  +-- 60: performance_schema	memory_summary_by_account_by_event_name
 978[--]  +-- 61: performance_schema	memory_summary_by_host_by_event_name
 979[--]  +-- 62: performance_schema	memory_summary_by_thread_by_event_name
 980[--]  +-- 63: performance_schema	memory_summary_by_user_by_event_name
 981[--]  +-- 64: performance_schema	memory_summary_global_by_event_name
 982[--]  +-- 65: performance_schema	metadata_locks
 983[--]  +-- 66: performance_schema	mutex_instances
 984[--]  +-- 67: performance_schema	objects_summary_global_by_type
 985[--]  +-- 68: performance_schema	performance_timers
 986[--]  +-- 69: performance_schema	persisted_variables
 987[--]  +-- 70: performance_schema	prepared_statements_instances
 988[--]  +-- 71: performance_schema	replication_applier_configuration
 989[--]  +-- 72: performance_schema	replication_applier_filters
 990[--]  +-- 73: performance_schema	replication_applier_global_filters
 991[--]  +-- 74: performance_schema	replication_applier_status
 992[--]  +-- 75: performance_schema	replication_applier_status_by_coordinator
 993[--]  +-- 76: performance_schema	replication_applier_status_by_worker
 994[--]  +-- 77: performance_schema	replication_connection_configuration
 995[--]  +-- 78: performance_schema	replication_connection_status
 996[--]  +-- 79: performance_schema	replication_group_member_stats
 997[--]  +-- 80: performance_schema	replication_group_members
 998[--]  +-- 81: performance_schema	rwlock_instances
 999[--]  +-- 82: performance_schema	session_account_connect_attrs
1000[--]  +-- 83: performance_schema	session_connect_attrs
1001[--]  +-- 84: performance_schema	setup_actors
1002[--]  +-- 85: performance_schema	setup_consumers
1003[--]  +-- 86: performance_schema	setup_instruments
1004[--]  +-- 87: performance_schema	setup_objects
1005[--]  +-- 88: performance_schema	setup_threads
1006[--]  +-- 89: performance_schema	socket_instances
1007[--]  +-- 90: performance_schema	socket_summary_by_event_name
1008[--]  +-- 91: performance_schema	socket_summary_by_instance
1009[--]  +-- 92: performance_schema	status_by_account
1010[--]  +-- 93: performance_schema	status_by_host
1011[--]  +-- 94: performance_schema	status_by_thread
1012[--]  +-- 95: performance_schema	status_by_user
1013[--]  +-- 96: performance_schema	table_handles
1014[--]  +-- 97: performance_schema	table_io_waits_summary_by_index_usage
1015[--]  +-- 98: performance_schema	table_io_waits_summary_by_table
1016[--]  +-- 99: performance_schema	table_lock_waits_summary_by_table
1017[--]  +-- 100: performance_schema	threads
1018[--]  +-- 101: performance_schema	user_defined_functions
1019[--]  +-- 102: performance_schema	user_variables_by_thread
1020[--]  +-- 103: performance_schema	users
1021[--]  +-- 104: performance_schema	variables_by_thread
1022[--]  +-- 105: performance_schema	variables_info
1023
1024-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
1025[--]  +-- 1: mysql	columns	1425408
1026[--]  +-- 2: mysql	time_zone_transition	1097728
1027[--]  +-- 3: mysql	tables	704512
1028[--]  +-- 4: mysql	routines	229376
1029[--]  +-- 5: mysql	index_column_usage	212992
1030[--]  +-- 6: mysql	time_zone_transition_type	212992
1031[--]  +-- 7: mysql	time_zone_name	131072
1032[--]  +-- 8: mysql	table_partitions	114688
1033[--]  +-- 9: mysql	indexes	98304
1034[--]  +-- 10: mysql	triggers	98304
1035[--]  +-- 11: mysql	events	81920
1036[--]  +-- 12: mysql	collations	81920
1037[--]  +-- 13: mysql	foreign_keys	65536
1038[--]  +-- 14: mysql	column_type_elements	65536
1039[--]  +-- 15: mysql	time_zone	49152
1040
1041-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
1042[--]  +-- 1: mysql	columns	364103
1043[--]  +-- 2: mysql	tables	185443
1044[--]  +-- 3: mysql	routines	131535
1045[--]  +-- 4: mysql	table_partitions	114688
1046[--]  +-- 5: mysql	time_zone_transition	113720
1047[--]  +-- 6: mysql	index_column_usage	107611
1048[--]  +-- 7: mysql	triggers	97228
1049[--]  +-- 8: mysql	time_zone_name	84374
1050[--]  +-- 9: mysql	events	81920
1051[--]  +-- 10: mysql	indexes	55692
1052[--]  +-- 11: mysql	foreign_keys	54982
1053[--]  +-- 12: mysql	collations	52004
1054[--]  +-- 13: mysql	check_constraints	49152
1055[--]  +-- 14: mysql	index_partitions	49152
1056[--]  +-- 15: mysql	column_statistics	49152
1057
1058-------- Performance schema: Top 15 Most executed queries ------------------------------------------
1059[--]  +-- 1: NULL	SELECT @@`version_comment` LIMIT ?	106
1060[--]  +-- 2: NULL	SELECT SCHEMA ( )	31
1061[--]  +-- 3: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	13
1062[--]  +-- 4: NULL	SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS	6
1063[--]  +-- 5: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	6
1064[--]  +-- 6: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	6
1065[--]  +-- 7: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	6
1066[--]  +-- 8: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	6
1067[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	5
1068[--]  +-- 10: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	4
1069[--]  +-- 11: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	4
1070[--]  +-- 12: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1071[--]  +-- 13: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	3
1072[--]  +-- 14: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	3
1073[--]  +-- 15: NULL	ALTER SYSTEM_USER ? @? IDENTIFIED BY ? PASSWORD EXPIRE NEVER	2
1074
1075-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
1076[--]  +-- 1: SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2020-04-10 12:59:35.536306
1077
1078-------- Performance schema: Top 20 queries with full table scans ----------------------------------
1079[--]  +-- 1: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	6
1080[--]  +-- 2: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	6
1081[--]  +-- 3: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	6
1082[--]  +-- 4: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	6
1083[--]  +-- 5: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	5
1084[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	4
1085[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	4
1086[--]  +-- 8: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1087[--]  +-- 9: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	3
1088[--]  +-- 10: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	3
1089[--]  +-- 11: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	2
1090[--]  +-- 12: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2
1091[--]  +-- 13: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2
1092[--]  +-- 14: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2
1093[--]  +-- 15: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2
1094[--]  +-- 16: sys	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2
1095[--]  +-- 17: NULL	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2
1096[--]  +-- 18: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
1097[--]  +-- 19: NULL	SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta	1
1098[--]  +-- 20: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	1
1099
1100-------- Performance schema: Last 50 queries with full table scans ---------------------------------
1101[--]  +-- 1: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.087962
1102[--]  +-- 2: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.074366
1103[--]  +-- 3: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.060871
1104[--]  +-- 4: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:36.046946
1105[--]  +-- 5: sys	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2020-04-10 12:59:35.869837
1106[--]  +-- 6: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	2020-04-10 12:59:35.853263
1107[--]  +-- 7: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	2020-04-10 12:59:35.767327
1108[--]  +-- 8: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2020-04-10 12:59:35.686522
1109[--]  +-- 9: NULL	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2020-04-10 12:59:35.648891
1110[--]  +-- 10: sys	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.624241
1111[--]  +-- 11: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.599982
1112[--]  +-- 12: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.587863
1113[--]  +-- 13: sys	SELECT IF ( ( `processlist` . `ID` IS NULL ) , `concat` ( `substring_index` ( `performance_schema` . `threads` . `NAME` 	2020-04-10 12:59:35.563139
1114[--]  +-- 14: NULL	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `object_schema` , `performanc	2020-04-10 12:59:35.549989
1115[--]  +-- 15: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2020-04-10 12:59:35.536306
1116[--]  +-- 16: sys	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:35.521319
1117[--]  +-- 17: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:35.507220
1118[--]  +-- 18: NULL	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	2020-04-10 12:59:35.425736
1119[--]  +-- 19: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	2020-04-10 12:59:35.388462
1120[--]  +-- 20: NULL	SELECT `r` . `trx_wait_started` AS `wait_started` , `timediff` ( NOW ( ) , `r` . `trx_wait_started` ) AS `wait_age` , TI	2020-04-10 12:59:35.366913
1121[--]  +-- 21: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	2020-04-10 12:59:35.349687
1122[--]  +-- 22: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:35.231710
1123[--]  +-- 23: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:35.122798
1124[--]  +-- 24: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	2020-04-10 12:59:35.100777
1125[--]  +-- 25: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.059044
1126[--]  +-- 26: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.043838
1127[--]  +-- 27: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:34.969804
1128[--]  +-- 28: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:34.841183
1129[--]  +-- 29: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	2020-04-10 12:59:34.804669
1130[--]  +-- 30: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	2020-04-10 12:59:34.679678
1131[--]  +-- 31: NULL	SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta	2020-04-10 12:59:34.112163
1132[--]  +-- 32: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2020-04-10 12:59:33.634198
1133
1134-------- Performance schema: TOP 15 reader queries (95% percentile) --------------------------------
1135[--]  +-- 1: NULL	SHOW VARIABLES	577
1136[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	175
1137[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1
1138
1139-------- Performance schema: TOP 15 most row look queries (95% percentile) -------------------------
1140[--]  +-- 1: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	28437
1141[--]  +-- 2: NULL	SHOW VARIABLES	577
1142[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2
1143
1144-------- Performance schema: TOP 15 total latency queries (95% percentile) -------------------------
1145[--]  +-- 1: NULL	SHOW VARIABLES	222356550000
1146[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	186945177000
1147[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
1148
1149-------- Performance schema: TOP 15 max latency queries (95% percentile) ---------------------------
1150[--]  +-- 1: NULL	SHOW VARIABLES	222356550000
1151[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
1152[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	57497769000
1153
1154-------- Performance schema: TOP 15 average latency queries (95% percentile) -----------------------
1155[--]  +-- 1: NULL	SHOW VARIABLES	222356550000
1156[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
1157[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	46736294000
1158
1159-------- Performance schema: Top 20 queries with sort ----------------------------------------------
1160[--]  +-- 1: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	13
1161[--]  +-- 2: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	6
1162[--]  +-- 3: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	6
1163[--]  +-- 4: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	6
1164[--]  +-- 5: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	6
1165[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	5
1166[--]  +-- 7: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	5
1167[--]  +-- 8: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	4
1168[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	4
1169[--]  +-- 10: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1170[--]  +-- 11: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	3
1171[--]  +-- 12: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	3
1172[--]  +-- 13: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	2
1173[--]  +-- 14: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2
1174[--]  +-- 15: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2
1175[--]  +-- 16: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2
1176[--]  +-- 17: sys	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2
1177[--]  +-- 18: NULL	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2
1178[--]  +-- 19: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2
1179[--]  +-- 20: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
1180
1181-------- Performance schema: Last 50 queries with sort ---------------------------------------------
1182[--]  +-- 1: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.214912
1183[--]  +-- 2: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	2020-04-10 12:59:36.200801
1184[--]  +-- 3: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.102283
1185[--]  +-- 4: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.074366
1186[--]  +-- 5: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:36.060871
1187[--]  +-- 6: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:36.046946
1188[--]  +-- 7: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	2020-04-10 12:59:35.853263
1189[--]  +-- 8: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	2020-04-10 12:59:35.767327
1190[--]  +-- 9: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2020-04-10 12:59:35.686522
1191[--]  +-- 10: NULL	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	2020-04-10 12:59:35.648891
1192[--]  +-- 11: sys	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.624241
1193[--]  +-- 12: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.599982
1194[--]  +-- 13: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	2020-04-10 12:59:35.587863
1195[--]  +-- 14: sys	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	2020-04-10 12:59:35.521319
1196[--]  +-- 15: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:35.507220
1197[--]  +-- 16: NULL	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	2020-04-10 12:59:35.425736
1198[--]  +-- 17: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	2020-04-10 12:59:35.388462
1199[--]  +-- 18: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	2020-04-10 12:59:35.349687
1200[--]  +-- 19: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:35.231710
1201[--]  +-- 20: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:35.122798
1202[--]  +-- 21: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	2020-04-10 12:59:35.100777
1203[--]  +-- 22: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.059044
1204[--]  +-- 23: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.043838
1205[--]  +-- 24: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:34.969804
1206[--]  +-- 25: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:34.841183
1207[--]  +-- 26: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	2020-04-10 12:59:34.804669
1208[--]  +-- 27: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	2020-04-10 12:59:34.679678
1209[--]  +-- 28: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	2020-04-10 12:59:34.654600
1210[--]  +-- 29: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2020-04-10 12:59:33.634198
1211
1212-------- Performance schema: TOP 15 row sorting queries with sort ----------------------------------
1213[--]  +-- 1: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2306
1214[--]  +-- 2: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	1044
1215[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	364
1216[--]  +-- 4: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	238
1217[--]  +-- 5: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	129
1218[--]  +-- 6: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	90
1219[--]  +-- 7: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	90
1220[--]  +-- 8: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	78
1221[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	65
1222[--]  +-- 10: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	52
1223[--]  +-- 11: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	49
1224[--]  +-- 12: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	42
1225[--]  +-- 13: sys	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	40
1226[--]  +-- 14: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	30
1227[--]  +-- 15: NULL	SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_	30
1228
1229-------- Performance schema: TOP 15 total latency queries with sort --------------------------------
1230[--]  +-- 1: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	223793529000
1231[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	186945177000
1232[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
1233[--]  +-- 4: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	64917071000
1234[--]  +-- 5: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	44909821000
1235[--]  +-- 6: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	43674802000
1236[--]  +-- 7: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	43419246000
1237[--]  +-- 8: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	37151265000
1238[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	36058292000
1239[--]  +-- 10: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	16553200000
1240[--]  +-- 11: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	12531199000
1241[--]  +-- 12: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	11690103000
1242[--]  +-- 13: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	10189354000
1243[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	8889783000
1244[--]  +-- 15: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	8843444000
1245
1246-------- Performance schema: TOP 15 merge queries with sort ----------------------------------------
1247[--]  +-- 1: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1248[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1
1249[--]  +-- 3: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
1250[--]  +-- 4: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	0
1251[--]  +-- 5: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	0
1252[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	0
1253[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	0
1254[--]  +-- 8: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	0
1255[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	0
1256[--]  +-- 10: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1257[--]  +-- 11: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1258[--]  +-- 12: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	0
1259[--]  +-- 13: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	0
1260[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	0
1261[--]  +-- 15: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	0
1262
1263-------- Performance schema: TOP 15 average sort merges queries with sort --------------------------
1264[--]  +-- 1: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1
1265[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1
1266[--]  +-- 3: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
1267[--]  +-- 4: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	0
1268[--]  +-- 5: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	0
1269[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	0
1270[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	0
1271[--]  +-- 8: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	0
1272[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	0
1273[--]  +-- 10: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1274[--]  +-- 11: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1275[--]  +-- 12: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	0
1276[--]  +-- 13: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	0
1277[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	0
1278[--]  +-- 15: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	0
1279
1280-------- Performance schema: TOP 15 scans queries with sort ----------------------------------------
1281[--]  +-- 1: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	30
1282[--]  +-- 2: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	30
1283[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	14
1284[--]  +-- 4: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	12
1285[--]  +-- 5: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	10
1286[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	8
1287[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	8
1288[--]  +-- 8: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	6
1289[--]  +-- 9: sys	SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance	6
1290[--]  +-- 10: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	4
1291[--]  +-- 11: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	3
1292[--]  +-- 12: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	3
1293[--]  +-- 13: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	3
1294[--]  +-- 14: sys	SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na	3
1295[--]  +-- 15: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	3
1296
1297-------- Performance schema: TOP 15 range queries with sort ----------------------------------------
1298[--]  +-- 1: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
1299[--]  +-- 2: NULL	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . `name` AS `SCHEMA_NAME` , `cs` . `name` AS `DEFAULT_CHARACTER_SET_NAME	0
1300[--]  +-- 3: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	0
1301[--]  +-- 4: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	0
1302[--]  +-- 5: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	0
1303[--]  +-- 6: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	0
1304[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	0
1305[--]  +-- 8: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1306[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	0
1307[--]  +-- 10: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	0
1308[--]  +-- 11: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	0
1309[--]  +-- 12: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	0
1310[--]  +-- 13: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	0
1311[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	0
1312[--]  +-- 15: NULL	SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` . 	0
1313
1314-------- Performance schema: Top 20 queries with temp table ----------------------------------------
1315[--]  +-- 1: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	13
1316[--]  +-- 2: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	6
1317[--]  +-- 3: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	6
1318[--]  +-- 4: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	6
1319[--]  +-- 5: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	5
1320[--]  +-- 6: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	5
1321[--]  +-- 7: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	4
1322[--]  +-- 8: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	4
1323[--]  +-- 9: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1324[--]  +-- 10: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	3
1325[--]  +-- 11: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2
1326[--]  +-- 12: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2
1327[--]  +-- 13: NULL	SHOW VARIABLES	1
1328[--]  +-- 14: NULL	SHOW GLOBAL VARIABLES	1
1329[--]  +-- 15: NULL	SHOW STATUS	1
1330[--]  +-- 16: NULL	SHOW GLOBAL STATUS	1
1331[--]  +-- 17: NULL	SHOW ENGINES	1
1332[--]  +-- 18: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
1333[--]  +-- 19: NULL	SELECT ? AS `sys_version` , `version` ( ) AS `mysql_version`	1
1334[--]  +-- 20: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	1
1335
1336-------- Performance schema: Last 50 queries with temp table ---------------------------------------
1337[--]  +-- 1: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	2020-04-10 12:59:36.200801
1338[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:36.046946
1339[--]  +-- 3: sys	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2020-04-10 12:59:35.869837
1340[--]  +-- 4: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	2020-04-10 12:59:35.853263
1341[--]  +-- 5: sys	SELECT IF ( ( `processlist` . `ID` IS NULL ) , `concat` ( `substring_index` ( `performance_schema` . `threads` . `NAME` 	2020-04-10 12:59:35.563139
1342[--]  +-- 6: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	2020-04-10 12:59:35.536306
1343[--]  +-- 7: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:35.507220
1344[--]  +-- 8: NULL	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	2020-04-10 12:59:35.425736
1345[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	2020-04-10 12:59:35.388462
1346[--]  +-- 10: NULL	SELECT `r` . `trx_wait_started` AS `wait_started` , `timediff` ( NOW ( ) , `r` . `trx_wait_started` ) AS `wait_age` , TI	2020-04-10 12:59:35.366913
1347[--]  +-- 11: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	2020-04-10 12:59:35.349687
1348[--]  +-- 12: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	2020-04-10 12:59:35.231710
1349[--]  +-- 13: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:35.122798
1350[--]  +-- 14: sys	SELECT IF ( ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance	2020-04-10 12:59:35.100777
1351[--]  +-- 15: sys	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.059044
1352[--]  +-- 16: NULL	SELECT IF ( ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_	2020-04-10 12:59:35.043838
1353[--]  +-- 17: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	2020-04-10 12:59:34.969804
1354[--]  +-- 18: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	2020-04-10 12:59:34.841183
1355[--]  +-- 19: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	2020-04-10 12:59:34.804669
1356[--]  +-- 20: NULL	SELECT ? AS `sys_version` , `version` ( ) AS `mysql_version`	2020-04-10 12:59:34.692633
1357[--]  +-- 21: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	2020-04-10 12:59:34.654600
1358[--]  +-- 22: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2020-04-10 12:59:33.634198
1359[--]  +-- 23: NULL	SHOW ENGINES	2020-04-10 12:59:32.245304
1360[--]  +-- 24: NULL	SHOW GLOBAL STATUS	2020-04-10 12:59:32.230212
1361[--]  +-- 25: NULL	SHOW STATUS	2020-04-10 12:59:32.215600
1362[--]  +-- 26: NULL	SHOW GLOBAL VARIABLES	2020-04-10 12:59:32.198419
1363[--]  +-- 27: NULL	SHOW VARIABLES	2020-04-10 12:59:32.181307
1364
1365-------- Performance schema: TOP 15 total latency queries with temp table --------------------------
1366[--]  +-- 1: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	223793529000
1367[--]  +-- 2: NULL	SHOW VARIABLES	222356550000
1368[--]  +-- 3: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	186945177000
1369[--]  +-- 4: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	97253123000
1370[--]  +-- 5: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	64917071000
1371[--]  +-- 6: NULL	SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , CONVERT 	44909821000
1372[--]  +-- 7: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	43674802000
1373[--]  +-- 8: sys	SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT` 	37151265000
1374[--]  +-- 9: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	36058292000
1375[--]  +-- 10: sys	SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch	16553200000
1376[--]  +-- 11: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	15129926000
1377[--]  +-- 12: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	12531199000
1378[--]  +-- 13: sys	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `perform	11690103000
1379[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `threads` . `PROCESSLIST_ID` IS NULL ) , `substring_index` ( `performance_schema` .	10189354000
1380[--]  +-- 15: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	8889783000
1381
1382-------- Performance schema: TOP 15 queries with temp table to disk --------------------------------
1383[--]  +-- 1: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	4
1384[--]  +-- 2: NULL	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?, 	1
1385[--]  +-- 3: sys	SELECT IF ( ( `processlist` . `ID` IS NULL ) , `concat` ( `substring_index` ( `performance_schema` . `threads` . `NAME` 	1
1386[--]  +-- 4: NULL	SHOW VARIABLES	0
1387[--]  +-- 5: NULL	SHOW GLOBAL VARIABLES	0
1388[--]  +-- 6: NULL	SHOW STATUS	0
1389[--]  +-- 7: NULL	SHOW GLOBAL STATUS	0
1390[--]  +-- 8: NULL	SHOW ENGINES	0
1391[--]  +-- 9: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
1392[--]  +-- 10: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , `tbl` . `	0
1393[--]  +-- 11: NULL	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` . `name` AS `TABLE_SCHEMA` , `tbl` . `name` AS `TABLE_NAME` , IF ( ( ( 	0
1394[--]  +-- 12: NULL	SELECT ? AS `sys_version` , `version` ( ) AS `mysql_version`	0
1395[--]  +-- 13: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `performance_schema	0
1396[--]  +-- 14: NULL	SELECT IF ( ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` IS NULL ) , ? , `perform	0
1397[--]  +-- 15: NULL	SELECT IF ( ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` IS NULL ) , ? , `performance_schema	0
1398
1399-------- Performance schema: TOP 15 class events by number -----------------------------------------
1400[--]  +-- 1: wait/io/file	2160
1401
1402-------- Performance schema: TOP 30 events by number -----------------------------------------------
1403[--]  +-- 1: wait/io/file/innodb/innodb_data_file	1299
1404[--]  +-- 2: wait/io/file/sql/binlog	402
1405[--]  +-- 3: wait/io/file/innodb/innodb_log_file	160
1406[--]  +-- 4: wait/io/file/sql/io_cache	146
1407[--]  +-- 5: wait/io/file/innodb/innodb_temp_file	93
1408[--]  +-- 6: wait/io/file/sql/binlog_index	21
1409[--]  +-- 7: wait/io/file/sql/casetest	10
1410[--]  +-- 8: wait/io/file/csv/metadata	8
1411[--]  +-- 9: wait/io/file/sql/ERRMSG	5
1412[--]  +-- 10: wait/io/file/mysys/cnf	5
1413[--]  +-- 11: wait/io/file/csv/data	4
1414[--]  +-- 12: wait/io/file/sql/pid	3
1415[--]  +-- 13: wait/io/file/mysys/charset	3
1416[--]  +-- 14: wait/io/file/sql/misc	1
1417
1418-------- Performance schema: TOP 15 class events by total latency ----------------------------------
1419[--]  +-- 1: wait/io/file	614679578346
1420
1421-------- Performance schema: TOP 30 events by total latency ----------------------------------------
1422[--]  +-- 1: wait/io/file/innodb/innodb_data_file	385324172124
1423[--]  +-- 2: wait/io/file/innodb/innodb_log_file	128894712876
1424[--]  +-- 3: wait/io/file/innodb/innodb_temp_file	70112474058
1425[--]  +-- 4: wait/io/file/sql/binlog	14091306360
1426[--]  +-- 5: wait/io/file/sql/io_cache	11225854896
1427[--]  +-- 6: wait/io/file/sql/ERRMSG	2443618482
1428[--]  +-- 7: wait/io/file/sql/binlog_index	1012155270
1429[--]  +-- 8: wait/io/file/csv/data	638847144
1430[--]  +-- 9: wait/io/file/csv/metadata	439258764
1431[--]  +-- 10: wait/io/file/sql/casetest	234047160
1432[--]  +-- 11: wait/io/file/sql/pid	146735886
1433[--]  +-- 12: wait/io/file/mysys/cnf	56504784
1434[--]  +-- 13: wait/io/file/mysys/charset	51275346
1435[--]  +-- 14: wait/io/file/sql/misc	8615196
1436
1437-------- Performance schema: TOP 15 class events by max latency ------------------------------------
1438[--]  +-- 1: wait/io/file	303207928446
1439
1440-------- Performance schema: TOP 30 events by max latency ------------------------------------------
1441[--]  +-- 1: wait/io/file/innodb/innodb_data_file	303207928446
1442[--]  +-- 2: wait/io/file/innodb/innodb_log_file	12346552818
1443[--]  +-- 3: wait/io/file/innodb/innodb_temp_file	5796889638
1444[--]  +-- 4: wait/io/file/sql/binlog	2642930310
1445[--]  +-- 5: wait/io/file/sql/ERRMSG	2217455058
1446[--]  +-- 6: wait/io/file/sql/binlog_index	669078486
1447[--]  +-- 7: wait/io/file/csv/data	535190244
1448[--]  +-- 8: wait/io/file/sql/io_cache	483917904
1449[--]  +-- 9: wait/io/file/csv/metadata	192331896
1450[--]  +-- 10: wait/io/file/sql/casetest	116812158
1451[--]  +-- 11: wait/io/file/sql/pid	101995584
1452[--]  +-- 12: wait/io/file/mysys/cnf	33992850
1453[--]  +-- 13: wait/io/file/mysys/charset	32925720
1454[--]  +-- 14: wait/io/file/sql/misc	8615196
1455
1456-------- ThreadPool Metrics ------------------------------------------------------------------------
1457[--] ThreadPool stat is disabled.
1458
1459-------- MyISAM Metrics ----------------------------------------------------------------------------
1460[--] MyISAM Metrics are disabled on last MySQL versions.
1461
1462-------- InnoDB Metrics ----------------------------------------------------------------------------
1463[--] InnoDB is enabled.
1464[--] InnoDB Buffers
1465[--]  +-- InnoDB Buffer Pool: 128.0M
1466[--]  +-- InnoDB Buffer Pool Instances: 1
1467[--]  +-- InnoDB Buffer Pool Chunk Size: 128.0M
1468[--]  +-- InnoDB Log File Size: 48.0M
1469[--]  +-- InnoDB Log File In Group: 2
1470[--]  +-- InnoDB Total Log File Size: 96.0M(75 % of buffer pool)
1471[--]  +-- InnoDB Log Buffer: 16.0M
1472[--]  +-- InnoDB Log Buffer Free: 6.9K
1473[--]  +-- InnoDB Log Buffer Used: 8.0K
1474[--] InnoDB Thread Concurrency: 0
1475[OK] InnoDB File per table is activated
1476[OK] InnoDB buffer pool / data size: 128.0M/16.0K
1477[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M should be equal to 25%
1478[OK] InnoDB buffer pool instances: 1
1479[--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
1480[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
1481[OK] InnoDB Read buffer efficiency: 93.44% (13237 hits/ 14166 total)
1482[OK] InnoDB Write log efficiency: 95.90% (631 hits/ 658 total)
1483[OK] InnoDB log waits: 0.00% (0 waits / 27 writes)
1484
1485-------- AriaDB Metrics ----------------------------------------------------------------------------
1486[--] AriaDB is disabled.
1487
1488-------- TokuDB Metrics ----------------------------------------------------------------------------
1489[--] TokuDB is disabled.
1490
1491-------- XtraDB Metrics ----------------------------------------------------------------------------
1492[--] XtraDB is disabled.
1493
1494-------- Galera Metrics ----------------------------------------------------------------------------
1495[--] Galera is disabled.
1496
1497-------- Replication Metrics -----------------------------------------------------------------------
1498[--] Galera Synchronous replication: NO
1499[--] No replication slave(s) for this server.
1500[--] Binlog format: ROW
1501[--] XA support enabled: ON
1502[--] Semi synchronous replication Master: Not Activated
1503[--] Semi synchronous replication Slave: Not Activated
1504[--] This is a standalone server
1505
1506-------- Recommendations ---------------------------------------------------------------------------
1507General recommendations:
1508    setup swappiness lower or equals to 10
1509    setup Max running number events greater than 1M
1510    MySQL was started within the last 24 hours - recommendations may be inaccurate
1511    Reduce your overall MySQL memory footprint for system stability
1512    Dedicate this server to your database for highest performance.
1513    Reduce or eliminate unclosed connections and network issues
1514    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
1515Variables to adjust:
1516  *** MySQL's maximum memory usage is dangerously high ***
1517  *** Add RAM before increasing MySQL buffer variables ***
1518    vm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness)
1519    fs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr)
1520    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.

  这边可以看出来结果还是很详细的,最后几行是根据当前的服务器数据库使用情况给出的优化建议

---------------------------------------------------------------
>> 博客地址:https://blog.mufengs.com
>> 邮箱地址:[email protected]
>> 微信帐号:Do8080
>> Github : https://github.com/mufengcoding
---------------------------------------------------------------