MariaDB CPU Intensive with XenForo

Ramnode has DDOS protection.

---

 

Change your php-fpm.conf to this:

 

Did you restart php-fpm?
fpmrestart command.

 

I just configured a server with 2 CPU core only, with medium traffic.
The best settings I got is this:

Code:

pm = static
pm.max_children = 2

So for your VPS with 4 cpu core, use this:

Code:

pm = static
pm.max_children = 4

or

Code:

pm = static
pm.max_children = 2

To give other cores to other process.
Just don't use more than your CPU core.

 

@RoldanLT - what about mine?

Code:

pm = ondemand
pm.max_children = 16
; Default Value: min_spare_servers + (max_spare_servers - min_spare_servers) / 2
pm.start_servers = 8
pm.min_spare_servers = 4
pm.max_spare_servers = 12
pm.max_requests = 1000

i google it, and if pm = ondemand then only relevant setting is pm.max_children.
When I use formula, it can be 18 for my configuraton

 

and your server specs?
CPU available?

 

Disk Space - 60 Gb SSD
Ram - 4 GB
2 CPU
swap 2GB
Centmin Mod 1.2.3-eva2000.08
redis server and cache
zendOp cache
pfp 5.6.15
mariaDB 10.x

 

I assume this if from DO?
Try this:

Code:

pm = dynamic
pm.max_children = 8
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 4

 

yep
if pm = ondemand then only relevant setting is pm.max_children
Did you tried that way?

 

Yes.
ondemand is only good if you have small traffic.

 

XenForo - 1.5.1
Database - 831 MB (about 126 MB zipped)
Number of attachments - 3,601
Attachments disk usage - 9,737 MB
Addons - 66
Posts - 243,337
Users - 3,613 (online registered users in peak time is about 50 + guests)

my forum is not with small traffic, so your settings should be better?
pm = dynamic
pm.max_children = 8
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 4

 

I will add this settings, and when finally transfer forum from old server, we shall see how it will be

 

what about pm.max_requests = 1000