I was having some problems with:
ERROR 1030: Got error 136 from table handler
many versions ago when my indexes got to be around 64M.
I started getting it again with 3.23.34 when I try to do inserts
into a table with this index size:
-rw-rw---- 1 mysql mysql 94232404 Mar 15 11:34 Files05.MYD
-rw-rw---- 1 mysql mysql 67058688 Mar 15 17:10 Files05.MYI
-rw-rw---- 1 mysql mysql 8664 Sep 20 00:23 Files05.frm
Here's my system info:
Server version 3.23.34
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 17 hours 34 min 7 sec
Threads: 62 Questions: 13610269 Slow queries: 0 Opens: 57 Flush tables: 1 Open
tables: 51 Queries per se
cond avg: 57.659
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux db2-3.audiogalaxy.com 2.2.18 #1 SMP Mon Dec 11 23:54:40
CST 2000 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/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer
-mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-fr
ame-pointer -felide-constructors -fno-exceptions
-fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Dec 11 23:28 /lib/libc.so.6
-> libc-2.1.94.so
-rwxr-xr-x 1 root root 4796386 Oct 5 16:46
/lib/libc-2.1.94.so
-rw-r--r-- 1 root root 22737326 Oct 5 16:09 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 5 16:09
/usr/lib/libc.so
Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all
-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefi
x=/ --with-extra-charsets=complex --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/
share --localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man --withou
t-berkeley-db --without-innobase '--with-comment=Official MySQL RPM'
--
Tom Kleinpeter
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
