0

I'm configuring a new web-server.

I've noticed that mysql 5.1 (default installation) is taking up 191 MB without any catalogs configured. This is also without any programs logged into mysql and zero queries having been run on it.

This seems a bit excessive.

Any thoughts on how to reduce this amount without significantly effecting speed?

Thanks.

Edit: I just noticed in the Resource Monitor that Commit column lists 191 MB, while the Working Set column reads 33 MB. Private Column shows 28 MB. In the Task Manager Processes Tab, it only shows 28 MB. A big concern of mine is that the Physical Memory Usage in the Performance Tab of the Task Manager shows that the full 191 is beign used (It seems to be allocating the full "Commit Column" amount because 671/980 MB are being used when MySQL is the only major thing installed).

1 Answer 1

1

It would be useful to see your configuration, however a simple way to lower memory is to disable any storage engines you aren't using (especially InnoDB and BSD). Lowering buffers (and possibly the query cache) to acceptable levels for your application may also help, but will be detrimental to performance.

Here is a link to a MySQL / Apache low memory configuration, although it references Linux file paths.

2
  • Windows Server 2008 fresh install Aug 17, 2009 at 23:21
  • Did removing superfluous storage engines lower the footprint? I'm not familiar with MySQL under Windows, could you update with an abridged my.cnf?
    – Andy
    Aug 24, 2009 at 13:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .