List:General Discussion« Previous MessageNext Message »
From:thomas Armstrong Date:December 10 2007 3:45pm
Subject:MySQL high CPU Load
View as plain text  
Hi

Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.

These are my server's data:
--------
back log  	50
basedir 	/usr/
bdb cache size 	8,388,600
bdb home 	/var/lib/mysql/
bdb log buffer size 	32,768
bdb logdir 	
bdb max lock 	10,000
bdb shared data 	OFF
bdb tmpdir 	/tmp/
binlog cache size 	32,768
bulk insert buffer size 	8,388,608
character set client 	utf8
(Global value) 	latin1
character set connection 	utf8
(Global value) 	latin1
character set database 	latin1
character set results 	utf8
(Global value) 	latin1
character set server 	latin1
character set system 	utf8
character sets dir 	/usr/share/mysql/charsets/
collation connection 	utf8_general_ci
(Global value) 	latin1_swedish_ci
collation database 	latin1_swedish_ci
collation server 	latin1_swedish_ci
concurrent insert 	ON
connect timeout 	5
datadir 	/var/lib/mysql/
date format 	%Y-%m-%d
datetime format 	%Y-%m-%d %H:%i:%s
default week format 	0
delay key write 	ON
delayed insert limit 	100
delayed insert timeout 	300
delayed queue size 	1,000
expire logs days 	0
flush 	OFF
flush time 	0
ft boolean syntax 	+ -><()~*:""&|
ft max word len 	84
ft min word len 	4
ft query expansion limit 	20
ft stopword file 	(built-in)
group concat max len 	1,024
have archive 	NO
have bdb 	YES
have blackhole engine 	NO
have compress 	YES
have crypt 	YES
have csv 	NO
have example engine 	NO
have geometry 	YES
have innodb 	YES
have isam 	YES
have ndbcluster 	NO
have openssl 	YES
have query cache 	YES
have raid 	NO
have rtree keys 	YES
have symlink 	YES
init connect 	
init file 	
init slave 	
innodb additional mem pool size 	1,048,576
innodb autoextend increment 	8
innodb buffer pool awe mem mb 	0
innodb buffer pool size 	8,388,608
innodb data file path 	ibdata1:10M:autoextend
innodb data home dir 	
innodb fast shutdown 	ON
innodb file io threads 	4
innodb file per table 	OFF
innodb flush log at trx commit 	1
innodb flush method 	
innodb force recovery 	0
innodb lock wait timeout 	50
innodb locks unsafe for binlog 	OFF
innodb log arch dir 	
innodb log archive 	OFF
innodb log buffer size 	1,048,576
innodb log file size 	5,242,880
innodb log files in group 	2
innodb log group home dir 	./
innodb max dirty pages pct 	90
innodb max purge lag 	0
innodb mirrored log groups 	1
innodb open files 	300
innodb table locks 	ON
innodb thread concurrency 	8
interactive timeout 	28,800
join buffer size 	131,072
key buffer size 	8,388,608
key cache age threshold 	300
key cache block size 	1,024
key cache division limit 	100
language 	/usr/share/mysql/english/
large files support 	ON
license 	GPL
local infile 	ON
locked in memory 	OFF
log 	OFF
log bin 	OFF
log error 	
log slave updates 	OFF
log slow queries 	ON
log update 	OFF
log warnings 	1
long query time 	5
low priority updates 	OFF
lower case file system 	OFF
lower case table names 	0
max allowed packet 	8,387,584
max binlog cache size 	4,294,967,295
max binlog size 	1,073,741,824
max connect errors 	10
max connections 	250
max delayed threads 	20
max error count 	64
max heap table size 	16,777,216
max insert delayed threads 	20
max join size 	4,294,967,295
max length for sort data 	1,024
max prepared stmt count 	16,382
max relay log size 	0
max seeks for key 	4,294,967,295
max sort length 	1,024
max tmp tables 	32
max user connections 	0
max write lock count 	4,294,967,295
myisam data pointer size 	4
myisam max extra sort file size 	2,147,483,648
myisam max sort file size 	2,147,483,647
myisam recover options 	OFF
myisam repair threads 	1
myisam sort buffer size 	8,388,608
myisam stats method 	nulls_unequal
net buffer length 	16,384
net read timeout 	30
net retry count 	10
net write timeout 	60
new 	OFF
old passwords 	ON
open files limit 	1,260
pid file 	/var/run/mysqld/mysqld.pid
port 	3,306
preload buffer size 	32,768
prepared stmt count 	0
protocol version 	10
query alloc block size 	8,192
query cache limit 	8,388,608
query cache min res unit 	4,096
query cache size 	16,777,216
query cache type 	ON
query cache wlock invalidate 	OFF
query prealloc size 	8,192
range alloc block size 	2,048
read buffer size 	131,072
read only 	OFF
read rnd buffer size 	262,144
relay log purge 	ON
relay log space limit 	0
rpl recovery rank 	0
secure auth 	OFF
server id 	0
skip external locking 	ON
skip networking 	OFF
skip show database 	OFF
slave net timeout 	3,600
slave transaction retries 	0
slow launch time 	2
socket 	/var/lib/mysql/mysql.sock
sort buffer size 	2,097,144
sql mode 	
sql notes 	ON
sql warnings 	ON
storage engine 	MyISAM
sync binlog 	0
sync frm 	ON
sync replication 	0
sync replication slave id 	0
sync replication timeout 	0
system time zone 	CET
table cache 	64
table type 	MyISAM
thread cache size 	0
thread stack 	131,072
time format 	%H:%i:%s
time zone 	SYSTEM
tmp table size 	33,554,432
tmpdir 	
transaction alloc block size 	8,192
transaction prealloc size 	4,096
tx isolation 	REPEATABLE-READ
version 	4.1.19-log
version bdb 	Sleepycat Software: Berkeley DB 4.1.24: (April 29, 2006)
version comment 	Source distribution
version compile machine 	i686
version compile os 	redhat-linux-gnu
wait timeout 	28,800
------------

Thank you very much.
Thread
MySQL high CPU Loadthomas Armstrong10 Dec
  • Re: MySQL high CPU Loadmos10 Dec