19 Feb
2012
19 Feb
'12
6:42 a.m.
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
19 Feb
19 Feb
4:27 p.m.
New subject: Mtree VS Htable getting huge amount of data from DB not on local machine
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.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda
20 Feb
20 Feb
12:33 a.m.
New subject: Mtree VS Htable getting huge amount of data from DB not on local machine
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(a)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
4693
days inactive
4694
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Uri Shacked