[freenet-dev] BDB uses far more memory than it's supposed to; ideas?

[NextGen$]

* Bob Ham <rah at bash.sh> [2007-02-02 02:50:53]:

> On Thu, 2007-02-01 at 18:44 +0000, Matthew Toseland wrote:
> 
> > that would be a grand total of 64MB.
> > Which IMHO is very reasonable.
> 
> As noted, that's pretty massive.  I don't think it's reasonable at all.
> Here's some stats for comparable daemons that I quickly plucked out of a
> "ps axu" on the box I'm running fred:
> 
> named	    3.17 MB
> imapd	    2.85 MB
> mysqld	   17.33 MB
> apache2	    7.82 MB
> postgres    6.47 MB
> fred	  120.82 MB
> 
> Now, to me, fred is seeming a little out of place there.  Even if it was
> 64MB, that's still three times the size of mysql's footprint.

How big is your mysql database ?

emu:~# du -hs /var/lib/mysql
117M    /var/lib/mysql

emu:~# ps auxf|grep mysql
mysql    17981  0.4  5.6 137184 25120 ?        Sl    2006 359:08  \_
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock

On the server we have ~100M of data and the memory footprint is ~25M. The
usual size for a datastore is 1G...

> What, exactly, requires all this memory?
> 
> Bob
> 
> -- 
> Bob Ham <rah at bash.sh>