Hmm, I'm pretty sure it's unrelated to odbc, since the mysql client
fails from the command line when executing the query. I've filed a
bug report with mysql.
Yes max_allowed_packet needs to be set. The default for the server
is 1M, but for the client it's 16M. Watching top while the query is
run, you see mysql (client, as opposed to mysqld) run up from 16M to
>1000M, whereupon it errors out.
Same behavior whether the query is run from the command line or
witango. Interestingly webmin can download the problematic blobs. My
webmin is configured to use DBI, so the perl interface works. I
presume DBI::DBD::mysql hooks to the C api rather than using the
mysql client. Of course it makes me wonder why unixODBC uses the
mysql client instead of the C api, but that's another issue, but
potentially relevant to you witango/php performance comparison. I
think php uses the C api.
Re apache2, I guess I'll have to compile and test it with witango.
thx.
On Apr 29, 2006, at 5:59 PM, Robert Garcia wrote:
no, but am running php5 with apache2.2.
Did you check that the option in mysqlodbc 3.51 allow big results
is checked?
And I think there may be a parameter we set on the server side.
I will run a test or two on some bigger blobs.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Apr 29, 2006, at 3:57 PM, William M Conlon wrote:
I'm having a problem with mysql 4.1.16-1-fc4. The client blows up
-- out of memory -- when reading medium blobs larger than around
4.2 MB. This first showed up as a Witango ODBC error, but I ran
the mysql client from the shell and confirmed it's a mysql problem.
So my questions:
1. anyone running mysql-4.1.18 who can confirm whether the
problem still exists? It's not available as an rpm for FC4 yet,
but I could build from source if needed.
2. I know Robert Garcia is running mysql 5 and retrieving blobs.
anyone else? What version of mysql?
3. Robert, You're running FC5 and apache 2.2. Have you tried
running Witango 5 with apache 2.2?
Thanks.
Bill
William M. Conlon, P.E., Ph.D.
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
_____________________________________________________________________
___
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Bill
William M. Conlon, P.E., Ph.D.
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
