Re: MySQL under heavy load

[Mike808 <mike808@users.sourceforge.net>]

Dav Glass wrote:
> Has anyone here used MySQL under a heavy load?
> 
> I know the MySQL site claims that their db can handle a heavy load, but they
> never say what a heavy load is.

Don't let that bother you. Oracle and MSSQL say and do the same thing.

I take it you've tweaked the OS for: loads of filehandles and raised the
maxes per-user and per-shell, boosted the socket wait queues?

Could it be a problem in the RAID drivers? Since MySQL is user-space stuff,
and panics are typically kernel-space, that points me towards hardware 
drivers. Since the disk is obviously getting a workout here, perhaps
that's where the problem lies. Try talking to your controller driver
vendor/authors and see if they can help diagnose it further, if not
replicate the problem.

Can you setup a testbench and replicate the problem independent of your
data and queries (i.e. with made-up dummy queries) and hammer it to cough
up a panic on cue?

Mike808/
-- 
perl -le "$_='7284254074:0930970:H4012816';tr[0->][ BOPEN!SMUT];print"

-
To unsubscribe, send email to majordomo@silug.org with
"unsubscribe silug-discuss" in the body.