I'm running a PHP based game which has over 45 Million members predicted for end of this year (2011) Currently we are on 7.5 Million, this game is being ran on facebook and I am in desperate need to help get this game server as efficient and as powerful as possible.
it is a dedicated server with
Processor Manufacturer Intel Model i7 920 Frequency 4x 2x 2.66 GHz NIC GigaEthernet RAM 12 GB Hard disk 4 x 1 TB
It has apache installed, cPanel, phpMyAdmin, several apache mods and MySQL.
The game also runs 47 mysql calls per second per user.
Is there any alternatives to the above which could be faster, more efficient etc?
I dont mind having to recode the game to fit to it, as long as it maximises our upper limit of members on the game.
Also, is there a way to tell what our maximum limit to players, database calls etc is?
Thank you again, hope you guys can help :)