MySQL Forums
Forum List  »  PHP

lots of LOCKED processes in MySQL 4.1.16
Posted by: Max
Date: December 29, 2005 10:40AM

Hi to all! I am using MySQL 4.1.16+Apache2+php 4.4.1 about month, and i have a problem when one of my user begin use IPB (Invision power board).
I have a lots of "locked" status processes in MySQL with time more than 1000 sec.!
I dont understanding why can i do to kill them !? Help me somebody please!

Here is my.cnf
[mysqld]
#datadir=/var/lib/mysql
datadir=/wsu/db/mysql
socket=/tmp/mysql.sock

init-connect='SET NAMES cp1251'

default-character-set=cp1251
default-collation=cp1251_general_ci

log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=20

skip-locking
skip-innodb
skip-bdb

query_cache_limit=400K
query_cache_size=15M
query_cache_type=1
max_connections=300
max_user_connections=20
interactive_timeout=10
wait_timeout=5
connect_timeout=10
thread_cache_size=60
key_buffer=70M
join_buffer=5M
max_allowed_packet=14M
table_cache=1200
record_buffer=15M
sort_buffer_size=15M
read_buffer_size=10M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
#thread_concurrency=2
myisam_sort_buffer_size=15M
log-bin
#server-id=1


[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=4192

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=40M
sort_buffer=40M
read_buffer=10M
write_buffer=10M

[myisamchk]
key_buffer=40M
sort_buffer=40M
read_buffer=10M
write_buffer=10M

[mysqlhotcopy]
interactive-timeout

[client]
default-character-set=cp1251
default-collation=cp1251_general_ci


System RedHat 9.0

Help me please!

Options: ReplyQuote


Subject
Written By
Posted
lots of LOCKED processes in MySQL 4.1.16
Max
December 29, 2005 10:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.