LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 09-21-2004, 08:07 AM   #1
robbiemorgan
LQ Newbie
 
Registered: Aug 2003
Posts: 19

Rep: Reputation: 0
Growing MySQL footprint


Hi,

According to 'top', the memory usage for each of my 'mysqld' processes appears to be increasing as the database grows.

Is this normal?

Thanks,

Rob
 
Old 09-22-2004, 07:29 AM   #2
subhasis_ray
Member
 
Registered: Jul 2001
Location: india
Distribution: RedHat 7.1,7.2,7.3, 8.0,9.0,Fedora,EL2.1,EL3.0
Posts: 103

Rep: Reputation: 16
Hi,

I am not very sure, but that is exactly what I also have seen. But this does not depend on the database size. It depends more on that time that this database is running. All you need to do is restart the mysqld process when you think that the footprint has increased to a high value.

Regards

Subhasis Ray
 
Old 09-22-2004, 08:28 AM   #3
Proud
Senior Member
 
Registered: Dec 2002
Location: England
Distribution: Used to use Mandrake/Mandriva
Posts: 2,794

Rep: Reputation: 116Reputation: 116
subhasis_ray, that sounds wrong and possibly like a memory leak. Check any updates for your DBMS version.

robbiemorgan, yes as the data which a process handles grows so must the memory allocated to the process to hold and manipulate that data.
 
Old 09-22-2004, 08:37 AM   #4
robbiemorgan
LQ Newbie
 
Registered: Aug 2003
Posts: 19

Original Poster
Rep: Reputation: 0
Hi Proud,

Ok, but 99% of the queries I'm running on the larger tables are INSERTs, the tables on which I'm doing SELECTs only have a handful of rows a piece.

Is there a way to optimize this? Otherwise the DB will eventually grow so big it saps all my memory.

I guess the other option is to periodically dump the data into a separate offline DB - keep the live DB lean...

Thanks,

Rob
 
  


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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
small footprint linux system mylinuxdna Linux - Newbie 2 06-18-2005 03:03 AM
small footprint linux system mylinuxdna Linux - General 1 06-14-2005 01:45 AM
small memory footprint grcunningham Linux - Software 1 05-26-2004 08:38 AM
Minimal Slack install to minimize footprint? busbarn Slackware - Installation 2 03-31-2004 12:31 PM
small footprint systems? siculars Linux - General 3 01-15-2003 02:43 PM


All times are GMT -5. The time now is 11:37 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration