Setting it in a DB parameter group applies the parameters only at the instance level. Note: For Amazon Aurora, you can modify the parameters and set them in a cluster parameter group to apply at the entire cluster level. For more information, see Modifying parameters in a DB parameter group. If the query that is generating the error is retrieving a large dataset, then increase the max_allowed_packet size parameter by using a custom parameter group.For more information, see Working with DB parameter groups. If a connection times out, then increase the timeouts for MySQL by increasing the wait_timeout and interactive_timeout parameters by using a custom parameter group.To resolve this issue, verify that application timeouts are shorter than the MySQL timeouts, and be sure that your applications close idle connections. If a connection is idle for too long, then the connection might be terminated incorrectly from the client. See the following causes for and related resolutions for these errors: CR_SERVER_LOST - The client didn't get an error when writing to the server, but the client didn't get a full answer (or any answer) to the question.įor more information, see the MySQL documentation for MySQL server has gone away.CR_SERVER_GONE_ERROR - The client couldn't send a question to the server.If the server timed out and closed the connection, you might receive one of the following errors:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |