Hi,
what might happen is that Solaris (including Solaris 7, but not Solaris 8) does
pageouts of text and data pages of a process in order to increas diskcache. That
means mysqld is able to force itself out of memory by doing io an large tables.
There is something to do about it: in /etc/system you can put set priority_paging=1
look it up on docs.sun.com before setting. This will tell the pageoutdeamon to free
cachepages in favor to other memory. (BTW The swap in use count does show how much
swap space is reserved but not necessarily used (pageouts done to it) on Solaris.)
lars
Thierry Coopman wrote:
> 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
---------------------------------------------------------------------
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
