web stats
Queue messages - DB - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2017, 10:04 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Exclamation 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
Reply With Quote
  #2  
Old 06-19-2017, 11:01 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 586
kirbykn2 is on a distinguished road
Default

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
__________________
Best,

Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.4
Mirth Connect Version 3.8.0
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_181-b13
PostgreSQL Version 9.6.8
Reply With Quote
  #3  
Old 06-19-2017, 11:14 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 06-19-2017, 11:28 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 586
kirbykn2 is on a distinguished road
Default

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

Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.4
Mirth Connect Version 3.8.0
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_181-b13
PostgreSQL Version 9.6.8
Reply With Quote
  #5  
Old 06-19-2017, 02:15 PM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Default

The Data Pruner Settings are:

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

Any suggestion?

Thanks
Reply With Quote
  #6  
Old 06-19-2017, 02:17 PM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 586
kirbykn2 is on a distinguished road
Default

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

Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.4
Mirth Connect Version 3.8.0
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_181-b13
PostgreSQL Version 9.6.8
Reply With Quote
Reply

Tags
database increase, disk space, postgres, queue, queued messages

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 09:16 PM.


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