469,323 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

How to speed up MySQL on a low resource server?

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 ;)

Jan 15 '07 #1
1 5165
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
Jan 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Klaus Hansen | last post: by
reply views Thread by mdh | last post: by
2 posts views Thread by Jon Dellaria | last post: by
5 posts views Thread by Tom Martin | last post: by
10 posts views Thread by Caffeneide | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.