How to improve SQL query performance?

Question

MySQL

There is a request -

SELECT * FROM all_data ad INNER JOIN required r ON ad.isbn=r.required_isbn

in the first table 800k, in the second 300k. There are indexes on isbn and required_isbn.
i.e. I need to get only those rows from the first table whose isbn values ​​match the required_isbn from the second.
it is normal that the request tupit? when outputting 1000 lines is not a problem. But how to "announce the entire list" (c)?
Thanks

Answer 1

Where should such requests be made?
The problem here is architecture.
It's one thing if it's rare, but it's another thing if it's constant.

Answer 2

And you can find out what tupit means?
As I understand it is necessary to return the full result of the request? Could this be a slow I/O problem?

Answer 3

The script is nowhere simpler and it is difficult to advise without a table structure. Depending on what is stored in the tables - I would remove the asterisk and clearly list the data to be returned (100% you return the same identifier twice)