Optimization help with 16 gig ram server

hi Optimization help with 16 gig ram server?

server information :

Total processors: 8
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #3
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #4
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #5
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #6
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #7
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB
Processor #8
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Speed
3599.999 MHz
Cache
10240 KB

*********************************
Memory Information
[ 0.000000] Memory: 16269204k/17825792k available (5391k kernel code, 1049092k absent, 507496k reserved, 6983k data, 1352k init)

**********************************
System Information
Linux 2.6.32-604.16.2.lve1.3.54.el6.x86_64 #1 SMP Mon Jul 27 11:32:29 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
**********************************
Physical Disks
[ 1.845671] sd 2:0:0:0: [sda] 419430400 512-byte logical blocks: (214 GB/200 GiB)
[ 1.845691] sd 2:0:0:0: [sda] Write Protect is off
[ 1.845693] sd 2:0:0:0: [sda] Mode Sense: 61 00 00 00
[ 1.845712] sd 2:0:0:0: [sda] Cache data unavailable
[ 1.845713] sd 2:0:0:0: [sda] Assuming drive cache: write through
[ 1.845817] sd 2:0:0:0: [sda] Cache data unavailable
[ 1.845819] sd 2:0:0:0: [sda] Assuming drive cache: write through
[ 1.845821] sda: sda1 sda2
[ 1.846276] sd 2:0:0:0: [sda] Cache data unavailable
[ 1.846278] sd 2:0:0:0: [sda] Assuming drive cache: write through
[ 1.846280] sd 2:0:0:0: [sda] Attached SCSI disk
[ 24.838356] sd 2:0:0:0: Attached scsi generic sg1 type 0

*****************************************
Current Memory Usage
total used free shared buffers cached
Mem: 16296416 13402124 2894292 504 417332 11556780
-/+ buffers/cache: 1428012 14868404
Swap: 8241148 0 8241148
Total: 24537564 13402124 11135440
*******************************************
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_srv1-lv_root 50G 19G 28G 41% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sda1 477M 137M 316M 31% /boot
/dev/mapper/vg_srv1-lv_home 140G 1.6G 131G 2% /home

*******************************************

mysql :
[mysqld]
default-storage-engine= MyISAM
local-infile=0
max_connections = 600
max_user_connections=1000
key_buffer_size = 512M
myisam_sort_buffer_size = 64M
read_buffer_size = 1M
table_open_cache = 5000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 128M
max_allowed_packet=268435456
net_buffer_length = 16384
max_connect_errors = 10
concurrent_insert = 2
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 5M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65535
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
max_write_lock_count = 8
log-error
external-locking=FALSE
open_files_limit=50000

[mysqld_safe]

[mysqldump]
quick
max_allowed_packet = 16M

[isamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M

[myisamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M

#### Per connection configuration ####
sort_buffer_size = 1M
join_buffer_size = 1M
thread_stack = 192K
thanks
Optimization help with 16 gig ram server

Comments

Didn't find what you were looking for?
