web stats
Message pruning in Mirth (3.5.1) - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2018, 09:41 PM
hgdevanand hgdevanand is offline
OBX.1 Kenobi
 
Join Date: Apr 2015
Posts: 26
hgdevanand is on a distinguished road
Default Message pruning in Mirth (3.5.1)

Hi All,

I have set pruning in settings for 1 day (as there is too much of data in a day).
Schedule to run the pruner is set for 1 AM.

I need to understand what happens when pruner runs in little detail.

I have below understanding of pruner theoretically
It deletes all saved messages in channel as per the "prune data older than settings" set inside channels.

Practically when i run it:-

It does not reduce the size of Mirth DB immediately, In fact it increases it slightly. Why database is not reduced as soon as the pruning runs ?

Regards,
Dev
Reply With Quote
  #2  
Old 09-05-2018, 01:16 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Default

Hello,


datapruner does not release the space in the DB, to do that after the pruning you need to perform/run "Vacuum" (Postgres) or "Shrink" (SQL Server) in Oracle i don't know.
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #3  
Old 09-05-2018, 01:39 AM
hgdevanand hgdevanand is offline
OBX.1 Kenobi
 
Join Date: Apr 2015
Posts: 26
hgdevanand is on a distinguished road
Default

what!!!!!

wooo...thanks a lot for the input, that was a news for me.
But why cant Mirth itself do a vacuum/shrink right after it prunes ?


Regards,
Dev
Reply With Quote
  #4  
Old 09-05-2018, 01:54 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Default

Hello,


i don't really know why but i know that because i saw that in the forum one time.
That is why Mirth advice to set autovacuum ON in server productions:
http://www.mirthcorp.com/community/w...production+use


I guess this a DB "thing" and can not be considered a "issue/problem" in Mirth... from my point of view i thing this is DB management.
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #5  
Old 09-05-2018, 06:10 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 857
agermano is on a distinguished road
Default

It's normally bad practice to shrink a db if it is expected to grow right back to where it was before you shrunk it. The database will reuse the space within the file that was freed before it makes the file larger.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 06:49 AM.


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