Hi,
untill today i used the mtree module to get some data from a remote DB and load it into memory. the table in the data base has 5 million rows. prefix is a number and value is some string.
i moved to htable because i need the prefix exact match and not longest....
now, after 5-10 sec, i get the following error (that i never got in mtree)
- "lost connection to mysql during query" and kamailio does not start.
any ideas how to solve it?
cheers,
Uri
Hello,
On 2/19/12 12:42 PM, Uri Shacked wrote:
Hi, untill today i used the mtree module to get some data from a remote DB and load it into memory. the table in the data base has 5 million rows. prefix is a number and value is some string. i moved to htable because i need the prefix exact match and not longest.... now, after 5-10 sec, i get the following error (that i never got in mtree) - "lost connection to mysql during query" and kamailio does not start. any ideas how to solve it?
iirc, htable does a sort with the query retrieving the data, in order to cope with "array" structures -- this may take a while in the mysql server, do you get any logs in the log file of mysql daemon?
Maybe an option to disable this sorting, for people not needing the "array" functionality would be good to speed up a bit.
Cheers, Daniel
Hey, I didn't get any logs from the mysqld. An option to disable this sorting will be great. Thanks, Uri
On Sun, Feb 19, 2012 at 11:27 PM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
On 2/19/12 12:42 PM, Uri Shacked wrote:
Hi,
untill today i used the mtree module to get some data from a remote DB and load it into memory. the table in the data base has 5 million rows. prefix is a number and value is some string.
i moved to htable because i need the prefix exact match and not longest....
now, after 5-10 sec, i get the following error (that i never got in mtree) - "lost connection to mysql during query" and kamailio does not start.
any ideas how to solve it?
iirc, htable does a sort with the query retrieving the data, in order to cope with "array" structures -- this may take a while in the mysql server, do you get any logs in the log file of mysql daemon?
Maybe an option to disable this sorting, for people not needing the "array" functionality would be good to speed up a bit.
Cheers, Daniel
-- Daniel-Constantin Mierla -- http://www.asipto.comhttp://linkedin.com/in/miconda -- http://twitter.com/miconda
-
Daniel-Constantin Mierla -
Uri Shacked