Bug #55394 Logging table scans in cluster log
Submitted: 20 Jul 2010 12:06
Reporter: Geert Vanderkelen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.1 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[20 Jul 2010 12:06] Geert Vanderkelen 
Description:
Log whenever a table scan happens in the cluster logs (management logs) including the table ID. It should be possible to turn this on and off, e.g. using ALL CLUSTERLOG INFO = 15.

How to repeat:
Feature request.

Suggested fix:
ndb_mgm> ALL CLUSTERLOG INFO=15;
2010-07-20 12:41:05 [MgmtSrvr] INFO     -- Node 3: Table scan detected on table 7
[10 Aug 2010 8:44] Geert Vanderkelen 
Jonas' proposal: use the NDB$INFO adding a table containing per-table statistics so you can see, for example, how much table scans are done.