V
V
vldud2018-11-12 15:43:57
MySQL
vldud, 2018-11-12 15:43:57

How to find out if the hard drive is to blame for the low performance of mysql?

Good afternoon. The site on Bitrix, the "Performance Panel" tool gives the following:
5be97587b1150154008446.jpeg
Question: how to find out if the hard drive is to blame for such low performance?
Let's assume that all the work on setting up the mysql configuration, optimizing slow queries, creating indexes has been completed, enough RAM has been allocated for mysql.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Viktor Taran, 2018-11-12
@shambler81

What is the server configuration?
my.cnf
in studio
especially should NOT be innodb_flush_log_at_trx_commit=0

I
idShura, 2018-11-12
@idShura

Look at smart hard drives, if the drives are hdd, then you can still do a linear reading test.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question