1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help This n00b optimize his server (mysql help)

Discussion in 'Server Configuration and Hosting' started by Adam Thomson, Aug 18, 2011.

  1. Adam Thomson

    Adam Thomson Member

    Hello! Below is my server specs and would like to know what mysql optimization should I use. Right now, its just the default my.cnf but would like to know what i should change to make sure things run smoothly (Its actually 5gigs of Ram i have available)

    Code:
    Total processors: 7
    Processor #1
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #2
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #3
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #4
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #5
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #6
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    Processor #7
    Vendor
    AuthenticAMD
    Name
    AMD Opteron(tm) Processor 6128
    Speed
    1142.662 MHz
    Cache
    512 KB
    
    Memory Information
     
    System Information
    Linux vps.doom4game.com 2.6.18-238.9.1.el5.028stab089.1 #1 SMP Thu Apr 14 14:06:01 MSD 2011 i686 athlon i386 GNU/Linux
     
    Physical Disks
      
    Current Memory Usage
                total      used      free    shared    buffers    cached
    Mem:      5767168    564388    5202780          0          0          0
    -/+ buffers/cache:    564388    5202780
    Swap:            0          0          0
    Total:    5767168    564388    5202780
     
    Current Disk Usage
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/simfs            250G  4.4G  246G  2% /
    none                  2.8G  4.0K  2.8G  1% /dev
    
    
    Thanks for the help :)
     
  2. Luke F

    Luke F Well-Known Member

    7 cores?
     
  3. Slavik

    Slavik XenForo Moderator Staff Member

    Looks like a "cloud vps" solution where you can pick and chose your cpu availablity etc.

    You say its default, can you paste the actual my.cnf you have just to verify.

    Thanks
     

Share This Page