Ѳ ¼ì ÈË£ºÐ¡ÂóÃç([QQ£º646634621] [΢ÐŹ«ÖںţºDB±¦] [ÌṩOCP¡¢OCM¡¢¸ß¿ÉÓá¢MySQLºÍPostgreSQL×îʵÓõÄÅàѵ])
Ѳ¼ìʱ¼ä£º2022-04-08 11:19:32
°æ ±¾ ºÅ£ºv7.0.0
ÐÞ¸ÄÈÕÆÚ£º2022-4-8 18:28:00

[תµ½Ò³µ×]

¡ñ Êý¾Ý¿â»ù±¾ÐÅÏ¢

now_date	user	CURRENT_USER1	CONNECTION_ID	db_name	Server_version	all_db_size_MB	all_datafile_size_MB	datadir	SOCKET	log_error	autocommit	log_bin	server_id
2022-04-08 11:19:38	root@192.168.66.64	root@%	15		8.0.25-15	7.61	86.00	/data/GreatSQL/	/data/GreatSQL/mysql.sock	/data/GreatSQL/error.log	1	1	3306

¡ñ °æ±¾ÐÅÏ¢
version_comment GreatSQL, Release 15, Revision c7feae175e0 version_compile_machine x86_64 version_compile_os Linux version_compile_zlib 1.2.11 version_suffix

¡ñ ²å¼þÐÅÏ¢

PLUGIN_NAME	PLUGIN_VERSION	PLUGIN_STATUS	PLUGIN_TYPE	PLUGIN_TYPE_VERSION	PLUGIN_LIBRARY	PLUGIN_LIBRARY_VERSION	PLUGIN_AUTHOR	PLUGIN_DESCRIPTION	PLUGIN_LICENSE	LOAD_OPTION
binlog	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	This is a pseudo storage engine to represent the binlog in a transaction	GPL	FORCE
mysql_native_password	1.1	ACTIVE	AUTHENTICATION	2.0			Oracle Corporation	Native MySQL authentication	GPL	FORCE
sha256_password	1.1	ACTIVE	AUTHENTICATION	2.0			Oracle Corporation	SHA256 password authentication	GPL	FORCE
caching_sha2_password	1.0	ACTIVE	AUTHENTICATION	2.0			Oracle Corporation	Caching sha2 authentication	GPL	FORCE
sha2_cache_cleaner	1.0	ACTIVE	AUDIT	4.1			Oracle Corporation	Cache cleaner for Caching sha2 authentication	GPL	FORCE
daemon_keyring_proxy_plugin	1.0	ACTIVE	DAEMON	80025.0			Oracle	A plugin that implements the keyring component services atop of the keyring plugin	GPL	FORCE
PERFORMANCE_SCHEMA	0.1	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	Performance Schema	GPL	FORCE
CSV	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	CSV storage engine	GPL	FORCE
MEMORY	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	Hash based, stored in memory, useful for temporary tables	GPL	FORCE
InnoDB	8.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	Percona-XtraDB, Supports transactions, row-level locking, and foreign keys	GPL	FORCE
INNODB_TRX	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB transactions	GPL	FORCE
INNODB_CMP	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compression	GPL	FORCE
INNODB_CMP_RESET	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compression; reset cumulated counts	GPL	FORCE
INNODB_CMPMEM	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compressed buffer pool	GPL	FORCE
INNODB_CMPMEM_RESET	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compressed buffer pool; reset cumulated counts	GPL	FORCE
INNODB_CMP_PER_INDEX	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compression (per index)	GPL	FORCE
INNODB_CMP_PER_INDEX_RESET	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Statistics for the InnoDB compression (per index); reset cumulated counts	GPL	FORCE
INNODB_BUFFER_PAGE	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Buffer Page Information	GPL	FORCE
INNODB_BUFFER_PAGE_LRU	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Buffer Page in LRU	GPL	FORCE
INNODB_BUFFER_POOL_STATS	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Buffer Pool Statistics Information	GPL	FORCE
INNODB_TEMP_TABLE_INFO	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Temp Table Stats	GPL	FORCE
INNODB_METRICS	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Metrics Info	GPL	FORCE
INNODB_FT_DEFAULT_STOPWORD	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	Default stopword list for InnDB Full Text Search	GPL	FORCE
INNODB_FT_DELETED	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	INNODB AUXILIARY FTS DELETED TABLE	GPL	FORCE
INNODB_FT_BEING_DELETED	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	INNODB AUXILIARY FTS BEING DELETED TABLE	GPL	FORCE
INNODB_FT_CONFIG	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	INNODB AUXILIARY FTS CONFIG TABLE	GPL	FORCE
INNODB_FT_INDEX_CACHE	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	INNODB AUXILIARY FTS INDEX CACHED	GPL	FORCE
INNODB_FT_INDEX_TABLE	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	INNODB AUXILIARY FTS INDEX TABLE	GPL	FORCE
INNODB_TABLES	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_TABLES	GPL	FORCE
INNODB_TABLESTATS	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_TABLESTATS	GPL	FORCE
INNODB_INDEXES	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_INDEXES	GPL	FORCE
INNODB_TABLESPACES	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_TABLESPACES	GPL	FORCE
INNODB_COLUMNS	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_COLUMNS	GPL	FORCE
INNODB_VIRTUAL	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB INNODB_VIRTUAL	GPL	FORCE
INNODB_CACHED_INDEXES	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB cached indexes	GPL	FORCE
INNODB_SESSION_TEMP_TABLESPACES	8.0	ACTIVE	INFORMATION SCHEMA	80025.0			Oracle Corporation	InnoDB Session Temporary tablespaces	GPL	FORCE
INNODB_TABLESPACES_ENCRYPTION	8.2	ACTIVE	INFORMATION SCHEMA	80025.0			Google Inc	InnoDB TABLESPACES_ENCRYPTION	BSD	FORCE
INNODB_TABLESPACES_SCRUBBING	8.0	ACTIVE	INFORMATION SCHEMA	80025.0			Google Inc	InnoDB TABLESPACES_SCRUBBING	BSD	FORCE
INNODB_CHANGED_PAGES	1.0	ACTIVE	INFORMATION SCHEMA	80025.0			Percona	InnoDB CHANGED_PAGES table	GPL	FORCE
MyISAM	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	MyISAM storage engine	GPL	FORCE
MRG_MYISAM	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	Collection of identical MyISAM tables	GPL	FORCE
TempTable	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	InnoDB temporary storage engine	GPL	FORCE
ARCHIVE	3.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	Archive storage engine	GPL	ON
BLACKHOLE	1.0	ACTIVE	STORAGE ENGINE	80025.0			Oracle Corporation	/dev/null storage engine (anything you write to it disappears)	GPL	ON
FEDERATED	1.0	DISABLED	STORAGE ENGINE	80025.0			Oracle Corporation	Federated MySQL storage engine	GPL	OFF
ngram	0.1	ACTIVE	FTPARSER	1.1			Oracle Corporation	Ngram Full-Text Parser	GPL	ON
mysqlx_cache_cleaner	1.0	ACTIVE	AUDIT	4.1			Oracle Corporation	Cache cleaner for sha2 authentication in X plugin	GPL	ON
mysqlx	1.0	ACTIVE	DAEMON	80025.0			Oracle Corporation	X Plugin for MySQL	GPL	ON
clone	1.0	ACTIVE	CLONE	1.0	mysql_clone.so	1.10	Oracle Corporation	CLONE PLUGIN	GPL	ON
group_replication	1.1	ACTIVE	GROUP REPLICATION	1.4	group_replication.so	1.10	Oracle Corporation	Group Replication (1.1.0)	GPL	ON

