Sample Header Ad - 728x90

Making mysql write more to ram and less to SSD

0 votes
2 answers
215 views
What are some tunning options that could make MySQL (8.0.36) write more to ram memory and less to SSD ? To have **less SSD wear** not to optimize performance. Do these two affect amount of bytes written to disk at all ? The way I know it, SSDs need to rearange data and constantly move it around when writing new data, so I am thinking if these options delays writes to SSD, then it might write less data ? Since it might already be optimally arranged while in Ram ?
innodb_flush_log_at_trx_commit = 0
innodb_flush_log_at_timeout = 3
I also have innodb_buffer_pool_size = 90G What are some [other] variables that I can tune so that it writes less to SSD and more to ram ? Having tables fully stored in memory would be nice, but I think they are too big for that to work properly. The server has 128 GB ram, largest database is around 100-150 GB. Would other variables help ? e.g innodb_log_buffer_size, innodb_redo_log_capacity ?
Asked by adrianTNT (206 rep)
Jun 29, 2024, 04:22 PM
Last activity: Jul 7, 2024, 02:13 PM