Comment on Tutorial - Handling BLOB in PHP and MySQL By Andi, Stig and Derick



Comment Added by : Tony Gingrich

Comment Added at : 2011-10-23 21:22:31

Comment on Tutorial : Handling BLOB in PHP and MySQL By Andi, Stig and Derick
I'm working on an intranet site/web application. We have a table for file storage (MySQL 4.1.22/InnoDB engine), with a field defined as LONGBLOB. MySQL specifies this type to be able to handle just over 4GB. While we will never be pushing this much data to a record, we do have a few instances of BLOBS up to 32MB, which is too much for the MEDIUMBLOB type.

However, I am using the mysql_query() method of inserting. This works well for data as long as 10MB, but the call hangs (no exceptions, timeouts, etc...just simply hangs as if in an infinite loop) for several hours. I have temporarily unlimited all PHP timeouts, as well as insured the max_allowed_packet on our MySQL instance is at 200MB (a little overkill, just to be sure). I even went so far as to set the net_write_timeout value to 120 seconds and the net_read_timeout to 240 seconds. Both the web and db servers are on our LAN (100Mb), so there is optimal communication between the 2 machines.

Are there any other settings I should be aware of to check? Also, is it possible that this is a limitation of the mysql_query() method, and that I need to switch up and use the mysqli interface?

I'm really at a loss here. My background comes from MS SQL, so I am still learning my way around MySQL.

Thanks in advance!


View Tutorial



Subscribe to Tutorials

Related Tutorials

Program using concept of byte long short and int in java

Update contents of a file within a jar file

Tomcat and httpd configured in port 8080 and 80

Java File

Java String

Count number of vowels, consonants and digits in a String in Java

Reverse a number in Java

Student marks calculation program in Java

Handling Fractions in Java

Calculate gross salary in Java

Calculate average sale of the week in Java

Vector in Java - Sample Program

MultiLevel Inheritance sample in Java

Multiple Inheritance sample in Java

Java program using Method Overriding

Archived Comments

1. site is very good explanation is very clear throug
View Tutorial          By: sridevi at 2013-03-20 15:26:29

2. Please let me know the SMSConnector number of any
View Tutorial          By: Chandra Shekhar at 2009-04-01 00:21:54

3. You only need 1 main method per application, not 1
View Tutorial          By: Michael at 2011-09-02 02:37:51

4. thank you so much i learn from your tutorial i wis
View Tutorial          By: Anonymous at 2009-01-03 20:08:41

5. This program not running on my system so give some
View Tutorial          By: Ajay Kumar Barik at 2009-06-15 02:28:47

6. Very informative and simple to understand. Thank y
View Tutorial          By: Rosa Vladivord at 2012-12-23 13:00:52

7. thanks a lot that helped.. =D
View Tutorial          By: Karthik at 2008-11-16 02:27:53

8. good work.
if there is a ValidatorForm the

View Tutorial          By: floriano at 2008-10-09 07:23:16

9. hi....can anybody help me....
i need the co

View Tutorial          By: nithin ms at 2007-02-23 08:34:01

10. guys i am getting this error..plz tell me the solu
View Tutorial          By: Ajit at 2010-06-17 07:38:51