470,848 Members | 1,307 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

How do I make mysql hang

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?
Jul 20 '05 #1
2 1918
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?

Jul 20 '05 #2
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?

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Ian.H | last post: by
2 posts views Thread by Tarbuza Smith | last post: by
reply views Thread by john townsley | last post: by
reply views Thread by Arthur Perry | last post: by
3 posts views Thread by Leonardo Javier Bel?n | last post: by
2 posts views Thread by pratchaya | last post: by
2 posts views Thread by daniel | last post: by
9 posts views Thread by Derrick Shields | last post: by
13 posts views Thread by Richard Brooks | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.