2 messages in com.mysql.lists.bugsmax_allowed_packet bigger than 64MB| From | Sent On | Attachments |
|---|---|---|
| Christian Gruber | 17 Sep 2002 06:39 | |
| Michael Widenius | 18 Sep 2002 11:06 |
| Subject: | max_allowed_packet bigger than 64MB |
|---|---|
| From: | Christian Gruber (Chri...@biomax.de) |
| Date: | 09/17/2002 06:39:24 AM |
| List: | com.mysql.lists.bugs |
Description:
I cannot set the parameter max_allowed_packet to values bigger than 64MB. According to the documentation, the upper limit for this variable is 2GB.
How-To-Repeat:
Set the variable max_allowed_packet to a value bigger than 64MB in /etc/my.cnf and restart mysqld. "show variables like '%packet%'" gives then the result of 62913536 bytes. When the variable is set to a value smaller than 64MB, it is set to the requested value.
Fix:
No fix available for me.
Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-4.0.3-beta-max (Official MySQL-max binary) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.48, for suse-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.3-beta-max-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql_3306.sock Uptime: 43 min 24 sec
Threads: 3 Questions: 11 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 0 Queries per second avg: 0.004
Environment:
<machine, os, target, libraries (multiple lines)> System: Linux succinat 2.4.19 #1 SMP Fri Aug 16 17:39:04 PDT 2002 i686 unknown Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-O2 -mpentium ' CXX='gcc' CXXFLAGS='-O2
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
-rwxr-xr-x 1 root root 1394238 Jul 12 17:29 /lib/libc.so.6
-rw-r--r-- 1 root root 25361424 Jul 12 15:58 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 23 19:05 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL-max binary' --with-extra-charsets=complex
--with-server-suffix=-max --enable-thread-safe-client --enable-local-infile
--enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared --with-berkeley-db
--with-raid --with-innodb 'CFLAGS=-O2 -mpentium ' 'CXXFLAGS=-O2 -mpentium
-felide-constructors' CXX=gcc LDFLAGS=-static