[image] Changelog v1.4.2 suspended for DB locking errors Use normal MariaDB/MySQL/…? Nooooo Use slow sqlite with locks and DQ for that? Yeeees

Short update from a meeting with the developers today about the db locking: The piece size is way too small and causing an IOPS bottleneck that we need to fix. I am not sure about the details but the long term goal is to write bigger pieces to disk. That should improve performance. Why do we store…

loved increased cache_size with old >4gb info.db btw vacuum never fixed malformed databases :rofl:

Of course, but you talked about defragmentation

I migrated my databases to the SSD and collected statistics. As I wrote before , we have a huge fragmentation of the databases, but after migration, to the SSD this problem is not actual. Let’s look into statistics of SSD with databases: [image] As you can see, we have spikes every hour (sent ord…

That’s very impressive and detailed study. Good job!

but wouldn’t copying the database remove the fragmentation and for my SSD with my current zfs my old ssd will only do 4k IOPS with my current Q1T1 bottleneck because of misconfiguration of the LUN’s But i’m not seeing any of that, i got the hourly spike, but it doesn’t created any sort of backlog, …

So, what’s the accepted way of doing it with docker? As I understand the paths in config.yaml are relative, so I probably need to mount the SSD under /storj/node/ssd and specify “ssd” in the config file? I am not super familiar with docker.

I see, I think I should prepare short instruction how we can move DB’s with docker. (I on docker too) Please give me some time.

[image] How to move DB’s to SSD on Docker How to move DB’s to SSD on Docker I think this should be a new topic so this can be categorized as SNO->FAQ

Yes, I agree, but I think this instruction for advanced SNO only, a newbie can kill their nodes… Let’s ask @Alexey to review it and make a decision for the move or not.

[image] How to move DB’s to SSD on Docker the node would crash This is the part I’m not sure about. If it doesn’t it could be online but fail to respond to audits. It could get into trouble quickly. It would be nice if it just crashed and would only be offline. Especially if you’re monitoring …

Storj Community Forum (official)

Database is locked. What is the reason? What is the possible solution?

Node Operators troubleshooting