Growing MySQL footprint

robbiemorgan · 09-21-2004, 08:07 AM

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

subhasis_ray · 09-22-2004, 07:29 AM

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

Proud · 09-22-2004, 08:28 AM

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.

robbiemorgan · 09-22-2004, 08:37 AM

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