SQL Queries Hangs When They Are More Than Around 1375 Bytes; MTU; ERROR 2013 (HY000): Lost Connection to MySQL Server During Query (Doc ID 2049367.1)

Last updated on APRIL 11, 2017

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute a query longer than around 1375 bytes by connecting to MySQL using TCP on a host name or IP address other than localhost or 127.0.0.1, the query freezes and/or returns the following error.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms