timeout - mysql workbench "Lost connection to mysql server" -

Firstly, I need to indicate that I have run a SQL file on Wikipedia dump on my machine and I may have to update many settings about the index size available on memory and some other settings. I just want to mention that those large SQL queries were successfully run and About if there was no problem.

Now I have a table pjlnx (pl_from, pl_title) which appears in each Wikipedia page, for example the data (1, "title1"), (1, "title) 2 "), (2," title 3 "), (2," title 1 "). I want to create a table which is titled by group group pl_fr for this, this is my SQL query (I am using workbench):

  SET @@ group_concat_max_len = 150000;  

I found an error in running this query: Link to the table "The connection to mysql server was lost during the query" (the keyword playlist, group_concat (pl_title, '')) and the system Asked me again for the password. So I searched and found. So I changed net_read_timeout to 1000 and connect_timeout to 60. This problem did not resolve, so I changed the query:

  SET @@ group_concat_max_len = 150000; Create table concatpagelinks (select pl_from, GROUP_CONCAT (pl_title, '') as link pagelinks group by pl_from 0,1000)  

Still the same problem, and surprisingly That every time the query runs for 600.495 seconds and the error occurs.

You can try to change the timeout value in the workspace. Visit: → Edit → Preferences → SQL Editor → Time to Read DBMS Connection

For more information, refer to this post:

Or in price Try to increase: Edit → Preferences → SQL Editor → DBMS Connections Keep Live Interval