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

    DB wait_timeout

    Scheduled Pinned Locked Moved
    General
    3
    4
    1.1k
    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.
    • Wayne WorkmanW
      Wayne Workman
      last edited by

      I’ve just learned about this MySQL / MariaDB setting. The wait_timeout.

      I’m not sure if FOG sets this or not, but my FOG server’s wait_timeout is set to 8 hours.

      Can someone running Ubuntu 14.04 or 15.04 check what their wait_timeout is please?

      mysql
      SHOW VARIABLES;
      

      The wait_timeout variable is towards the bottom, it’s in seconds.

      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
      • S
        Sebastian Roth Moderator
        last edited by

        @Wayne-Workman Same here, 8 hours on Debian! Are you concerned about it being that high or what especially made you aware of this setting. My guess is that MySQL connections that don’t get any input for 8 hours straight will be terminated from the server side. All good I reckon!

        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
        • Wayne WorkmanW
          Wayne Workman
          last edited by

          I don’t really know lol. I stumbled across it working on a dhcp service manager for fog. Then I started thinking about how the fog database has a bad habit of crashing on Ubuntu…

          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/

          Raymond BellR 1 Reply Last reply Reply Quote 0
          • Raymond BellR
            Raymond Bell Testers @Wayne Workman
            last edited by

            @Wayne-Workman

            Ubuntu 14.04

            | version_compile_os                                | debian-linux-gnu                                                                                                       |
            | wait_timeout                                      | 28800                                                                                                               
            

            Raymond Bell
            WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

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

            125

            Online

            12.1k

            Users

            17.3k

            Topics

            155.4k

            Posts
            Copyright © 2012-2024 FOG Project