How to speed up MySQL on a low resource server?

[antonioetayo]

I was wondering, are there any recommended ways to speed MySQL up a bit
in low resource environments? See, I'm running a small webserver for
kicks on an old Compaq Presario with only 16mb RAM (Yes, I'm aware of
the 256mb requirement). MySQL is runnin just fine although obviously it
is quite slow.

What would you do to speed it up if you absolutely had to? (Besides
buying another ram stick >_>)

Anything you can come up with is appreciated, guys. Thanks in advance ;)

[Michael Austin]

an**********@gmail.com wrote:

I was wondering, are there any recommended ways to speed MySQL up a bit
in low resource environments? See, I'm running a small webserver for
kicks on an old Compaq Presario with only 16mb RAM (Yes, I'm aware of
the 256mb requirement). MySQL is runnin just fine although obviously it
is quite slow.

What would you do to speed it up if you absolutely had to? (Besides
buying another ram stick >_>)

Anything you can come up with is appreciated, guys. Thanks in advance ;)

Turn off unused/unnecessary resources, tune the queries using "explain", add
appropriate indexes, buy more memory.

--
Michael Austin
Database Consultant
Domain Registration and Linux/Windows Web Hosting Reseller
http://www.spacelots.com