Kryptix Posted October 31, 2009 Share Posted October 31, 2009 I don't know what to title this really, but I own a online game that uses MySQL as it's back on which transfers hundreds of queries every minute. Sometimes the game will just drop for some reason, but the people online will remain online. It's just the login process (which uses the most queries). I'm using a bog-standard MySQL install, and whilst the CPU isn't overloaded I was wandering if there's anything in MySQL that would restrict me? Is there a certain limit that I have to up or something? Quote Link to comment https://forums.phpfreaks.com/topic/179698-too-many-connections-too-many-queries/ Share on other sites More sharing options...
slyte33 Posted October 31, 2009 Share Posted October 31, 2009 I, too, own an online game and i believe it depends on your database storage usage. I use godaddy and pay a pretty penny a month for a dedicated server, so i'm basically unlimited with no lag. Since your the creator and owner of the domain you use and everything, your connection is usually different, meaning the site could be offline for you, but online with no lag for others. If you have over 500 active players online at once, and your not on a dedicated server, youll probably get a 503 server timeout for the whole day. You need a dedicated server so you can set your own max connections, without it you can only get a certain amount which will in no way work out for a big rpg game. Quote Link to comment https://forums.phpfreaks.com/topic/179698-too-many-connections-too-many-queries/#findComment-948173 Share on other sites More sharing options...
Kryptix Posted October 31, 2009 Author Share Posted October 31, 2009 I'm on a Quad Core 2.4 dedicated server with 4gB RAM, 1tB HDD, 100mB/s Port and 50,000pps DDoS Protection... It's nothing to do with that, if there's anything it's MySQL settings/configuration... But I don't know enough about it to be certain. Quote Link to comment https://forums.phpfreaks.com/topic/179698-too-many-connections-too-many-queries/#findComment-948468 Share on other sites More sharing options...
Mchl Posted October 31, 2009 Share Posted October 31, 2009 Check these for example: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_user_connections Quote Link to comment https://forums.phpfreaks.com/topic/179698-too-many-connections-too-many-queries/#findComment-948481 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.