udf configuration resources

Yong Lee · *nix forums beginner Joined: 08 Jun 2006 Posts: 5

Hi all,

I hope I have hit the right group for this question.

I would like to create a UDF that is configurable at run time. Similar to
how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF
to make use of configuration parameters that can be set at run time.

I'm wondering if this is possible and what strategy to take to implement
this, ie: a mechanism to have mysql or the UDF read something once and then
have the UDF able to refer back to it everytime it is run.

I know I could read a file in the _init function, but this seems very
wasteful to read a file every time the function is being used.

Any thoughts on this would be appreciated.

thanks,

Yong.

Eric Bergen · *nix forums addict Joined: 10 Feb 2005 Posts: 73

Your udf is executing in a threaded environment so you have the option
of creating a datastrucutre to store options in that will persist
across udf executions. However since you won't be deallocating this
structure ever it's essentially leaked memory.

What are you doing with udfs that you want to store configuration for?
I have a feeling udfs are not he right solution.

On 7/19/06, Yong Lee <ylee@eqo.com> wrote:

Google