I am trying to use gearman mysql udf. I downloaded tarball from http://gearman.org/index.php?id=download and installed it with the instructions given at http://gearman.org/index.php?id=mysql_udf_readme
I am trying to create a gman_do function in mysql, but I am getting some error
Error -
mysql> create function gman_do returns string soname "libgearman_mysql_udf.so"; ERROR 1126 (HY000): Can't open shared library 'libgearman_mysql_udf.so' (errno: 22 /usr/local/lib/libgearman_mysql_udf.so: cannot open shared object file: No such file or directory)
I had to change some variable path for the shared library. MySQL should find libgearman_mysql_udf.so from plugindir , which is /usr/lib/mysql/plugin , which was provided by me during installation using -
bash configure --with-mysql=/usr/local/mysql/bin/mysql_config --libdir=/usr/lib/mysql/plugin make make install
What should I do? Where, how can I make MySQL look for .so gearman_mysql_udf files in some other directory, say plugindir .
source share