Thanks, I finally figured this out thanks to help from ML support. Problem was I had a "forgotten" forest lying around unattached to any DB with huge amounts of data in it (18 million documents). Since it doesnt show up in the database space I couldnt account for the key space used. Deleting it and I'm down to 2.5% which is much more realistic.
Thanks for the suggestions ! ( and hint for newbies ... unattached forests still count towards license use !) ---------------------------------------- David A. Lee Senior Principal Software Engineer Epocrates, Inc. d...@epocrates.com<mailto:d...@epocrates.com> 812-482-5224 From: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] On Behalf Of Danny Sokolsky Sent: Thursday, September 22, 2011 4:09 PM To: General MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] License "key" space usage question Hi David, Do you have a lot of deleted fragments? Trailing wildcards and range indexes can use quite a bit of space; the amount of space they use is pretty application specific, so it is hard to say what a "normal" factor is. For example, if you have small xml documents with lots of unique values on an element for which you have a range index, that would take up a lot more space than a range index on an element that only had 10 unique values. The license looks at the space used by all of the databases on your system, and so the factors you mention do not sound that out of line. If you do have a lot of deleted fragments, then you can do a full merge to get rid of them. At some point, the db would do that merge on its own, but you can force it to do so. You can look on the database status page or in the status built-ins to see the deleted fragment count. -Danny From: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] On Behalf Of Lee, David Sent: Thursday, September 22, 2011 1:00 PM To: General Mark Logic Developer Discussion (general@developer.marklogic.com) Subject: [MarkLogic Dev General] License "key" space usage question I have a license which grants me 40GB of "license key space". I have about 150,000 xml documents total of less than 2GB data loaded and the manager is showing me "47.3% license key space used". This seems very odd ... I know key space can exceed actual storage space but this seems about 10x off. I have very few indexing options enabled - all the stemming off and only trailing wildcards on. I do have a few range indexes but this seems very odd. Is there any diagnostics or tools to run which shows where this space is going ? I can't find anything on either the manager app or the API docs which tell where "key" space is accounted for. Suggestions welcome ! Thanks. ---------------------------------------- David A. Lee Senior Principal Software Engineer Epocrates, Inc. d...@epocrates.com<mailto:d...@epocrates.com> 812-482-5224
_______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general