Hi

i'm doing a "Big" project using apache/php/mysql on local ethernet.

i had a linux server running slackware 8.1 and now i'm trying to use redhat 8.0.

cpu: i've got Intel(R) Pentium(R) 4 CPU 1.70GHz
memory: 512940K

current swap size: 618492K

the problem:

after a day or 2 swap start to get full. and it seems that the swap is not clean/clear the space after using the swap.

the result is that the kernel kill mysqld cause he aint got enough
memory available...

anyone have any idea how can i make the server more efficient ?
or how else could i manage the swap ?

Sounds like a memory leak in MySQL. Check your logs and upgrade your system to the latest versions. What does redhat use? up2date?

since i'm tring to solve this problem for a long time i already did that.

my first mysql version was: mysql-3.23.43

now i use : mysql-3.23.55

which is the current stable vertion.

i dont use up2date ..

i complied it from sources.

You can add a swap file to see if more will help. But like the other post said it could be a memory leak. Did you have the same problem with slack?

http://www.justlinux.com/nhf/Filesys..._Swapping.html

yeah!

i've got the same problem with slackware 8.1

i cant undestand what make this memory leak...
to make the swap bigger is not a good idea cause it will just take more time to get full.

cause mysql isnt work that hard:
Threads: 1 Questions: 1444510 Slow queries: 0 Opens: 28 Flush tables: 1 Open tables: 22 Queries per second avg: 15.230

i've got another computer that run slackware 8.0 kernel 2.2.19
the computer is a lot slower:
cpu: Celeron (Mendocino) 334 Mhrtz
Mem: 257492K

and mysql work harder:
Threads: 1 Questions: 22948 Slow queries: 0 Opens: 38 Flush tables: 1 Open tables: 32 Queries per second avg: 0.066.

and the second computer is not using the swap at all !!!