Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   Queue messages - DB (http://www.mirthcorp.com/community/forums/showthread.php?t=217285)

AlexNeiva 06-19-2017 09:04 AM

Queue messages - DB
 
Hello,

i have a question regarding the DB increasing size.
DB that i use is postgres and my question is:
If i have 300k queued messages in one Mirth channel, did this increase, like a lot, the DB rows/DISK space?
I have a mirth engine that process a lot of messages per day, is there some routines or some maintenance jobs that we can perform in order to the disk space not increase or just to maintain.

Thank you

kirbykn2 06-19-2017 10:01 AM

Depending on how you have your environment configured, having 300K queued messages can increase the DB size.

Search the forum for Data Pruner and Message Pruning

AlexNeiva 06-19-2017 10:14 AM

Thanks for the reply.
Regarding the Data Pruner i have it running every day!
I don't know for sure if it is correct apply those settings in the pruner option.
Even if data pruner runs every day, did it delete the pruner rows or just mark them as deleted? Did i need to run the vaccum tool from postgres engine?

Best Regards

kirbykn2 06-19-2017 10:28 AM

What do you set "Message Pruning" too in your channels?

AlexNeiva 06-19-2017 01:15 PM

The Data Pruner Settings are:

Schedule: Daily
Block Size: 1000
Prune Events: Yes
Prune Event Age: 90 days

Any suggestion?

Thanks

kirbykn2 06-19-2017 01:17 PM

In your channels, on the Summary tab, what do you have configured for Message Pruning.

AlexNeiva 06-19-2017 01:19 PM

Ah sorry...

Metadata:
Prune metadata older than 365 days

Content:
Prune when message metadata is removed

kirbykn2 06-19-2017 01:21 PM

How long have your channels been processing messages?

AlexNeiva 06-19-2017 01:22 PM

6 Month

kirbykn2 06-19-2017 01:27 PM

:):):):):)

If you have Message Pruning set to 365 days, and the channel has been running for 6 months, the db will continue to grow for another 6 months. Once you go past the 365 day setting that you established, the db should stop growing.

If you don't need to keep the messages in Mirth for 365 days, you can adjust your Message Pruning down. You can archive the messages at part of the pruning process.

Its dependent on your needs, but usually 2 weeks to a month is the max I keep in Mirth. Everything else is archived.


All times are GMT -8. The time now is 04:34 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation