blob field limitation

[topcoder1]

question 1:

there's a limit on how much you can upload and insert into a blob field in phpMyAdmin: 8192 kb, this is certainly not the blob limit, a quick search on google says it's a process stack size limit. 

what is this 8192 kb limit?  is it simply the limit on file size that can be uploaded into phpMyAdmin? what's the reason behind it?

 

question 2:

another related issue is  whenever I tries to insert a big file(for example, >1MB) into a longblob field using mysql_query, mysql dies and says "MySQL server has gone away"), smaller files are ok.. what's up with that?

thanks

 

[MadTechie]

1. to stop people trying to overload the system with too much data in one go.

 

2. the server timed out and closed the connection to the SQL server.

[topcoder1]

Thanks!

for 2) I found out that there's a bug in my mysql community server version 5.02

http://bugs.mysql.com/bug.php?id=14955

so I'm stuck with 1MB max file insert blob unless I upgrade mysql server.... which I am hesitant to do.

so much for trying to store files in database...