Skip to content

Latest commit

 

History

History
46 lines (31 loc) · 1.11 KB

README.md

File metadata and controls

46 lines (31 loc) · 1.11 KB

MySQL Data Analysis Extension

An data analysis extension for MySQL server using MySQL loadable function

Prerequisite

Make sure you have the mysql_config command. You can install it via yum install mysql-devel(on CentOS)

Otherwise, you have to modify the INC and PLUGIN_DIR variable in Makefile with your path to mysql (/usr/local/mysql)

INC = -I/usr/local/mysql/include
PLUGIN_DIR = /usr/local/mysql/lib/plugin

Usage

Compile

  1. Compile the source files via make

    make

  2. Install the library to MySQL

    sudo make install

MySQL

  1. Install/Uninstall functions from MySQL

    mysql -u root -p < install.sql
mysql -u root -p < uninstall.sql

  2. Launch MySQL server with --binary-as-hex=0 flag. (reference)

    mysql -u root -p --binary-as-hex=0