DGRFL

@Pavel, you are completely correct @Damerva , thanks

Thanks for the clarification. So in the above picture inserted+updated+deleted is around 200 in total. If rows_modified is 400 times bigger, there is a huge amount of temporary tables involved Because there is a similar huge gap between rows_returned and rows_read, I can imagine that there are many queries with full table…