Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Need help to understand select_scan

nrafiqnrafiq EntrantInactive User Role Beginner
Hi Guys,

I am new to MySQL and i have to analyze and reduce the value of select_scan status variable for a large web application. but i don't have a deep knowledge about these select_scan.

i just know that it is incremented whenever a full table scan is done on the first table used in a join. But i am not sure about how can i reduce this and what can be an acceptable value for a large application. Currently it averages to 43000 per day.

The application uses Hibernate and all the queries are generated by hibernate.

Can anyone kindly explain these select_scan to me and help me out that how to reduce the number. will indexing be of any help for this.

any help will be appreciated deeply.

regards,

Nasir Rafiq
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.