Brian,
the support for > 8000 byte rows in InnoDB is not yet in binary
distributions of MySQL. To use < 4 GB rows you have
to download InnoDB-3.23.39b source from www.innodb.com
replace it to MySQL-3.23.40 (or .39) source and recompile.
I am right now compiling and testing the new InnoDB-3.23.40b
source on Linux. It may appear for download today or
tomorrow.
The MySQL -Max binary 3.23.41 will contain InnoDB-3.23.40b,
and hence also the support for < 4 GB rows.
Regards,
Heikki
Innobase Oy
Copied message:
..............
Hi!
I'm new to the list so please forgive me if this problem has already been
solved.
I've been using MySQL for development for sometime. Up until now I've been
using
MyISAM tables. I've decided to switch to InnoDB because some table files
(*.MYD)
are approaching the OS limit.
I get the above error (139) when trying to enter a moderately sized (~ 23k)
into
a text column. This error also occurs on sparc running Solaris 2.5.
I have increased max_allowed_packet as well as net_buffer_length with no
change.
Has anyone else experienced this? Is there a workaround?
Thanks very much in advance for any advice or help.
Regards,
Brian Pittman
System: Linux pcep-1.physics.ncsu.edu 2.2.17-14 #1 Mon Feb 5 15:25:12 EST
2001 i586
unknown
Architecture: i586
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc'
CXXFLAGS='-O3
-mpentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Feb 21 08:09 /lib/libc.so.6 ->
libc-2.2.so
-rwxr-xr-x 1 root root 5073794 Jan 17 2001 /lib/libc-2.2.so
-rw-r--r-- 1 root root 24548548 Jan 17 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 17 2001 /usr/lib/libc.so
Configure command:
./configure --prefix=/home/mysql --enable-assembler --with-mysqld-ldflags=-
all-static
--disable-shared --with-innodb
----------------------------------------------------------------------------
----
---------------------------------------------------------------------
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
