[Dxspider-support] MySQL Help

[Dirk Koopman]

On 20/01/15 14:33, IZ8MBW Fabio wrote:
> Hi,
> I also tried to set the MySQL DB by enable it in the local/DXVars.pm, I
> was able to use it.
> The main "problem" is that when the Cluster start the first time it will
> go to create the "spot" table and then to populate it....
> Less then 3 months of running Cluster are equivalent about 680000 rows
> in the DB.... and if you will go to reboot the Cluster, it will try
> again to populate the DB (ignoring the duplicates) with a very high CPU
> utilization.

This should not happen.

The way it works is that on start up (Spot::init) if there is a database 
defined in DXVars.pm, then the routine will search for a spot table. If 
there is one already, then it will just exit this routine and and normal 
operations should occur.

Furthermore, when it is loading up the database on first startup, each 
spot file is treated as one transaction. So if you interrupt it, 
provided at least one spot file has been added, the spot table will 
still be there on the next startup and no further spots should be added 
by the Spot::init routine. However, a downside of interrupting the 
initial load is that the indexes won't be created and any resulting 
search will be slower.

I think there is enough experience out there (apart from mine) to 
suggest that this system works as I intended and you should maybe look 
at your mysql configuration (and firewall?) and also allow the process 
to come to completion.

Dirk