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? Quote Link to comment https://forums.phpfreaks.com/topic/130465-big-mysqli-insert-dead-connection/ Share on other sites More sharing options...
fenway Posted October 30, 2008 Share Posted October 30, 2008 There's a variable called max_allowed_packet... but php also have a max size. Quote Link to comment https://forums.phpfreaks.com/topic/130465-big-mysqli-insert-dead-connection/#findComment-678528 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.