Hello ,
i have Intel(R) Xeon(R) CPU E5405 @ 2.00GHz server with 8 cpus and 6 giga ram
and my forum have 8k unique visitors per day ,
and forum mysql take all resource and make load very very high
see for ex :
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4519 mysql 15 0 689m 324m 4016 S 454.0 5.4 56:36.81 mysqld
take more than 400 % from cpu
and this my.cnf config
i hope some one here check that !! and advise me what i do !
realted ticket : Ticketid: 1062285
i have Intel(R) Xeon(R) CPU E5405 @ 2.00GHz server with 8 cpus and 6 giga ram
and my forum have 8k unique visitors per day ,
and forum mysql take all resource and make load very very high
see for ex :
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4519 mysql 15 0 689m 324m 4016 S 454.0 5.4 56:36.81 mysqld
take more than 400 % from cpu
and this my.cnf config
PHP Code:
[mysqld]
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=64M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=100
max_connections=200
interactive_timeout=30
wait_timeout=200
connect_timeout=200
thread_cache_size=128
key_buffer=128M ## 64MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
old-passwords = 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
#safe-updates
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
open_files_limit=8192
[mysqlhotcopy]
interactive-timeout
realted ticket : Ticketid: 1062285
Comment