JSON Spawning mysql sleep processes

I am in the process of making a Javascript(Front end, PHP back end) game. In this game it checks the server for updates every 2 seconds. There is one 1 sql call being run and at the end I use $mysqli->close() to close the SQL connection. The columns in th开发者_运维知识库e where are both indexed.

The problem I am having is after its running for a little while MYSQL starts spawning tons of sleep processes. Does anyone have any idea what might be causing this?

---

I'd push updates to your users instead of polling for them. Check out the AJAX Push Engine, that can help a lot. Also, turn on persistent MySQL connections, that could help.

---

Do the processes stick around? Mysql likes to keep a few threads open to recieve requests, i wouldn't worry about them unless it leaving a lot of them open and there taking up resources.

If your hitting the request every 2 seconds its cheaper to keep the pool waiting for a request than instantiating a connection every time.