Page 1 of 3

Server update

Posted: Thu Feb 25, 2016 10:59 pm
by yo3ggx
Hi everybody.

Today I've updated the server hardware and software, including phpBB.
You must see a significant improvement in speed.
If something does not work as expected, please send me a mail.

Thank you.
73 Dan YO3GGX

Re: Server update

Posted: Sun Dec 16, 2018 7:51 pm
by Bas
Did you change the Mysql/MariaDB parameters like keybuffer and such?
Those make a very big difference in speed.

I can give you many hints as the default settings are very poor and mostly enough for home-user use, but not for a public forum.

Re: Server update

Posted: Sun Dec 16, 2018 8:26 pm
by yo3ggx
Hi Bas,

This is a very old post. Did you observed any performance issues with this forum?

73 Dan YO3GGX

Re: Server update

Posted: Mon Dec 17, 2018 7:54 pm
by Bas
Hi Dan,

Yes I do as it takes quite a bit of time before the forum responding to command, but when it does it shows the page very quickly.
However, just clicking on a post can take 20 seconds before something happens.

If it's not something external doing this then it's your database running out of cache-memory, looks like your tables/indexes are too big to be stored into memory, as such take a long time to process.

Greeting Bas.

Re: Server update

Posted: Mon Dec 17, 2018 8:29 pm
by yo3ggx
Hi Bas,

For me everything looks fast, take less than 1s. Is a big server with 24GB of ram and a very small forum, so I don't expect to be a performance issue. Do you recommend me to check something specific?

73 Dan YO3GGX

Re: Server update

Posted: Mon Dec 17, 2018 8:47 pm
by Bas
Check /etc/mysql/my.cnf

Set this:

Code: Select all

#
# * Fine Tuning
#
key_buffer              = 1024M
max_allowed_packet      = 16M
thread_stack            = 512K
thread_cache_size       = 192
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
max_connections        = 500
table_cache            = 256
thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 2M
query_cache_size        = 32M
#
By default these settings are very small, key_buffer could be just 8MB or 16MB and such a low setting will hinder all mysql databases small and big.
I have run many very big forums and if you don't change the defaults they will slow down to a crawl, like yours does.

If those settings won't solve it, you may have other problems.

Greetings Bas.

Re: Server update

Posted: Mon Dec 17, 2018 8:54 pm
by yo3ggx
I'm running Centos 7, with a different folder structure.
This is what I have in /etc/my.cnf

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock


[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Re: Server update

Posted: Mon Dec 17, 2018 8:56 pm
by yo3ggx
I'm still trying to understand what is slow here, because for me everything is very fast. Just give me an example.

Re: Server update

Posted: Mon Dec 17, 2018 9:23 pm
by Bas
Every click takes 20 or more seconds....no matter what I do.
No clue why.....

Could be a firewall or whatever, but it's always the same....click and wait about 20 secs...

Re: Server update

Posted: Mon Dec 17, 2018 9:25 pm
by Bas
Again 20sec...for a message to be posted...