From: Wagner Bianchi
Date: April 5 2011 3:34pm
Subject: Re: Tool to check content of tablespace
List-Archive: http://lists.mysql.com/cluster/8023
Message-Id: <BANLkTiksPOVzB=k0Jbcj=SmkxeObt72+-A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0015175cf8d40ce09d04a02d9b23

--0015175cf8d40ce09d04a02d9b23
Content-Type: text/plain; charset=ISO-8859-1

CREATE OR REPLACE VIEW ndb_dd_df AS
SELECT
FILE_NAME,
((TOTAL_EXTENTS * EXTENT_SIZE) / (1024 * 1024)) AS "Total MB",
((FREE_EXTENTS * EXTENT_SIZE) / (1024 * 1024)) AS "Free MB",
(
((FREE_EXTENTS * EXTENT_SIZE) * 100)
/(TOTAL_EXTENTS * EXTENT_SIZE)
)
EXTRA
FROM
INFORMATION_SCHEMA.FILES
WHERE
ENGINE = "NDBCLUSTER" AND FILE_TYPE = "DATAFILE";

Best regards.
--
Wagner Bianchi - (31) 8654-9510


2011/4/5 Bernhard Ocklin <bernd.ocklin@stripped>

>
> Am 21.03.2011 um 18:05 schrieb Steiner Helmut:
>
> > Hi,
> >
> > we are using MySql Cluster 7.1.3 and are facing some problems with the
> > way the disk space is used.
> >
> > To get a better feeling about what's going on we would appreciate to
> > have a tool or whatever to check which data goes to which extent in the
> > table space.
>
> You can certainly check storage consumption. Maybe you take a look here:
>
> http://dev.mysql.com/doc/refman/5.1/en/files-table.html (see FREE EXTENDS)
>
> But I assume you are consuming more disk space then you thought? Please
> note that varchars are using const char size on disk (not in memory though).
>
> Regards,
> Bernd
> MySQL Cluster Dev Team
>
>
> >
> > Thanks for assistance
> >
> > Cheers Helmut
> >
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=wagnerbianchijr@stripped
>
>

--0015175cf8d40ce09d04a02d9b23--