Client disconnects from MySql server

[ste z]

I'm facing a problem with the connection to my MySql server.
The connection is lost every 20-22 seconds and i have to connect again.
The connection to the WIFI network is not affected.
I would like to keep the connection alive even if there is no activity (INSERT statements), in order to reduce the delay. Note that the wait_timeout parameter in MySQL server is set to 28800 secs (default).


void setup()
{
Serial.begin(9600);
connectToWiFi();
connectToMySQL();
}

void checkMySQLConnection()
{
if (my_conn.is_connected() == 0)
{
Serial.println("Connection is lost");
connectToMySQL();
}

}


void loop()
{
checkWiFiConnection();
checkMySQLConnection();

//read pressure mat sensor
.
.
//INSERT data to db

delay(100);
}




Using Arduino Uno R3, Arduino WiFi shield R3 (firmware 1.0), and the latest MySql connector.

Any help would be greatly appreciated.