Hello, I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram.
I am only using InnoDB for databases (40gb) other than the mysql.*. I have the following relevant memory settings: set-variable = sort_buffer=2M set-variable = record_buffer=2M ## For redhat 8.0 set-variable = thread_stack=192k set-variable = myisam_sort_buffer_size=2M ... set-variable = innodb_log_buffer_size=30M set-variable = innodb_buffer_pool_size=396M set-variable = innodb_additional_mem_pool_size=2M I don't have anything other than the basic daemons running on this machine. Top reports: 71 processes: 69 sleeping, 2 running, 0 zombie, 0 stopped CPU0 states: 6.0% user, 1.0% system, 0.0% nice, 91.0% idle CPU1 states: 55.1% user, 11.1% system, 0.0% nice, 32.0% idle Mem: 513296K av, 506796K used, 6500K free, 0K shrd, 7468K buff Swap: 1048568K av, 241628K used, 806940K free 159928K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 2772 mysql.pr 15 0 480M 302M 53104 S 63.8 60.3 1:15 mysqld-max Vmstat reports: [EMAIL PROTECTED] prod]# vmstat 1 procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 1 0 0 376168 6580 3176 105724 2 3 10 25 259 10 0 0 99 0 1 0 376168 7160 3212 104216 1064 0 1064 5823 846 631 30 3 67 1 0 0 376168 6592 3192 101156 1688 0 1700 5820 988 929 30 4 67 1 0 0 376168 6516 2680 102644 848 16 2924 6312 769 627 29 8 63 This doesn't seem right. Why so much swap usage? Why am I swapping? The other processes on the box don't even come close to accounting for the swap usage, let alone the swapping. Any help here is greatly appreciated. Thanks Richard --------------------------------------------------------------------- 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
