<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1421832646696_2964"><span style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class="">Hi Dirk,</span><br style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class=""><span style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class="" id="yui_3_16_0_1_1421832646696_2963">the first time I waited for full DB import, the problem come up at the next reboot.</span><br style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class=""><span style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class="" id="yui_3_16_0_1_1421832646696_2965">Anyway I will drop the table then I will enable once again your DB interface then I will reboot to start again the DB import.</span><br style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class=""><span style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class="" id="yui_3_16_0_1_1421832646696_2966">Then I will reboot again and I will infirm you about what happens.</span><br style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class=""><br style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class=""><br></div><div class="signature" id="yui_3_16_0_1_1421832646696_2941"><div id="yui_3_16_0_1_1421832646696_2944">73</div><div id="yui_3_16_0_1_1421832646696_2943">Fabio, IZ8MBW</div><div id="yui_3_16_0_1_1421832646696_2942">www.iz8mbw.net</div><div id="yui_3_16_0_1_1421832646696_2940"><br></div></div><br> <blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;" id="yui_3_16_0_1_1421832646696_2939"> <div style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1421832646696_2938"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1421832646696_2937"> <div dir="ltr" id="yui_3_16_0_1_1421832646696_2936"> <hr size="1"> <font size="2" face="Arial" id="yui_3_16_0_1_1421832646696_2935"> <b><span style="font-weight:bold;">Da:</span></b> Dirk Koopman <djk@tobit.co.uk><br> <b><span style="font-weight: bold;">A:</span></b> IZ8MBW Fabio <iz8mbw@yahoo.it>; The DXSpider Support list <dxspider-support@dxcluster.org> <br> <b id="yui_3_16_0_1_1421832646696_3115"><span style="font-weight: bold;" id="yui_3_16_0_1_1421832646696_3114">Inviato:</span></b> Martedì 20 Gennaio 2015 19:31<br> <b id="yui_3_16_0_1_1421832646696_3113"><span style="font-weight: bold;" id="yui_3_16_0_1_1421832646696_3112">Oggetto:</span></b> Re: [Dxspider-support] MySQL Help<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1421832646696_3111"><br>On 20/01/15 14:33, IZ8MBW Fabio wrote:<div class="qtdSeparateBR"><br><br></div><div class="yqt2540120340" id="yqtfd05496"><br clear="none">> Hi,<br clear="none">> I also tried to set the MySQL DB by enable it in the local/DXVars.pm, I<br clear="none">> was able to use it.<br clear="none">> The main "problem" is that when the Cluster start the first time it will<br clear="none">> go to create the "spot" table and then to populate it....<br clear="none">> Less then 3 months of running Cluster are equivalent about 680000 rows<br clear="none">> in the DB.... and if you will go to reboot the Cluster, it will try<br clear="none">> again to populate the DB (ignoring the duplicates) with a very high CPU<br clear="none">> utilization.</div><br clear="none"><br clear="none">This should not happen.<br clear="none"><br clear="none">The way it works is that on start up (Spot::init) if there is a database <br clear="none">defined in DXVars.pm, then the routine will search for a spot table. If <br clear="none">there is one already, then it will just exit this routine and and normal <br clear="none">operations should occur.<br clear="none"><br clear="none">Furthermore, when it is loading up the database on first startup, each <br clear="none">spot file is treated as one transaction. So if you interrupt it, <br clear="none">provided at least one spot file has been added, the spot table will <br clear="none">still be there on the next startup and no further spots should be added <br clear="none">by the Spot::init routine. However, a downside of interrupting the <br clear="none">initial load is that the indexes won't be created and any resulting <br clear="none">search will be slower.<br clear="none"><br clear="none">I think there is enough experience out there (apart from mine) to <br clear="none">suggest that this system works as I intended and you should maybe look <br clear="none">at your mysql configuration (and firewall?) and also allow the process <br clear="none">to come to completion.<br clear="none"><br clear="none">Dirk<div class="yqt2540120340" id="yqtfd93063"><br clear="none"></div><br><br></div> </div> </div> </blockquote> </div></body></html>