MarkLogic - Database size units2019 Community Moderator ElectionSearching Binary files in marklogicHierarchical directory structure in marklogicMarkLogic clustering, after the factMarkLogic SQL Collation not usedIssue with NEAR query in MarklogicHow to insert empty values into Marklogic databaseReactive approach of Marklogic databaseImpact of increased queue size in Marklogic task serverMarkLogic ErrorLogs- Slow background cluster logsMarkLogic - xdmp.save
Does the US political system, in principle, allow for a no-party system?
Unidentified signals on FT8 frequencies
How to install "rounded" brake pads
Draw this image in the TIKZ package
Can Witch Sight see through Mirror Image?
Tabular environment - text vertically positions itself by bottom of tikz picture in adjacent cell
I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?
Unfamiliar notation in Diabelli's "Duet in D" for piano
Professor forcing me to attend a conference, I can't afford even with 50% funding
Why do we say 'Pairwise Disjoint', rather than 'Disjoint'?
A vote on the Brexit backstop
Will the concrete slab in a partially heated shed conduct a lot of heat to the unconditioned area?
Does an unused member variable take up memory?
Should we avoid writing fiction about historical events without extensive research?
Having the player face themselves after the mid-game
ESPP--any reason not to go all in?
How to distinguish easily different soldier of ww2?
Short story about an infectious indestructible metal bar?
Where is the License file location for Identity Server in Sitecore 9.1?
Interpretation of linear regression interaction term plot
Is it appropriate to ask a former professor to order a library book for me through ILL?
How do you make a gun that shoots melee weapons and/or swords?
Propulsion Systems
How does learning spells work when leveling a multiclass character?
MarkLogic - Database size units
2019 Community Moderator ElectionSearching Binary files in marklogicHierarchical directory structure in marklogicMarkLogic clustering, after the factMarkLogic SQL Collation not usedIssue with NEAR query in MarklogicHow to insert empty values into Marklogic databaseReactive approach of Marklogic databaseImpact of increased queue size in Marklogic task serverMarkLogic ErrorLogs- Slow background cluster logsMarkLogic - xdmp.save
I am using below query to return the size of each database in MarkLogic server. The query is returning data but not sure what units (KB/MB/GB etc) the query is returning. I tried to find approximate size of each collection manually to add up, but somehow the numbers are not matching. Does MarkLogic apply compression by default on the documents?
xquery version "1.0-ml";
declare namespace forest = "http://marklogic.com/xdmp/status/forest";
for $db-id in xdmp:databases()
let $db-name := xdmp:database-name($db-id)
let $db-size :=
fn:sum(
for $f-id in xdmp:database-forests($db-id)
let $f-status := xdmp:forest-status($f-id)
let $space := $f-status/forest:device-space
let $f-name := $f-status/forest:forest-name
let $f-size :=
fn:sum(
for $stand in $f-status/forest:stands/forest:stand
let $stand-size := $stand/forest:disk-size/fn:data(.)
return $stand-size
)
return $f-size
)
order by $db-size descending
return $db-name || " = " || $db-size
marklogic-9
add a comment |
I am using below query to return the size of each database in MarkLogic server. The query is returning data but not sure what units (KB/MB/GB etc) the query is returning. I tried to find approximate size of each collection manually to add up, but somehow the numbers are not matching. Does MarkLogic apply compression by default on the documents?
xquery version "1.0-ml";
declare namespace forest = "http://marklogic.com/xdmp/status/forest";
for $db-id in xdmp:databases()
let $db-name := xdmp:database-name($db-id)
let $db-size :=
fn:sum(
for $f-id in xdmp:database-forests($db-id)
let $f-status := xdmp:forest-status($f-id)
let $space := $f-status/forest:device-space
let $f-name := $f-status/forest:forest-name
let $f-size :=
fn:sum(
for $stand in $f-status/forest:stands/forest:stand
let $stand-size := $stand/forest:disk-size/fn:data(.)
return $stand-size
)
return $f-size
)
order by $db-size descending
return $db-name || " = " || $db-size
marklogic-9
add a comment |
I am using below query to return the size of each database in MarkLogic server. The query is returning data but not sure what units (KB/MB/GB etc) the query is returning. I tried to find approximate size of each collection manually to add up, but somehow the numbers are not matching. Does MarkLogic apply compression by default on the documents?
xquery version "1.0-ml";
declare namespace forest = "http://marklogic.com/xdmp/status/forest";
for $db-id in xdmp:databases()
let $db-name := xdmp:database-name($db-id)
let $db-size :=
fn:sum(
for $f-id in xdmp:database-forests($db-id)
let $f-status := xdmp:forest-status($f-id)
let $space := $f-status/forest:device-space
let $f-name := $f-status/forest:forest-name
let $f-size :=
fn:sum(
for $stand in $f-status/forest:stands/forest:stand
let $stand-size := $stand/forest:disk-size/fn:data(.)
return $stand-size
)
return $f-size
)
order by $db-size descending
return $db-name || " = " || $db-size
marklogic-9
I am using below query to return the size of each database in MarkLogic server. The query is returning data but not sure what units (KB/MB/GB etc) the query is returning. I tried to find approximate size of each collection manually to add up, but somehow the numbers are not matching. Does MarkLogic apply compression by default on the documents?
xquery version "1.0-ml";
declare namespace forest = "http://marklogic.com/xdmp/status/forest";
for $db-id in xdmp:databases()
let $db-name := xdmp:database-name($db-id)
let $db-size :=
fn:sum(
for $f-id in xdmp:database-forests($db-id)
let $f-status := xdmp:forest-status($f-id)
let $space := $f-status/forest:device-space
let $f-name := $f-status/forest:forest-name
let $f-size :=
fn:sum(
for $stand in $f-status/forest:stands/forest:stand
let $stand-size := $stand/forest:disk-size/fn:data(.)
return $stand-size
)
return $f-size
)
order by $db-size descending
return $db-name || " = " || $db-size
marklogic-9
marklogic-9
asked 2 days ago
BhanuBhanu
1786
1786
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The measure of unit shown in Admin UI on the Cluster Status page is always MB, and the numbers shown there match what your code returns.
MarkLogic doesn't really apply compression, but it does have complex logic to take data, and structure information apart for each document. There is some gain when you have repetition in your documents. The more repetition, which also includes element names, the larger the difference.
HTH!
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55027537%2fmarklogic-database-size-units%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The measure of unit shown in Admin UI on the Cluster Status page is always MB, and the numbers shown there match what your code returns.
MarkLogic doesn't really apply compression, but it does have complex logic to take data, and structure information apart for each document. There is some gain when you have repetition in your documents. The more repetition, which also includes element names, the larger the difference.
HTH!
add a comment |
The measure of unit shown in Admin UI on the Cluster Status page is always MB, and the numbers shown there match what your code returns.
MarkLogic doesn't really apply compression, but it does have complex logic to take data, and structure information apart for each document. There is some gain when you have repetition in your documents. The more repetition, which also includes element names, the larger the difference.
HTH!
add a comment |
The measure of unit shown in Admin UI on the Cluster Status page is always MB, and the numbers shown there match what your code returns.
MarkLogic doesn't really apply compression, but it does have complex logic to take data, and structure information apart for each document. There is some gain when you have repetition in your documents. The more repetition, which also includes element names, the larger the difference.
HTH!
The measure of unit shown in Admin UI on the Cluster Status page is always MB, and the numbers shown there match what your code returns.
MarkLogic doesn't really apply compression, but it does have complex logic to take data, and structure information apart for each document. There is some gain when you have repetition in your documents. The more repetition, which also includes element names, the larger the difference.
HTH!
answered yesterday
grtjngrtjn
15.8k11830
15.8k11830
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55027537%2fmarklogic-database-size-units%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown