Hello. I have the following problem. OpenServer gives the error MySQL server has gone away with the fact that I installed

wait_timeout=288000 max_allowed_packet = 10240M

But even with such huge values, the error did not disappear. The fact is that I work with a table with about 147 million rows.

Tell me how else you can solve this problem. Thank.

Request

 SELECT LAT_LA_ID FROM tof_link_la_typ WHERE tof_link_la_typ.LAT_TYP_ID=:type_id

The answer when using EXPLAIN

 [id] => 1 [select_type] => SIMPLE [table] => tof_link_la_typ [type] => ALL [possible_keys] => [key] => [key_len] => [ref] => [rows] => 140794627 [Extra] => Using where

The table without primary key This is a lingual table, but I already try to just get the data from it, because thought that the problem is in join

  • How do you fulfill the request? In the console mysql client it turns out to wait for a response? How long does the query take? - cheops
  • @cheops, I execute a request from a php script. The script runs for about 5 minutes and then the error appears. - Taras
  • Execute EXPLAIN for a query, add a question to this statement, and if it’s not difficult to give the query itself. You may have to optimize the query, but for this you need to find out by what plan MySQL executes it. - cheops
  • @cheops, here’s the answer for EXPLAIN [id] => 1 [select_type] => SIMPLE [table] => tof_link_la_typ [type] => ALL [possible_keys] => [key] => [key_len] => [ref] = > [rows] => 140794627 [Extra] => Using where - Taras
  • Request added to question description - Taras

0