¡ñ µ±Ç°Êý¾Ý¿âʵÀýµÄËùÓÐÊý¾Ý¿â¼°ÆäÈÝÁ¿´óС

SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	table_rows	data_size_mb	index_size_mb	all_size_mb	max_size_mb	free_size_mb	disk_size_mb
mysql	utf8mb4	utf8mb4_0900_ai_ci	138550	7.43	0.31	7.75	0.00	132.00
sys	utf8mb4	utf8mb4_0900_ai_ci	6	0.01	0.00	0.01	0.00	0.00	0.00
information_schema	utf8	utf8_general_ci	0	0.00	0.00	0.00	0.00	0.00
performance_schema	utf8mb4	utf8mb4_0900_ai_ci	2964672	0.00	0.00	0.00	0.00	0.00

¡ñ Êý¾Ý¿â¶ÔÏó

db_name	ob_type	sums
mysql	TABLE	35
performance_schema	TABLE	114
sys	TABLE	1
sys	TRIGGERS	2
sys	PROCEDURE	26
sys	FUNCTION	22
sys	VIEWS	100

¡ñ ²é¿´Êý¾Ý¿âµÄÔËÐÐ״̬

-------------- mysql Ver 14.14 Distrib 5.7.30, for Win64 (x86_64) Connection id: 15 Current database: Current user: root@192.168.66.64 SSL: Cipher in use is ECDHE-RSA-AES128-GCM-SHA256 Using delimiter: ; Server version: 8.0.25-15 GreatSQL, Release 15, Revision c7feae175e0 Protocol version: 10 Connection: 192.168.66.35 via TCP/IP Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 26 min 15 sec Threads: 2 Questions: 3801 Slow queries: 9 Opens: 1736 Flush tables: 3 Open tables: 297 Queries per second avg: 2.413 --------------

¡ñ Õ¼Óÿռä×î´óµÄÇ°10ÕÅ´ó±í

db_name	table_name	TABLE_TYPE	ENGINE	CREATE_TIME	UPDATE_TIME	TABLE_COLLATION	table_rows	tb_size_mb	index_size_mb	all_size_mb	free_size_mb	disk_size_mb
mysql	time_zone_transition	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	120838	4.51	0.00	4.51	4.00
mysql	help_topic	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	462	1.51	0.09	1.60	4.00
mysql	time_zone_transition_type	BASE TABLE	InnoDB	2022-04-08 10:52:50		utf8_general_ci	9777	0.42	0.00	0.42	4.00
mysql	help_keyword	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	1005	0.12	0.12	0.25	4.00
mysql	time_zone_name	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	1864	0.23	0.00	0.23	4.00
mysql	help_relation	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	2631	0.09	0.00	0.09	4.00
mysql	time_zone	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	1812	0.07	0.00	0.07	4.00
mysql	global_grants	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_bin	70	0.06	0.00	0.06	4.00
mysql	tables_priv	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_bin	2	0.01	0.01	0.03	4.00
mysql	help_category	BASE TABLE	InnoDB	2022-04-08 10:52:49		utf8_general_ci	53	0.01	0.01	0.03	4.00

¡ñ Õ¼Óÿռä×î´óµÄÇ°10¸öË÷Òý

database_name	table_name	index_name	SizeMB	NON_UNIQUE	INDEX_TYPE	COLUMN_NAME

¡ñ ËùÓд洢ÒýÇæÁбí

ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS
FEDERATED	NO	Federated MySQL storage engine
PERFORMANCE_SCHEMA	YES	Performance Schema	NO	NO	NO
InnoDB	DEFAULT	Percona-XtraDB, Supports transactions, row-level locking, and foreign keys	YES	YES	YES
MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
MyISAM	YES	MyISAM storage engine	NO	NO	NO
MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
BLACKHOLE	YES	/dev/null storage engine (anything you write to it disappears)	NO	NO	NO
CSV	YES	CSV storage engine	NO	NO	NO
ARCHIVE	YES	Archive storage engine	NO	NO	NO

¡ñ ´æ´¢ÒýÇæºÍDBµÄÊýÁ¿¹Øϵ

ENGINE	counts
	191
InnoDB	34
CSV	2
PERFORMANCE_SCHEMA	114

TABLE_SCHEMA	ENGINE	counts
information_schema		91
mysql	CSV	2
mysql	InnoDB	33
performance_schema	PERFORMANCE_SCHEMA	114
sys		100
sys	InnoDB	1

¡ñ InnoDB ϵͳ±í¿Õ¼ä

FILE_ID	FILE_NAME	FILE_TYPE	TABLESPACE_NAME	TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	LOGFILE_GROUP_NAME	LOGFILE_GROUP_NUMBER	ENGINE	FULLTEXT_KEYS	DELETED_ROWS	UPDATE_COUNT	FREE_EXTENTS	TOTAL_EXTENTS	EXTENT_SIZE	INITIAL_SIZE	MAXIMUM_SIZE	AUTOEXTEND_SIZE	CREATION_TIME	LAST_UPDATE_TIME	LAST_ACCESS_TIME	RECOVER_TIME	TRANSACTION_COUNTER	VERSION	ROW_FORMAT	TABLE_ROWS	AVG_ROW_LENGTH	DATA_LENGTH	MAX_DATA_LENGTH	INDEX_LENGTH	DATA_FREE	CREATE_TIME	UPDATE_TIME	CHECK_TIME	CHECKSUM	STATUS	EXTRA
0	./ibdata1	TABLESPACE	innodb_system						InnoDB				2	12	1048576	12582912		67108864													6291456					NORMAL
4294967293	./ibtmp1	TEMPORARY	innodb_temporary						InnoDB				2	12	1048576	12582912		67108864													6291456					NORMAL
4294967279	./undo_001	UNDO LOG	innodb_undo_001						InnoDB				4	16	1048576	16777216		16777216													8388608					NORMAL
4294967278	./undo_002	UNDO LOG	innodb_undo_002						InnoDB				0	16	1048576	16777216		16777216													8388608					NORMAL

