Skip navigation links

MySQL Forums :: Quality Assurance :: Network Packet Size Limit


Advanced Search

Network Packet Size Limit
Posted by: Moeen Khurshid ()
Date: November 18, 2010 03:08PM

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.

Options: ReplyQuote


Subject Views Written By Posted
Network Packet Size Limit 2163 Moeen Khurshid 11/18/2010 03:08PM
Re: Network Packet Size Limit 766 moeen khurshid 11/26/2010 11:12AM


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.