Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


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

Rep: Reputation: 0
Growing MySQL footprint


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

Is this normal?


Old 09-22-2004, 07:29 AM   #2
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

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.


Subhasis Ray
Old 09-22-2004, 08:28 AM   #3
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
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...




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 05:09 PM.

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