Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: wii1mii on November 04, 2013, 10:03:22 AM

Title: Forum is being slow
Post by: wii1mii on November 04, 2013, 10:03:22 AM
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
Title: Re: Forum is being slow
Post by: 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.
Title: Re: Forum is being slow
Post by: 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...
Title: Re: Forum is being slow
Post by: wii1mii on November 04, 2013, 03:42:35 PM
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.  :)
Title: Re: Forum is being slow
Post by: 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.

So basically the problem is in mysql server ?
Title: Re: Forum is being slow
Post by: kat on November 04, 2013, 05:10:43 PM
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)
Title: Re: Forum is being slow
Post by: butch2k on November 04, 2013, 06:02:52 PM
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 ?