[OpenSIPS-Devel] Location table structure - account_contact_idx
donat.zenichev at gmail.com
Mon Sep 30 05:38:52 EDT 2019
Hi opensips community.
I have a question about an sql structure of the location table.
I came across a capacity obstacle when working without
'account_contact_idx' on the opensips version 2.4+
I'm completely aware that 'account_contact_idx' was deprecated after the
What did I do, was setting up of the database structure as for 2.4 version,
but with added 'account_contact_idx' unique key to a location table.
Why did I do this? Because the capacity of the database increased by
As an example:
When having a usual 2.4 version db structure, a sending of 50-60
registrations per second gives me 2/3 of requests that are re-transmitted.
When having a location table with 'account_contact_idx' unique key, I can
send 700+ registrations per second without any re-transmissions occurred.
Why does it happen?
My mysql setup is as following:
Version - 5.7.27
engine for opensips database - innodb
binlog_format = mixed <--- needed to fix a replication errors 1032/1062
when failing over
max_connections = 2000
max_allowed_packet = 16M
table_open_cache = 2000
max_binlog_size = 500M
It almost works out well with 'account_contact_idx' unique key, but it
generates lots of duplicate entries, that's I want to deprecate this.
But I don't know of how to save the same capacity as we have with that
Looking forward to any advice, thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Devel