Re: [SR-Users] Inser Delayed in MySQL

Hi Daniel. Thanks for your response. Looking at the link you sent me, at the end of it, 7. Limitations, sec 2. By default MySQL doesn't support.. 7. Limitations * 1. Only one capturing mode on RAW socket is supported: IPIP or monitoring/mirroring port. Don't activate both at the same time. * 2. By default MySQL doesn't support INSERT DELAYED for partitioning table. You can patch MySQL (http://bugs.mysql.com/bug.php?id=50393) * 3. Mirroring port capturing works only on Linux. In order to patch it, what the steps by steps to do it (http://bugs.mysql.com/bug.php?id=50393) I don't understand what I have to do here. Sorry for my little knowledge in this matter. Thanks, Gus From: sr-users-bounces(a)lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Tuesday, October 29, 2013 2:16 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Inser Delayed in MySQL Hello, maybe the documentation is old, you should be able to do it via sipcapture module parameter: - http://kamailio.org/docs/modules/devel/modules/sipcapture.html#sipcapture. p.db_insert_mode Cheers, Daniel On 10/29/13 9:29 PM, Gus Monti wrote: Hi, I can see that we are missing a lot of Sip messages in or db, so, checking Homer FAQ there is a way to compile MySql with Insert Delayed for partitioning table. The problem is that I don't understand how to recompile MySql and make the necessary changes. The URL is https://code.google.com/p/homer/wiki/FAQ#Q:_I_have_a_lot_of_SIP_traffic_an d_some_SIP_messages_are_missing The question is, can you send me a step by step how to do this? I really appreciate your help. I have CentOS 6.4: [root@Homerdb02 ~]# kamailio -v version: kamailio 4.1.0-dev9 (x86_64/linux) f8f3d3 [root@Homerdb02 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.4 (Santiago) [root@Homerdb02 ~]# uname -a Linux Homerdb02 2.6.32-358.18.1.el6.x86_64 #1 SMP Fri Aug 2 17:04:38 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux [root@Homerdb02 ~]# mysql -V mysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1 Thanks, Gus _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Trainings - Berlin, Nov 25-28 - more details about Kamailio trainings at http://www.asipto.com -