sfxworks Posted July 7, 2011 Share Posted July 7, 2011 Let me explain. I host a game. When a player talks, creates, destroys, or does anything of the sorts, it gets logged into the mysql database. When I hosted this locally, everything was completely instant. Now, im having to constantly restart my server because the queue to the databse keeps getting overloaded (in the thousands). Is this a latency issue? I mean, I bought my server... Quote Link to comment https://forums.phpfreaks.com/topic/241368-network-limitations/ Share on other sites More sharing options...
gristoi Posted July 8, 2011 Share Posted July 8, 2011 Could be a memory leak, basically a query, or piece of code logic, you wrote could be causing an issue. For example you caould have a query that incorectly joins two tables and instead of searching 100 records it search 1,000,000 records. The best way to get started at tracking the issue down is to look at using your slow query log ( google it). Secondly look at how to use the mysql EXPLAIN function. this will tell you exactly how many rows of data you query is traversing to get your results. Also look into indexing your tables. Quote Link to comment https://forums.phpfreaks.com/topic/241368-network-limitations/#findComment-1240040 Share on other sites More sharing options...
fenway Posted July 8, 2011 Share Posted July 8, 2011 What the "queue to the database"? Quote Link to comment https://forums.phpfreaks.com/topic/241368-network-limitations/#findComment-1240070 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.