2 ms·

mysqlnd Fixed crash when using more than 28,000 bound parameters. Workaround is to set mysqlnd.net_cmd_buffer_size to at least 9000. (Andrey) Whew. Thank goo

mysqlnd Fixed crash when using more than 28,000 bound parameters. Workaround is to set mysqlnd.net_cmd_buffer_size to at least 9000. (Andrey) Whew. Thank goodness that's fixed?

fletchowns 15y ago
Ya seriously, why in the world would you have so many bound parameters?
- pornel 15y ago
  e.g. a Bayesian classifier that updates word counts: INSERT INTO words(word, spam, ham) VALUES(?, ?, ?),(?, ?, ?),(?, ?, ?),… ON DUPLICATE KEY UPDATE … and n-grams to this, and document with few thousand words will need 28k parameters.
FuzzyDunlop 15y ago
This bug really frustrated me. I couldn't figure out how to make a simple blogging application without at least 28,000 bound parameters because the thing kept crashing out. I'm glad I can now un-hobble my database query and retrieve the full output.