increasing handler_read_rnd
Closed this issue · 0 comments
ebang091 commented
Problem
Detected increasing handler_read_rnd.
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](https://private-user-images.githubusercontent.com/108053947/263211544-5d29ce7b-d6ba-45ab-970d-980c81f431f5.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ2Nzc0NjcsIm5iZiI6MTcyNDY3NzE2NywicGF0aCI6Ii8xMDgwNTM5NDcvMjYzMjExNTQ0LTVkMjljZTdiLWQ2YmEtNDVhYi05NzBkLTk4MGM4MWY0MzFmNS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI2JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyNlQxMjU5MjdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0zZWJjNTRkOTgxM2QxN2MwNGMxM2E2YjI3MWI3YWM0ZGIxNzY2ZTJlMjUwODJmNTA1NTljYzkxYWE0MTAyZDQ4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.5GkfR7V5KyCDoWkzaQJEzU0I9X0PVWjKEpG8__kFwYQ)