Bug #47131 Impossible to get extent data_free for table/partition
| Submitted: | 4 Sep 2009 10:57 | Modified: | 7 Sep 2009 14:52 |
|---|---|---|---|
| Reporter: | Jonas Oreland | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Disk Data | Severity: | S3 (Non-critical) |
| Version: | mysql-5.1-telco-6.3 | OS: | Any |
| Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[4 Sep 2009 11:01]
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/82447 3032 Jonas Oreland 2009-09-04 ndb - bug#47131 - add pseudo columns for extent space/free space
[4 Sep 2009 11:44]
Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090904113338-65p55dyr4v62k5rg) (version source revid:jonas@mysql.com-20090904113338-65p55dyr4v62k5rg) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[4 Sep 2009 11:44]
Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:jonas@mysql.com-20090904113937-h018xnx1ynmbnk5a) (version source revid:jonas@mysql.com-20090904113937-h018xnx1ynmbnk5a) (merge vers: 5.1.35-ndb-7.1.0) (pib:11)
[4 Sep 2009 11:45]
Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090904110123-8qk0tj3f4z4eap9g) (version source revid:jonas@mysql.com-20090904110123-8qk0tj3f4z4eap9g) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[7 Sep 2009 14:52]
Jon Stephens
Documented feature addition in the NDB-6.3.27 and 7.0.8 changelogs as follows:
Two new columns have been added to the output of ndb_desc to make
it possible to determine how much of the disk space allocated to a
given table or fragment remains free. (This information is not
available from the INFORMATION_SCHEMA.FILES table, since the FILES
table applies only to Disk Data files.) For more information, see
"ndb_desc — Describe NDB Tables".
Also updated ndb_desc documentation and Cluster Roadmap section.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Currently it is impossible to find out how much disk space allocated to a table(fragment) that is currently free. It's not available for other fragments, but can be used by owning fragment. How to repeat: . Suggested fix: The patch adds 2 new pseudo columns (that I added to ndb_desc) -- Per partition info -- Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space 0 99383 99383 4423680 0 26214400 567552 This means that table has allocated 26214400 from tablespace, and 567552 bytes of those are free. Note: this is a *per table* property (actually per fragment), and will not show up in INFORMATION_SCHEMA.FILES (since the 567552 bytes is not available for inserts from any other table (fragment)) --- Possibly they could also be exposed in mysqld...unsure about where though