hello every one i have a game server with +1000 online player this game server has a heavy database (about 2gig) and its going to increase. this game server always run a lot of queries... and that cause delay in game server my hardware information is this: HDD SSD 240GB Kingston Hpyerx ( Read 555Mb/s , Write 510Mb/s) 1T HDD Westren Digital Cavier Black CPU XEON E5-2630 V2 32GB RAM Crucial Motherboards SUPERMICRO X9DRi-LN4F+ this is my config pls help me to config mysql i need your help
Is this 1,000 simultaneous connections on average? You may have to split up your servers and have one just to handle the large amount of queries.
Try to keep two different servers. One for your site files and one separate Database server. This will help the performance drastically.