MySQL Forums
Forum List  »  Newbie

MySQL 4.0.20 usage 95-100% CPU :(
Posted by: Maxim V
Date: August 26, 2004 03:58AM

Hi All!

There was a problem,
MYSQL 4.0.20 approximately in day of work starts to load CPU on 95-100 %
Helps only:
#./mysql.sh stop
#./mysql.sh start

MySQL answers all inquiries, in process a sheet is not present what active processes which can so to load CPU.

What can it be?


OS: FreeBSD 4.10
MySQL 4.0.20 (src)
(CC=gcc CFLAGS="-O2 -fno-strength-reduce" \
CXX=gcc CXXFLAGS="-O2 -fno-rtti -fno-exceptions -felide-constructors \
-fno-strength-reduce" \
./configure --prefix=/usr/local/mysql --enable-assembler
)

Hardware:
CPU: Intel® XENON™ HTT 2.4 GHz х2
RAM: 1024MB
Chipset: Intel® E7501

my.cnt:
***
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
max_connections = 1000
thread_concurrency = 8
skip-bdb
skip-innodb
***



Options: ReplyQuote


Subject
Written By
Posted
MySQL 4.0.20 usage 95-100% CPU :(
August 26, 2004 03:58AM


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.