Colin Faber schrieb am Dienstag, 7. August 2001, 09:29:45:
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
-->> http://lists.mysql.com/ (the list archive)
Very nice hint, indeed, I didn't think of it before, and I
experience these things, too. So I went to it and did a search on
error reading communication packets
which gave me 5 results. Fine.
The first hint I found was
max_allowed_packet
Well, this is taken care of:
set-variable = max_allowed_packet=16M
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
then continues to
The MySQL server shrinks each communication buffer to
net_buffer_length bytes after each query. For clients, the size
of the buffer associated with a connection is not decreased until
the connection is closed, at which time client memory is
reclaimed.
Does this mean that the error signals that buffer has become too
low and will be increased again with each error? Sorry, I don't
get that.
> DS wrote:
>>
>> Anyone seen this in your log file before?
>>
>> It's perlscripts on the same host, so before the DBI
>> routine all the data needed for an insert is on the
>> machine, not like it's loggin in from another machine.
>>
>> Could this be a problem with the loop back device? Any
>> other ideas as to what causes mysql to spit this out?
>>
>> Thanks
>> David
>>
>> 010804 20:00:40 mysqld started
>> /usr/local/mysql/bin/mysqld: ready for connections
>> 010805 4:08:29 Aborted connection 140 to db: 'rose'
>> user: 'rainman2' host: `localhost' (Got an error
>> reading
>> communication packets)
>> 010805 4:09:48 Aborted connection 166 to db: 'rose'
>> user: 'rainman2' host: `localhost' (Got an error
>> reading
>> communication packets)
>>
>> =====
>> http/email [EMAIL PROTECTED]
>> +380676920324
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Make international calls for as low as $.04/minute with Yahoo! Messenger
>> http://phonecard.yahoo.com/
>>
>> ---------------------------------------------------------------------
>> 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
> ---------------------------------------------------------------------
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
