Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
In MariaDB, we have a confusing problem where:
- The transaction_isolation option can be set in a configuration file, but it cannot be set dynamically.
- The tx_isolation system variable can be set dynamically, but it cannot be set in a configuration file.
Therefore, we have two different names for the same thing in different contexts. This is needlessly confusing, and it complicates the documentation.
MySQL 5.7 solved this problem by making transaction_isolation into a system variable:
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_transaction_isolation
Same has been done to transaction_read_only option:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-20.html
Attachments
Issue Links
- causes
-
MDEV-31746 Problems with tx_isolation after MDEV-21921
-
- Closed
-
- is part of
-
-
- Open
-
- relates to
-
CONJ-1087 handle mariadb-11.1+ transaction_isolation
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to DBAAS-2761 [ DBAAS-2761 ] |
| Labels | beginner-friendly |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 104800 ] | MariaDB v4 [ 131234 ] |
| Labels | beginner-friendly | beginner-friendly gsoc22 |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Nikita Malyavin [ nikitamalyavin ] |
| Description |
In MariaDB, we have a confusing problem where:
* The {{transaction_isolation}} option can be set in a configuration file, but it cannot be set dynamically. * The {{tx_isolation}} system variable can be set dynamically, but it cannot be set in a configuration file. Therefore, we have two different names for the same thing in different contexts. This is needlessly confusing, and it complicates the documentation. MySQL 5.7 solved this problem by making {{transaction_isolation}} into a system variable: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_transaction_isolation It may be a good idea for MariaDB to make the same change. |
In MariaDB, we have a confusing problem where:
* The {{transaction_isolation}} option can be set in a configuration file, but it cannot be set dynamically. * The {{tx_isolation}} system variable can be set dynamically, but it cannot be set in a configuration file. Therefore, we have two different names for the same thing in different contexts. This is needlessly confusing, and it complicates the documentation. MySQL 5.7 solved this problem by making {{transaction_isolation}} into a system variable: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_transaction_isolation Same has been done to {{transaction_read_only}} option: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-20.html |
| Remote Link | This issue links to "tx_isolation in MariaDB knowledge base (Web Link)" [ 34973 ] |
| Remote Link | This issue links to "tx_read_only in MariaDB knowledge base (Web Link)" [ 34974 ] |
| Link | This issue is part of MDEV-28906 [ MDEV-28906 ] |
| issue.field.resolutiondate | 2023-04-12 01:05:50.0 | 2023-04-12 01:05:50.143 |
| Fix Version/s | 11.1.1 [ 28704 ] | |
| Assignee | Nikita Malyavin [ nikitamalyavin ] | Daniel Black [ danblack ] |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link |
This issue is blocked by |
| Link |
This issue relates to |
| Link |
This issue is blocked by |
| Link |
This issue causes |
| Link |
This issue relates to |