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