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

Reply via email to