Windows vs. Linux

[Kryptix]

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.

[trq]

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.

[corbin]

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?

[Mchl]

AFAIR Windows builds of MySQL have some limits as far as InnoDB HDD access is concerned.

[fenway]

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.