Erlang/OTP Forums

Author Message

<  Erlyweb mailing list  ~  [erlang-questions] erlang-mysql-driver timeout

Guest
Posted: Tue Jan 22, 2008 10:06 am Reply with quote
Guest
whoops, meant to post it to the erlyweb list. This what happens when
your in a rush.

This is not exactly an erlyweb problem, but this seems to be the most
appropriate list for it seeing as yariv had a hand in the module.

I downloaded the erlang-mysql-driver via svn and have a small program
querying a mysql table with 6638930 rows. A pool of connects are set up,
I've tried 1 to about 6, and select queries run against the database.
Small numbers of queries work but after about eight queries are logged
on the console. This happens

** exception exit: {timeout,{gen_server,call,
[mysql_dispatcher,
{fetch,p1,
<< The select string
removed ...>>}]}}
in function gen_server:call/2
in call from cust_speeds:'-process_files/3-fun-0-'/4
in call from lists:foldl/3
in call from cust_speeds:process_files/3

I've run some of the queries manually in the mysql client and no more
than about 40 rows are ever returned and the processing is never slow.
Does anyone have any suggestions?

The other question is how do I stop the mysql driver process started
with mysql:start_link(...) ?

Jeff.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post recived from mailinglist

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum