GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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-s...lersocket-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

  • #2
    Hi,

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

    Code:
    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 |
    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-s...n-installation

    Comment

    Working...
    X