RDSのパラメータグループ

MySQLを5.6から5.7に切り替えることに伴って、

パラメータグループも新設する必要があった。

5.6のデフォルトパラメータグループから変更していた箇所を洗い出したので、

メモっておく。

上段　5.6と5.7のデフォルトパラメータグループ、

中段　5.6の変更後のパラメータグループ（使用中）

下段　5.7の変更後のパラメータグループ（新設）

init_connect		TRUE	engine-default	dynamic	string		String to be executed by the server for each client that connects.
init_connect	CALL shared.store_time_zone	TRUE	user	dynamic	string		String to be executed by the server for each client that connects.
init_connect	CALL shared.store_time_zone	TRUE	user	dynamic	string		String to be executed by the server for each client that connects.
long_query_time		0-31536000	TRUE	engine-default	dynamic	float	Defines what MySQL considers long queries
long_query_time	1	0-31536000	TRUE	user	dynamic	float	Defines what MySQL considers long queries
long_query_time	1	0-31536000	TRUE	user	dynamic	float	Defines what MySQL considers long queries
max_connections	{DBInstanceClassMemory/12582880}	1-100000	TRUE	system	dynamic	integer	The number of simultaneous client connections allowed.
max_connections	{DBInstanceClassMemory/12582880}	1-100000	TRUE	user	dynamic	integer	The number of simultaneous client connections allowed.
max_connections	{DBInstanceClassMemory/12582880}	1-100000	TRUE	system	dynamic	integer	The number of simultaneous client connections allowed.
slow_query_log		0, 1	TRUE	engine-default	dynamic	boolean	Enable or disable the slow query log
slow_query_log	1	0, 1	TRUE	user	dynamic	boolean	Enable or disable the slow query log
slow_query_log	1	0, 1	TRUE	user	dynamic	boolean	Enable or disable the slow query log
thread_cache_size		0-16384	TRUE	engine-default	dynamic	integer	Number of threads to be cached. Doesn't improve perf for good thread implementations.
thread_cache_size	2	0-16384	TRUE	user	dynamic	integer	Number of threads to be cached. Doesn't improve perf for good thread implementations.
thread_cache_size	2	0-16384	TRUE	user	dynamic	integer	Number of threads to be cached. Doesn't improve perf for good thread implementations.
wait_timeout		1-31536000	TRUE	engine-default	dynamic	integer	The number of seconds the server waits for activity on a non-interactive TCP/IP or UNIX File connection before closing it.
wait_timeout	60	1-31536000	TRUE	user	dynamic	integer	The number of seconds the server waits for activity on a non-interactive TCP/IP or UNIX File connection before closing it.
wait_timeout	60	1-31536000	TRUE	user	dynamic	integer	The number of seconds the server waits for activity on a non-interactive TCP/IP or UNIX File connection before closing it.