LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 03-14-2003, 05:04 AM   #1
yahelb
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Rep: Reputation: 0
swap space is running out ...


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 ?
 
Old 03-14-2003, 05:44 AM   #2
acid2000
Member
 
Registered: Nov 2001
Location: Exeter, UK
Distribution: Gentoo 1.4
Posts: 243

Rep: Reputation: 30
Sounds like a memory leak in MySQL. Check your logs and upgrade your system to the latest versions. What does redhat use? up2date?
 
Old 03-14-2003, 05:51 AM   #3
yahelb
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Original Poster
Rep: Reputation: 0
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.
 
Old 03-14-2003, 07:20 AM   #4
michaelk
Moderator
 
Registered: Aug 2002
Posts: 18,804

Rep: Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807Reputation: 2807
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
 
Old 03-14-2003, 07:43 AM   #5
yahelb
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Original Poster
Rep: Reputation: 0
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 !!!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to reduce swap space and reclaim the space grantm Linux - Newbie 7 08-16-2012 07:05 AM
Too much SWAP space? Mufasa Linux - General 1 11-20-2004 09:50 AM
How to unmount actual swap and mount a new(bigger) swap space? isaac Linux - Newbie 1 06-06-2004 01:23 AM
Swap space JIV Linux - Newbie 8 11-13-2003 10:07 AM
swap space not being used DarkBeethoven Linux - General 9 06-09-2002 12:09 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 12:43 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration