Hello.
On Mon 2002-12-09 at 00:57:37 -0800, [EMAIL PROTECTED] wrote:
>
> The problem is that after working 5-6 hours without
> swapping Mysql begin to swap.
How do you determine that? Is MySQL the only process on the server?
> If I switch off swap with swapoff -a and then switch it on again
> after 5-6 horis withut swapping Mysql begin to swap again. Can
> anybody give me some advice?
What does the command "free" print in this case? Do you still have
memory free or is swapping really needed.
If it is needed, you probably made some MySQL buffers bigger than
reasonable. Check your my.cnf.
> I'm using Apache with mod_perl enabled+mysql
Do you have applied limits for max_connections (mysql) and MaxClients
(Apache?). mod_perl uses quite some memory per instance.
> OS is Linux RedHat 7.3 kernel 2.4.18-3smp
> 2 CPU x 1GHz Intel
> 1 GB RAM
> SCSI Seagate HDD/with scsi controller which transfer
> rate is 20MB/s !!! I still can persuade my boss to
> change it/.
Disk usage is so much slower (magnitudes) there the only reasonable
solution is to get trim your server config to not cause swapping.
HTH,
Benjamin.
--
[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
