Re: Bulk Insert Prepared Statement

[Chris Khan]

I came to the conclusion that it's most likely a bug in 6.0. I tried it in 5.0 and it worked perfectly. Here is my bug: http://bugs.mysql.com/bug.php?id=45512.

I use Plan B for certain situations, but it's not acceptable in this case. I was beginning to think Plan A was going to be my only option, but I wasn't quite prepared to accept that as a solution. I already felt like I was making concessions with 1k rows.

In the case that I did legitimately exceed some server memory limit, could you possibly point me to the server variable responsible for that limit? It's only ~2MB worth of variables and inserted data at most, and it worked in 5.0.