Installing the Zenoss provided user defined percentile function to MariaDB

The mysql SQL windowing functions are rather limited. To enable a sql database function for calculating percentiles (used by the Analytics percentile aggregation capabilities), Zenoss has written a mysql User Defined Function (UDF) and this needs to be installed into mysql. To install this function, log in to the Analytics server as root, or as a user with superuser privileges and execute the following procedure to install this function and restart the sql server (required by installation of any UDF):

Log in as the root user or a user with superuser permissions and execute the following commands:
su - zenoss
/opt/zenoss_analytics/bin/setup_zenoss_extensions install
service zenoss_analytics stop
/etc/init.d/mysql restart
service zenoss_analytics start