Bug #59831 | ndbinfo - counters not increasing after first query | ||
---|---|---|---|
Submitted: | 31 Jan 2011 6:06 | Modified: | 2 Feb 2011 11:20 |
Reporter: | John David Duncan | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
Version: | 7.1.6 | OS: | Any |
Assigned to: | Magnus Blåudd | CPU Architecture: | Any |
[31 Jan 2011 6:06]
John David Duncan
[31 Jan 2011 6:23]
John David Duncan
It turns out this is due to the query cache being enabled! So, maybe not really a bug, but still "surprising" behavior.
[1 Feb 2011 13:46]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130126
[1 Feb 2011 14:59]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130137
[1 Feb 2011 15:05]
Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.22 (revid:magnus.blaudd@oracle.com-20110201145855-p71typ0fhvh7z2fe) (version source revid:magnus.blaudd@oracle.com-20110201145821-pmfqmdoi2xmreq2r) (merge vers: 5.1.51-ndb-7.0.22) (pib:24)
[2 Feb 2011 8:00]
Magnus Blåudd
Pushed to 7.0.22 and 7.1.11
[2 Feb 2011 11:20]
Jon Stephens
Documented as follows in the NDB-7.0.22 and 7.1.11 changelogs: Successive queries on the ndbinfo.counters table from the same SQL node returned unchanging results. To fix this issue, and to prevent similar issues from occurring in the future, ndbinfo tables are now excluded from the query cache. Behaviour change also noted at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-ndbinfo.html. Closed.