FAQFAQ   SearchSearch   RegisterRegister   ProfileProfile   Log inLog in 

Boost table size

 
Post new topic   Reply to topic    CactiUsers.org Forum Index -> General
View previous topic :: View next topic  
Author Message
Linuxx
New User


Joined: 29 Jan 2008
Posts: 16
PostPosted: Wed May 07, 2008 12:17 pm    Post subject: Boost table size Reply with quote
I think my boost table is getting full, and I am getting gaps in graphs. I lowered my Maximum records to 5000 so boost would update more frequently, but I would like to change the table size too. Would this help me at all, or is the recommended solution to lower the maximum records in the boost config?

Quote:
Boost On Demand Updating: Running
Total Data Sources: 3957
Total Boost Records: 11869
Table Size Estimates
Current Boost Table Size: 16 MBytes
Avg Bytes/Record: 545 Bytes
Max Allowed Boost Table Size: 16 MBytes
Estimated Maximum Records: 30174 Records
Previous Runtime
Last Start Time: 2008-05-07 13:13:11
Last Run Duration: 41.6968 Seconds
RRD's Updated: 7912
Run Time Configuration
Update Frequency: 10 Minutes
Next Start Time: 2008-05-07 13:20:08
Maximum Records: 5000 Records
Maximum Allowed Runtime: 10 Minutes


Quote:
05/07/2008 01:13:42 PM - SYSTEM BOOST STATS: Time:94.2942 RRDUpdates:7913
05/07/2008 01:13:10 PM - SYSTEM STATS: Time:9.1255 Method:spine Processes:1 Threads:10 Hosts:121 HostsPerProcess:121 DataSources:3956 RRDsProcessed:0


untitled.jpg
 Description:
 Filesize:  46.74 KB
 Viewed:  38 Time(s)

untitled.jpg
Back to top
View user's profile
jimmy
Site Admin


Joined: 11 Nov 2004
Posts: 1495
PostPosted: Thu May 08, 2008 9:45 pm    Post subject: Reply with quote
You need to configure mysql to allow bigger temp tables.

Put this in your /etc/my.cnf

max_heap_table_size=256M

after the [mysqld]

and then restart mysqld
Back to top
View user's profile Visit poster's website
Linuxx
New User


Joined: 29 Jan 2008
Posts: 16
PostPosted: Fri May 09, 2008 3:51 pm    Post subject: Hum... Reply with quote
Still have gaps, and got an error now.
ERROR: Detected Poller Boost Abend, Contact support

odd...
Linuxx
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    CactiUsers.org Forum Index -> General All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
Forums Sitemap