Mysql - Lost connection with server ?

MySQL & MariaDB Other MySQL® Questions
1

Hi,

As i write on tittle, i have problem when executing stats request during 15/20min.
I tested with cli mysql, or with php, same thing.
I tested on “direct” or via loadblancer, same thing.

This message doesn’t appear at same time, and not all the time ( some request work great… )

wait_timeout is ok :
mysql> show variables like ‘%timeout%’;
±---------------------------±------+
| Variable_name | Value |
±---------------------------±------+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800 |
±---------------------------±------+

I have read everything on it on mysqldoc and i didn’t see any problem…

anyone have an idea ?

Thanks )

2

I think there can be a few different causes for this error including… network problems faulty hardware, unreliable link),

DNS problems (faiing to reverse dns the client if you have hostname based logins)

Mismatched client and server libraries (in some certain situations this can cause a connection to drop)

The first place to check would be in your mysql error log, since if a connection is actually established, there should be an error there when it drops

Also check your php error log which might give some clues