Jasper Bryant-Greene wrote:
On Fri, 2005-10-21 at 21:40 -0700, Logg, Connie A. wrote:
The max packet size depends on the MTU your network and interface settings
allow.
The common packet size is 1500, however, if you can use 9000, you will get much
better performace.
I believe Rob is talking about MySQL packet sizes, not TCP/IP
(networking) packets.
Rob, as far as I know it is only limited by the amount of memory your
machine has.
-----Original Message-----
From: Rob Brooks [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 8:01 PM
To: 'MySQL list'
Subject: max packet size question
Is there a practical maximum for max packet size? Is it simply a function of the amount of memory that you have?
From the manual
<http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html>, "The
protocol limit for max_allowed_packet is 16MB before MySQL 4.0 and 1GB thereafter."
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
