Re: max_allowed_package problem
From: Remo Sanges (sanges_at_biogem.it)
Date: 01/26/05
- Next message: JupiterHost.Net: "Re: Paged Querys"
- Previous message: Wojciech Karlowski: "max_allowed_package problem"
- In reply to: Wojciech Karlowski: "max_allowed_package problem"
- Next in thread: Wojciech Karlowski: "RE: max_allowed_package problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 26 Jan 2005 15:27:15 +0100 To: wkarlowski@web.de
On Jan 26, 2005, at 3:19 PM, Wojciech Karlowski wrote:
> I am using Linux Debian (Sid) with libdbi-perl version 1.46-5 and mySQL
> version 4.1. Currently, I am trying to set up a perl script which will
> use the DBI module to connect to database. Everything works fine unless
> I try to insert large (around 18MB) text object. When I do this I get a
> following error:
>
> !! ERROR: 2020 'Got packet bigger than 'max_allowed_packet'
>
> I have already changed to settings for the "max_allowed_package"
> variable in the mysql server config (/etc/mysql/my.cnf) and in the
> local
> settings (~/.my.cnf) file.
>
> When I issue the same statement using the mysql client everything works
> w/o problems.
>
> Does someone know where can I set up the "max_allowed_package" variable
> for the DBI-driven connection? Obviously, it doesn't care about the
> server or client settings!
Have you restarted the server?
BTW this is a 'server side' setting.
I usually prefer to restart the server
with the rigth settings rather than modify
the conf files:
safe_mysqld --max_allowed_packet=100M
HTH
Remo
- Next message: JupiterHost.Net: "Re: Paged Querys"
- Previous message: Wojciech Karlowski: "max_allowed_package problem"
- In reply to: Wojciech Karlowski: "max_allowed_package problem"
- Next in thread: Wojciech Karlowski: "RE: max_allowed_package problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
