I've just run the mysqltuner.pl script for the first time. Here's the whole thing: So yes, this is a tiny VPS, but this is what I have to work with. Based on this, what would be the most important improvements I could do? Also, what I'd like to know is, when it lists the "variables to adjust" at the end, does it mean that I should be setting them to the ranges listed, or that they are already in those ranges? (E.g. it says "query_cache_size (> 16M)", so does that mean query_cache_size is > 16M or that it should be > 16M? The my.cnf file says "query_cache_size = 16M" ...) Anyway, any and all optimization recommendations are welcome. By the way, is there a way to run one single command to run "optimize table" on all the tables?