¡ñ ²éѯËùÓÐÓû§

Host	User	Select_priv	Insert_priv	Update_priv	Delete_priv	Create_priv	Drop_priv	Reload_priv	Shutdown_priv	Process_priv	File_priv	Grant_priv	References_priv	Index_priv	Alter_priv	Show_db_priv	Super_priv	Create_tmp_table_priv	Lock_tables_priv	Execute_priv	Repl_slave_priv	Repl_client_priv	Create_view_priv	Show_view_priv	Create_routine_priv	Alter_routine_priv	Create_user_priv	Event_priv	Trigger_priv	Create_tablespace_priv	ssl_type	ssl_cipher	x509_issuer	x509_subject	max_questions	max_updates	max_connections	max_user_connections	plugin
%	repl	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	Y	N	N	N	N	N	N	N	N	N					0	0	0	0	mysql_native_password
%	root	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y					0	0	0	0	caching_sha2_password
localhost	mysql.infoschema	Y	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N					0	0	0	0	caching_sha2_password
localhost	mysql.session	N	N	N	N	N	N	N	Y	N	N	N	N	N	N	N	Y	N	N	N	N	N	N	N	N	N	N	N	N	N					0	0	0	0	caching_sha2_password
localhost	mysql.sys	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N					0	0	0	0	caching_sha2_password
localhost	root	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y					0	0	0	0	caching_sha2_password

¡ñ ²éѯMySQLÖ§³ÖµÄËùÓÐ×Ö·û¼¯

CHARACTER_SET_NAME	DEFAULT_COLLATE_NAME	DESCRIPTION	MAXLEN
big5	big5_chinese_ci	Big5 Traditional Chinese	2
dec8	dec8_swedish_ci	DEC West European	1
cp850	cp850_general_ci	DOS West European	1
hp8	hp8_english_ci	HP West European	1
koi8r	koi8r_general_ci	KOI8-R Relcom Russian	1
latin1	latin1_swedish_ci	cp1252 West European	1
latin2	latin2_general_ci	ISO 8859-2 Central European	1
swe7	swe7_swedish_ci	7bit Swedish	1
ascii	ascii_general_ci	US ASCII	1
ujis	ujis_japanese_ci	EUC-JP Japanese	3
sjis	sjis_japanese_ci	Shift-JIS Japanese	2
hebrew	hebrew_general_ci	ISO 8859-8 Hebrew	1
tis620	tis620_thai_ci	TIS620 Thai	1
euckr	euckr_korean_ci	EUC-KR Korean	2
koi8u	koi8u_general_ci	KOI8-U Ukrainian	1
gb2312	gb2312_chinese_ci	GB2312 Simplified Chinese	2
greek	greek_general_ci	ISO 8859-7 Greek	1
cp1250	cp1250_general_ci	Windows Central European	1
gbk	gbk_chinese_ci	GBK Simplified Chinese	2
latin5	latin5_turkish_ci	ISO 8859-9 Turkish	1
armscii8	armscii8_general_ci	ARMSCII-8 Armenian	1
utf8	utf8_general_ci	UTF-8 Unicode	3
ucs2	ucs2_general_ci	UCS-2 Unicode	2
cp866	cp866_general_ci	DOS Russian	1
keybcs2	keybcs2_general_ci	DOS Kamenicky Czech-Slovak	1
macce	macce_general_ci	Mac Central European	1
macroman	macroman_general_ci	Mac West European	1
cp852	cp852_general_ci	DOS Central European	1
latin7	latin7_general_ci	ISO 8859-13 Baltic	1
cp1251	cp1251_general_ci	Windows Cyrillic	1
utf16	utf16_general_ci	UTF-16 Unicode	4
utf16le	utf16le_general_ci	UTF-16LE Unicode	4
cp1256	cp1256_general_ci	Windows Arabic	1
cp1257	cp1257_general_ci	Windows Baltic	1
utf32	utf32_general_ci	UTF-32 Unicode	4
binary	binary	Binary pseudo charset	1
geostd8	geostd8_general_ci	GEOSTD8 Georgian	1
cp932	cp932_japanese_ci	SJIS for Windows Japanese	2
eucjpms	eucjpms_japanese_ci	UJIS for Windows Japanese	3
gb18030	gb18030_chinese_ci	China National Standard GB18030	4
utf8mb4	utf8mb4_0900_ai_ci	UTF-8 Unicode	4

¡ñ һЩÖØÒªµÄ²ÎÊý
autocommit ON datadir /data/GreatSQL/ innodb_buffer_pool_size 134217728 innodb_file_per_table ON innodb_flush_log_at_trx_commit 1 innodb_io_capacity 4000 innodb_lock_wait_timeout 10 log_error /data/GreatSQL/error.log log_output FILE log_queries_not_using_indexes ON log_slave_updates ON log_throttle_queries_not_using_indexes 60 long_query_time 0.100000 lower_case_table_names 1 max_connect_errors 1000000 max_connections 512 max_user_connections 0 pid_file mysql.pid read_only OFF server_id 3306 slow_query_log ON slow_query_log_file /data/GreatSQL/slow.log socket /data/GreatSQL/mysql.sock sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION time_zone +08:00 transaction_isolation REPEATABLE-READ

¡ñ ²é¿´µ±Ç°Á¬½Óµ½Êý¾Ý¿âµÄÓû§ºÍHost

USER	HOST
event_scheduler	localhost
root	192.168.66.64:7401

¡ñ ²é¿´Ã¿¸öhostµÄµ±Ç°Á¬½ÓÊýºÍ×ÜÁ¬½ÓÊý

HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
	1	7
localhost	1	1
192.168.66.64	1	8

¡ñ °´ÕյǼÓû§+µÇ¼·þÎñÆ÷²é¿´µÇ¼ÐÅÏ¢

login_user	login_ip	login_count
event_scheduler		1
root	192.168.66.64	1

¡ñ °´ÕյǼÓû§+Êý¾Ý¿â+µÇ¼·þÎñÆ÷²é¿´µÇ¼ÐÅÏ¢

database_name	login_user	login_ip	login_count
	event_scheduler		1
	root	192.168.66.64	1

ËøÇé¿ö

¡ñ ²éѯËùÓÐỊ̈߳¨ÅųýsleepỊ̈߳©

ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
5	event_scheduler	localhost		Daemon	1576	Waiting on empty queue

