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