• 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

      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

        @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

          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

            @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

              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

                @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 Reply Quote 0
                • L
                  lebrun78 @Sebastian Roth
                  last edited by

                  @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

                    @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

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

                      143

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project