Re: [SR-Users] htable 1 Millon registers
Am Dienstag, 23. Oktober 2018, 23:45:49 CEST schrieb Mauricio Tejeda: > Hello Henning. > Thanks for answered. > Yes, the failure is during the kamailio load. > > I'm increased the shared memory but there is no change, the failure > persists. > > I will try with redis Hello Mauricico, ok - if you want to look people on this list into the error you need to give more details, like some actual error messages from the Kamailio log. But as already pointed out, going with redis is indeed a valid option. Best regards, Henning -- Henning Westerholt - https://skalatan.de/blog/ Kamailio security assessment - https://skalatan.de/de/assessment ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] htable 1 Millon registers
Am Montag, 22. Oktober 2018, 22:35:17 CEST schrieb Brooks Bridges: > IMHO, anything more than about 100k keys really should be stored in > something external to Kamailio (such as redis) to prevent exactly this > issue. If you’re running redis on the same server as Kamailio and using > localhost to access it, then the latency increase for accessing the data > via redis as opposed to htable is almost nonexistent. Hi Brooks, this is of course also a valid option. Some years ago I was asked to optimized the carrierroute module to properly take care of a 1 million routing tree for several users. So there are some use cases to do something like this, but probably (nowadays) not that many anymore, I agree. Best regards, Henning -- Henning Westerholt - https://skalatan.de/blog/ Kamailio security assessment - https://skalatan.de/de/assessment ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] htable 1 Millon registers
Am Montag, 22. Oktober 2018, 22:30:44 CEST schrieb Mauricio Tejeda: > Trying to use the htables module to load an extensive table in memory, I > can not start kamailio. > > If the table contains few records (5 and 10 in my examples), this works > without problems, for everything else I lose the connection to the database > > "Lost connection to MySQL server during query" > > I modified the timeout of mariadb but I can not work. > > Someone with a similar problem or ideas on how to solve it? Hello Mauricio, do you get other errors in the log file during the data load? Do you increased the shared memory of the server to have space for the data? Best regards, Henning -- Henning Westerholt - https://skalatan.de/blog/ Kamailio security assessment - https://skalatan.de/de/assessment ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] htable 1 Millon registers
IMHO, anything more than about 100k keys really should be stored in something external to Kamailio (such as redis) to prevent exactly this issue. If you’re running redis on the same server as Kamailio and using localhost to access it, then the latency increase for accessing the data via redis as opposed to htable is almost nonexistent. Brooks Bridges | Engineering Manager O1 Communications 4359 Town Center Boulevard, Suite 217 El Dorado Hills, California 95762 office: 916.235.2097 | main: 888.444., Option 2 email: bbrid...@o1.com<mailto:bbrid...@o1.com> | web: www.o1.com<http://www.o1.com/> From: sr-users [mailto:sr-users-boun...@lists.kamailio.org] On Behalf Of Mauricio Tejeda Sent: Monday, October 22, 2018 13:31 To: sr-users@lists.kamailio.org Subject: [SR-Users] htable 1 Millon registers Good afternoon. Trying to use the htables module to load an extensive table in memory, I can not start kamailio. If the table contains few records (5 and 10 in my examples), this works without problems, for everything else I lose the connection to the database "Lost connection to MySQL server during query" I modified the timeout of mariadb but I can not work. Someone with a similar problem or ideas on how to solve it? Thank you ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] htable 1 Millon registers
Good afternoon. Trying to use the htables module to load an extensive table in memory, I can not start kamailio. If the table contains few records (5 and 10 in my examples), this works without problems, for everything else I lose the connection to the database "Lost connection to MySQL server during query" I modified the timeout of mariadb but I can not work. Someone with a similar problem or ideas on how to solve it? Thank you ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users