Insert into member_base_secret(entity_id, secret_value) value ('72292894', 'iXD4BEZutQqIbCMJ5FpMEw=') Insert into member_base_secret(entity_id, secret_value) value ('72292516', 'M5UbeO83nhLil+KC6SQUmGIdOEVWABcWYnnDB1U5a9k=') Insert into member_base_secret(entity_id, secret_value) value ('72290279', 'EktgzNE4MtlMS8nCmcLfWQ=') Insert into member_base_secret(entity_id, secret_value) value ('72287742', 'd0FPktUG元dgjSj9k2Mc+A=') Insert into member_base_secret(entity_id, secret_value) value ('72287654', '/dgPxRdaVdcoZq5zu7RDxQ=') Insert into member_base_secret(entity_id, secret_value) value ('72286979', 'YRc8Um12WcVGwzpDKu4ZJQ=') Insert into member_base_secret(entity_id, secret_value) value ('72176931', 'FtngxzeyLtXFZaLwFqatxg=') Insert into member_base_secret(entity_id, secret_value) value ('72168810', '/1LYJQef6GFGWX8KQt58of8KvLMH4TMEM0s16+blnyE=') Insert into member_base_secret(entity_id, secret_value) value ('32879435', 'aJNtKaE//8DksU03FyX4YA=') # insert data into table member_base_secret IF arg_value IS NOT NULL AND TRIM(arg_value) '' AND '' AND >= 32 THEN source include/have_binlog_format_row.incĬREATE TABLE `member_base_secret` (`id` bigint NOT NULL AUTO_INCREMENT, `entity_id` bigint NOT NULL COMMENT '实体Id', `entity_column` varchar(50) DEFAULT 'NAME' COMMENT '列名', `secret_value` varchar(1024) NOT NULL COMMENT '密文', PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2031586 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ĬREATE FUNCTION `PMS_DECRYPT`(arg_value VARCHAR(3000)) RETURNS varchar(3000) CHARSET utf8mb4 DETERMINISTIC
There is no the issue when binlog is disabled. We found that the memory is mainly allocate in function get_var_with_binlog, which is in src/sql/sql/item_ through jemalloc. We can see that the memory usage grows hundreds of megabytes during the execution by "select current_alloc from sys.memory_global_by_current_bytes where event_name = 'memory/sql/THD::main_mem_root'". When binlog is enabled, executing a SELECT statement causes to allocate lots of memory for binlog, the SELECT statement calls a function which does not contain any DML.
0 kommentar(er)