THREAD_ID	NAME	TYPE	PROCESSLIST_ID	PROCESSLIST_USER	PROCESSLIST_HOST	PROCESSLIST_DB	PROCESSLIST_COMMAND	PROCESSLIST_TIME	PROCESSLIST_STATE	PROCESSLIST_INFO	PARENT_THREAD_ID	ROLE	INSTRUMENTED	HISTORY	CONNECTION_TYPE	THREAD_OS_ID
43	thread/sql/event_scheduler	FOREGROUND	5	event_scheduler	localhost		Daemon	1576	Waiting on empty queue		1		YES	YES		168
47	thread/sql/compress_gtid_table	FOREGROUND	7				Daemon	1576	Suspending		1		YES	YES		172

¡ñ sleepÏß³ÌTOP20

ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO

THREAD_ID	NAME	TYPE	PROCESSLIST_ID	PROCESSLIST_USER	PROCESSLIST_HOST	PROCESSLIST_DB	PROCESSLIST_COMMAND	PROCESSLIST_TIME	PROCESSLIST_STATE	PROCESSLIST_INFO	PARENT_THREAD_ID	ROLE	INSTRUMENTED	HISTORY	CONNECTION_TYPE	THREAD_OS_ID

¡ñ ÓжàÉÙÏß³ÌÕýÔÚʹÓñí

¡ñ ²éѯInnoDB´æ´¢ÒýÇæµÄÔËÐÐʱÐÅÏ¢£¬°üÀ¨ËÀËøµÄÏêϸÐÅÏ¢
InnoDB \n=====================================\n2022-04-08 03:19:43 139779176699648 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 18 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 27 srv_active, 0 srv_shutdown, 1549 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 7\nOS WAIT ARRAY INFO: signal count 7\nRW-shared spins 0, rounds 0, OS waits 0\nRW-excl spins 0, rounds 0, OS waits 0\nRW-sx spins 0, rounds 0, OS waits 0\nSpin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx\n------------\nTRANSACTIONS\n------------\nTrx id counter 2102\nPurge done for trx's n:o < 2064 undo n:o < 0 state: running but idle\nHistory list length 0\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 421254750273144, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421254750272232, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421254750271320, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for completed aio requests (insert buffer thread)\nI/O thread 1 state: waiting for completed aio requests (log thread)\nI/O thread 2 state: waiting for completed aio requests (read thread)\nI/O thread 3 state: waiting for completed aio requests (read thread)\nI/O thread 4 state: waiting for completed aio requests (read thread)\nI/O thread 5 state: waiting for completed aio requests (read thread)\nI/O thread 6 state: waiting for completed aio requests (write thread)\nI/O thread 7 state: waiting for completed aio requests (write thread)\nI/O thread 8 state: waiting for completed aio requests (write thread)\nI/O thread 9 state: waiting for completed aio requests (write thread)\nPending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,\n ibuf aio reads:, log i/o's:, sync i/o's:\nPending flushes (fsync) log: 0; buffer pool: 0\n961 OS file reads, 467 OS file writes, 145 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 0.33 writes/s, 0.00 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 0, seg size 2, 0 merges\nmerged operations:\n insert 0, delete mark 0, delete 0\ndiscarded operations:\n insert 0, delete mark 0, delete 0\nHash table size 34679, node heap has 2 buffer(s)\nHash table size 34679, node heap has 0 buffer(s)\nHash table size 34679, node heap has 0 buffer(s)\nHash table size 34679, node heap has 0 buffer(s)\nHash table size 34679, node heap has 0 buffer(s)\nHash table size 34679, node heap has 2 buffer(s)\nHash table size 34679, node heap has 7 buffer(s)\nHash table size 34679, node heap has 2 buffer(s)\n140.44 hash searches/s, 143.66 non-hash searches/s\n---\nLOG\n---\nLog sequence number 28333940\nLog buffer assigned up to 28333940\nLog buffer completed up to 28333940\nLog written up to 28333940\nLog flushed up to 28333940\nAdded dirty pages up to 28333940\nPages flushed up to 28333940\nLast checkpoint at 28333940\nCheckpoint age target 83374592\nModified age no less than 28333940\nCheckpoint age 0\nMax checkpoint age 80576000\nNumber of logs 2\nLog size 50331648\nLog total size 100663296\n106 log i/o's done, 0.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 137035776\nDictionary memory allocated 489575\nBuffer pool size 8191\nBuffer pool size, bytes 134201344\nFree buffers 7092\nDatabase pages 1086\nOld database pages 381\nModified db pages 3\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 131, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 934, created 164, written 302\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 1086, unzip_LRU len: 0\nI/O sum[13]:cur[0], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n0 read views open inside InnoDB\n0 RW transactions active inside InnoDB\nProcess ID=1, Main thread ID=139779330270976 , state=sleeping\nNumber of rows inserted 252, updated 0, deleted 0, read 255\n3.33 inserts/s, 0.00 updates/s, 0.00 deletes/s, 3.33 reads/s\nNumber of system rows inserted 61, updated 317, deleted 25, read 22310\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 186.32 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n

¡ñ µ±Ç°InnodbÄÚºËÖеĵ±Ç°»îÔ¾£¨active£©ÊÂÎñ

trx_id	trx_state	trx_started	trx_requested_lock_id	trx_wait_started	trx_weight	trx_mysql_thread_id	trx_query	trx_operation_state	trx_tables_in_use	trx_tables_locked	trx_lock_structs	trx_lock_memory_bytes	trx_rows_locked	trx_rows_modified	trx_concurrency_tickets	trx_isolation_level	trx_unique_checks	trx_foreign_key_checks	trx_last_foreign_key_error	trx_adaptive_hash_latched	trx_adaptive_hash_timeout	trx_is_read_only	trx_autocommit_non_locking

¡ñ ËøÏêÇé

¡ñ ÔªÊý¾ÝËøµÄÏà¹ØÐÅÏ¢

NAME	ENABLED	TIMED
wait/lock/metadata/sql/mdl	YES	YES

locked_schema	locked_table	locked_type	waiting_processlist_id	waiting_age	waiting_query	waiting_state	blocking_processlist_id	blocking_age	blocking_query	sql_kill_blocking_connection

locked_schema	locked_table	locked_type	waiting_processlist_id	waiting_age	waiting_query	waiting_state	blocking_processlist_id	blocking_age	blocking_query	sql_kill_blocking_connection

NULL

thd_id	conn_id	user	db	command	state	time	current_statement	statement_latency	progress	lock_latency	rows_examined	rows_sent	rows_affected	tmp_tables	tmp_disk_tables	full_scan	last_statement	last_statement_latency	current_memory	last_wait	last_wait_latency	source	trx_latency	trx_state	trx_autocommit	pid	program_name	lock_summary

