Richard, ----- Original Message ----- From: "Richard Gabriel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help
> Thanks for the tip. I'll see about upgrading, but it won't be a small task. > Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm > trying to search for a solution that does not involve upgrading kernels on > 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. > Richard Gabriel > Director of Technology, > CoreSense Inc. > (518) 306-3043 x3951 Regards, Heikki > ----- Original Message ----- > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, July 15, 2003 3:45 PM > Subject: Re: Frequent Table Corruption - Please Help > > > > Richard, > > > > you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much > more > > reliable. > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > http://www.innodb.com > > Transactions, foreign keys, and a hot backup tool for MySQL > > Order MySQL technical support from https://order.mysql.com/ > > > > ----- Original Message ----- > > From: "Richard Gabriel" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.mysql > > Sent: Tuesday, July 15, 2003 9:52 PM > > Subject: 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: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] > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
