1. Home
  2. Knowledge Base
  3. Problems (EN)
  4. Pandora FMS’ database is too big and pandora_db.pl freezes

Pandora FMS’ database is too big and pandora_db.pl freezes

If any trouble cleaning up Pandora FMS’ database, edit pandora_db.pl and increase value.

 $BIG_OPERATION_STEP

(to 1000-10000, for example) and decrease

$SMALL_OPERATION_STEP

to 100-200.

$BIG_OPERATION_STEP is the number of blocks that a time interval is split into. A bigger value means bigger blocks, which is faster but heavier on the database.

$SMALL_OPERATION_STEP is the number of rows that are processed in a single query. A smaller value means lighter queries.

Was this article helpful?
Yes No

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support

Recent Discussions

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .