From owner-freebsd-stable Sat Mar 17 19:52:59 2001 Delivered-To: freebsd-stable@freebsd.org Received: from agena.meridian-enviro.com (thunder.meridian-enviro.com [207.109.234.227]) by hub.freebsd.org (Postfix) with ESMTP id 4712437B71B; Sat, 17 Mar 2001 19:52:55 -0800 (PST) (envelope-from rand@meridian-enviro.com) Received: from localhost.meridian-enviro.com (kfarms.meridian-enviro.com [10.10.10.20]) by agena.meridian-enviro.com (8.11.1/8.9.3) with ESMTP id f2I3qpQ50317; Sat, 17 Mar 2001 21:52:52 -0600 (CST) (envelope-from rand@meridian-enviro.com) Date: Sat, 17 Mar 2001 21:52:50 -0600 Message-ID: <87itl768dp.wl@localhost.meridian-enviro.com> From: rand@meridian-enviro.com To: Mike Smith Cc: "Douglas K. Rand" , freebsd-stable@FreeBSD.ORG, Mike Tancsa , bryanh@meridian-enviro.com Subject: Re: 3ware problems In-Reply-To: <200103180251.f2I2pEU04264@mass.dis.org> References: <3AB27EE5.7CCB1387@meridian-enviro.com> <200103180251.f2I2pEU04264@mass.dis.org> User-Agent: Wanderlust/2.5.8 (Smooth) SEMI/1.14.3 (Ushinoya) FLIM/1.14.2 (Yagi-Nishiguchi) APEL/10.2 MULE XEmacs/21.1 (patch 14) (Cuyahoga Valley) (i386--freebsd) X-Face: $L%T~#'9fAQ])o]A][d7EH`V;"_;2K;TEPQB=v]rDf_2s% So far the only way I can get the problem to show up is banging Doug> on MySQL for 3-12 hours. Doug> Here is a short perl script that along with MySQL 3.23.33 will Doug> hang our 3ware controller: Mike> I had to change this to 'fortune -s' to prevent the server from Mike> aborting the client connection, but it's just passed 2.5M rows Mike> and still counting. This has run up until 10 million rows or so with out failing for us. Sometimes if fails earlier, but not often before 2 million rows. I've had it insert 30 million rows before. Mike> Do you have any other tuning in effect? Is the filesystem Mike> mounted with softupdates enabled, for example? We do have softupdates on the filesystem, but it has failed for us with out softupdates. We also have a few things in the my.cnf file: skip-locking set-variable = max_allowed_packet=24M set-variable = key_buffer=128M set-variable = table_cache=128 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 Although we have reproduced the problem with out any tuning. Mike> Please find attached diffs to bring the driver up to my current Mike> working version. There's a couple of small races closed in this Mike> code which might have an effect on your problem (not sure about Mike> that, though), so I'd love to know if they help you. Just as soon as I watch the University of North Dakota win the WCHA in overtime I'll rebuild the kernel with your patch and run it again. :) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message