Hello.
Number of idata tables should be roughly the same as number of nodes in the system.
This query should return list of tables without corresponding record in nodes or clusters:
Number of idata tables should be roughly the same as number of nodes in the system.
This query should return list of tables without corresponding record in nodes or clusters:
Code Select
SELECT s.id,s.name FROM (SELECT substr(t.table_name,7) AS id, t.table_name AS name FROM information_schema.tables t WHERE t.table_schema='mtest' AND t.table_name LIKE 'idata_%') AS s WHERE s.id NOT IN (SELECT id FROM nodes UNION SELECT id FROM clusters);