469,600 Members | 2,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

Frequent Table Corruption - Please Help

Hi everyone,

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

Jul 19 '05 #1
0 1597

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Richard Gabriel | last post: by
2 posts views Thread by Patrick Fleury | last post: by
21 posts views Thread by Dan | last post: by
5 posts views Thread by Upendra Agnihotram | last post: by
19 posts views Thread by adirat | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.