Hi,

in the standard configuration of a mysql server the 'max_allowed_packet'
variable is set to '1M' which is the maximal data amount received in client
interaction (with the mysql client you can supply the buffer size when
starting the client, but not with jdbc). You can query this parameter from
the command prompt with:
mysqladmin variables
or the mysql client prompt with:
show variables
You can set this server variable at startup. Either by providing a line:
set-variable = max_allowed_packet=16M
in the [mysqld] section of your /etc/my.cnf as described here:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Option_files
or by supplying as a parameter at the command line when starting the server:
--set-variable=max_allowed_packet=16M 

Greetings,
  Marcus

> -----Urspr�ngliche Nachricht-----
> Von: Candide Kemmler [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 12. September 2001 16:13
> An: [EMAIL PROTECTED]
> Betreff: how do I change the maximum size of a message ?
> 
> 
> Hi,
> 
> One of my users has had problems receiving mails > 1Mb. I use a mysql 
> backend. Could that be the origin of the problem ?
> 
> Cheers,
> 
> Aur�lien
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to