FOG Project

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

    .sql from Configuration Save is bloated

    FOG Problems
    2
    5
    1003
    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.
    • sudburr
      sudburr last edited by sudburr

      Build 7180 on CentOS7.1.1503

      Performing my monthly backups I have encountered one server that upon selecting Configuration Save from Fog Settings, has output a 927 MiB .sql .

      Ordinarily I would expect a 4-9 MiB file.

      What can I do to fix/trim this sucker down to size?

      Host and Image export file sizes are normal.

      [ Standing in between extinction in the cold and explosive radiating growth ]

      1 Reply Last reply Reply Quote 0
      • sudburr
        sudburr last edited by

        You betcha. thx again!

        [ Standing in between extinction in the cold and explosive radiating growth ]

        1 Reply Last reply Reply Quote 1
        • Tom Elliott
          Tom Elliott @sudburr last edited by

          @sudburr Future reference, without having to recreate the table, just run:

          truncate table `fog`.`history`;

          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.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 1
          • sudburr
            sudburr last edited by sudburr

            Thanks Tom! It was indeed the history table. I did the following for happy, happy, joy, joy.

            mysql -u root -p
            use fog;
            DROP TABLE IF EXISTS `history`;
            CREATE TABLE `history` (
              `hID` int(11) NOT NULL AUTO_INCREMENT,
              `hText` longtext NOT NULL,
              `hUser` varchar(200) NOT NULL,
              `hTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
              `hIP` varchar(50) NOT NULL,
              PRIMARY KEY (`hID`)
            ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
            
            

            [ Standing in between extinction in the cold and explosive radiating growth ]

            Tom Elliott 1 Reply Last reply Reply Quote 0
            • Tom Elliott
              Tom Elliott last edited by

              For a small period of time I had been recording EVERYTHING to the db in the history table. This mean EVERYTHING. All items that got updated (of which hosts update every time they checkin), login’s, imaging tasks, etc… This was a means for me trying to get things a bit more debugging friendly but would cause the “bloating” as you describe. To fix, simple truncate the history table, then see if backing up would be smaller. (It should be much smaller.)

              Sorry for trying to do something in an attempt to make it more debugging friendly and causing such a weird problem. I’m not sorry for trying to do these things directly but rather the “effects” of what it would 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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

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

              233
              Online

              10.2k
              Users

              16.3k
              Topics

              149.9k
              Posts

              Copyright © 2012-2020 FOG Project