How to optimize MySQL performance?

Question

MySQL

Good afternoon!
Faced the problem of very low performance of the database server located on the physical machine during joint development!
CMS 1C-Bitrix issues only 40 (!!!) requests per second! At local - 3-4 thousand requests.
What can be done?
The configuration of the entire server is as follows:
1) Beeline 100Mbit + dedicated IP
2) D-LINK DIR-825AC
3) Intel Xeon X3470
4) ASUS P7-H57D EVO
5) 2x4Gb DDR3
6) 1Tb HDD
7) Windows Server 2012 R2
8) Open Server latest version
9) MariaDB 10.2
Thanks in advance!

Answer 1

Typically, this problem is solved by using connection pools with the DBMS, rewriting queries so that they are made less often, but more data is raked out at a time, as well as caching query results. But not in the case of Bitrix.