Top zegt:
28122 mysql 15 0 79480 13m 3428 S 94.8 0.7 0:14.79 mysqld
94,8% CPU load dus voor mysqld.
Hoe kan ik uitvinden waar deze load vandaan komt?
1e keer server geherstart: direct terug zoveel load
2e keer server geherstart: direct terug zoveel load
ik herstart de server met:
service mysqld start --log-slow-queries
En nu komt de cpu load niet boven de 30%
Een beetje raar, of zit daar een verklaring achter?
locate *-slow.log
kan niets vinden...
Dus toch geen trage query's ofzo?
my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqld]
skip-locking
skip-innodb
query_cache_limit=21M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=30
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1
[safe_mysqld]
#err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
==> Moet er hier soms iets verbeterd worden?
Ik probeer nu al geen select * te gebruiken en goede indexes...