> Adriano Manocchia wrote:
> Well, first off, I can't seem to get max_allowed_packet higher than 64 
> MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are 
> reflected in the system settings, but only up to 64 MB, then regardless 
> of what I put in there, it stays at 64 MB. But like I said, the file is 
> only 34 MB, so theoretically it shouldn't be a problem. As for the 
> client, I'm trying to insert the record with the Perl DBI, which, 
> according the documentation, uses the server's max_allowed_packet value. 
> There's no way to set it on the client side that I'm aware of.

Hi, you might look for 4.0.2 (or 3.23.50) which contains some extra fix
to take into account
the size of the packet header when counting size of the whole packet.
This affects you only if you cannot reimport mysqldump back into mysql,
I used to get on 3.23.49a:

$ mysqldump -O net_buffer_length=16M --extended-insert --add-drop-table
Sulfolobus_solfataricus_P2 known3d | mysql -O      
net_buffer_length=16M mmo
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table 'known3d' at row: 106977
$ mysqldump -O net_buffer_length=16M --extended-insert --add-drop-table
Sulfolobus_solfataricus_P2 known3d | mysql mmo     
mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table 'known3d' at row: 107088            
$ mysqldump --extended-insert --add-drop-table
Sulfolobus_solfataricus_P2 known3d | mysql mmo
$

Look for subject
"Re: --extended-insert breaks import of some tables through pipe" on
similar thread in the bugs list.

Note the last one succeeeds - this is a current workaround for me.

"
Martin MOKREJS wrote:
> On Fri, 15 Mar 2002, Michael Widenius wrote:
>
> Martin> And if user sets net_buffer_length=80M, then happens what? Is it set just    
>                                    
> Martin> to 16M or is it ignored? This is what's not clear from docs.                 
>                                    
>                                                                                      
>                                    
> You can test this with:                                                              
>                                    
>                                                                                      
>                                    
> mysql -O net_buffer_length=80M --help                                                
>                                    
>                                                                                      
>                                    
> In 4.0 it's set to about 80M, in 3.23 to 24 M (which was wrong, it                   
>                                    
> should be 16M)                                                                       
>                                    
                                                                                       
                                    
Yes, then please update the docs to say clearly that the value
for                                                         
net_buffer_length CAN be larger then 16M, although automatically it
will                                                   
grow only up to the value of
max_allowed_packet.                                                                    
       
                                                                                       
                                    
And mention the `mysql -O net_buffer_length=80M --help' example,
that's                                                    
nice.
"

Hope this helps
Martin

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to