Skip to content

increasing handler_read_rnd #445

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
ebang091 opened this issue Aug 25, 2023 · 0 comments · Fixed by #448
Closed

increasing handler_read_rnd #445

ebang091 opened this issue Aug 25, 2023 · 0 comments · Fixed by #448

Comments

@ebang091
Copy link
Contributor

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant