Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1142

Accessing INFORMATION_ SCHEMA STATISTICS reports a large number of checking permissions

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • None
    • 3.3.2
    • metadata
    • 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

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1129 Metadata getPrimaryKeys using like in place of strict equality

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            kennyliao kennyliao created issue -
            kennyliao kennyliao made changes -
            Field Original Value New Value
            Description *************************** 68. row ***************************
                  Id: 827
                User: mysql
                Host: 192.168.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 = 'dss') AND (B.TABLE_SCHEMA = 'dss') AND A.TABLE_NAME LIKE 'adm_va_vehicle_feature_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
            *************************** 69. row ***************************             		SHOW FULL PROCESSLIST;

                  Id: 827
                User: mysql
                Host: 192.168.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 = 'dss') AND (B.TABLE_SCHEMA = 'dss') AND A.TABLE_NAME LIKE 'adm_va_vehicle_feature_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
            kennyliao kennyliao made changes -
            Description SHOW FULL PROCESSLIST;

                  Id: 827
                User: mysql
                Host: 192.168.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 = 'dss') AND (B.TABLE_SCHEMA = 'dss') AND A.TABLE_NAME LIKE 'adm_va_vehicle_feature_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
            		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
            kennyliao kennyliao made changes -
            Comment [ 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 ]
            diego dupin Diego Dupin made changes -
            wlad Vladislav Vaintroub made changes -
            Component/s metadata [ 14002 ]
            Component/s Platform Windows [ 10138 ]
            Key MDEV-32915 CONJ-1142
            Affects Version/s 10.5.17 [ 27509 ]
            Project MariaDB Server [ 10000 ] MariaDB Connector/J [ 10301 ]
            diego dupin Diego Dupin made changes -
            Priority Blocker [ 1 ] Major [ 3 ]
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            Fix Version/s 3.3.2 [ 29602 ]
            Assignee Diego Dupin [ diego dupin ]
            Resolution Done [ 10200 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

              diego dupin Diego Dupin
              kennyliao kennyliao
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.