Author Topic: Edited:Suggestions? MySQL tweaking  (Read 2280 times)

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,855
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like
Edited:Suggestions? MySQL tweaking
« on: February 13, 2008, 08:13:03 AM »
Edit: NEVERMIND, I'm gonna do some bigger maintenance before getting more into these.


I've been looking at my status.php for a while,
and it seems I have three values there that won't stay within
the limits stated.

Key buffer read hit rate:
(key_buffer_size)  0.0358 (should be <= 0.01) 

Thread cache usage:
(thread_cache_size)  0.9375 (should be >= 0.7 and <= 0.9) 

Query cache miss rate:
(query_cache_limit)  0.5989 (should be <= 0.5) 

At the moment the forum is under a quite light load, and we are expecting more after we close our other board and redirect to this one, so I'm trying to make sure this board will work smoothly after the expected increase in user activity.

I would be grateful for suggestions as to what should be changed and to what direction? I'm a noob when it comes to MySQL. :)

« Last Edit: February 13, 2008, 12:19:31 PM by LexArma »
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas