mysql优化工具mysqltuner
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
---------------------------------------------------------------