XF problem or simply insufficient server?

[Nnirvi]

Hi!

We're running XF 1.5.4 on a managed server with following hardware:

Intel® Core™ i7-3930K Hexa-Core incl. Hyper-Threading Technology
64 GB DDR3 RAM
2 x 500 GB SATA 6 Gb/s SSD

Our forum is a fairly active one with nearly 2M messages and we're running Widget Framework plugin.

We have also made a custom plugin for subscriber validation which checks the user ID against a database and modifies their user groups accordingly. There's also a fairly lightweight ProcessWire based website associated with the forum which communicates with XF for user permissions.

The entire website and XF crash from time to time, just now two times within the same day. The error message we get is too many MySQL connections.

Both the website and the forums run a pretty heavy ad system but it's served from elsewhere. Nevertheless, it makes insane amount of http requests.

1. Do you think that the server is enough for a forum that size?
2. Any idea how to start debugging this?

 

[AndyB]

The error message we get is too many MySQL connections.

Have you optimized MySQL?

This website has tools to optimize MySQL.

http://mysqltuner.com/

 

[eva2000]

That server is a beast even if it's several generations old due to high cpu clock speed and 12 cpu threads. But tuning it's settings for it's LAMP (linux, apache, mysql, php) / LEMP (linux, nginx, mysql, php) stack is important

read docs https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html