Not the answer you need?
Register and ask your own question!

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

SargeSarge EntrantCurrent User Role Beginner
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

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.