MariaDB 10.5.5 fine tuning

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!

Taidot: Linux, MySQL, PHP, Järjestelmänvalvoja, Tietokannan hallinto

Näytä lisää: language fine tuning, fine tuning courier imap, fine tuning oracle application vsat, mariadb 10.4 manual, mariadb guide, mariadb 10.5 new features, mariadb 10.5 roadmap, mariadb 10.5 vs mysql 8, mariadb 10.5 download, mariadb download, mariadb 10.5 release date, fine tuning adwords, adobe premiere fine tuning, website fine tuning, phplist fine tuning, oracle fine tuning vsat network, fine tuning javascript, fine tuning joomla, lamp fine tuning jobs, php fine tuning projects

Tietoa työnantajasta:
( 20 arvostelua ) Bar, Montenegro

Projektin tunnus: #27495565

Myönnetty käyttäjälle:

(392 Arvostelua)

7 freelancers are bidding on average $160 for this job

(33 arvostelua)

Hello..I am an experienced cloud server engineer ...I can help you with optimizating the database server .......Let me know in chat

$120 USD 2 päivässä
(35 arvostelua)

I am Senior SQL Developer with 10+ years experience. And my offer is to search a bottleneck in a select and update statements and in a way how they are perform in a simultaneous mode. Because if database has a problem Lisää

$250 USD 3 päivässä
(10 arvostelua)

Thanks for your job posting I just read your job posting and your job catches my eye. I am professional web developer with skills including Database Administration, System Admin, PHP, Linux and MySQL. My deep experien Lisää

$100 USD 3 päivässä
(2 arvostelua)

Hello. Glad to meet you. I am very interested in your job post involving these skills Let me do this job for you now just to prove my expertise in this field. I have confident that I will do your work very [login to view URL] i Lisää

$250 USD 1 päivässä
(1 arvostelu)

Hello Team, I have overall 5+ experience into Software industries as a Performance Test Engineer, Please give me chance to complete this project. Expertise in php website design, .NET, MySQL development. Key points: Lisää

$100 USD 7 päivässä
(0 arvostelua)