object_schema	object_name	waiting_thread_id	waiting_pid	waiting_account	waiting_lock_type	waiting_lock_duration	waiting_query	waiting_query_secs	waiting_query_rows_affected	waiting_query_rows_examined	blocking_thread_id	blocking_pid	blocking_account	blocking_lock_type	blocking_lock_duration	sql_kill_blocking_query	sql_kill_blocking_connection

¡ñ ²é¿´·þÎñÆ÷µÄ״̬
Com_lock_instance 0 Com_lock_tables 0 Com_lock_tables_for_backup 0 Com_unlock_instance 0 Com_unlock_tables 0 Handler_external_lock 266 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_encryption_n_merge_blocks_encrypted 0 Innodb_encryption_n_merge_blocks_decrypted 0 Innodb_encryption_n_rowlog_blocks_encrypted 0 Innodb_encryption_n_rowlog_blocks_decrypted 0 Key_blocks_not_flushed 0 Key_blocks_unused 26792 Key_blocks_used 0 Locked_connects 0 Performance_schema_locker_lost 0 Performance_schema_metadata_lock_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_table_lock_stat_lost 0 Table_locks_immediate 248 Table_locks_waited 0

SQL²¿·Ö

¡ñ ¸ú×Ù³¤Ê±¼ä²Ù×÷µÄ½ø¶È

THREAD_ID	EVENT_ID	END_EVENT_ID	EVENT_NAME	SOURCE	TIMER_START	TIMER_END	TIMER_WAIT	WORK_COMPLETED	WORK_ESTIMATED	NESTING_EVENT_ID	NESTING_EVENT_TYPE

¡ñ ²é¿´Æ½¾ùÖ´ÐÐʱ¼äÖµ´óÓÚ95%µÄƽ¾ùÖ´ÐÐʱ¼äµÄÓï¾ä£¨¿É½üËƵØÈÏΪÊÇƽ¾ùÖ´ÐÐʱ¼ä³¬³¤µÄÓï¾ä£©£¬Ä¬ÈÏÇé¿öÏ°´ÕÕÓï¾äƽ¾ùÑÓ³Ù(Ö´ÐÐʱ¼ä)½µÐòÅÅÐò NULL NULL NULL NULL

query	db	full_scan	exec_count	err_count	warn_count	total_latency	max_latency	avg_latency	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	first_seen	last_seen	digest

¡ñ ²é¿´µ±Ç°ÕýÔÚÖ´ÐеÄÓï¾ä½ø¶ÈÐÅÏ¢

thd_id	conn_id	user	db	command	state	time	current_statement	statement_latency	progress	lock_latency	rows_examined	rows_sent	rows_affected	tmp_tables	tmp_disk_tables	full_scan	last_statement	last_statement_latency	current_memory	last_wait	last_wait_latency	source	trx_latency	trx_state	trx_autocommit	pid	program_name

¡ñ ²é¿´ÒѾ­Ö´ÐÐÍêµÄÓï¾äÏà¹Øͳ¼ÆÐÅÏ¢

thd_id	conn_id	user	db	command	state	time	current_statement	statement_latency	progress	lock_latency	rows_examined	rows_sent	rows_affected	tmp_tables	tmp_disk_tables	full_scan	last_statement	last_statement_latency	current_memory	last_wait	last_wait_latency	source	trx_latency	trx_state	trx_autocommit	pid	program_name

¡ñ ²é¿´Ê¹ÓÃÁËÁÙʱ±íµÄÓï¾ä£¬Ä¬ÈÏÇé¿öÏ°´ÕÕ´ÅÅÌÁÙʱ±íÊýÁ¿ºÍÄÚ´æÁÙʱ±íÊýÁ¿½øÐнµÐòÅÅÐò

query	db	exec_count	total_latency	memory_tmp_tables	disk_tmp_tables	avg_tmp_tables_per_query	tmp_tables_to_disk_pct	first_seen	last_seen	digest
SELECT ? UNION ALL SELECT `con ... MIT ? ) `V` UNION ALL SELECT ?		4	3.84 ms	12	4	3	33	2022-04-08 10:57:10.819758	2022-04-08 11:19:41.677440	c2f0920e26e84d609a0962ab9bacb45804aece48f45228010822c564b710f943
SELECT ? UNION ALL SELECT `con ... - ? ) ) `V` UNION ALL SELECT ?		4	3.89 ms	12	4	3	33	2022-04-08 10:57:11.112107	2022-04-08 11:19:41.971445	87f263403e4a1aaf439a3b73f3c2c2498b4f3e85181498e2fe88f97aed7959b7
SELECT ? UNION ALL SELECT `con ... MIT ? ) `V` UNION ALL SELECT ?		4	4.03 ms	8	4	2	50	2022-04-08 10:57:11.846188	2022-04-08 11:19:42.702883	a71f560a8e0c260d57080c81c9f5c83e3d60ad725a4a01fdd8102f8eed32282f
SELECT ? UNION ALL SELECT `con ... GINS` ) `V` UNION ALL SELECT ?		4	6.53 ms	4	4	1	100	2022-04-08 10:57:08.546113	2022-04-08 11:19:38.880159	c9c8560645bced1d0f2c0bd7c0874c6d451581ce3425b2efcc1b431c21536866
SELECT ? UNION ALL SELECT `con ... ` ( ) ) `V` UNION ALL SELECT ?		4	3.45 ms	4	4	1	100	2022-04-08 10:57:11.603436	2022-04-08 11:19:42.460369	2541f6d4972434db06768a3a92e024b72f7e52b7dbf1aa0320177313069e9828
SELECT ? UNION ALL SELECT `con ... ` = ? ) `V` UNION ALL SELECT ?		3	3.27 ms	3	3	1	100	2022-04-08 10:57:16.816440	2022-04-08 11:18:55.998557	937193685b21f68dfcd74005d63e109e89dbf18d899fd6899436b9ceafd712d7
SELECT ? UNION ALL SELECT `con ... - ? ) ) `V` UNION ALL SELECT ?		2	1.89 ms	6	2	3	33	2022-04-08 11:18:50.684498	2022-04-08 11:19:42.119288	28a8cf0aee2963d7ef833895a67d515329bf3204c7c6df73a052b70d50a4ea23
SELECT ? UNION ALL SELECT `con ... - ? ) ) `V` UNION ALL SELECT ?		2	1.9 ms	6	2	3	33	2022-04-08 10:57:11.260678	2022-04-08 11:09:11.444207	642b5ecf0eb82817a42cd32434ff07466bb8b88e805580fdcb19bd831055a930
SELECT `concat` ( ? , `ifnull` ... TION ( ? IN HOST ) - ? ) ) `V`		1	1.44 ms	3	1	3	33	2022-04-08 11:15:23.145158	2022-04-08 11:15:23.145158	9912d114bdb0db0b052a3880bd0067e9f89d0d56745713eab94b4a96aaa2ef33
SELECT `concat` ( ? , `databas ... TION ( ? IN HOST ) - ? ) ) `V`		1	1.76 ms	3	1	3	33	2022-04-08 11:10:49.306695	2022-04-08 11:10:49.306695	9cfd71d42688c678067b03076dfef242e3b218d6a0d88142e7e15e89c75ad57f

