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

Feature request for FOG 1.6.x - Change database format from ISAM to INNODB

Scheduled Pinned Locked Moved
Feature Request
2
4
419
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.
  • G
    george1421 Moderator
    last edited by Sep 27, 2020, 8:24 PM

    To allow FOG to process more transactions and to prevent heavy backlogs the FOG database structure should be changed from the ISAM engine to the INNODB engine. The issue is when many fog clients are in one FOG Server ream. The ISAM data engine does table locking on a record update. The INNODB engine uses row locking on an update. With table locking in isam, only one fog client can update a table at a time causing a back log on the SQL server and generating a heavy backlog of client transaction. This backlog causes a high CPU usage condition. This backlog doesn’t become an issue unless you have several hundred computers with the FOG client hitting the same master FOG server.

    ref: https://forums.fogproject.org/topic/14254/high-cpu-usage

    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
    • T
      Tom Elliott
      last edited by Sep 27, 2020, 8:55 PM

      Fog 1.6 already does this

      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

      G 1 Reply Last reply Sep 27, 2020, 8:56 PM Reply Quote 2
      • G
        george1421 Moderator @Tom Elliott
        last edited by Sep 27, 2020, 8:56 PM

        @Tom-Elliott said in Feature request for FOG 1.6.x - Change database format from ISAM to INNODB:

        Fog 1.6 already does this

        Nice!

        So the zero in date issue has been resolved too? They kind of go hand in hand.

        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
        • T
          Tom Elliott
          last edited by Sep 27, 2020, 8:56 PM

          Let me clarify, it turns off the limitation preventing the update to move all tables to innodb.

          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
          1 / 1
          • First post
            1/4
            Last post

          157

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project