System tuning

We offer you several steps to achieve maximum performance of the system. 

If your network is small and your server has no problem with high CPU load - you can skip this page

Hardware

The first and main recommendation is to keep Grusher and operating system up-to-date. Today not possible to use "install and forget" principle. Updates are released help to improve performance and resolve issues.

Second recommendation for highly loaded systems is to separate the web server (Application) and database (DB) on different servers or virtual machines. This will help balance processor time and memory for each machine, and there will be no competition for a shared pool of capacity.

Software

MariaDB tuning

At the time of writing this article latest version was 11.3.2.

MariaDB Server 11.0 brings many significant improvements to the query optimizer! Try it out and please let us know of your experience. We aim to incorporate all the feedback we receive. 

Read this articles 

• https://mariadb.com/kb/en/optimization-and-tuning/ 
  
• https://www.cloudways.com/blog/mariadb-performance-tuning/ 
  

• https://galeracluster.com/
• https://www.server-world.info/en/note?os=Ubuntu_22.04&p=mariadb&f=5

 

Ngnix

If you have a lot of active system users (more than 10) or you actively use the Grusher API, you need to configure php-fpm.

Otherwise, requests submitted to the web will take a long time to be processed.

• PHP-FPM Process Calculator
  

 

Grusher