Hilfe: Datenbank sehr groß

define('BO_STATION_STAT_DISABLE', true);


define('BO_PURGE_SIG_NS', 24);     //signals with no strike assigned        
define('BO_PURGE_SIG_ALL', 192);   //all signals
define('BO_PURGE_STR_NP', 240);      //strikes not participated
define('BO_PURGE_STR_ALL', 0);     //all strikes
define('BO_PURGE_STR_DIST', 0);    //strikes farther than BO_PURGE_STR_DIST_KM
define('BO_PURGE_STRSTA_ALL', 24); //strike <-> stations table (very important!)
define('BO_PURGE_STA_OTHER',  96); //station statistics: other (not yours)
define('BO_PURGE_STA_ALL', 0);     //station statistics: all


//completely enable/disable
define('BO_PURGE_ENABLE', true);


//main interval in hours
define('BO_PURGE_MAIN_INTVL', 6);

2016-02-12 18:25:03 +    0ms |  
2016-02-12 18:25:03 +    0ms | ***** Getting lightning data from blitzortung.org *****
2016-02-12 18:25:03 +    0ms |  
2016-02-12 18:25:03 +   10ms | Information: PHP Execution timeout is 30s  --> Fine :) *** Setting MyBlitzortung timeout to: 55s
2016-02-12 18:25:03 +   17ms |  
2016-02-12 18:25:03 +   17ms | === Purging data ===
2016-02-12 18:25:03 +   37ms | Raw signals (with no strikes assigned): 0
2016-02-12 18:25:03 +   37ms | Raw signals: 0


Database Query Error:


The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay


 


for query
 


DELETE a,b FROM mybo_strikes a, mybo_stations_strikes b
						WHERE time < '2016-02-02 17:25:03' AND a.id=b.strike_id AND part=0