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
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
Java program to get location meta data from an image
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
Count number of vowels, consonants and digits in a String in Java
Student marks calculation program in Java
Calculate gross salary in Java
Calculate average sale of the week in Java
Vector in Java - Sample Program
Archived Comments
1. I tried this code,but is showing this error
View Tutorial By: anju at 2009-05-22 07:42:11
2. This is an excerpt from Java Complete Reference.Ju
View Tutorial By: Guest at 2010-03-25 01:36:57
3. For Jaime,
Maybe using JavaScript f
View Tutorial By: Jair Aviles at 2011-11-22 05:49:05
4. Thank You,
Code is working well.
Is
View Tutorial By: dinesh at 2012-06-23 04:33:16
5. Works great! Thanks!
View Tutorial By: Ewa at 2013-06-19 10:52:07
6. Thank you so much
View Tutorial By: Daniel at 2011-02-14 22:47:05
7. Excellent. I want you to publish about memory allo
View Tutorial By: Mohamed firnaz at 2011-12-07 04:54:27
8. really superb in simple english with examples. Exp
View Tutorial By: hariharan at 2009-01-14 22:22:32
9. this work is good
View Tutorial By: sanath at 2008-12-15 01:18:43
10. excellent, very clear, thx!!!
View Tutorial By: ma at 2010-04-07 07:42:47