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

schema router flood information schemas with queries

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.4
    • 2.4.19
    • schemarouter
    • None
    • 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

            markus makela markus makela
            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.