Analytic DB-Storage Ubuntu 2404

Completed

Claudius

March 27, 2025 08:28 Edited

Hey guys, 

I can't select any Storage for Analytic on Ubuntu. There's only the option for main Storage.
Any ideas what could be causing this?

Serverwebsite

NX

0

• 

  Norman

  • Network Optix team

  March 27, 2025 09:00

  Hi Claudius,

  At the moment, it's not possible to store the analytics database on external storage.

  The main reason is due to how the SQLite database handles file operations—it relies on advanced file system features like file locking, which can behave unpredictably with certain SMB implementations. Unfortunately, this often results in database corruption that can’t be recovered.

  The second reason is related to performance. Storing the analytics database on a NAS can cause issues because most NAS devices—and the hard drives they use—aren’t typically fast enough to handle the high data throughput required for analytics. In fact, even local HDDs can struggle in larger setups or systems generating a high volume of analytics events. For the best results, we recommend using an SSD or, ideally, an NVMe drive for analytics storage.
  
  With kind regards.

  0
• 

  Claudius

  March 27, 2025 09:14

  Hi Norman, 

  the NAS storage is configured only for recordings. The Ubuntu system is on an SSD that's split into two partitions. However, I still can't move analytics data.

  Unfortunately, it doesn't work on my Pi5 with PiOS or Ubuntu either. It's not a big deal; I just wanted to know the reason or whether it's a bug :)

  0

Post is closed for comments.