neoform Posted October 28, 2008 Share Posted October 28, 2008 It took me about two hours to track down the problem, but it seems a large INSERT has been killing my mysqli connection (in PHP). The query inserts 1 row with a serialized array in one of the fields. The query is 1.1MB, which seems to hose the connection. So, the question is, what is the size limit for a given mysqli query? Is this a mysql configration issue, or a mysqli limitation? My mysql wait timeout isn't being reached, since I set it to 900 seconds and the page is dying after about 20 seconds.. Link to comment https://forums.phpfreaks.com/topic/130467-big-mysqli-query-dead-connection/ Share on other sites More sharing options...
bobbinsbro Posted October 28, 2008 Share Posted October 28, 2008 possibly because of a low max_allowed_packet on the mysql server. see: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html Link to comment https://forums.phpfreaks.com/topic/130467-big-mysqli-query-dead-connection/#findComment-676889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.