Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table
corruption often. It happens about twice per week (with about 500
queries per second average). I have even set up a cron to run
mysqlcheck every hour to try to do some damage control. The biggest
problem is that once the table is corrupted, it seems to be locked.
Well, no clients can read from it. Once repaired, just one record is
usually lost for each time the corruption occurs. I am not sure if this
is a MySQL bug or even how to reproduce it, but I was hoping that
someone here could help. I have included all the information that I
have about this below. Any insight is greatly appreciated!
Here is the mysqlbug information:
Release: mysql-4.0.13 (Official MySQL RPM) C compiler: 2.95.3
C++ compiler: 2.95.3
Environment:
System: Linux *****.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002
i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/ccGCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --host=i386-redhat-linux --with-system-zlib
--enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer
-mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Nov 1 2002 /lib/libc.so.6
-> libc-2.2.93.so
-rwxr-xr-x 1 root root 1235468 Sep 5 2002
/lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 5 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 5 2002 /usr/lib/libc.so
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--without-berkeley-db' '--with-innodb' '--without-vio'
'--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--with-embedded-server' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium'
Other System Information:
The system is running hardware RAID-10 with SCSI drives. It has 4 Xeon
processors at 2.2GHz each, 2GB RAM.
MySQL Configuration (my.cnf):
[mysqld]
set-variable = max_connections=1000
set-variable = delayed_queue_size=100000
innodb_data_file_path=ibdata:30M:autoextend:max:20 00M
# Set buffer pool size to
# 50 - 80 % of your computer's
# memory
set-variable = innodb_buffer_pool_size=1G
set-variable = innodb_additional_mem_pool_size=20M
# Set the log file size to about
# 15 % of the buffer pool size
set-variable = innodb_log_file_size=150M
set-variable = innodb_log_buffer_size=8M
#
log-bin
server-id=1
master-host=192.168.1.3
master-user=repl
master-password=*****
master-port=3306
set-variable = query_cache_size=268435456
Log Entries:
[The first entry is repeated many times. The second is from the
mysqlcheck cron that repairs the tables]
030715 0:43:49 read_const: Got error 127 when reading table ****
030715 2:00:31 Note: Found 23550 of 23551 rows when repairing ****
Thanks again for your help in advance!
--
Richard Gabriel <rg******@coresense.com>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
