MariaDb - Histórico de revisão

Murilo: /* Variáveis AWS */

2023-10-19T20:25:05Z

Variáveis AWS

← Edição anterior		Edição das 20h25min de 19 de outubro de 2023
Linha 65:		Linha 65:

	character_set_* = utf8		character_set_* = utf8

			== Aurora ==

	aurora_parallel_query=1 # consultas paralelas		aurora_parallel_query=1 # consultas paralelas

Murilo: /* Variáveis AWS */

2023-10-19T20:24:42Z

Variáveis AWS

← Edição anterior		Edição das 20h24min de 19 de outubro de 2023
Linha 65:		Linha 65:

	character_set_* = utf8		character_set_* = utf8

			aurora_parallel_query=1 # consultas paralelas

Murilo: /* Variáveis especiais */

2023-05-24T13:01:58Z

Variáveis especiais

← Edição anterior		Edição das 13h01min de 24 de maio de 2023
Linha 39:		Linha 39:

	* SET SESSION group_concat_max_len = 1000000;		* SET SESSION group_concat_max_len = 1000000;


	* SET SESSION group_concat_max_len=4294967295; - 32bits		* SET SESSION group_concat_max_len=4294967295; - 32bits
	* SET GLOBAL group_concat_max_len=4294967295; - 54bits		* SET GLOBAL group_concat_max_len=4294967295; - 54bits


	= Variáveis AWS =		= Variáveis AWS =

Murilo: /* Variáveis AWS */

2023-05-24T12:52:07Z

Variáveis AWS

← Edição anterior		Edição das 12h52min de 24 de maio de 2023
Linha 66:		Linha 66:

	group_concat_max_len = 5000000		group_concat_max_len = 5000000

			character_set_* = utf8

Murilo: /* Variáveis AWS */

2023-05-24T12:48:29Z

Variáveis AWS

← Edição anterior		Edição das 12h48min de 24 de maio de 2023
Linha 64:		Linha 64:

	time_zone = Brazil/East		time_zone = Brazil/East

			group_concat_max_len = 5000000

Murilo: /* Variáveis AWS */

2023-01-18T10:43:31Z

Variáveis AWS

← Edição anterior		Edição das 10h43min de 18 de janeiro de 2023
Linha 51:		Linha 51:
	<blockquote>		<blockquote>
	To enable SQL database triggers for the Amazon Relational Database Service (RDS).		To enable SQL database triggers for the Amazon Relational Database Service (RDS).

	If one attempts to create a SQL database trigger, then the database server will complain a confusing and misleading message like: “ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)“.		If one attempts to create a SQL database trigger, then the database server will complain a confusing and misleading message like: “ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)“.

	It happens that Amazon decided to disable all user defined SQL code, as binary procedures could compromise the RDS architecture. And for this purpose, Amazon blocked granting the missing ‘SUPER’ privileges to any database user except the ‘rdsadmin’ user owned by Amazon itself.		It happens that Amazon decided to disable all user defined SQL code, as binary procedures could compromise the RDS architecture. And for this purpose, Amazon blocked granting the missing ‘SUPER’ privileges to any database user except the ‘rdsadmin’ user owned by Amazon itself.

	As a workaround, one may set the mysterious parameter ‘log_bin_trust_function_creators’ to 1, that prevents the database from complaining against simple and inoffensive triggers.		As a workaround, one may set the mysterious parameter ‘log_bin_trust_function_creators’ to 1, that prevents the database from complaining against simple and inoffensive triggers.

			https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/
	</blockquote>		</blockquote>

Murilo: /* Variáveis AWS */

2023-01-18T10:43:20Z

Variáveis AWS

← Edição anterior		Edição das 10h43min de 18 de janeiro de 2023
Linha 50:		Linha 50:

	<blockquote>		<blockquote>
	enable SQL database triggers for the Amazon Relational Database Service (RDS).		To enable SQL database triggers for the Amazon Relational Database Service (RDS).
	If one attempts to create a SQL database trigger, then the database server will complain a confusing and misleading message like: “ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)“.		If one attempts to create a SQL database trigger, then the database server will complain a confusing and misleading message like: “ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)“.
	It happens that Amazon decided to disable all user defined SQL code, as binary procedures could compromise the RDS architecture. And for this purpose, Amazon blocked granting the missing ‘SUPER’ privileges to any database user except the ‘rdsadmin’ user owned by Amazon itself.		It happens that Amazon decided to disable all user defined SQL code, as binary procedures could compromise the RDS architecture. And for this purpose, Amazon blocked granting the missing ‘SUPER’ privileges to any database user except the ‘rdsadmin’ user owned by Amazon itself.

Murilo: /* Variáveis AWS */

2023-01-18T10:41:31Z

Variáveis AWS

← Edição anterior		Edição das 10h41min de 18 de janeiro de 2023
Linha 48:		Linha 48:

	log_bin_trust_function_creators = 1; #https://aws.amazon.com/pt/premiumsupport/knowledge-center/rds-mysql-functions/		log_bin_trust_function_creators = 1; #https://aws.amazon.com/pt/premiumsupport/knowledge-center/rds-mysql-functions/

			<blockquote>
			enable SQL database triggers for the Amazon Relational Database Service (RDS).
			If one attempts to create a SQL database trigger, then the database server will complain a confusing and misleading message like: “ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)“.
			It happens that Amazon decided to disable all user defined SQL code, as binary procedures could compromise the RDS architecture. And for this purpose, Amazon blocked granting the missing ‘SUPER’ privileges to any database user except the ‘rdsadmin’ user owned by Amazon itself.
			As a workaround, one may set the mysterious parameter ‘log_bin_trust_function_creators’ to 1, that prevents the database from complaining against simple and inoffensive triggers.
			</blockquote>

	sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION		sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

	time_zone = Brazil/East		time_zone = Brazil/East

Murilo em 12h16min de 9 de janeiro de 2023

2023-01-09T12:16:56Z

← Edição anterior		Edição das 12h16min de 9 de janeiro de 2023
Linha 2:		Linha 2:
	Informações do Banco de Dados		Informações do Banco de Dados

			= Backup =

			<code>
			mysqldump -u user database > arquivo.sql
			</code>

	= Usuários =		= Usuários =

Murilo: /* Variáveis AWS */

2022-05-22T17:01:07Z

Variáveis AWS

← Edição anterior		Edição das 17h01min de 22 de maio de 2022
Linha 45:		Linha 45:

	sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION		sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

			time_zone = Brazil/East