<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_7544" dir="ltr"><span id="yui_3_16_0_1_1421832646696_7638">Ok guys ALL OK.</span></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><span>I have:</span></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><span><br></span></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><span id="yui_3_16_0_1_1421832646696_7593">1. Dropped the Database</span></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><span id="yui_3_16_0_1_1421832646696_7634">2. Recreated an empty new Database</span></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><span id="yui_3_16_0_1_1421832646696_7635">3. Enabled again the DB into the file </span>local/DXVars.pm</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr">4. Rebooted the Server</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr">5. At the boot the Cluster will create the Table into Database and populate it</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr">6. I waited until it finished</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr">7. Rebooted the Server again</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr">8. All OK!</div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"><br></div><div id="yui_3_16_0_1_1421832646696_7544" dir="ltr"> <br></div><div class="signature" id="yui_3_16_0_1_1421832646696_7547"><div id="yui_3_16_0_1_1421832646696_7546">73</div><div id="yui_3_16_0_1_1421832646696_7548">Fabio, IZ8MBW</div><div id="yui_3_16_0_1_1421832646696_7587">www.iz8mbw.net</div><div id="yui_3_16_0_1_1421832646696_7549"><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_7553"> <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_7552"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1421832646696_7551"> <div dir="ltr" id="yui_3_16_0_1_1421832646696_7550"> <hr size="1"> <font size="2" face="Arial" id="yui_3_16_0_1_1421832646696_7658"> <b><span style="font-weight:bold;">Da:</span></b> IZ8MBW Fabio <iz8mbw@yahoo.it><br> <b><span style="font-weight: bold;">A:</span></b> "dxspider-support@dxcluster.org" <dxspider-support@dxcluster.org> <br> <b><span style="font-weight: bold;">Inviato:</span></b> Mercoledì 21 Gennaio 2015 10:31<br> <b><span style="font-weight: bold;">Oggetto:</span></b> Re: [Dxspider-support] MySQL Help<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1421832646696_7556"><br><div id="yiv9942317497"><div id="yui_3_16_0_1_1421832646696_7555"><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;" id="yui_3_16_0_1_1421832646696_7554"><div id="yiv9942317497yui_3_16_0_1_1421832646696_2964"><span class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;">Hi Dirk,</span><br clear="none" class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;"><span class="yiv9942317497" id="yiv9942317497yui_3_16_0_1_1421832646696_2963" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;">the first time I waited for full DB import, the problem come up at the next reboot.</span><br clear="none" class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;"><span class="yiv9942317497" id="yiv9942317497yui_3_16_0_1_1421832646696_2965" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;">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 clear="none" class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;"><span class="yiv9942317497" id="yiv9942317497yui_3_16_0_1_1421832646696_2966" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;">Then I will reboot again and I will infirm you about what happens.</span><br clear="none" class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;"><br clear="none" class="yiv9942317497" style="font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:13px;"><br clear="none"></div><div class="yiv9942317497signature" id="yiv9942317497yui_3_16_0_1_1421832646696_2941"><div id="yiv9942317497yui_3_16_0_1_1421832646696_2944">73</div><div id="yiv9942317497yui_3_16_0_1_1421832646696_2943">Fabio, IZ8MBW</div><div id="yiv9942317497yui_3_16_0_1_1421832646696_2942">www.iz8mbw.net</div><div id="yiv9942317497yui_3_16_0_1_1421832646696_2940"><br clear="none"></div></div><br clear="none"> <div class="qtdSeparateBR"><br><br></div><div class="yiv9942317497yqt3024432343" id="yiv9942317497yqt92786"><blockquote id="yiv9942317497yui_3_16_0_1_1421832646696_2939" style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;margin-top:5px;padding-left:5px;"> <div id="yiv9942317497yui_3_16_0_1_1421832646696_2938" style="font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div id="yiv9942317497yui_3_16_0_1_1421832646696_2937" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr" id="yiv9942317497yui_3_16_0_1_1421832646696_2936"> <hr size="1"> <font id="yiv9942317497yui_3_16_0_1_1421832646696_2935" size="2" face="Arial"> <b><span style="font-weight:bold;">Da:</span></b> Dirk Koopman <djk@tobit.co.uk><br clear="none"> <b><span style="font-weight:bold;">A:</span></b> IZ8MBW Fabio <iz8mbw@yahoo.it>; The DXSpider Support list <dxspider-support@dxcluster.org> <br clear="none"> <b id="yiv9942317497yui_3_16_0_1_1421832646696_3115"><span id="yiv9942317497yui_3_16_0_1_1421832646696_3114" style="font-weight:bold;">Inviato:</span></b> Martedì 20 Gennaio 2015 19:31<br clear="none"> <b id="yiv9942317497yui_3_16_0_1_1421832646696_3113"><span id="yiv9942317497yui_3_16_0_1_1421832646696_3112" style="font-weight:bold;">Oggetto:</span></b> Re: [Dxspider-support] MySQL Help<br clear="none"> </font> </div> <div class="yiv9942317497y_msg_container" id="yiv9942317497yui_3_16_0_1_1421832646696_3111"><br clear="none">On 20/01/15 14:33, IZ8MBW Fabio wrote:<div class="yiv9942317497qtdSeparateBR"><br clear="none"><br clear="none"></div><div class="yiv9942317497yqt2540120340" id="yiv9942317497yqtfd05496"><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="yiv9942317497yqt2540120340" id="yiv9942317497yqtfd93063"><br clear="none"></div><br clear="none"><br clear="none"></div> </div> </div> </blockquote></div> </div></div></div><br><br></div> </div> </div> </blockquote> </div></body></html>