Ask the Community
Groups
Tip: How Do I optimize the DGE Database - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>PROBLEM:</strong></p> <p>If there are "gaps" in the test charts (see example error below), it is likely that the database needs to be optimized.</p> <p><strong>SOLUTION:</strong></p> <p>Please also note that it is highly recommended that the below procedure is run after a database repair (db_repir.sh or db_repair.cmd). <strong>The MySQL DB (Performance and Event Database) must be running to perform an optimization.</strong></p> <p>To do so where <TRAVERSE_HOME> is the Traverse installation directory.</p> <p>(Windows)</p> <div> <pre class="code codeBlock" spellcheck="false" tabindex="0"> cd <TRAVERSE_HOME> utils\db_optimize.pl --run </pre> </div> <p> </p> <p>(Linux)</p> <div> <pre class="code codeBlock" spellcheck="false" tabindex="0"> cd <TRAVERSE_HOME>utils/db_optimize.pl --run </pre> </div> <p> </p> <p>********</p> <p>one may see an error message such as the below:</p> <p>2014-11-08 07:02:07,703 m.MonitorServer[Monitor Server]: (ERROR\) Warning: too many elements on aggregation-writer Queue: 157993 elements with 39158 testConfigs, clearing out queue</p> <p> </p> <p><strong>RELATED ARTICLES:</strong></p> <p><a rel="nofollow" href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/hc/en-gb/articles/229041468-How-Do-I-Repair-An-Error-with-a-Traverse-Database">How Do I Repair An Error With A Traverse Database</a></p> </article> </main>