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

updating database very long

Scheduled Pinned Locked Moved Solved
FOG Problems
2
9
874
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.
  • L
    lebrun78
    last edited by Mar 29, 2019, 8:31 AM

    Hello,
    Our fog server is working very well for several years.
    Its configuration has not changed for 1 year.
    But for 2 mounth, when deploying image, the sequence “updating database” is very long, about 2 minutes.
    Everythings else seems to be working nice.

    Arnaud

    Fog Version: Fog 1.5.10
    Server OS: AlmaLinux release 8.8

    1 Reply Last reply Reply Quote 0
    • S
      Sebastian Roth Moderator
      last edited by Mar 29, 2019, 10:06 AM

      @lebrun78 Does it fail or succeed on “updating database”?

      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
      • L
        lebrun78
        last edited by lebrun78 Mar 29, 2019, 4:08 AM Mar 29, 2019, 10:07 AM

        The task is finished, so I suppose the database update is successful.

        Fog Version: Fog 1.5.10
        Server OS: AlmaLinux release 8.8

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Mar 29, 2019, 10:43 AM

          @lebrun78 I suppose it’s got to do with your database having a lot of entries collected over the years. But it’s just a wild guess. Are you familiar with slow request logging in mysql? That’s probably a good starting point to figure out why the update takes long.

          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
          • L
            lebrun78
            last edited by Mar 29, 2019, 11:18 AM

            Precisely, it is following a purge of the deployment reports that the problem appeared.
            How could I evaluate access time off a base log request ?

            Fog Version: Fog 1.5.10
            Server OS: AlmaLinux release 8.8

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Mar 31, 2019, 4:11 PM

              @lebrun78 Sorry for my late reply, have been away for a bit. I am not exactly sure I get what you are saying here.

              See here on how to enable slow query logging and see if you can find out if it’s the database itself taking so long at “Updating databse” stage: https://www.a2hosting.com/kb/developer-corner/mysql/enabling-the-slow-query-log-in-mysql

              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

              L 1 Reply Last reply Apr 4, 2019, 9:52 AM Reply Quote 0
              • L
                lebrun78 @Sebastian Roth
                last edited by Apr 4, 2019, 9:52 AM

                @Sebastian-Roth
                Thank you,
                I tried the procedure you proposed but , with a log for request over 2 seconds, I don’t obtain anything in my /var/lib/mysql/fogus-slow.log .

                Fog Version: Fog 1.5.10
                Server OS: AlmaLinux release 8.8

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Apr 4, 2019, 10:39 AM

                  @lebrun78 said in updating database very long:

                  with a log for request over 2 seconds,

                  Do you really mean two seconds? You probably need to look into this for longer.

                  What did you set long_query_time to? see here

                  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
                  • L
                    lebrun78
                    last edited by Apr 5, 2019, 7:08 AM

                    I have reboot the server yesterday,
                    Now updating database is very fast.
                    And I receive mails for task results…

                    I think the problem appeared when I set “FOG_EMAIL_ACTION”.

                    Thanks for your answers

                    Fog Version: Fog 1.5.10
                    Server OS: AlmaLinux release 8.8

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

                    154

                    Online

                    12.0k

                    Users

                    17.3k

                    Topics

                    155.2k

                    Posts
                    Copyright © 2012-2024 FOG Project