HandlerSocket installed but not active - Percona Server 5.5 on Centos 6.5

Hello, everybody !

//I made a successful installation of Percona Server 5.5 on Centos 6.5 using standard
yum install Percona-Server-server-55 Percona-Server-client-55 Percona-Server-shared-55 Percona-Server-shared-compat percona-toolkit xtrabackup perl-DBD-MySQL php-mysql MySQL-python
//after remove of mysql

//after that added to my.cnf as instructed
loose_handlersocket_port = 9998

the port number to bind to for read requests

loose_handlersocket_port_wr = 9999

the port number to bind to for write requests

loose_handlersocket_threads = 16

the number of worker threads for read requests

loose_handlersocket_threads_wr = 1

the number of worker threads for write requests

open_files_limit = 65535

to allow handlersocket to accept many concurrent

connections, make open_files_limit as large as

possible.

//after that logged in to mysql as root and
mysql> install plugin handlersocket soname ‘handlersocket.so’;

//after that checked as
mysql>show plugins;

//result
mysql> show plugins;
±-------------------------------±---------±-------------------±-----------------±--------+
| Name | Status | Type | Library | License |
±-------------------------------±---------±-------------------±-----------------±--------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |

| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| handlersocket | ACTIVE | DAEMON | handlersocket.so | BSD |

//so we can see that
| handlersocket | ACTIVE | DAEMON | handlersocket.so | BSD |

//but
mysql> show processlist;
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------±----------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read |
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------±----------+
| 6 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0 | 0 | 0 |
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------±----------+

//so I DON’T SEE as it should be from http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html#handlersocket-page

mysql> SHOW PROCESSLIST;
±—±------------±----------------±--------------±--------±-----±------------------------------------------±-----------------+
| Id | User | Host | db | Command | Time | State | Info |
±—±------------±----------------±--------------±--------±-----±------------------------------------------±-----------------+
| 1 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 2 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |

//so we see that
STATE = NULL but not STATE = handlersocket: mode=rd, 0 conns, 0 active

Service mysql start/stop - MADE.
No reaction.

Shell command
netstat -lnptu
does not show anything running on ports 9998 and 9999.

Selinux - checked - disabled.
Firewall - disabled.

So we have the situation when HandlerSocket is installed and even shows itself as an ACTIVE DAEMON - but it does not running actually.

Will be pleased for any ideas what else to check and try - to enable HandlerSocket actually running !

P.S. If it’s important - I have no any InnoDB engine/tables, only MyISAM.

Wishing to everybody nice Christmas holidays !
Regards,
Serge

Hi,

As per your processlist, STATE is “handlersocket: mode=rd, 0 conns, 0 active” and not NULL.

[COLOR=#252C2F]mysql> SHOW PROCESSLIST;
[COLOR=#252C2F]+----+-------------+-----------------+---------------+---------+------+-------------------------------------------+------------------+
[COLOR=#252C2F]| Id | User | Host | db | Command | Time | State | Info |
[COLOR=#252C2F]+----+-------------+-----------------+---------------+---------+------+-------------------------------------------+------------------+
[COLOR=#252C2F]| 1 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
[COLOR=#252C2F]| 2 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |

It seems, Db, Time and Info are null. Still I would like you to test it by creating table and insert row mentioned here and check if its working or not.

http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html#testing-the-plugin-installation