Hello,
I run MySQL-server-pro-gpl-4.1.10a-0.sles9 on two AMD Opteron dual cpu systems
with 16GB RAM. Due to some hardware problems the mainboard of a system was
replaced with a new one. The kernel is the original one from SuSE version
kernel-smp-2.6.5-7.151.
The system runs MySQL replication as slave. The problem is that when mysql is
started the kswapd1 process runs often with very high cpu load as well as
mysqld. If mysqld does not run then anything is fine.
top - 09:04:21 up 7:03, 2 users, load average: 0.53, 0.52, 1.07
Tasks: 52 total, 4 running, 48 sleeping, 0 stopped, 0 zombie
Cpu0 : 79.0% us, 1.0% sy, 0.0% ni, 16.0% id, 4.0% wa, 0.0% hi, 0.0% si
Cpu1 : 14.1% us, 85.9% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 16357716k total, 16308892k used, 48824k free, 172908k buffers
Swap: 0k total, 0k used, 0k free, 5969556k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM SWAP TIME+ COMMAND
16 root 16 0 0 0 0 R 83.8 0.0 0 139:55.31 kswapd1
6854 mysql 16 0 9833m 9.4g 6032 S 92.7 60.5 164m 57:43.60 mysqld
6913 root 16 0 40224 2052 1404 S 0.0 0.0 37m 0:33.51 sshd
17 root 15 0 0 0 0 S 1.0 0.0 0 0:19.70 kswapd0
15 root 15 0 0 0 0 S 0.0 0.0 0 0:16.58 pdflush
1 root 16 0 640 92 48 S 0.0 0.0 548 0:06.66 init
6729 root 15 0 40224 2032 1400 R 0.0 0.0 37m 0:06.24 sshd
2940 root 16 0 26760 1596 1124 S 0.0 0.0 24m 0:00.45 sshd
3949 root 18 0 6984 788 660 S 0.0 0.0 6196 0:00.23 mingetty
639 root 25 0 0 0 0 S 0.0 0.0 0 0:00.19 kseriod
2499 root 16 0 3540 384 260 S 0.0 0.0 3156 0:00.17 syslogd
2674 root 16 0 20008 1168 728 S 0.0 0.0 18m 0:00.14 master
3952 root 19 0 6984 788 660 S 0.0 0.0 6196 0:00.14 mingetty
1321 root 16 0 2452 288 204 S 0.0 0.0 2164 0:00.13 irqbalance
3243 ntp 15 0 12252 3760 2156 S 0.0 0.0 8492 0:00.12 ntpd
2703 postfix 16 0 20116 1264 808 S 0.0 0.0 18m 0:00.11 qmgr
3953 root 20 0 6984 788 660 S 0.0 0.0 6196 0:00.10 mingetty
7 root 5 -10 0 0 0 S 0.0 0.0 0 0:00.08 events/1
2544 daemon 16 0 12640 1040 696 S 0.0 0.0 11m 0:00.08 slpd
The swap is turned off since 'swapon -s' doesn't show anything.
When the system runs as replication master node and thus handling all select
statments and data imports the cpu usage for mysqld and kswapd is almost at
100%. If swap is on then the 1GB swap device is completely used after a few
seconds and the problem ae the same.
The other machine with the same hardware and software configuration has no
problems - mysqld shows normal cpu usage and kswapd does nothing when swap is
turned off.
I've had a look into the bios configuration but found nothing unusual. Has
anyone an idea? And - well I know this is the wrong list to ask this question -
why kswapd is running when no swap device is configured and why there are some
processes using swap memory (see top output)?
Kind regards,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
