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=comple x' '--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=Officia l 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_s ize=100000
innodb_data_fil e_path=ibdata:3 0M:autoextend:m ax:2000M
# Set buffer pool size to
# 50 - 80 % of your computer's
# memory
set-variable = innodb_buffer_p ool_size=1G
set-variable = innodb_addition al_mem_pool_siz e=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_buff er_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_siz e=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******@cores ense.com>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw