Q:

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 the 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? 

A:

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.