Server update

Here we will discuss general topics related to other potential hardware or software projects
User avatar
yo3ggx
Site Admin
Posts: 757
Joined: Wed Aug 15, 2012 8:30 pm
Location: Bucharest, România
Contact:

Server update

Post 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
Bas
Posts: 19
Joined: Sat Jun 23, 2018 8:34 pm

Re: Server update

Post 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.
User avatar
yo3ggx
Site Admin
Posts: 757
Joined: Wed Aug 15, 2012 8:30 pm
Location: Bucharest, România
Contact:

Re: Server update

Post by yo3ggx »

Hi Bas,

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

73 Dan YO3GGX
Bas
Posts: 19
Joined: Sat Jun 23, 2018 8:34 pm

Re: Server update

Post 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.
User avatar
yo3ggx
Site Admin
Posts: 757
Joined: Wed Aug 15, 2012 8:30 pm
Location: Bucharest, România
Contact:

Re: Server update

Post 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
Bas
Posts: 19
Joined: Sat Jun 23, 2018 8:34 pm

Re: Server update

Post 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.
User avatar
yo3ggx
Site Admin
Posts: 757
Joined: Wed Aug 15, 2012 8:30 pm
Location: Bucharest, România
Contact:

Re: Server update

Post 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
User avatar
yo3ggx
Site Admin
Posts: 757
Joined: Wed Aug 15, 2012 8:30 pm
Location: Bucharest, România
Contact:

Re: Server update

Post by yo3ggx »

I'm still trying to understand what is slow here, because for me everything is very fast. Just give me an example.
Bas
Posts: 19
Joined: Sat Jun 23, 2018 8:34 pm

Re: Server update

Post 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...
Bas
Posts: 19
Joined: Sat Jun 23, 2018 8:34 pm

Re: Server update

Post by Bas »

Again 20sec...for a message to be posted...
Post Reply