How to make handler plugin to mysql in CentOS


Problem :

Environment: CentOS+mysql-5.6.14

This is what I tried:

cd /usr/local/src/
tar zvfx ahiguti-HandlerSocket-Plugin-for-MySQL-1.0.6-71-g159ea6d.tar.gz
cd ahiguti-HandlerSocket-Plugin-for-MySQL-159ea6d/

./autogen.sh
./configure --with-mysql-source=/usr/local/src/mysql-5.1.47 --with-mysql-bindir=/usr/local/app/mysql/bin/ --with-mysql-plugindir=/usr/local/app/mysql/lib/mysql/plugin/ --prefix=/usr/local/app/mysql
make

but when i do 'make', I encounter the following errors:

In file included from database.cpp:16:
mysql_incl.hpp:12:1: warning: "HAVE_CONFIG_H" redefined
<command line>:1:1: warning: this is the location of the previous definition
database.cpp: In member function 'virtual void dena::dbcontext::init_thread(const void*, volatile int&)':
database.cpp:294: error: 'LOCK_thread_count' was not declared in this scope
database.cpp:296: error: 'threads' was not declared in this scope
database.cpp:297: error: 'thread_count' was not declared in this scope
database.cpp:310: error: 'create' is not a member of 'MDL_request'
database.cpp: In member function 'virtual void dena::dbcontext::term_thread()':
database.cpp:337: error: 'LOCK_thread_count' was not declared in this scope
database.cpp:340: error: 'thread_count' was not declared in this scope
database.cpp: In member function 'void dena::dbcontext::cmd_find_internal(dena::dbcallback_i&, const dena::prep_stmt&, ha_rkey_function, const dena::cmd_exec_args&)':
database.cpp:649: error: 'struct st_key' has no member named 'key_parts'
/data/install/mysql-5.6.14/sql/handler.h:2228: error: 'virtual int handler::index_read_map(uchar*, const uchar*, key_part_map, ha_rkey_function)' is protected
database.cpp:689: error: within this context
/data/install/mysql-5.6.14/sql/handler.h:2247: error: 'virtual int handler::index_prev(uchar*)' is protected
database.cpp:694: error: within this context
/data/install/mysql-5.6.14/sql/handler.h:2244: error: 'virtual int handler::index_next(uchar*)' is protected
database.cpp:698: error: within this context
/data/install/mysql-5.6.14/sql/handler.h:2256: error: 'virtual int handler::index_next_same(uchar*, const uchar*, uint)' is protected
database.cpp:701: error: within this context
database.cpp: In member function 'virtual void dena::dbcontext::cmd_open_index(dena::dbcallback_i&, size_t, const char*, const char*, const char*, const char*)':
database.cpp:770: error: cannot convert 'MEM_ROOT*' to 'Open_table_context*' for argument '3' to 'bool open_table(THD*, TABLE_LIST*, Open_table_context*)'
make[2]: *** [handlersocket_la-database.lo] error 1
make[1]: Leaving directory `/usr/local/src/HandlerSocket-Plugin-for-MySQL-1.0.6'
make: *** [all] error 2


Solution :

You should use version 1.1 of https://github.com/DeNA/HandlerSocket-Plugin-for-MySQL


Mysql Tutorials

Mysql Howto..

How to use regex in MySQL?

How can I get the most popular words in a table via mysql?

How to echo the result of my query? PHP & MySQL

How to make filtration query fast in my C# code with MySQL?

How to get UUID generated by MySQL into a C# variable

MySQL query and PHP: how to know how many results per each “WHERE” condition

How to take MySQL data and read it into an Android App

How to delete rows from a mysql database using php with a form delete button

How to alter the character set on the mysql database

How to safely connect to a database [closed]

How to return multiple rows from a table in in php using mysql

How to get a list of rows from a database

MYSQL Query : How to UNION two table with ORDER BY

How do I add millions of rows to a live production mysql table?

How to move rows in mysql

how to display the day on which a user born in mysql?

MySQL Months stored as strings, how to order chronologically, rather than alphabetically?

How to load file into mysql DB on a shared hosting platform?

MySQL - how to optimize query to count votes

How to get a count from a Field in another Table - MySQL

How to transpose mysql table rows into columns

how to post ng-value to mysql database

How to optimize a slow “select distinct” query across three tables, 40k rows, that only returns 22 results

How to get maximum and average of a field from mysql table with some conditions

How to write a MySQL if else endif statement?

How to dynamically accumulate checkbox values in a SQL query

How do I use a Derby database?

How can I insert automatic number to field id in mysql?

MYSQL Group by Hour - showing zero results

How to get error code returned by query using MySQL in Asp.Net