Kryptix Posted November 15, 2009 Share Posted November 15, 2009 I run a online game which is VERY MySQL based. We've been having some issues for a while now, which is allowing lots (40-150) of players logging-in at once. We don't know exactly where the problem is, but the exact same code run on other Linux servers works fine. Each login does about 8-10 queries from a large database. Is there any write restriction that can be increased or something? It's a 2.4 Quad Core processor and the CPU generally doesn't go higher than 30% but there's something, somewhere stopping this from working properly and it's becoming very difficult to track down. I'm running the standard installation of XAMPP. Link to comment https://forums.phpfreaks.com/topic/181658-windows-vs-linux/ Share on other sites More sharing options...
trq Posted November 16, 2009 Share Posted November 16, 2009 We've been having some issues for a while now, which is allowing lots (40-150) of players logging-in at once What code have you got in place to prevent this? Most sites won't limit the amount of users permitted to login. Link to comment https://forums.phpfreaks.com/topic/181658-windows-vs-linux/#findComment-958170 Share on other sites More sharing options...
corbin Posted November 16, 2009 Share Posted November 16, 2009 Sounds like it could be a schema problem. Is everything indexed properly? Also, do you have any MyISAM tables that have lots of modifying transactions in quick succession? Link to comment https://forums.phpfreaks.com/topic/181658-windows-vs-linux/#findComment-958226 Share on other sites More sharing options...
Mchl Posted November 16, 2009 Share Posted November 16, 2009 AFAIR Windows builds of MySQL have some limits as far as InnoDB HDD access is concerned. Link to comment https://forums.phpfreaks.com/topic/181658-windows-vs-linux/#findComment-958326 Share on other sites More sharing options...
fenway Posted November 19, 2009 Share Posted November 19, 2009 There are literally hundreds of differences between platforms, chipsets, filesystems, memory addressing, etc. that could be responsible. There's just no way to answer your question. Link to comment https://forums.phpfreaks.com/topic/181658-windows-vs-linux/#findComment-960975 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.