Date: Sat, 17 Mar 2001 21:52:50 -0600 From: rand@meridian-enviro.com To: Mike Smith <msmith@FreeBSD.ORG> Cc: "Douglas K. Rand" <rand@meridian-enviro.com>, freebsd-stable@FreeBSD.ORG, Mike Tancsa <mike@sentex.net>, bryanh@meridian-enviro.com Subject: Re: 3ware problems Message-ID: <87itl768dp.wl@localhost.meridian-enviro.com> In-Reply-To: <200103180251.f2I2pEU04264@mass.dis.org> References: <3AB27EE5.7CCB1387@meridian-enviro.com> <200103180251.f2I2pEU04264@mass.dis.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Doug> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?87itl768dp.wl>