boost plugin causing serious problems

[saryas]

hello,

i just enabled the boost plugin for cacti and it is causing alot of problems:
the graphs are no longer being updated plus i have the following lines in my cacti log file:

05/04/2010 03:31:13 PM - SYSTEM THOLD STATS: Time:0.1347 Tholds:48 Hosts:0
05/04/2010 03:31:13 PM - THOLD: Threshold Breached ID: 40 DataTemplate: Eltek - AC Voltage 1 DataSource: ACVoltage1 Type: High/Low Enabled: on Current: 0 High: Low: 180 Trigger: 5 Minutes SentTo:
05/04/2010 03:31:13 PM - SYSTEM STATS: Time:12.2866 Method:spine Processes:3 Threads:10 Hosts:89 HostsPerProcess:30 DataSources:4729 RRDsProcessed:0
05/04/2010 03:31:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO poller_output_boost (local_data_id, rrd_name, time, output) VALUES ('1266','traffic_out','2010-05-04 15:31:02','2169158211'), ('1266','traffic_in','2010-05-04 15:31:02','2164917299'), ('1265','traffic_out','2010-05-04 15:31:02','1213090552'), ('1265','traffic_in','2010-05-04 15:31:02','2003201068'), ('1264','traffic_out','2010-05-04 15:31:02','2629462788'), ('1264','traffic_in','2010-05-04 15:31:02','1993923835'), ('1263','traffic_out','2010-05-04 15:31:02','778092147'), ('1263','traffic_in','2010-05-04 15:31:02','4073594409'), ('1262','traffic_out','2010-05-04 15:31:02','781715965'), ('1262','traffic_in','2010-05-04 15:31:02','397218859'), ('1261','traffic_out','2010-05-04 15:31:02','3972601338'), ('1261','traffic_in','2010-05-04 15:31:02','2340522999'), ('1260','traffic_out','2010-05-04 15:31:02','1578224370'), ('1260','traffic_in','2010-05-04 15:31:02','1774775566'), ('1259','traffic_out','2010-05-04 15:31:02','807476626'), ('1259','traffic_in','2010-05-04 15:31:02','2789333593'), ('1258','traffic_out','2010-05-04 15:31:02','2441348447'), ('1258','traffic_in','2010-05-04 15:31:02','2354802669'), ('1257','traffic_out','2010-05-04 15:31:02','2106175112'), ('1257','traffic_in','2010-05-04 15:31:02','764247027'), ('1256','traffic_out','2010-05-04 15:31:02','884996388'), ('1256','traffic_in','2010-05-04 15:31:02','728953005'), ('1255','traffic_out','2010-05-04 15:31:02','2987364489'), ('1255','traffic_in','2010-05-04 15:31:02','2891204519'), ('1254','traffic_out','2010-05-04 15:31:02','1264130721'), ('1254','traffic_in','2010-05-04 15:31:02','1147279511'), ('1253','traffic_out','2010-05-04 15:31:02','1821285703'), ('1253','traffic_in','2010-05-04 15:31:02','2851821553'), ('1252','traffic_out','2010-05-04 15:31:02','4178773854'), ('1252','traffic_in','2010-05-04 15:31:02','3093221755'), ('1251','traffic_out','2010-05-04 15:31:02','3108777515'), ('1251','traffic_in','2010-05-04 15:31:02','1770143217'), ('1250','traffic_out','2010-05-04 15:31:02','752056298'), ('1250','traffic_in','2010-05-04 15:31:02','3491280822'), ('1249','traffic_out','2010-05-04 15:31:02','2353559572'), ('1249','traffic_in','2010-05-04 15:31:02','1566255835'), ('1248','traffic_out','2010-05-04 15:31:02','1910013038'), ('1248','traffic_in','2010-05-04 15:31:02','80041837'), ('1247','traffic_out','2010-05-04 15:31:02','1588278822'), ('1247','traffic_in','2010-05-04 15:31:02','571280543'), ('1246','traffic_out','2010-05-04 15:31:02','3711356554'), ('1246','traffic_in','2010-05-04 15:31:02','2493096586') ON DUPLICATE KEY UPDATE output=VALUES(output)'

it seems that the poller-output-boost is getting full. i truncated it and in 2 minutes it got full again!!

can anyone help me solving this problem

thank you in advance

[Sirup]

Before enabling boost, please consider very carefully how you plan to use it long term. Carefull thought should be given to how often you update RRD's at what point you need to either increase your MySQL max heap table size, or increase your update frequency. You should also consider carefully how much memory to allocate to PHP when retrieving records during major updates.

If you are unsure of what I am talking about, you should not use Boost!!!

Did you consider this stuff? MySQl heap table size, update frequency of RRds etc.

05/04/2010 03:31:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114',

See this? Error 1114, which is tells you there is a problem with your Heap table (full).