MySQL变量gtid_executed频繁更改

Question

MySQL全局变量gtid_executed立即发生多次更改是否正常？

这些MySQL命令在10秒的时间范围内执行：

mysql> show global variables like 'gtid_executed';
+---------------+-------------------------------------------------+
| Variable_name | Value                                           |
+---------------+-------------------------------------------------+
| gtid_executed | d4eeed2f-6cc7-11e9-aa15-fa163e5318c7:1-26918205 |
+---------------+-------------------------------------------------+
1 row in set (0.00 sec)

mysql> show global variables like 'gtid_executed';
+---------------+-------------------------------------------------+
| Variable_name | Value                                           |
+---------------+-------------------------------------------------+
| gtid_executed | d4eeed2f-6cc7-11e9-aa15-fa163e5318c7:1-26918206 |
+---------------+-------------------------------------------------+
1 row in set (0.00 sec)

mysql> show global variables like 'gtid_executed';
+---------------+-------------------------------------------------+
| Variable_name | Value                                           |
+---------------+-------------------------------------------------+
| gtid_executed | d4eeed2f-6cc7-11e9-aa15-fa163e5318c7:1-26918207 |
+---------------+-------------------------------------------------+
1 row in set (0.00 sec)

每次都有不同的值！这正常吗？它是云环境中的单节点SaaS MySQL RDS实例。提前感谢您的好意。

Answer 1

如果您在服务器上有活动，这是正常行为，因为对于每个新事务，都会为其分配一个新的GTID值，递增1。