I'm stuck at creating a real-time index with sphinx search engine. I'm following the documentation but I get weird results:
mysql> attach index profile to rtindex rt_profile;
ERROR 1064 (42000): sphinxql: syntax error, unexpected PROFILE, expecting IDENT near 'profile to rtindex rt_profile'
I'm using Sphinx 2.1.2-id64-release (r4245)
Any ideas on what I'm doing wrong ?
OK I just figured it out - profile is a key word: ( used in SHOW PROFILE command)