Req #70020 [NEW]: Make mysqli->multi_query use separate packets

From: Date: Wed, 08 Jul 2015 11:20:24 +0000
Subject: Req #70020 [NEW]: Make mysqli->multi_query use separate packets
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-194204@lists.php.net to get a copy of this message
From: mail at tomsommer dot dk Operating system: PHP version: 5.6.10 Package: MySQLi related Bug Type: Feature/Change Request Bug description:Make mysqli->multi_query use separate packets Description: ------------ When executing a large query through mysqli->multi_query() you can hit MySQL's max_allowed_packet setting, because all queries are sent as one packet, rather than one query per packet. Test script: --------------- $largefiledata = file_get_contents('10G.sql'); $mysqli->multi_query($largefiledata); -- Edit bug report at https://bugs.php.net/bug.php?id=70020&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=70020&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=70020&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=70020&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=70020&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=70020&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=70020&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=70020&r=needscript Try newer version: https://bugs.php.net/fix.php?id=70020&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=70020&r=support Expected behavior: https://bugs.php.net/fix.php?id=70020&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=70020&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=70020&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=70020&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=70020&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=70020&r=dst IIS Stability: https://bugs.php.net/fix.php?id=70020&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=70020&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=70020&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=70020&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=70020&r=mysqlcfg

« previous php.bugs (#194204) next »