¡ñ ÓÐÁÙʱ±íµÄÇ°10ÌõSQLÓï¾ä

query	db	full_scan	exec_count	err_count	warn_count	total_latency	max_latency	avg_latency	lock_latency	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	rows_affected	rows_affected_avg	tmp_tables	tmp_disk_tables	rows_sorted	sort_merge_passes	digest	first_seen	last_seen
SELECT `internal_tablespace_id ... _ROWS` , ? AS `UPDATE_COUNT` ,		*	16	0	0	1.90 s	1.58 s	118.62 ms	33.09 ms	108	7	2556	160	0	0	28	0	80	0	56ebc6e21608c16d20579b17eca3668ef7bae51b1c1cdd8a0622ae1c146006ff	2022-04-08 10:57:08.246401	2022-04-08 11:19:40.944840
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GROUP BY `avg_us`		*	4	0	0	57.66 ms	16.44 ms	14.42 ms	6.51 ms	20	5	436	109	0	0	28	0	24	0	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dcc937737c2f7138	2022-04-08 10:57:14.146283	2022-04-08 11:19:44.803821
SELECT ( `cat` . `name` COLLAT ... ction_collation_id` ) ) ) JOIN		*	4	0	0	85.46 ms	40.09 ms	21.37 ms	20.85 ms	36	9	36	9	0	0	28	0	0	0	513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b60522b1f566f0ef	2022-04-08 10:57:08.910704	2022-04-08 11:19:39.729505
SELECT `t` . `THREAD_ID` AS `t ... T_NUMBER_OF_BYTES_USED` ) DESC		*	4	0	0	462.04 ms	132.60 ms	115.51 ms	9.56 ms	12	3	20	5	0	0	24	0	401	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75c10afa4cfe9c9d	2022-04-08 10:57:13.349374	2022-04-08 11:19:44.008150
SELECT ( `cat` . `name` COLLAT ... te_data` , COALESCE ( `stat` .		*	11	0	0	59.99 ms	6.91 ms	5.45 ms	13.02 ms	62	6	62	6	0	0	19	0	24	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741ce5b09be33c7dbf	2022-04-08 10:57:09.878336	2022-04-08 11:19:40.795331
SELECT `t` . `THREAD_ID` AS `t ... F_BYTES_USED` ) DESC (unknown)		*	8	0	0	20.84 ms	3.36 ms	2.61 ms	12.25 ms	16	2	16	2	0	0	16	0	0	0	1564cd5c0d3704b0b7f27cfb3ea273ab3261f37040a5d3f51f2471f811db7a13	2022-04-08 10:57:14.246423	2022-04-08 11:19:45.002062
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COALESCE ( `stat` .		*	7	0	0	40.26 ms	9.08 ms	5.75 ms	9.47 ms	146	21	1786	255	0	0	12	0	0	0	65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d96182b73852d64	2022-04-08 10:57:09.579160	2022-04-08 11:19:40.392265
SELECT ? UNION ALL SELECT `con ... DESC ) `V` UNION ALL SELECT ?		*	3	0	3	2.23 ms	775.34 us	744.80 us	1.17 ms	6	2	6	2	0	0	12	0	0	0	23a299fabdfca3771d2e39118c51cf18d337f0a47e58d576ca55e2b325fe31b9	2022-04-08 10:57:14.891786	2022-04-08 11:18:54.066369
SELECT ? UNION ALL SELECT `con ... MIT ? ) `V` UNION ALL SELECT ?		*	4	0	0	3.84 ms	997.95 us	961.12 us	1.81 ms	16	4	16	4	0	0	12	4	0	0	c2f0920e26e84d609a0962ab9bacb45804aece48f45228010822c564b710f943	2022-04-08 10:57:10.819758	2022-04-08 11:19:41.677440
SELECT ? UNION ALL SELECT `con ... - ? ) ) `V` UNION ALL SELECT ?		*	4	0	0	3.89 ms	1.02 ms	971.85 us	1.85 ms	16	4	16	4	0	0	12	4	0	0	87f263403e4a1aaf439a3b73f3c2c2498b4f3e85181498e2fe88f97aed7959b7	2022-04-08 10:57:11.112107	2022-04-08 11:19:41.971445

¡ñ ²é¿´Ö´ÐÐÁËÎļþÅÅÐòµÄÓï¾ä£¬Ä¬ÈÏÇé¿öÏ°´ÕÕÓï¾ä×ÜÑÓ³Ùʱ¼ä£¨Ö´ÐÐʱ¼ä£©½µÐòÅÅÐò NULL NULL NULL NULL NULL NULL NULL NULL NULL

query	db	exec_count	total_latency	sort_merge_passes	avg_sort_merges	sorts_using_scans	sort_using_range	rows_sorted	avg_rows_sorted	first_seen	last_seen	digest

¡ñ ²éѯSQLµÄÕûÌåÏûºÄ°Ù·Ö±È

state	total_r	pct_r	calls	r/call

¡ñ Ö´ÐдÎÊýTop10

query	db	full_scan	exec_count	err_count	warn_count	total_latency	max_latency	avg_latency	lock_latency	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	rows_affected	rows_affected_avg	tmp_tables	tmp_disk_tables	rows_sorted	sort_merge_passes	digest	first_seen	last_seen
SELECT `internal_tablespace_id ... _ROWS` , ? AS `UPDATE_COUNT` ,		*	16	0	0	1.90 s	1.58 s	118.62 ms	33.09 ms	108	7	2556	160	0	0	28	0	80	0	56ebc6e21608c16d20579b17eca3668ef7bae51b1c1cdd8a0622ae1c146006ff	2022-04-08 10:57:08.246401	2022-04-08 11:19:40.944840
SELECT ( `cat` . `name` COLLAT ... te_data` , COALESCE ( `stat` .		*	11	0	0	59.99 ms	6.91 ms	5.45 ms	13.02 ms	62	6	62	6	0	0	19	0	24	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741ce5b09be33c7dbf	2022-04-08 10:57:09.878336	2022-04-08 11:19:40.795331
SELECT `t` . `THREAD_ID` AS `t ... F_BYTES_USED` ) DESC (unknown)		*	8	0	0	20.84 ms	3.36 ms	2.61 ms	12.25 ms	16	2	16	2	0	0	16	0	0	0	1564cd5c0d3704b0b7f27cfb3ea273ab3261f37040a5d3f51f2471f811db7a13	2022-04-08 10:57:14.246423	2022-04-08 11:19:45.002062
SELECT ( `cat` . `name` COLLAT ... den` ) ) , COALESCE ( `stat` .		*	7	0	0	40.26 ms	9.08 ms	5.75 ms	9.47 ms	146	21	1786	255	0	0	12	0	0	0	65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d96182b73852d64	2022-04-08 10:57:09.579160	2022-04-08 11:19:40.392265
SELECT `sys` . `format_stateme ... atency` , `format_pico_time` (		*	7	0	0	28.45 ms	4.44 ms	4.06 ms	5.09 ms	84	12	84	12	0	0	7	0	70	0	508486bd060b13d75e7374136fec54ea4e8827b60fbb8fac7aded21a9ecf3c8a	2022-04-08 10:57:14.596631	2022-04-08 11:19:45.258692
SHOW GLOBAL VARIABLES WHERE `V ... l_variables` . `VARIABLE_NAME`		*	7	0	0	26.02 ms	5.11 ms	3.72 ms	2.50 ms	158	23	158	23	0	0	7	0	0	0	3843bbd6565b5be5ced26d3cd6b87c95388208a8bda45858bee0ef931b4dbfb1	2022-04-08 10:57:10.623187	2022-04-08 11:19:41.482724
SHOW VARIABLES LIKE ? (unknown ... n_variables` . `VARIABLE_NAME`		*	4	0	0	19.64 ms	6.16 ms	4.91 ms	801.00 us	20	5	20	5	0	0	4	0	0	0	a87043a2f1fedffea3d9eb9c3f1ea4066dbb6481c035609112a31b4425b3aac9	2022-04-08 10:57:08.398344	2022-04-08 11:19:38.727789
SELECT ? UNION ALL SELECT `con ... GINS` ) `V` UNION ALL SELECT ?		*	4	0	0	6.53 ms	1.69 ms	1.63 ms	2.82 ms	208	52	208	52	0	0	4	4	0	0	c9c8560645bced1d0f2c0bd7c0874c6d451581ce3425b2efcc1b431c21536866	2022-04-08 10:57:08.546113	2022-04-08 11:19:38.880159
SELECT ( `cat` . `name` COLLAT ... ction_collation_id` ) ) ) JOIN		*	4	0	0	85.46 ms	40.09 ms	21.37 ms	20.85 ms	36	9	36	9	0	0	28	0	0	0	513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b60522b1f566f0ef	2022-04-08 10:57:08.910704	2022-04-08 11:19:39.729505
SELECT ? UNION ALL SELECT `con ... INES` ) `V` UNION ALL SELECT ?		*	4	0	0	2.12 ms	555.00 us	529.12 us	1.05 ms	44	11	44	11	0	0	4	0	0	0	d3a5b69de359299423c84c180dc32c5945166dab355a2dce7c2a5028ed74cbde	2022-04-08 10:57:09.726094	2022-04-08 11:19:40.539108

¡ñ ʹÓÃÈ«±íɨÃèµÄSQLÓï¾ä

object_schema	object_name	rows_full_scanned	latency

¡ñ ²é¿´È«±íɨÃè»òÕßûÓÐʹÓõ½×îÓÅË÷ÒýµÄÓï¾ä£¨¾­¹ý±ê×¼»¯×ª»¯µÄÓï¾äÎı¾£©£¬Ä¬ÈÏÇé¿öÏ°´ÕÕÈ«±íɨÃè´ÎÊýÓëÓï¾ä×Ü´ÎÊý°Ù·Ö±ÈºÍÓï¾ä×ÜÑÓ³Ùʱ¼ä(Ö´ÐÐʱ¼ä)½µÐòÅÅÐò NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

query	db	exec_count	total_latency	no_index_used_count	no_good_index_used_count	no_index_used_pct	rows_sent	rows_examined	rows_sent_avg	rows_examined_avg	first_seen	last_seen	digest

¡ñ ²é¿´²úÉú´íÎó»ò¾¯¸æµÄÓï¾ä£¬Ä¬ÈÏÇé¿öÏ£¬°´ÕÕ´íÎóÊýÁ¿ºÍ¾¯¸æÊýÁ¿½µÐòÅÅÐò

query	db	exec_count	errors	error_pct	warnings	warning_pct	first_seen	last_seen	digest
SELECT ? UNION ALL SELECT `con ... DESC ) `V` UNION ALL SELECT ?		4	0	0.0000	4	100.0000	2022-04-08 10:57:14.891786	2022-04-08 11:19:45.605355	23a299fabdfca3771d2e39118c51cf18d337f0a47e58d576ca55e2b325fe31b9
SHOW SLAVE HOSTS		3	0	0.0000	3	100.0000	2022-04-08 10:57:17.253847	2022-04-08 11:18:56.437664	f59f2dee8175a875cdb3093ec4d2e4e82f9198f48fd99b6090cf6f00ebc3321e
SHOW SLAVE STATUS		3	0	0.0000	3	100.0000	2022-04-08 10:57:17.892558	2022-04-08 11:18:57.080809	aeea8d14c430e6eaaf2ffc1c542f366c21a261cbe130323702b18c3c36cf92ae

Ë÷Òý²¿·Ö

¡ñ ÈßÓàË÷Òý

¡ñ ÎÞЧË÷Òý£¨´ÓδʹÓùýµÄË÷Òý£©

object_schema	object_name	index_name
performance_schema	cond_instances	NAME
performance_schema	data_lock_waits	REQUESTING_ENGINE_LOCK_ID
performance_schema	data_lock_waits	BLOCKING_ENGINE_LOCK_ID
performance_schema	data_lock_waits	REQUESTING_ENGINE_TRANSACTION_ID
performance_schema	data_lock_waits	BLOCKING_ENGINE_TRANSACTION_ID
performance_schema	data_lock_waits	REQUESTING_THREAD_ID
performance_schema	data_lock_waits	BLOCKING_THREAD_ID
performance_schema	data_locks	ENGINE_TRANSACTION_ID
performance_schema	data_locks	THREAD_ID
performance_schema	data_locks	OBJECT_SCHEMA
performance_schema	error_log	THREAD_ID
performance_schema	error_log	PRIO
performance_schema	error_log	ERROR_CODE
performance_schema	error_log	SUBSYSTEM
performance_schema	events_waits_summary_by_instance	EVENT_NAME
performance_schema	file_instances	EVENT_NAME
performance_schema	file_summary_by_instance	FILE_NAME
performance_schema	file_summary_by_instance	EVENT_NAME
performance_schema	host_cache	HOST
performance_schema	metadata_locks	OBJECT_TYPE
performance_schema	metadata_locks	OWNER_THREAD_ID
performance_schema	mutex_instances	NAME
performance_schema	mutex_instances	LOCKED_BY_THREAD_ID
performance_schema	prepared_statements_instances	STATEMENT_ID
performance_schema	prepared_statements_instances	STATEMENT_NAME
performance_schema	prepared_statements_instances	OWNER_OBJECT_TYPE
performance_schema	replication_applier_status_by_coordinator	THREAD_ID
performance_schema	replication_applier_status_by_worker	THREAD_ID
performance_schema	replication_asynchronous_connection_failover	CHANNEL_NAME
performance_schema	replication_connection_status	THREAD_ID
performance_schema	rwlock_instances	NAME
performance_schema	rwlock_instances	WRITE_LOCKED_BY_THREAD_ID
performance_schema	socket_instances	THREAD_ID
performance_schema	socket_instances	SOCKET_ID
performance_schema	socket_instances	IP
performance_schema	socket_summary_by_instance	EVENT_NAME
performance_schema	table_handles	OBJECT_TYPE
performance_schema	table_handles	OWNER_THREAD_ID
performance_schema	threads	PROCESSLIST_ID
performance_schema	threads	THREAD_OS_ID
performance_schema	threads	NAME
performance_schema	threads	PROCESSLIST_ACCOUNT
performance_schema	threads	PROCESSLIST_HOST
performance_schema	threads	RESOURCE_GROUP

¡ñ ÿÕűíµÄË÷ÒýÇø·Ö¶È£¨Ç°100Ìõ£©

Çø·Ö¶ÈÔ½½Ó½ü1£¬±íʾÇø·Ö¶ÈÔ½¸ß£»µÍÓÚ0.1£¬Ôò˵Ã÷Çø·Ö¶È½Ï²î£¬¿ª·¢ÕßÓ¦¸ÃÖØÐÂÆÀ¹ÀSQLÓï¾äÉæ¼°µÄ×ֶΣ¬Ñ¡ÔñÇø·Ö¶È¸ßµÄ¶à¸ö×ֶδ´½¨Ë÷Òý

ASdb	AStable	ASindex_name	AScols	ASdefferRows	ASROWS	sel_persent

Ö÷´ÓÇé¿ö

¡ñ Ö÷´Ó¸´ÖÆÉæ¼°µ½µÄÖØÒª²ÎÊý
auto_increment_increment 1 auto_increment_offset 1 binlog_format ROW expire_logs_days 0 log_bin ON log_bin_basename /data/GreatSQL/binlog log_bin_index /data/GreatSQL/binlog.index log_slave_updates ON max_allowed_packet 67108864 max_binlog_size 1073741824 read_only OFF server_id 3306 server_uuid f9014e00-b6e6-11ec-adfe-0242ac110006 slave_exec_mode STRICT slave_max_allowed_packet 1073741824 slave_skip_errors OFF sql_slave_skip_counter 0 sync_binlog 1

¡ñ Ö÷´Ó¿âÏß³Ì

THREAD_ID	NAME	TYPE	PROCESSLIST_ID	PROCESSLIST_USER	PROCESSLIST_HOST	PROCESSLIST_DB	PROCESSLIST_COMMAND	PROCESSLIST_TIME	PROCESSLIST_STATE	PROCESSLIST_INFO	PARENT_THREAD_ID	ROLE	INSTRUMENTED	HISTORY	CONNECTION_TYPE	THREAD_OS_ID

ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO

¡ñ ¶þ½øÖÆÈÕÖ¾

binlog.000001 179 No binlog.000002 156 No

¡ñ Ö÷¿â¶Ë²é¿´ËùÓдӿâ

¡ñ MGRÏêÇé NULL

CHANNEL_NAME	MEMBER_ID	MEMBER_HOST	MEMBER_PORT	MEMBER_STATE	MEMBER_ROLE	MEMBER_VERSION	MEMBER_COMMUNICATION_STACK

¡ñ Ö÷¿â״̬¼à²â
binlog.000002 156

¡ñ ´Ó¿â״̬¼à²â£¨ÐèÒªÔÚ´Ó¿âÖ´ÐвÅÓÐÊý¾Ý£©

CHANNEL_NAME	HOST	PORT	USER	CONNECTION_RETRY_COUNT	CONNECTION_RETRY_INTERVAL	SOURCE_UUID	THREAD_ID	SERVICE_STATE	COUNT_RECEIVED_HEARTBEATS	LAST_HEARTBEAT_TIMESTAMP	LAST_ERROR_NUMBER	LAST_ERROR_MESSAGE	LAST_ERROR_TIMESTAMP

¡ñ ¿Ë¡½ø¶ÈºÍ״̬

ID	PID	STATE	BEGIN_TIME	END_TIME	SOURCE	DESTINATION	ERROR_NO	ERROR_MESSAGE	BINLOG_FILE	BINLOG_POSITION	GTID_EXECUTED

stage	state	START TIME	FINISH TIME	DURATION	Estimate	Done(%)

Êý¾Ý¿âÐÔÄÜ

¡ñ ÐÔÄܲÎÊýͳ¼Æ
Com_delete 0 Com_insert 0 Com_select 1271 Connections 15 Created_tmp_disk_tables 31 Created_tmp_files 4 Created_tmp_tables 318 Handler_read_rnd_next 16939 Open_files 5 Opened_tables 1883 Slow_queries 9 Sort_merge_passes 0 Sort_range 0 Sort_rows 732 Sort_scan 99 Table_locks_immediate 288 Table_locks_waited 0 Uptime 1584

ÆäËü

¡ñ setup_consumers

NAME	ENABLED
events_stages_current	NO
events_stages_history	NO
events_stages_history_long	NO
events_statements_current	YES
events_statements_history	YES
events_statements_history_long	NO
events_transactions_current	YES
events_transactions_history	YES
events_transactions_history_long	NO
events_waits_current	NO
events_waits_history	NO
events_waits_history_long	NO
global_instrumentation	YES
thread_instrumentation	YES
statements_digest	YES

¡ñ ×ÔÔöIDµÄʹÓÃÇé¿ö£¨Ç°20Ìõ£©

table_schema	table_name	engine	Auto_increment

¡ñ ÎÞÖ÷¼ü»òΨһ¼üµÄ±í£¨Ç°100Ìõ£©

table_schema	table_name