Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
None
-
None
Description
After running MySQL, there are 7 servers executing concurrently initially access information_schemaļ¼ There are a large number of checking permissions in the schema, which takes a long time. There are 3200 files underdatabase ds
SHOW FULL PROCESSLIST;
Id: 827
User: mysql
Host: 192.1.3.115:38378
db: dss
Command: Query
Time: 14
State: checking permissions
Info: SELECT A.TABLE_SCHEMA TABLE_CAT, NULL TABLE_SCHEM, A.TABLE_NAME, A.COLUMN_NAME, B.SEQ_IN_INDEX KEY_SEQ, B.INDEX_NAME PK_NAME FROM INFORMATION_SCHEMA.COLUMNS A, INFORMATION_SCHEMA.STATISTICS B WHERE A.COLUMN_KEY in ('PRI','pri') AND B.INDEX_NAME='PRIMARY' AND (A.TABLE_SCHEMA = 'ds') AND (B.TABLE_SCHEMA = 'ds') AND A.TABLE_NAME LIKE 'adm_history' AND B.TABLE_NAME LIKE 'adm_history' AND A.TABLE_SCHEMA = B.TABLE_SCHEMA AND A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME ORDER BY A.COLUMN_NAME
Progress: 0.000
Attachments
Issue Links
- is caused by
-
CONJ-1129 Metadata getPrimaryKeys using like in place of strict equality
- Closed