* 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>
