How to make sql select on a large amount of data?

Question

MySQL

Guys, tell me, you need to make a total selection of 5 tables, the volume of records in the table is 3 million records, you need to filter and select by condition, how to do it so that everything is more or less fast, I connect tables inner join, hung indexes on the fields, anyway the request hangs somewhere for 2-3 minutes

Answer 1

habrahabr.ru/company/cackle/blog/259301 Read the article, maybe you can take something for yourself.

Answer 2

underground knock

Answer 3

It is of course an accordion - but maybe you should pay attention to EXPLAIN? It will immediately become clear what exactly is SO slowing down.
I once found out that a simple-simple query is done on a table with 18 million rows on a field without an index.