Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3892

schema router flood information schemas with queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4.19
    • Component/s: schemarouter
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-147, MXS-SPRINT-148

      Description

      As we discuss with MAxscale team, schema router create tons of queries to information_schema:

      SELECT CONCAT(schema_name, '.') FROM information_schema.schemata AS s 
      LEFT JOIN information_schema.tables AS t ON s.schema_name = t.table_schema 
      WHERE t.table_name IS NULL
      UNION
      SELECT CONCAT (table_schema, '.', table_name) FROM information_schema.tables
      

      in a large databases this is going to be a HUGE flood problem in performance, the queries getting slower and slower and the response of database is getting stack there due the queries that maxscale keep going.

      Information schema is based on views . The customer has just more the 400 tables .

      The massive performance issue is killing the Column Store instance

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            massimo.disaro Massimo
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.