some one professional ##(Please Help)##
hiI have a very strong load in my server same time from vBulletin script site
I want some one professional to optimizing my.cnf MySql setting
There is my server info:
CPU
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) D CPU 3.00GHz
Processor #1 speed: 3000.582 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) D CPU 3.00GHz
Processor #2 speed: 3000.582 MHz
Processor #2 cache size: 1024 KB
Memory Information
Memory: 513388k/524032k available (1868k kernel code, 10012k reserved, 755k data, 180k init, 0k highmem)
System Information
Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux
urrent Memory Usage
total used free shared buffers cached
Mem: 514292 496668 17624 0 21932 192712
-/+ buffers/cache: 282024 232268
Swap: 2096472 128780 1967692
Total: 2610764 625448 1985316
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) D CPU 3.00GHz
Processor #1 speed: 3000.582 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Pentium(R) D CPU 3.00GHz
Processor #2 speed: 3000.582 MHz
Processor #2 cache size: 1024 KB
Memory Information
Memory: 513388k/524032k available (1868k kernel code, 10012k reserved, 755k data, 180k init, 0k highmem)
System Information
Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux
urrent Memory Usage
total used free shared buffers cached
Mem: 514292 496668 17624 0 21932 192712
-/+ buffers/cache: 282024 232268
Swap: 2096472 128780 1967692
Total: 2610764 625448 1985316
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1000
interactive_timeout=10
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1000
interactive_timeout=10
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
can some one give me a right sitting ?
Thank you