On 11.10.2024 11:59, Raffaele Gambelli wrote:
The transaction isolation level, at least for MariaDB you can set in the
command run line, for example in this way:
mysqld --lower-case-table-names=1 --character-set-server=utf8
--collation-server=utf8_unicode_ci --transaction-isolation=READ-COMMITTED
--max-allowed-packet=128M --max_connections=250
While character-set and collation can be set at db level, the transaction
isolation level can be set globally or at session level.
Best regards
FWIW, when I last touched the documentation, I wrote
inhttps://jackrabbit.apache.org/oak/docs/nodestore/document/rdb-document-store.html#mysql:
To verify, check the INFO level log message written by RDBDocumentStore upon
startup. For example:
13:40:46.637 INFO [main] RDBDocumentStore.java:1065 RDBDocumentStore
(SNAPSHOT) instantiated for database MySQL 8.0.15 (8.0), using driver: MySQL
Connector/J mysql-connector-java-8.0.15 (Revision:
79a4336f140499bd22dd07f02b708e163844e3d5) (8.0), connecting to:
jdbc:mysql://localhost:3306/oak?serverTimezone=UTC, properties:
{character_set_database=utf8mb4, character_set_client=utf8mb4,
character_set_connection=utf8mb4, character_set_results=,
max_allowed_packet=8388608, collation_database=utf8mb4_unicode_ci,
character_set_system=utf8, collation_server=utf8mb4_0900_ai_ci,
collation=utf8mb4_unicode_ci, character_set_filesystem=binary,
character_set_server=utf8mb4, collation_connection=utf8mb4_0900_ai_ci},
transaction isolation level: TRANSACTION_REPEATABLE_READ (4), .nodes: ID
VARBINARY(512), MODIFIED BIGINT(20), HASBINARY SMALLINT(6), DELETEDONCE
SMALLINT(6), MODCOUNT BIGINT(20), CMODCOUNT BIGINT(20), DSIZE BIGINT(20),
VERSION SMALLINT(6), SDTYPE SMALLINT(6), SDMAXREVTIME BIGINT(20), DATA
VARCHAR(16000), BDATA LONGBLOB(2147483647) /* {BIGINT=-5, LONGBLOB=-4,
SMALLINT=5, VARBINARY=-3, VARCHAR=12} */ /* unique index oak.PRIMARY on nodes
(ID ASC) other (#0, p0), index oak.NODES_MOD on nodes (MODIFIED ASC) other (#0,
p0), index oak.NODES_SDM on nodes (SDMAXREVTIME ASC) other (#0, p0), index
oak.NODES_SDT on nodes (SDTYPE ASC) other (#0, p0), index oak.NODES_VSN on
nodes (VERSION ASC) other (#0, p0) */
So even back then, we just used "TRANSACTION_REPEATABLE_READ (4)".
Best regards, Julian
