An Urgent Note to Boost Users

[TheWitness]

All,

I have been doing some investigation on Boost and gaps, and have found the following bug in MySQL. I don't know what versions it affects. I will do more research.

However, if you have a MEMORY table and the PRIMARY KEY is BTREE, deletes do not work properly!!!

The following command should resolve this problem:

Code: Select all

ALTER TABLE poller_output_boost, drop primary key, add primary key  (`local_data_id`,`rrd_name`,`time`);

This has me completely baffled. Again, I will report if I can find the bug in the MySQL bug database.

Regards,

TheWitness

[timi]

valid for any version of boost ? I have 2.4

[TheWitness]

If you do a show create table poller_output_boost and the primary key is listed as btree, then the issue might be with you. It also depends on your MySQL version.

TheWitness

[tuux1598g]

Any further news on this? MySQL Bug#30590 would appear to relate directly to this, and was committed to versions > 5.0.52 / 4.1.24. I have also tested this using a Debian 5.0.5 package (assumed fairly common) which reports MySQL 5.0.51a and the issue mentioned isn't replicable. Additionally, boost has been running fine on this (fairly large) test system using BTREE indexes without any issues for the past month or so.