For me this was the first experience of managing the base without access to the server, it was interesting to myself.
The customer quickly came out of contact and provided the values of the parameters and configurations of Mysql, the Linux core.
After applying the parameters, according to my recommendations, I received a feedback on the successful result. They held a meeting where they met closer and discussed the work of the server.
A great book I recommend to everyone.

5.0

Valery Bashtovoy

Reciprocal Feedback

28 August 2021

Project translated automatically. Log in or register, to view the original You need an extra-class specialist for the MariaDB 10.6 thin tuning, from the core and network/disk subsystem settings to the config. You need a deep knowledge of the configuration parameters of MySQL, as well as knowledge of the nuances of the work of MariaDB. Source data: Standalone Linux server, no replication 32GB RAM Order 42Gb data in the InnoDB tables Load 150-250 rps Direct access to the server when the project is performed will not be due to the policy of confidential data processing, but any logs will be provided and commands will be performed quickly. Please describe in the bet an example of solving such tasks for highload projects.

Proposals 2 Discussions 5

Aziz I. 3 August 2021

😏

Dmitry Sergeyevich 6 August 2021

250 rps это не highload, расслабьтесь и дайте спецу доступ к серверу)
Вслепую поиграть в "испорченный телефон" в командной строке - то ещё удовольствие.

Aziz I. 6 August 2021

Removed by moderator

Oleg Vilko

7 August 2021

Дмитрий, к сожалению, в данном случае это невозможно, так как сервер содержит конфиденциальные пользовательские данные.
Полагаю, это не должно быть проблемой, так как испорченного телефона не будет.

Yevgeny O. 6 August 2021

Removed by moderator

Add Comment

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 17 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 19 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD
Client registration and visit confirmation system (MVP)

Web Programming 162 proposals 10 July

Not specified

Oleg Vilko
Kyiv, Ukraine
РОДЖЕР ВІЛКО

Projects 5
Rating 5.0
Rating 185

Optimization of the MariaDB server

Client's review of cooperation with Valery Bashtovoy

Optimization of the MariaDB server

4.9

Oleg Vilko

Freelancer's review of cooperation with Oleg Vilko

Optimization of the MariaDB server

5.0

Valery Bashtovoy

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client registration and visit confirmation system (MVP)