How do I make mysql hang

[Jeremy K]

So one of my production mysql server's starts to hang every once in
awhile, threads keep on building up and building up until it's
completely unresponsive. Right now my clients aren't dealing with
that well, they will try to make the connection and hold on to it
forever until I go in a kill all the mysqld on the server.

I want to try to do some things to make the clients behave better in
this situation, but I need to be able to reproduce mysqld hanging in
development to see if my fixes work.

Any idea on how I can do this to my server on purpose?

[Greg Brant]

im no genious (or SQL warrior) but can you put it into an infinate loop?

you could use the function constructor to declair a function to MySQL and
then call the function from inside its self?

might that work
or is there some safety about recursion???

"Jeremy K" <jk******@yahoo.com> wrote in message
news:ed**************************@posting.google.c om...

So one of my production mysql server's starts to hang every once in
awhile, threads keep on building up and building up until it's
completely unresponsive. Right now my clients aren't dealing with
that well, they will try to make the connection and hold on to it
forever until I go in a kill all the mysqld on the server.

I want to try to do some things to make the clients behave better in
this situation, but I need to be able to reproduce mysqld hanging in
development to see if my fixes work.

Any idea on how I can do this to my server on purpose?

[Greg Brant]

im no genious (or SQL warrior) but can you put it into an infinate loop?

you could use the function constructor to declair a function to MySQL and
then call the function from inside its self?

might that work
or is there some safety about recursion???

"Jeremy K" <jk******@yahoo.com> wrote in message
news:ed**************************@posting.google.c om...

So one of my production mysql server's starts to hang every once in
awhile, threads keep on building up and building up until it's
completely unresponsive. Right now my clients aren't dealing with
that well, they will try to make the connection and hold on to it
forever until I go in a kill all the mysqld on the server.

I want to try to do some things to make the clients behave better in
this situation, but I need to be able to reproduce mysqld hanging in
development to see if my fixes work.

Any idea on how I can do this to my server on purpose?