Statistics Appliance: MySQL server has gone away


This error can be due to a a big query on statistics that generates big data to be insert from the PostGreSQL to the MySQL database. You may increase some values to avoid this error.
This operation is available only if you using a “Statistics Appliance”, not the Artica Proxy itself.

  • Click on the top menu under System.
  • Choose MySQL database server link.

2017-04-25_15-09-29

  • Select Parameters Tab

2017-04-25_15-11-48

  • Increase values of
    • MAX Allowed packet
    • NET buffer length
    • Wait timeout
  • Click on Apply

 

2017-04-25_15-15-20

 

 

Leave a comment