Question Questions ⇒ Mchat crashes forum

[deninho32]

If I use Mchat on my board it crashes the whole forum on some busier days. When we have 120+ visitors at the same time on our forum with 30+ people using the chat during a match, it causes a huge serverload. Is this extension limited to a certain amount of users?

Our VPS stats:

VM with 4 CPU's allocated model name: Intel (R) Xeon (R) CPU E5-2660 v4 @2.00 GHz en 4 GB RAM

General recommendations:
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Adjust your join queries to always utilize indexes
Variables to adjust:
query_cache_size (> 64M)
join_buffer_size (> 2.0M, or always use indexes with joins)
innodb_buffer_pool_instances (=1)

( query_cache_size en join_buffer_size zijn al eens verdubbeld )

PHP 7.4 with these settings :

pm = dynamic
pm.max_children = 80
pm.start_servers = 8
pm.min_spare_servers = 8
pm.max_spare_servers = 16


Mysqltuner notofication :

[!!] Joins performed without indexes: 20774

[martin]

Dont allow guests to see chat and see if how that goes.

[deninho32]

That was set to "no" in permissions already.

[martin]

You may be in need of some more ram 4gb is enough for most servers but as you have alot online at one time in chat you may need to upgrade to 8gb min.

[deninho32]

Thanks, I will contact our host.