Hi Ivan,
Thx for the quick reply. I was looking into the admin guide
http://www.sedna.org/adminguide/AdminGuidesu3.html and noticed that it’s
possible to set the max file size during creation. That would probably be a
safer future proof way to prevent our disk from filling up. But what would be
the scenario to accomplish this as our database is obviously already created.
I just want to make sure I don’t miss out on anything here as obviously we want
the data, xquery libraries and indexes to be fully restored after this
procedure.
Robby
From: Ivan Shcheklein [mailto:shchekl...@gmail.com]
Sent: Friday, February 15, 2013 10:23 AM
To: Robby Pelssers
Cc: sedna-discussion@lists.sourceforge.net
Subject: Re: [Sedna-discussion] question regarding data files [extremely big]
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
<robby.pelss...@nxp.com<mailto:robby.pelss...@nxp.com>> 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
Sedna-discussion@lists.sourceforge.net<mailto:Sedna-discussion@lists.sourceforge.net>
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
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion