julien-duponchelle/python-mysql-replication

increasing handler_read_rnd

Closed this issue · 0 comments

Problem

Detected increasing handler_read_rnd.
스크린샷 2023-08-25 오후 4 33 04

Concerns

This can lead to an increase in I/O operations, as the system needs to read through potentially large amounts of data. This can strain the disk subsystem and lead to increased latency for other operations.
Also, Sequentially reading through rows can lead to increased CPU usage, especially if the dataset is large.

Solution

This can be done by removing 'ORDER BY' statement in table_map event.

스크린샷 2023-08-25 오후 4 43 56