https://www.ejabberd.im/node/4215 en https://www.ejabberd.im/node/4215#comment-56525 <div class="quote-msg"> <div class="quote-author"><em>ragelink</em> wrote:</div> <p>The problem is a few weeks ago our server was reaching 1.8GBs on one of its tables (offline_messages) and the problem is that a few weeks ago I checked again and the table (file) was 600MBs big. Anyone know what happens when you reach the limit? does the table recycle itself and starts from scratch, does it crash? does it do some sort of cleaning or maintenance? I appreciate any insight you have on what may have happened. </p></div> <p>There may be some limits in Erlang, but probably your machine will run out of RAM and virtual RAM before those software limits are reached. The erlang node crashes and leaves a big erl_crash.dump</p> <div class="quote-msg"> <div class="quote-author"><em>ragelink</em> wrote:</div> <p>We run a big chat implementation with ejabberd, the storage engine we're using is mnesia </p></div> <p>Mnesia is acceptable for small deployments, but it isn't suitable for big ones. Switch your data to MySQL or PostgreSQL.</p> <div class="quote-msg"> <div class="quote-author"><em>ragelink</em> wrote:</div> <p>the second part to this question is I was hoping to migrate to MySQL as the backend database so we can store more messages, but we dont want to lose any any messages in the process </p></div> <p>Install mod_admin_extra, then run the ejabberdctl command export2odbc. It generates SQL files of some of your existing Mnesia tables.</p> Mon, 23 Aug 2010 22:55:21 +0000 mfoss comment 56525 at https://www.ejabberd.im