29 Feb
2016
29 Feb
'16
7:35 p.m.
Daniel-Constantin Mierla writes:
The index can be useful if there is an operation in the config file, because I think the module doesn't do any match internally only on this column.
It is possible to save connection_id to hash table based on source ip/port and then on connection close add sql_query() call to config that removes the location table entry.
Also, it may be needed to be done in relation with server_id, if the same location table is shared between different server instances that use server_id identifiers.
So the index would be:
CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`)
-- Juha