LOAD

Load or reload the shared library file.

Summary

LOAD 'filename'

describe

This command loads the shared library file into the YMatrix database server address space. If the file has been loaded previously, uninstall it first. This command is mainly used to uninstall and reload shared library files that have been changed since the server first loaded. To use a shared library, you need to declare the functions in it using the CREATE FUNCTION command.

The method for specifying a file name is the same as the method for specifying a shared library name in CREATE FUNCTION. In particular, it may depend on the automatic addition of search paths and system standard shared library file name extensions.

Note that in the YMatrix database, the shared library file (.so file) must be located in the same path to each host in the YMatrix database array (master, segments, and mirrors).

Only database superusers can load shared library files.

Parameters

filename

The path and file name of the shared library file. This file must exist in the same location on all hosts in the YMatrix database array.

Example

Loading shared library files:

// YMatrix 4.X path
LOAD '/usr/local/matrixdb/lib/myfuncs.so';

// YMatrix 5.X path
LOAD '/opt/ymatrix/matrixdb5/lib/myfuncs.so';

compatibility

LOAD is a YMatrix database extension.