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 [url]http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html#handlersocket-page[/url]
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