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
***
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.