I’ve been using MySQL 5.1.14 for last few weeks without any problems. Yesterday I compiled it with Sphinx storage engine (built-in, not as a pluggable module) and weird things started to show up. The server crashes randomly on deletes and updates to MyISAM(!) tables if any Sphinx table has been accessed since mysqld startup. Does anyone else experience such behaviour? I’m not sure if it’s Sphinx SE falut or not, but that is the only thing that changed, so this would be the most obvious.
Another thing is the warning that server logs at each startup:
[Warning] Storage engine ‘SPHINX’ has conflicting typecode. Assigning value 42.