Skip to content

meta/mysql: set defalut transation_isolation to repeatable-read #5432

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 3 commits into from
Dec 25, 2024
Merged

Conversation

Xuyuchao-juice
Copy link
Contributor

No description provided.

@davies davies merged commit 1297700 into main Dec 25, 2024
40 checks passed
@davies davies deleted the xuyuchao branch December 25, 2024 09:01
@Xuyuchao-juice
Copy link
Contributor Author

tidb验证结果
image

@zhoucheng361
Copy link
Contributor

zhoucheng361 commented Apr 11, 2025

mysql Test Result:

(venv) root@bench-04:~# mysql -uroot -proot
mysql> SHOW VARIABLES LIKE 'transaction_isolation';
+-----------------------+----------------+
| Variable_name         | Value          |
+-----------------------+----------------+
| transaction_isolation | READ-COMMITTED |
+-----------------------+----------------+
1 row in set (0.00 sec)

mysql> set global general_log = on;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'general%';
+------------------+-----------------------------+
| Variable_name    | Value                       |
+------------------+-----------------------------+
| general_log      | ON                          |
| general_log_file | /var/lib/mysql/bench-04.log |
+------------------+-----------------------------+
2 rows in set (0.00 sec)

(venv) root@bench-04:~/juicefs# cat  /var/lib/mysql/bench-04.log
2025-04-11T07:28:35.344596Z        21 Connect   juicedata@localhost on test3 using TCP/IP
2025-04-11T07:28:35.344732Z        21 Query     SET transaction_isolation = 'repeatable-read'
2025-04-11T07:28:35.345502Z        21 Prepare   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEM
A`=? and `TABLE_NAME`=?
2025-04-11T07:28:35.345533Z        21 Execute   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEM
A`='test3' and `TABLE_NAME`='jfs_setting'
2025-04-11T07:28:35.345890Z        21 Close stmt
2025-04-11T07:28:35.346044Z        21 Prepare   SELECT `name`, `value` FROM `jfs_setting` WHERE `name`=? LIMIT 1
2025-04-11T07:28:35.346075Z        21 Execute   SELECT `name`, `value` FROM `jfs_setting` WHERE `name`='format' LIMIT 1
2025-04-11T07:28:35.346171Z        21 Close stmt
2025-04-11T07:28:35.347326Z        21 Quit
2025-04-11T07:28:35.385834Z        22 Connect   juicedata@localhost on test3 using TCP/IP
2025-04-11T07:28:35.385955Z        22 Query     SET transaction_isolation = 'repeatable-read'
2025-04-11T07:28:35.386864Z        22 Prepare   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEM
A`=? and `TABLE_NAME`=?
2025-04-11T07:28:35.386898Z        22 Execute   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEM
A`='test3' and `TABLE_NAME`='jfs_setting'
2025-04-11T07:28:35.387197Z        22 Close stmt
2025-04-11T07:28:35.387314Z        22 Prepare   SELECT `name`, `value` FROM `jfs_setting` WHERE `name`=? LIMIT 1
2025-04-11T07:28:35.387329Z        22 Execute   SELECT `name`, `value` FROM `jfs_setting` WHERE `name`='format' LIMIT 1
2025-04-11T07:28:35.387409Z        22 Close stmt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

3 participants