I have a high load on SQL and I want to set a good rules for my.cnf

Processor Information

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Quad CPU Q9300 @ 2.50GHz
Processor #1 speed: 2000.000 MHz
Processor #1 cache size: 3072 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Core(TM)2 Quad CPU Q9300 @ 2.50GHz
Processor #2 speed: 2000.000 MHz
Processor #2 cache size: 3072 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Core(TM)2 Quad CPU Q9300 @ 2.50GHz
Processor #3 speed: 2000.000 MHz
Processor #3 cache size: 3072 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Core(TM)2 Quad CPU Q9300 @ 2.50GHz
Processor #4 speed: 2000.000 MHz
Processor #4 cache size: 3072 KB


Memory Information

Memory for crash kernel (0x0 to 0x0) notwithin permissible range
Memory: 8297204k/9175040k available (2093k kernel code, 79720k reserved, 872k data, 228k init, 7460736k highmem)


System Information

Linux server.rock2host.com 2.6.18-92.1.13.el5PAE #1 SMP Wed Sep 24 20:07:49 EDT 2008 i686 i686 i386 GNU/Linux


Physical Disks

SCSI device sda: 1465147055 512-byte hdwr sectors (750155 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
SCSI device sda: 1465147055 512-byte hdwr sectors (750155 MB)
sda: Write Protect is off
sda: Mode Sense: 00 3a 00 00
SCSI device sda: drive cache: write back
sd 0:0:0:0: Attached scsi disk sda
sd 0:0:0:0: Attached scsi generic sg0 type 0


Current Memory Usage

total used free shared buffers cached
Mem: 8301400 7984756 316644 0 308676 5470164
-/+ buffers/cache: 2205916 6095484
Swap: 2031608 68 2031540
Total: 10333008 7984824 2348184


Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
675G 196G 445G 31% /
/dev/sda1 99M 18M 77M 19% /boot
tmpfs 4.0G 0 4.0G 0% /dev/shm
/usr/tmpDSK 2.0G 73M 1.8G 4% /tmp