You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Konstantin Orlov (Jira)" <ji...@apache.org> on 2026/03/13 12:14:00 UTC
[jira] [Created] (IGNITE-28226) Latency spikes on INSERT due to checkpoint
Konstantin Orlov created IGNITE-28226:
-----------------------------------------
Summary: Latency spikes on INSERT due to checkpoint
Key: IGNITE-28226
URL: https://issues.apache.org/jira/browse/IGNITE-28226
Project: Ignite
Issue Type: Bug
Components: storage engines ai3
Affects Versions: 3.1
Reporter: Konstantin Orlov
Attachments: InsertTest-1.java
See the attached reproduced (you may add this class as {{intergationTest}} of JDBC module).
In short, this test open JDBC connection and then executes multiple times following sequence:
# Creates table
# Loads 10k rows by batches of 500 rows
# Drops table
Starting from the 2nd iteration, execution time for some batches increases in x10-15 times. Every time such increases happens right after checkpoint and/or compaction:
{code}
[2026-03-13T14:09:54,506][WARN ][main][TestLogger] Orders loading iteration completed in: 48.70 ms
[2026-03-13T14:09:54,553][WARN ][main][TestLogger] Orders loading iteration completed in: 46.29 ms
[2026-03-13T14:09:54,593][WARN ][main][TestLogger] Orders loading iteration completed in: 39.10 ms
[2026-03-13T14:09:54,604][INFO ][%test%checkpoint-thread][Checkpointer] Checkpoint started [checkpointId=7114cf7e-851e-4c14-8dd6-66df8d6bce48, beforeWriteLockTime=1ms, writeLockWait=0us, beforeCheckpointBeginTime=1406us, markCheckpointBeginTime=132us, writeLockHoldTime=166us, splitAndSortPagesDuration=0ms, pages=954, reason='Triggered by replicator']
[2026-03-13T14:09:55,011][INFO ][%test%checkpoint-thread][Checkpointer] Checkpoint finished [checkpointId=7114cf7e-851e-4c14-8dd6-66df8d6bce48, writtenPages=954, fsyncFiles=132, pagesWriteTime=9ms, fsyncTime=393ms, replicatorLogSyncTime=3ms, waitCompletePageReplacementTime=0ms, totalTime=408ms, avgIoWriteSpeed=37MB/s, avgWriteSpeed=36MB/s]
[2026-03-13T14:09:55,014][INFO ][%test%compaction-thread][Compactor] Starting new compaction round [compactionId=d7b2d9a9-c6eb-4964-8f56-4b225b119816, files=66]
[2026-03-13T14:09:55,303][INFO ][%test%compaction-thread][Compactor] Compaction round finished [compactionId=d7b2d9a9-c6eb-4964-8f56-4b225b119816, pages=269, skipped=0, duration=288ms, avgWriteSpeed=15MB/s]
[2026-03-13T14:09:55,333][WARN ][main][TestLogger] Orders loading iteration completed in: 738.9 ms
[2026-03-13T14:09:55,383][WARN ][main][TestLogger] Orders loading iteration completed in: 48.94 ms
[2026-03-13T14:09:55,431][WARN ][main][TestLogger] Orders loading iteration completed in: 47.19 ms
[2026-03-13T14:09:55,486][WARN ][main][TestLogger] Orders loading iteration completed in: 54.44 ms
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)