Hi Robby,
Actually, you can. Just restart database - "setmp" should be restored to
its default size.
To get statistics, try:
- $schema_<name> document – the descriptive schema of the document
or collection
named <name>;
- $document_<name> document – statistical information about the document
named <name>;
- $collection_<name> document – statistical information about the collection
named <name>.
details there: http://sedna.org/progguide/ProgGuidesu8.html#x14-580002.5.6
You can also try to determine if your data (sedata) file is fragmented. Use
se_exp to export and then import data into clean database. Compare new
sedata size with the old one.
Ivan Shcheklein,
Sedna Team
On Fri, Feb 15, 2013 at 1:16 PM, Robby Pelssers <[email protected]>wrote:
> Hi all,
>
> Seems like some files are growing out of proportion for the database nxp.
> It kind of surprises me as I don't expect we have that much data. But to
> find a possible bottleneck or get more insight into which collection might
> be this big, how can I get some statistics? And I guess we can't clean up
> one of these files, right?
>
> Thx in advance,
> Robby
>
>
>
> drwxr-xr-x 2 pxprod1 spider 4096 Feb 15 05:40 ./
> drwxr-xr-x 3 pxprod1 spider 983040 Feb 15 08:59 ../
> -rw-rw---- 1 pxprod1 spider 1313106 Feb 15 10:04 nxp.15516.llog
> -rw-rw---- 1 pxprod1 spider 15309275136 Feb 15 10:04 nxp.sedata
> -rw-rw---- 1 pxprod1 spider 31352422400 Feb 15 10:08 nxp.setmp
> pxprod1@nlscli71:/appl/spider_prod/sedna/pxprod1/sedna35/data/nxp_files>
>
>
> pxprod1@nlscli71:/appl/spider_prod/sedna/pxprod1/sedna35/data/nxp_files>du
> -hs *
> 1.3M nxp.15516.llog
> 15G nxp.sedata
> 41G nxp.setmp
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Sedna-discussion mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
