[Solved] Boost Max Allowed Boost Table Size

[ssnapp]

I'm having trouble increasing the Max Allowed Boost Table Size. I've increased the max_heap_table_size but the value for 'Max Allowed Boost Table Size' doesn't change.

I'm fine with updating the RRD files every 30 minutes, but the table size exceeds 14MB after three polls. I end up with gaps in my graphs. Any help is appreciated, and please let me know if more data is needed.

Thanks

Database Engine: MEMORY
Current Boost Tables Size: 14 MBytes
Avg Bytes/Record: 556 Bytes
Max Allowed Boost Table Size: 14 MBytes
Estimated Maximum Records: 26696 Records

[ssnapp]

I'm replying to this email so that it shows answered.

Under /etc/my.cnf I placed the following line.

Code: Select all

 max_heap_table_size = 512M 

The code was not under mysqld like it should have been.

Code: Select all

[mysqld]
max_heap_table_size = 512M

Everything is working beautifully!