[MarkLogic Dev General] Decreased performance after reindexing database in MarkLogic 3.2
mike at blakeley.com
Sun Nov 13 14:29:05 PST 2011
I can make a couple of observations that are valid for every version of MarkLogic Server to date:
* The changes to in-memory tree size and in-memory range index size were not a good idea. Higher limits mean larger in-memory stands, which will increase memory utilization. That is not likely to improve performance, and may well hurt performance. I would undo those changes.
* The increased database size and memory utilization probably indicate a large number of deleted fragments, which should be visible on the database status page. Merge the database to get rid of those.
3.2 is indeed very old now, and I would recommend upgrading as quickly as is practical. Note that upgrading will require more reindexing. So I would defer the full merge, recommended above, until after that upgrade is complete.
On 13 Nov 2011, at 12:32 , Eric Bloch wrote:
> I believe a formal end-of-life notice has been given for MarkLogic 3.2.
> Eric Bloch
> eric.bloch at marklogic.com
> On Nov 13, 2011, at 11:11 AM, Mariano Grau Calín wrote:
>> Hi all:
>> We had to reindexing/refragmenting the database because searchs by trailing date not working.
>> The new documents was not indexed by date. After reindexing (the operation takes 40 hours), all works fine. However, searchs by text that previously took less than a second, now takes between five and ten seconds. Also, database size increased 30 GB.
>> The database has 12,5 millions documents and 140 GB in two forests. Run on hp DL385 AMD 64bits Quad Core 2,2 Ghz, 16 GB RAM and one disk 250 GB raid 1 on EVA8000. The operating system is Windows 2003 Standard Edition SP2 and MarkLogic Server 3.2.
>> We modified parameters database for improving performance, now Marklogic process in memory is 12 GB (before 9,5GB), with not sucess.
>> Before After
>> in memory limit 524288 1048576
>> in memory list size 1024 1024 (máx.)
>> in memory tree size 256 1024
>> in memory range index size 16 64 (máx.)
>> We hope to improve the performance without to buy new hardware and licens.
>> Thanks and regards,
>> Mariano Grau
>> Dpto. Systems
>> Grupo Joly
>> General mailing list
>> General at developer.marklogic.com
> General mailing list
> General at developer.marklogic.com
More information about the General