slow queries / Timeout on Mysql DB

[MrDadone]

Canvas server,

During rollback, queries on co_block scan 1.7M+ rows taking 30+ seconds, causing a timeout.

stacktrace:

[01:59:19 WARN]:        at java.base/java.util.concurrent.CompletableFuture.timedGet(CompletableFuture.java:1960)
[01:59:19 WARN]:        at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2095)
[01:59:19 WARN]:        at CoreProtect-23.1.jar//net.coreprotect.database.rollback.RollbackEntityHandler.processEntity(RollbackEntityHandler.java:76)
[01:59:19 WARN]:        at CoreProtect-23.1.jar//net.coreprotect.database.rollback.RollbackProcessor.processChunkLogic(RollbackProcessor.java:206)
[01:59:19 WARN]:        at CoreProtect-23.1.jar//net.coreprotect.database.rollback.RollbackProcessor.lambda$processChunk$0(RollbackProcessor.java:76)
[01:59:19 WARN]:        at CoreProtect-23.1.jar//net.coreprotect.thread.Scheduler.lambda$scheduleSyncDelayedTask$0(Scheduler.java:24)
[01:59:19 WARN]:        at io.papermc.paper.threadedregions.scheduler.FoliaRegionScheduler$LocationScheduledTask.run(FoliaRegionScheduler.java:334)
[01:59:19 WARN]:        at io.papermc.paper.threadedregions.scheduler.FoliaRegionScheduler$Scheduler.tick(FoliaRegionScheduler.java:275)
[01:59:19 WARN]:        at io.papermc.paper.threadedregions.scheduler.FoliaRegionScheduler.tick(FoliaRegionScheduler.java:142)
[01:59:19 WARN]:        at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1670)
[01:59:19 WARN]:        at net.minecraft.server.dedicated.DedicatedServer.tickServer(DedicatedServer.java:459)
[01:59:19 WARN]:        at io.papermc.paper.threadedregions.TickRegions$ConcreteRegionTickHandle.tickRegion(TickRegions.java:564)
[01:59:19 WARN]:        at io.papermc.paper.threadedregions.TickRegionScheduler$RegionScheduleHandle.runTick(TickRegionScheduler.java:553)
[01:59:19 WARN]:        at ca.spottedleaf.concurrentutil.scheduler.EDFSchedulerThreadPool$TickThreadRunner.run(EDFSchedulerThreadPool.java:526)
[01:59:19 WARN]:        at java.base/java.lang.Thread.run(Thread.java:1583)