[erlang-questions] erlang-mysql-driver timeout

jm jeffm@REDACTED
Tue Jan 22 08:58:16 CET 2008


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.



More information about the erlang-questions mailing list