4 forum sites locking mysql
Posted: Fri Sep 01, 2006 8:00 am
hello,
we have a dedicated server with the configuration of ;
- xeon 3.0, 3 gigs of ram running on Apache/2.0.52 (CentOS) and mysql 4.1.20
we have 4 forum sites running PHP & MySql, 2 of them are PHP BB2, the others are developed by themselves.
The problem is ;
the usage of mysql sometimes picks to %100 and we have no chance but restart the mysql service.
do you have any ideas to resolve the problem ?
our mySQL config file like that ;
we have a dedicated server with the configuration of ;
- xeon 3.0, 3 gigs of ram running on Apache/2.0.52 (CentOS) and mysql 4.1.20
we have 4 forum sites running PHP & MySql, 2 of them are PHP BB2, the others are developed by themselves.
The problem is ;
the usage of mysql sometimes picks to %100 and we have no chance but restart the mysql service.
do you have any ideas to resolve the problem ?
our mySQL config file like that ;
Code: Select all
[mysqld]
query_cache_type=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_size=128M
connect_timeout=5
max_connections=300
thread_cache=100
thread_concurrency=120
thread_stack=512000
key_buffer_size=512K
sort_buffer_size=100K
read_buffer_size=100K
max_allowed_packet=64M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/my
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/my