Hello dear freelancers!
I have a server with such parameters:
- OS: Ubuntu 18.04.4 LTS x86_64
- Kernel: 4.15.0-112-generic
- CPU: Intel Xeon Silver 4214 (48 Cores) @ 2.201GHz
- Memory: 96Gb
- SSD SAMSUNG MZQLB960HAJR-00007 894.3Gb x 2
With installed 5.5.5-10.5.5-MariaDB-1:10.5.5+maria~bionic. I have a PHP written project with pretty high number of DB queries (~400-500 SELECTs per second + ~200-300 UPDATEs per second). The problem is: the database is rather slow during a lot of users activity, but ok in any other time. I need a fine tune of this setup. My [login to view URL] file is attached below.
!!!PLEASE NOTE!!! You MUST have a DBA experience in your portfolio! Otherwise you will be ignored! Happy bidding!