I have noticed that my server running mysql-3.23.45 on Solaris 8/400MHz sparc/1GB ram system appears to be only using up swap space and not free memory. During light usage this doesn't seem to be a problem but under heavy usage this causes my cpu to hit 90 - 100% at times. Even with nothing but the OS running on my system and I start mysql it seems to only grab swap. I am strictly using the my-small, my-medium & my-large configuration files as a reference. Here is the output from top with my-large so that you can easily see the swap usage. I have never seen this activity before and it has me stumped, I can only duplicate this on Solaris 8 02/02 release, os patches are up to date. Has anyone seen this activity before?
This is before mysql:
CPU states: 96.4% idle, 1.0% user, 2.6% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M real, 866M free, 19M swap in use, 1787M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
21836 root 1 50 0 2232K 1608K cpu 0:00 0.44% top
21833 root 1 12 0 2616K 2072K sleep 0:00 0.27% logit
21844 root 1 22 0 1176K 1032K sleep 0:00 0.04% iostat
16686 root 1 58 0 3360K 2224K sleep 0:07 0.03% sshd
223 root 17 55 0 8624K 7960K sleep 1:18 0.03% nscd
21832 root 1 48 0 1032K 864K sleep 0:00 0.03% sh
1 root 1 58 0 2336K 1384K sleep 0:44 0.02% init
16690 root 1 48 0 2496K 1992K sleep 0:01 0.02% bash
210 root 12 58 0 4000K 2328K sleep 0:03 0.00% syslogd
313 root 1 59 0 3168K 1728K sleep 0:01 0.00% sendmail
16688 jds 1 48 0 2408K 1872K sleep 0:00 0.00% bash
197 root 1 48 0 1784K 984K sleep 0:00 0.00% inetd
16689 root 1 48 0 312K 312K sleep 0:00 0.00% sh
49 root 5 51 0 1288K 808K sleep 0:00 0.00% syseventconfd
47 root 9 52 0 1480K 1112K sleep 0:00 0.00% syseventd
This is after:
CPU states: 98.0% idle, 0.4% user, 1.4% kernel, 0.2% iowait, 0.0% swap
Memory: 1024M real, 862M free, 275M swap in use, 1530M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
21885 root 1 50 0 2232K 1608K cpu 0:00 0.44% top
21871 mysql 11 20 0 260M 4888K sleep 0:00 0.24% mysqld
21873 root 1 41 0 2616K 2072K sleep 0:00 0.19% logit
16686 root 1 58 0 3360K 2224K sleep 0:07 0.15% sshd
16690 root 1 48 0 2496K 1992K sleep 0:01 0.10% bash
21886 root 1 51 0 1800K 1304K sleep 0:00 0.09% netstat
223 root 17 55 0 8624K 7960K sleep 1:18 0.06% nscd
21872 root 1 48 0 1032K 864K sleep 0:00 0.05% sh
21852 root 1 20 0 1040K 872K sleep 0:00 0.05% safe_mysqld
1 root 1 58 0 2336K 1384K sleep 0:44 0.02% init
210 root 12 58 0 4000K 2328K sleep 0:03 0.00% syslogd
313 root 1 59 0 3168K 1728K sleep 0:01 0.00% sendmail
16688 jds 1 48 0 2408K 1872K sleep 0:00 0.00% bash
197 root 1 48 0 1784K 984K sleep 0:00 0.00% inetd
16689 root 1 48 0 312K 312K sleep 0:00 0.00% sh
At 09:20 AM 12/16/2002 -0800, you wrote:
On Mon, Dec 16, 2002 at 10:43:28AM -0600, Jamie Sullivan wrote:
> Hello,
>
> I am setting up a mySQL box in my development environment and have
> noticed that even under little usage mysql will consume a couple
> hundred MB's of swap space even though I have almost 1GB of apparent
> "free" physical memory. I am using the 'my-large.cnf' configuration
> file and otherwise haven't modified anything. The server is a 400Mhz
> sparc w/ 2GB ram and 1 SCSI disk. Can someone please provide some
> guidance as to whether this is normal or am I not configuring
> something properly.
What OS are you using?
Some versions of the Linux kernel had problems that caused it to
needlessly swap out MySQL memory when there was lots of memory still
available.
Here was some of my original discussion on the topic:
http://jeremy.zawodny.com/blog/archives/000132.html
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 1 days, processed 55,530,181 queries (426/sec. avg)
---------------------------------------------------------------------
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
Jamie Sullivan EOS, Inc. 717 South Grand Avenue West Springfield, IL 62704 217-241-6000 ext.104 [EMAIL PROTECTED] --------------------------------------------------------------------- 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
