Thierry Coopman writes:
> 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.
Hi!
You have allocated half of RAM for a key_buffer. It is allocated
entirely on mysqld startup.
You have set high sort and record buffer, and every single query that
needs them allocates them on startup and frees them on exit. So if you
have lot's of simultaneous queries running you can have lot's of
memory used up.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
