Help This n00b optimize his server (mysql help)

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 :)
 

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

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)
Thanks for the help :)

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

Thanks
 
Top Bottom