Ady, INSERT into .. SELECT .. would be the largest part of the workload. My workload is a relatively small number of relatively large operations. Your reported bug appears to be the other way around.
I am using MyISAM - very large quantities of data - can't afford, and don't need, transactions. For me, MySQL 5 on 2.4 seems to be less unstable than on 2.6, although I'm getting TomCat hangs on 2.4, but that's another story and may be hiding MySQL instability. Dave -----Original Message----- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 11:38 PM To: Dave Pullin Cc: mysql@lists.mysql.com Subject: Re: Signal 11 crashes on MySQL V5 Dave What common transaction you have? INSERT? SELECT? UPDATE? DELETE? Are you using InnoDB? I have my personal experience with InnoDB and MySQL 5, with kernel 2.4 (as you use on RedHat 9) MySQL 5 is unstable on high load insert/update/delete with kernel 2.6 (CentOS, Fedora, ...) you'll get more stability but it still not stable enough. Please see http://forums.mysql.com/read.php?22,74279,74279#msg-74279 It has been confirmed as bug on MySQL 5. Dave Pullin wrote: >I am running MySQL on 6 servers - 3 Linux and 3 Windows. I recently upgraded >to V5 on all servers. Now MySQL is crashing regularly (several times per >day, some days) with 'got signal 11'. > >My 3 Linux servers are very different machines running different software >a uniprocessor Pentium with 512MB running Redhat9 with MySQL 5.0.18-0.i386 >, a new dual XEON with 8GB running Fedora Core 4 with 64bit MySQL >5.0.18-0.glibc23.x86_64 >, a old quad XEON with 4GB running Fedora Core 4 with MySQL 5.0.18-0.i386 > >The windows machines are not having a problem. All 6 are running essentially >the same application. > >It seems unlikely to be a hardware problem because its on 3 machines at >once. It looks like a MySQL V5 problem but I can't pin it down to anything >specific enough to report a bug. > >Anyone had similar experiences with MySQL V5? > >Dave > > > > -- 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]
