Mysql + blackhole storage engine

Asked by Will Oberman on 2010-09-27

Do you have the blackhole storage engine in any of your packages? There is an old google hit to plugins-blackhole in ius-testing, but that seems to be gone.

Thanks!

Question information

Language:
English Edit question
Status:
Solved
For:
IUS Community Project Edit question
Assignee:
No assignee Edit question
Solved by:
Will Oberman
Solved:
2010-09-27
Last query:
2010-09-27
Last reply:
2010-09-27
BJ Dierkes (derks) said : #1

Will,

Thank you for the question. As of mysql51-5.1.46-1.ius, all plugins are bundled with mysql51-server. This includes archive, blackhole, example, and innodb_plugin. Please let us know if you have any other questions, either here or on the ius-community mailing list. (http://launchpad.net/~ius-community)

Thanks!

For those of us who never loaded a storage engine as a plugin, this seemed to do the trick:
INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so';
from a MySQL console (with some elevated rights). Based on the MySQL docs, this method of loading a plugin survives MySQL restarts. I searched the package (rpm -ql mysql51-server) to find the SONAME.