Server update
Server update
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
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
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.
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
Hi Bas,
This is a very old post. Did you observed any performance issues with this forum?
73 Dan YO3GGX
This is a very old post. Did you observed any performance issues with this forum?
73 Dan YO3GGX
Re: Server update
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.
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
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
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
Check /etc/mysql/my.cnf
Set this:
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.
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
#
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
I'm running Centos 7, with a different folder structure.
This is what I have in /etc/my.cnf
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
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
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...
No clue why.....
Could be a firewall or whatever, but it's always the same....click and wait about 20 secs...
Re: Server update
Again 20sec...for a message to be posted...