Symptom:
Mysql Client want to fetch about 200 lines data from mysql server.
From the mysql server end, it stuck at 'sending data' status for a long time.
Solution:
1. First, pls check the Netwerk IO and HW network status.-> low possibility
2. Check the select query is stocked by requiring a lock. -> high possiblity.
-> if the query is blocked by lock, the status is always 'sending data'