Hello, SW. community. Tell me, please, moved the website from shared hosting to vds(4 cores, 4 RAM) and are faced with the problem that queries to the database(server Version: 5.5.60-MariaDB - MariaDB Server) were processed several times slower than a shared host,what could be the problem?
Louvenia.Herzog55 answered on March 19th 20 at 08:29
There is no single correct setting for all occasions. It all depends on the load of the database, the availability of resources, drives used, etc.
In the simplest case, you can check the settings with the help of some mysqltuner, but need to understand that it only checks a few simple rules, and its recommendations are not always reasonable.
It is also possible that in your case, the problem is not in the settings, and the bottleneck is IO, with him on many virtualtech is all quite sad, like even when it is claimed that they are on the SSD.
armani_Metz answered on March 19th 20 at 08:31
What size base?
What is the CPU load?
Which processors the host (vps)? Can a weak frequency and architecture
If the database fits in RAM?
What settings MariaDB?
That means several times more slowly? It is on the eye, or are You on the page show the number of DB queries and the time of the request.
The problem in the database? With the rest you sure you're okay? Web server, caching,.. all set? The firewall is configured? The system is optimized?