Network Packet Size Limit
Posted by: Moeen Khurshid
Date: November 18, 2010 03:08PM
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
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.
Edited 1 time(s). Last edit at 11/19/2010 11:40AM by Moeen Khurshid.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.