How to optimize DLE database to increase server response speed?

Question

DLE

How to optimize the DLE database to increase server response speed?

There is a server on Linux (Ubuntu), it has a website, the server response speed is from 3 to 5-6 seconds, it needs to be accelerated to 100-500 ms. Another site is connected to the database of this site with a traffic of 200-300 uniques per day, so it can hardly slow it down

. Server characteristics: 2CPU, 2RAM, 40 SSD, 250mb/s port. There are 16 thousand materials in the database, a site on DLE

On a similar server there is another site with a database of 500 materials, it opens in 150-300 ms. What can be ideas for optimization or maybe there are articles on this topic

Answer 1

To begin with, it is worth looking at what generally happens when processing requests to the site. Understand exactly where the bottleneck is. To figure out if there is a problem in the database at all, which is not at all necessary. Look at the amount of data, queries, see explain frequent and long queries. It is possible to tweak something in the mysql configuration. It is possible to add indexes somewhere, it is possible to rewrite something.
Your task is not solved in some general form, in some unambiguous way: it requires the work of a qualified specialist, it is simply impossible to teach this in answer to a question.

Answer 2

1) how did you calculate the speed? (what tests were there?)
2) kroner daily optimization of the base in the minimum used time
3) such a speed of opening which pages?
4) How quickly do different categories open and how many short stories per page??
5) What version of dle?
6) what requests are slowed down?
We need more data, clairvoyants have not yet been brought here