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:2000M # 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 <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
