A
A
Andrey2015-04-07 23:02:54
MySQL
Andrey, 2015-04-07 23:02:54

How much slower will an SSD be without TRIM support?

We have a database server on which periodically there are performance plugs
mysql starts to slow down.
The server is quite loaded up to 2.5K requests per second.
requests to change information up to 250 per second. Requests are small, the amount of information to change is small.
During the proceedings, we found out that trim does not work in the system and ssd work without it.
Could this be a serious problem causing serious delays in processing requests

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem @Jump, 2015-04-07
Tag curated by

Of course this will be a major problem.
The write speed can drop to very low values.
When recording, the HDD writes over the old information, overwriting it. That is, such an operation as erasing data in the HDD is not provided at all, because it is not needed.
An SSD can only write to a cleared cell. If the cell contains information, it must first be erased, then written down. This is a lengthy operation.
Since the disk connection interface is tailored specifically for the HDD, there are no signals for erasing unnecessary information there, the data is simply marked as unused and remains on the disk.
For HDD this is normal, for SSD it is a big problem.
That is, with active recording, all SSD cells are clogged with old unnecessary information, the disk cannot delete this information in advance, because it does not know that it is unnecessary.
As a result, deletion occurs at the time of recording - which at times squanders the recording speed.
TRIM is a command to delete information, tells the disk what information is not needed, and it deletes it in advance.
As a result, the write speed is always high.
So be sure to turn on the trim.
If this is not possible, use folk remedies - leave a piece of unallocated space on the SSD.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question