[Project_owners] Re: What is wrong today??

Philip Chee philip at aleytys.pc.my
Sun Mar 26 13:07:49 EST 2006


On Sun, 26 Mar 2006 13:41:18 +0900, Gerald Vogt wrote:

> xulplanet.com is expired. Whois says:

I use the offline version of devboi <http://devboi.mozdev.org/> which
puts several references (XUL, CSS, HTML) into a sidebar.

I also have a ZIP/RAR archive of XULPlanet someone posted to a ruskie
website. I use Foxdoc <http://percro.sssup.it/~pit/mozilla/foxdoc/> to
browse html files inside ZIP archives.

>> SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

A.2.9. Packet too large

A communication packet is a single SQL statement sent to the MySQL
server or a single row that is sent to the client.

The largest possible packet that can be transmitted to or from a MySQL
5.0 server or client is 1GB.

When a MySQL client or the mysqld server receives a packet bigger than
max_allowed_packet bytes, it issues a Packet too large error and closes
the connection. With some clients, you may also get a Lost connection to
MySQL server during query error if the communication packet is too large.

Both the client and the server have their own max_allowed_packet
variable, so if you want to handle big packets, you must increase this
variable both in the client and in the server.

If you are using the mysql client program, its default
max_allowed_packet variable is 16MB. To set a larger value, start mysql
like this:

shell> mysql --max_allowed_packet=32M

That sets the packet size to 32MB.

The server's default max_allowed_packet value is 1MB. You can increase
this if the server needs to handle big queries (for example, if you are
working with big BLOB columns). For example, to set the variable to
16MB, start the server like this:

shell> mysqld --max_allowed_packet=16M

You can also use an option file to set max_allowed_packet. For example,
to set the size for the server to 16MB, add the following lines in an
option file:

[mysqld]
max_allowed_packet=16M

....etc....

Phil
-- 
Philip Chee <philip at aleytys.pc.my>, <philip.chee at gmail.com>
http://flashblock.mozdev.org/ http://xsidebar.mozdev.org
Guard us from the she-wolf and the wolf, and guard us from the thief,
oh Night, and so be good for us to pass.
[ ]Hell hath no fury like the lawyer of a woman scorned.
* TagZilla 0.059


More information about the Project_owners mailing list