Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.4.7
-
mariadb 10.4.7 galera 26.4.2
Description
i create two table jian is innodb ,jianm is myisam
(root@localhost) [sbdb] 11:38:22> show create table jian;
|
+-------+----------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------+
|
| jian | CREATE TABLE `jian` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
|
+-------+----------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
(root@localhost) [sbdb] 11:42:39> show create table jianm;
|
+-------+-----------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------------------------------------+
|
| jianm | CREATE TABLE `jianm` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
|
+-------+-----------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
do the insert into the tables
(root@localhost) [sbdb] 11:42:45> show variables like '%gtid%';
|
+-------------------------+---------------+
|
| Variable_name | Value |
|
+-------------------------+---------------+
|
| gtid_binlog_pos | 1-1-7,101-1-9 |
|
| gtid_binlog_state | 1-1-7,101-1-9 |
|
| gtid_cleanup_batch_size | 64 |
|
| gtid_current_pos | 1-1-7,101-1-9 |
|
| gtid_domain_id | 101 |
|
| gtid_ignore_duplicates | ON |
|
| gtid_pos_auto_engines | |
|
| gtid_seq_no | 0 |
|
| gtid_slave_pos | |
|
| gtid_strict_mode | ON |
|
| last_gtid | 101-1-9 |
|
| wsrep_gtid_domain_id | 1 |
|
| wsrep_gtid_mode | ON |
|
+-------------------------+---------------+
|
13 rows in set (0.00 sec)
|
|
(root@localhost) [sbdb] 11:43:31> insert into jianm values(1);
|
Query OK, 1 row affected (0.00 sec)
|
|
(root@localhost) [sbdb] 11:43:43> show variables like '%gtid%';
|
+-------------------------+----------------+
|
| Variable_name | Value |
|
+-------------------------+----------------+
|
| gtid_binlog_pos | 1-1-7,101-1-10 |
|
| gtid_binlog_state | 1-1-7,101-1-10 |
|
| gtid_cleanup_batch_size | 64 |
|
| gtid_current_pos | 1-1-7,101-1-10 |
|
| gtid_domain_id | 101 |
|
| gtid_ignore_duplicates | ON |
|
| gtid_pos_auto_engines | |
|
| gtid_seq_no | 0 |
|
| gtid_slave_pos | |
|
| gtid_strict_mode | ON |
|
| last_gtid | 101-1-10 |
|
| wsrep_gtid_domain_id | 1 |
|
| wsrep_gtid_mode | ON |
|
+-------------------------+----------------+
|
13 rows in set (0.00 sec)
|
|
(root@localhost) [sbdb] 11:43:44> insert into jian values(1);
|
Query OK, 1 row affected (0.00 sec)
|
|
(root@localhost) [sbdb] 11:43:50> show variables like '%gtid%';
|
+-------------------------+----------------+
|
| Variable_name | Value |
|
+-------------------------+----------------+
|
| gtid_binlog_pos | 1-1-7,101-1-11 |
|
| gtid_binlog_state | 1-1-7,101-1-11 |
|
| gtid_cleanup_batch_size | 64 |
|
| gtid_current_pos | 1-1-7,101-1-11 |
|
| gtid_domain_id | 101 |
|
| gtid_ignore_duplicates | ON |
|
| gtid_pos_auto_engines | |
|
| gtid_seq_no | 0 |
|
| gtid_slave_pos | |
|
| gtid_strict_mode | ON |
|
| last_gtid | 101-1-11 |
|
| wsrep_gtid_domain_id | 1 |
|
| wsrep_gtid_mode | ON |
|
+-------------------------+----------------+
|
13 rows in set (0.00 sec)
|
This is a galera env
my question is i think it it right the gtid_domain_id transaction sequence increase when i insert into the myisam table ,but why when i insert into the innodb table the gtid_domain_id transaction sequence increase also ,i think when insert into the innodb table the wsrep_gtid_domain_id transaction sequence shoud be increase