How to properly set up Mysql on Ubuntu?

S

serNevajno2019-03-25 13:58:45

MySQL

serNevajno, 2019-03-25 13:58:45

Hello uv. community. Tell me, please, I transferred the site from virtual hosting to vds (4 cores, 4 RAM) and ran into a problem that requests to the database (Server version: 5.5.60-MariaDB - MariaDB Server) began to be processed several times slower than on virtual hosting, what could be the problem?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

B

Boris Syomov, 2019-03-25
@kotomyava

There is no one correct setting for all occasions. It all depends on the loads, the base itself, the availability of resources, the drives used, etc.
In the simplest case, you can check the settings using some mysqltuner, but you 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, but the bottleneck is IO, with it on many virtual machines everything is rather sad, even when it seems like it is stated that they are on an SSD.

A

Anatoly, 2019-03-25
@Tolly

Little data!
What is the base size?
What is the CPU load?
What processors does the hoster (vps) have? Maybe weak in frequency and architecture
Does the base fit in RAM?
What are the MariaDB settings?
What does several times slower mean? This is by eye, or you show on the page the number of requests to the database, as well as the time of the request.
DB problem? Are the rest all right? Web server, caching, .. is everything set up? Firewall configured? Is the system optimized?