Why are mysql queries taking a long time?

Question

MySQL

There is a table, in it 12 million records. With any selection (example: select * from table where url = "test" limit 1), memory is slowly running out (it has 8 GB of RAM in total) and, of course, it is not possible to get a record. No matter how I try to change the query, nothing helps.

Answer 1

I agree with Anton Anton - memory should not leak.

it has 8 GB of RAM in total

How much does MySQL take? What else is running?
Send us the output of
top -b -o +%MEM | head -n 15