# HandlerSocket installed but not active - Percona Server 5.5 on Centos 6.5 **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [December 26, 2013, 2:28pm UTC](https://forums.percona.com/t/handlersocket-installed-but-not-active-percona-server-5-5-on-centos-6-5/3164 "2013-12-26T14:28:05Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Sarge](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@Sarge](https://forums.percona.com/u/Sarge)\ **Post date:** [December 26, 2013, 2:28pm UTC](https://forums.percona.com/t/handlersocket-installed-but-not-active-percona-server-5-5-on-centos-6-5/3164/1 "2013-12-26T14:28:05Z")
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](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 ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [January 3, 2014, 12:56am UTC](https://forums.percona.com/t/handlersocket-installed-but-not-active-percona-server-5-5-on-centos-6-5/3164/2 "2014-01-03T00:56:42Z")
Hi, As per your processlist, STATE is “handlersocket: mode=rd, 0 conns, 0 active” and not NULL. ```auto [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. [URL][HandlerSocket](http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html#testing-the-plugin-installation%5B/URL%5D)