HandlerSocket-Plugin-for-MySQL icon indicating copy to clipboard operation
HandlerSocket-Plugin-for-MySQL copied to clipboard

Built mysql 5.1.53 and trunk HandlerSocket on Mac. Installs but doesn't start listening.

Open spullara opened this issue 14 years ago • 4 comments

I've installed from scratch on Mac OS X 10.6. It successfully installs the handlersocket.so in mysql. It doesn't start listening though it claims that it is initialized. Any ideas on how to debug further?

spullara avatar Dec 07 '10 19:12 spullara

I see the same problem. There's nothing in the mysql log to suggest what might be going on.

bos avatar May 02 '11 18:05 bos

I've partly addressed this in bos@c1e5790, so that it's at least possible to tell that the plugin knows that something possibly odd is happening.

bos avatar May 02 '11 19:05 bos

This could possibly be due to a bug in MySQL itself, or (maybe?) to the handlersocket plugin not interacting with the MySQL plugin API correctly.

What I observe is that by the time MySQL has called the handlersocket plugin's daemon_handlersocket_init function, it has not correctly set any of the plugin's system variables.

Therefore, the plugin sees a port number of zero for both read and write requests, and all other system variables are also set to their default values.

What's weird is that the server is setting those values to something: the default value for handlersocket_threads is 32 in the declaration of the variable, but 16 when MYSQL_SYSVAR_UINT is used to tell MySQL about it. Its value when daemon_handlersocket_init is called is 16, so MySQL has tweaked the variable ... just not to the value I put in my.cnf.

bos avatar May 02 '11 19:05 bos

I think that this issue can be closed.

Just compiled handler socket on my MBP.

MySQL 5.1.60

Darwin bastard.local 11.2.0 Darwin Kernel Version 11.2.0: Tue Aug 9 20:54:00 PDT 2011; root:xnu-1699.24.8~1/RELEASE_X86_64 x86_64

nijikon avatar Jan 27 '12 14:01 nijikon