News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Forum is being slow

Started by wii1mii, November 04, 2013, 10:03:22 AM

Previous topic - Next topic

wii1mii

Hello,

I noticed that my forum is kinda slow lately..
Since i don't really understand how things work ill leave this link..
"sygc.biz/status.php"

*I do host this site on my own machine

Thanks

butch2k

Your mysql server seems awfully configured  :o
For instance the query cache size is set to 0 ! Please set it to 32M.
set key_buffer_size to 32M as well as it seems too small as it is.

margarett

May I ask *why* are you running it from your local machine?

There are a *lot* of factors that can cause that... One is the server misconfiguration as stated, plus the security hole you might be exposing yourself to, plus your current line upload, ...
It isn't really recommended to do so. If you're sure of what you're doing then, for sure, do it. But it's quite a risk...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

wii1mii

Quote from: margarett on November 04, 2013, 03:33:07 PM
May I ask *why* are you running it from your local machine?

There are a *lot* of factors that can cause that... One is the server misconfiguration as stated, plus the security hole you might be exposing yourself to, plus your current line upload, ...
It isn't really recommended to do so. If you're sure of what you're doing then, for sure, do it. But it's quite a risk...

Well i'm being cheep. I run few servers and i kinda need forum for it. This seemed like a best option at a time.  :)

wii1mii

Quote from: butch2k on November 04, 2013, 01:50:23 PM
Your mysql server seems awfully configured  :o
For instance the query cache size is set to 0 ! Please set it to 32M.
set key_buffer_size to 32M as well as it seems too small as it is.

So basically the problem is in mysql server ?

kat

For what it's worth, I just browsed around, on your forum.

Seems quick enough, to me. (Opera v12.16, Build 1860, x64, Windows 7)

butch2k

Quote from: wii1mii on November 04, 2013, 04:11:47 PM
Quote from: butch2k on November 04, 2013, 01:50:23 PM
Your mysql server seems awfully configured  :o
For instance the query cache size is set to 0 ! Please set it to 32M.
set key_buffer_size to 32M as well as it seems too small as it is.
There are at least a few misconfiguration there that i could see, and those are definitely performance related.

So basically the problem is in mysql server ?

Advertisement: