On MYSQL Workbench, I'm running this query : `count(*) from test.nameTable` I have couple millions rows in this table .
after a while I get this error : `Lost connection to MySQL server during query`

I saw this question and its answers in other places but none of the answers helped.  

I tried setting all timeout and packet size global variables to their maximum value, and spliting my query somehow..
But none of this methods worked.

```
SET GLOBAL connect_timeout=10000000
SET GLOBAL net_read_timeout=10000000
SET GLOBAL max_allowed_packet=1073741824

```

Anyone knows what could be the problem and how to solve it please?