basapuram-kumar commented on PR #391:
URL: https://github.com/apache/ranger/pull/391#issuecomment-2413311269
Hello @vikaskr22 ,
Thanks for the details explaination on the pros and cons of the suggested
settings.
yes, absolutely agreed on the pointers.
For the asked info,
> What is the MySql version where you got this error ? What is default
"storage_engine"? It should be 'InnoDb'.
I am using `MySQL-8.0.36`, and the detault `storage_engine` is `InnoDB`
mysql > show create table x_trx_log_v2;
>
> x_trx_log_v2 | CREATE TABLE `x_trx_log_v2` (
> `id` bigint NOT NULL AUTO_INCREMENT,
> `create_time` datetime DEFAULT NULL,
> `added_by_id` bigint DEFAULT NULL,
> `class_type` int NOT NULL DEFAULT '0',
> `object_id` bigint DEFAULT NULL,
> `parent_object_id` bigint DEFAULT NULL,
> `parent_object_class_type` int NOT NULL DEFAULT '0',
> `parent_object_name` varchar(1024) DEFAULT NULL,
> `object_name` varchar(1024) DEFAULT NULL,
> `change_info` mediumtext,
> `trx_id` varchar(1024) DEFAULT NULL,
> `action` varchar(255) DEFAULT NULL,
> `sess_id` varchar(512) DEFAULT NULL,
> `req_id` varchar(30) DEFAULT NULL,
> `sess_type` varchar(30) DEFAULT NULL,
> PRIMARY KEY (`id`),
> KEY `x_trx_log_v2_FK_added_by_id` (`added_by_id`),
> KEY `x_trx_log_v2_cr_time` (`create_time`),
> KEY `x_trx_log_v2_trx_id` (`trx_id`)
> ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1
ROW_FORMAT=DYNAMIC |
>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@ranger.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
