1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

mysql config

Discussion in 'MySQL' started by newonee, Mar 19, 2014.

0
  1. #1
    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
     

    Attached Files:

    • my.zip
      File size:
      3.5 KB
      Views:
      174
    newonee, Mar 19, 2014 IP
  2. MikeLugar

    MikeLugar Well-Known Member

    Messages:
    1,453
    Likes Received:
    36
    Best Answers:
    2
    Trophy Points:
    150
    #2
    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.
     
    MikeLugar, Mar 20, 2014 IP
  3. adams26

    adams26 Well-Known Member

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    108
    #3
    Try to keep two different servers. One for your site files and one separate Database server. This will help the performance drastically.
     
    adams26, Apr 9, 2014 IP