Way over my head!

chinclub

I have written a PHP script and now I am learning how much I don't know because although my site only has 20 people or less on at a time I have too many clicks per second and have crashed my webhost. I then had to buy a dedicated server just to keep it active until I can figure out where to go to hire someone to help me optimize my script. In the mean time she sent me a readout of the processes running. Many of them I recognized as actions called by my PHP scripts but there were a ton of these:

8 fsvzwtpl_virtual localhost fsvzwtpl_virtualpet Sleep 1 NULL
11 fsvzwtpl_virtual localhost fsvzwtpl_virtualpet Sleep 7 NULL
etc...

What is that and what might cause it? Also, does anyone know where I might could go to find someone to hire to help optimize my scripts?

rulian

what do you mean your site is crashing,
did you reach your bandwith limit?
does your website freeze?
do you get error messages on it?
can we get a link to it?

chinclub

No, I am not even close to my bandwidth limit. Apparently my clicks per second ratio is too high on the database and I am tieing up the database so much that it is not usable to any of the other sites hosted. I had to close the site until I could fix it. My host gave me a list of the processes to the database over a 30 second span and three were queries I recognized from my scripts but the rest were just the

Sleep 1 NULL

sort of thing and I have no idea what causes that.