I have encountered the same problem and will look into the recommendations above. Suggestion:
How about a check of the MySQL version on activating the plugin with an error message or notification if it encounters a version less than 4.1? Might help folks like me avoid lost time. Thanks.
tom