Kryptix Posted January 8, 2010 Share Posted January 8, 2010 Anyone know why? I thought it was a INDEX issue at first, but now I know otherwise. I run a online game and when starting the game up 100-200 players try logging in at once which generates 5-6 queries each, and after a day or two of running these become very, very slow and end up messing the game up. Restart MySQL and all is good again, for another day or two. This never happened before. It's Windows Server 2003, latest version of MySQL originally installed through XAMPP. Any help would be appreciated. I'm pretty new to this. Quote Link to comment https://forums.phpfreaks.com/topic/187650-queries-go-slow-after-a-day-or-two-of-mysql-running/ Share on other sites More sharing options...
corbin Posted January 8, 2010 Share Posted January 8, 2010 Have you setup a slow query log? Also, are you sure it's MySQL and not the game server? Quote Link to comment https://forums.phpfreaks.com/topic/187650-queries-go-slow-after-a-day-or-two-of-mysql-running/#findComment-990729 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.