1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with mysqltuner.pl results

Discussion in 'Server Configuration and Hosting' started by karll, Mar 13, 2013.

  1. karll

    karll Well-Known Member

    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?
  2. hellreturn

    hellreturn Active Member

    tmp_table_size increase that to 32M and same for max_heap_table_size

    Change u max connections from 150 to 75.
    max_connections = 75

    Now another question is.. how much extra RAM you have on sever/VPS?
  3. karll

    karll Well-Known Member

    Thank you for these ideas.

    You mean how much free memory? Not much, total RAM is 512MB, unused RAM is only 64KB or so. I can get 90MB extra for $5 per month, but can't really afford / justify the expense for the time being.
  4. hellreturn

    hellreturn Active Member

    If you are on 512Mb RAM and having no free memory then you are on tight plan. I believe 512MB should work just fine for 50 users/sec but that's just my thought.

    How much is price for your current plan?
  5. karll

    karll Well-Known Member

    I'm paying $19.99 per month. This is the 512MB plan with linode.com.

    I can't guarantee that I was reading the amount of unused memory correctly, but I got it from the "free" command (oh, now it's even less):
    $ free
    total used free shared buffers cached
    Mem: 508252 495744 12508 0 20212 143008
    -/+ buffers/cache: 332524 175728
    Swap: 262140 127848 134292

    Maybe I'm running unnecessary processes or something.
  6. CyclingTribe

    CyclingTribe Well-Known Member

    Just run #top - it should report total mem in the summary at the top of the page (press 'q' to quit). (y)
  7. karll

    karll Well-Known Member

    Ah, I see now. Both programs (free, top) are by default reporting in kilobytes. Right now it's ~68000KB free, i.e. 68MB.
  8. shawn

    shawn Well-Known Member

    I wouldn't worry about the query_cache_size and tmp_table_size comments. I've messed around with those in the past, but increasing them didn't satisfy the script. I think it's going strictly off of the prunes number and the temp tables on disc numbers... which really probably has more to do with what web software you're running (a forum) and how it's being used (lots of unique queries).
  9. hellreturn

    hellreturn Active Member

    Install htop it's best.

    32M for temp tables is pretty low anyways. I use 96M for my forums and temp tables created on disk are way less. But i have 4GB RAM
    karll likes this.
  10. Freddie Agricola

    Freddie Agricola Active Member

    karll likes this.
  11. karll

    karll Well-Known Member

Share This Page