Hi,
I have a Sun R220 single CPU with 512MB RAM.
I start mysql using
$bindir/safe_mysqld \
--datadir=$datadir --pid-file=$pid_file \
-O wait_timeout=180 -O key_buffer=256M -O
max_connections=250 -O table_cache=512 -O sort_buffer=2M -O
thread_cache=8 -O record_buffer=2M -O thread_concurrency=2 -O
myisam_sort_buffer_size=64M --log-slow-queries&
I have the output of a top below...
If I start the mysql deamon it immediatly starts using swap space and
I want to avoid this.
I will start using HEAP tables, but since the machine is swapping
right now, I can't see the benifit.
I try to do 500+ updates per second and have several hundered inserts
per second also. I'm convinced that this machine should be able to
handle that with ease, but why does it start swapping if I start the
mysqldeamon
last pid: 9109; load averages: 0.65, 0.73, 0.72
16:41:35
21 processes: 19 sleeping, 1 running, 1 on cpu
CPU states: 19.7% idle, 30.8% user, 21.1% kernel, 28.4% iowait, 0.0% swap
Memory: 512M real, 9424K free, 377M swap in use, 2069M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
8833 root 25 48 0 370M 222M run 32.6H 43.38% mysqld
9109 root 1 58 0 2496K 1792K cpu 0:00 0.02% top
136 root 8 55 0 2608K 1328K sleep 1:35 0.00% nscd
1 root 1 58 0 744K 96K sleep 0:09 0.00% init
9010 root 1 59 0 1944K 624K sleep 0:04 0.00% sshd1
9092 root 1 58 0 1944K 1440K sleep 0:03 0.00% sshd1
120 root 12 58 0 3272K 1128K sleep 0:03 0.00% syslogd
168 root 1 58 0 1000K 552K sleep 0:01 0.00% utmpd
109 root 1 0 0 1688K 480K sleep 0:00 0.00% inetd
8814 root 1 0 0 1032K 464K sleep 0:00 0.00% safe_mysqld
49 root 4 33 0 2224K 552K sleep 0:00 0.00% devfsadm
184 root 1 38 0 1704K 552K sleep 0:00 0.00% ttymon
159 root 3 41 0 1264K 512K sleep 0:00 0.00% powerd
173 root 6 43 0 2488K 736K sleep 0:00 0.00% vold
47 root 7 43 0 1232K 536K sleep 0:00 0.00% devfseventd
9095 root 1 48 0 2408K 1688K sleep 0:00 0.00% bash
9013 root 1 48 0 2408K 624K sleep 0:00 0.00% bash
121 root 1 48 0 1776K 624K sleep 0:00 0.00% cron
138 root 1 58 0 2496K 976K sleep 0:00 0.00% sshd2
183 root 1 58 0 1640K 680K sleep 0:00 0.00% sac
187 root 1 59 0 1720K 736K sleep 0:00 0.00% ttymon
here's the output of mysqladmin version
Server version 3.23.27-beta-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 14 days 6 hours 25 min 49 sec
Threads: 22 Questions: 144381525 Slow queries: 0 Opens: 0 Flush
tables: 1 Open tables: 161 Queries per second avg: 117.122
--
Thierry Coopman - [EMAIL PROTECTED]
My opinions are personal, and have really nothing or nothing to do
with Keytrade!
You know that you are drinking too much coffee if:
You can take a picture of yourself from ten feet away without using the timer.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
