CODEWITHSUNDEEP
mysqllinuxdebian
Sebi
Sebi

Reputation: 1436

Lightweighted mySQL server?

I have very limited resources (RAM) on my server (Debian lenny) and I need to install mySQL server, it will not be extensively used. I installed apt-get install mysql-server before but it was taking about 150MB of RAM and I am looking for alternative servers, are there any, I couldn't find anything.

Thank you in advance!

Upvotes: 1

Views: 373

Answers (1)

MarkR
MarkR

Reputation: 63538

It can certainly be tuned to use less ram than the default. In particular, Debian may ship it with a configuration which is more suitable for a typical server-grade machine.

If you feel the need to run MySQL on a very memory-constrained platform, consider tuning its memory usage as described here: How MySQL Uses Memory

You probably want to use InnoDB; the most important thing to tune is to make your innodb_buffer_pool a sensible size (There are other InnoDB buffers you may want to tune too; read its documentation).

If you aren't using MyISAM, reduce its key_buffer_size to a small value (say 4M). MyISAM can't be disabled as it's used internally.

If you aren't using InnoDB, turn it off entirely.

Upvotes: 4

Related Questions