Network Packet Size Limit

[Moeen Khurshid]

QS:



we have a server with following configuration

Intel Bi Xeon E5530 (2x 4x 2x 2.40+ GHz)
24 GB DDR3 ram
36x 2000 GB - SAS
10GBIT Network/NIC

we are running bulk updates to MySQL server. Now the problem is that we have a limit of 32 MB as maximum packet size in MySQL.

we need to configure it to 100mbps so that we can transfer LARGE OBJECTS Easily to the database.

Now has anyone came across modifying mysql binaries which can result into the expansion of this packet size? As if we run 100 batch transations each passing 1MB data we require it to be 100mbps. Our networks support it our server support it but MySQL is holding back.

The data we are trying to add is NTEXT and has to be NTEXT.


Regards,


M.



Edited 1 time(s). Last edit at 11/19/2010 11:40AM by Moeen Khurshid.