web stats
Mirth Table Growing - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2018, 12:34 AM
mmirth mmirth is offline
Mirth Newb
 
Join Date: Sep 2018
Posts: 9
mmirth is on a distinguished road
Question Mirth Table Growing

Hello everybody,

I have realized that my database is growing very fast very large, then I looked at it closer I found that the mirth tables are too large. Especially:

-> dbo.D_MM1
-> dbo.D_M1
-> dbo.DMCM1

is there a way to prevent this table to grow so fast ? Because I didnīt found a swith that would simply turn the unneeded mirth tables off.

Thanks in advance

mmirth
Reply With Quote
  #2  
Old 11-16-2018, 04:11 AM
srini,chillara srini,chillara is offline
Mirth Newb
 
Join Date: Dec 2008
Posts: 11
srini,chillara
Default

you should set pruning correctly. Or if you don't need these messages then you can clean the channels by removing all the messages and then compact the DB.
Reply With Quote
  #3  
Old 11-16-2018, 04:43 AM
mmirth mmirth is offline
Mirth Newb
 
Join Date: Sep 2018
Posts: 9
mmirth is on a distinguished road
Default

Thank you for you reply,

did you mean right click on the chanel and "Clean Statistics" and then "Invert Selection" ?
Attached Images
File Type: png mirth.png (5.8 KB, 10 views)
Reply With Quote
  #4  
Old 11-16-2018, 04:45 AM
mmirth mmirth is offline
Mirth Newb
 
Join Date: Sep 2018
Posts: 9
mmirth is on a distinguished road
Default

My pruning options are set as in this picture. Is this the problem ?
Reply With Quote
  #5  
Old 11-16-2018, 04:46 AM
mmirth mmirth is offline
Mirth Newb
 
Join Date: Sep 2018
Posts: 9
mmirth is on a distinguished road
Default

sorry this picture
Attached Images
File Type: png mirth_question2.png (56.1 KB, 21 views)

Last edited by mmirth; 11-16-2018 at 04:49 AM.
Reply With Quote
  #6  
Old 11-16-2018, 07:44 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 956
agermano is on a distinguished road
Default

Under settings there is a Data Pruner tab. You have to enable it to run on a schedule, and then it will follow the settings you have set on your channels.

On that settings screen, there is also a "Prune Now" option on the left side-bar menu.

Just pruning by itself won't make your on-disk files smaller, but it will free up the space within the files for reuse so they are unlikely to grow further.
Reply With Quote
  #7  
Old 11-19-2018, 07:26 PM
hgdevanand hgdevanand is offline
OBX.1 Kenobi
 
Join Date: Apr 2015
Posts: 26
hgdevanand is on a distinguished road
Default

Hi,

Once you set the pruning and database size still doesn't decrease, then please refer to below mentioned thread in the forum

http://www.mirthproject.org/communit...741#post264741


Regards,
Dev
Reply With Quote
  #8  
Old 01-21-2019, 05:08 AM
mmirth mmirth is offline
Mirth Newb
 
Join Date: Sep 2018
Posts: 9
mmirth is on a distinguished road
Default Thank you very much.

I found the tab "Data Pruner" and will try it. Does this data pruner clean the database ?

I Thank all of you very much.
Reply With Quote
Reply

Tags
dbo, ms-sql, mssql

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 02:43 AM.


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