• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Database Maintenance

    Scheduled Pinned Locked Moved
    Feature Request
    4
    5
    1.7k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      ablohowiak
      last edited by

      I don’t need fog to keep user tracking for eternity. It would be nice to be able to set a time frame of data to keep.

      Another thing to keep things tidy would be to purge hosts that haven’t communicated in X amount of time.

      Then maybe some schedule to run “optimize table” to get the benefits of those row removals.

      Thanks for all the hard work!

      1 Reply Last reply Reply Quote 0
      • J
        Joe Schmitt Senior Developer
        last edited by Joe Schmitt

        @ablohowiak for both your cases, it would work best (and probably quickest) if you had/made a simple CRON script that runs the appropriate SQL commands. Not every user would want/need these features, and in general we take the approach of not making assumptions of what data users need to keep.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        1 Reply Last reply Reply Quote 3
        • george1421G
          george1421 Moderator
          last edited by

          While the goal is different here, the concept is similar to this tutorial.

          https://forums.fogproject.org/topic/9449/dynamic-fog-replicator-transfer-rates

          You will need to create a new mysql table to accept these records and your own way to report on them. But it is for sure, possible to do.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

          1 Reply Last reply Reply Quote 0
          • A
            ablohowiak
            last edited by

            Joe, that’s fine. I was just surprised at the size of my userTracking table.

            What tables would be useful to locate old hosts?

            Wayne WorkmanW 1 Reply Last reply Reply Quote 0
            • Wayne WorkmanW
              Wayne Workman @ablohowiak
              last edited by Wayne Workman

              @ablohowiak said in Database Maintenance:

              What tables would be useful to locate old hosts?

              hosts and hostMAC

              I can help with the SQL if you have questions. Whatever you come up with, we can probably add it to our existing list of maintenance commands with a little description for each one:
              https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post

              225

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project