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

    MYSQL connections max out and slow down fog server

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    21
    6.8k
    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.
    • johnomazJ
      johnomaz
      last edited by

      I tried the persistent DB option earlier i found on a different thread and that didn’t work. Lokoing at the php session purging fix, this is what my line looks like:

      09,39 * * * * root [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php5/sessionclean /var/lib/php5 $(/usr/lib/php5/maxlifetime)

      It doesn’t look like the fog wiki page. Should I still change it to match?

      1 Reply Last reply Reply Quote 0
      • Joseph HalesJ
        Joseph Hales Testers
        last edited by

        Only if your running ubuntu its an os specific fix I believe.

        RTFM

        1 Reply Last reply Reply Quote 0
        • johnomazJ
          johnomaz
          last edited by

          I am on Ubuntu but i figured the before line would match. it doesn’t.

          1 Reply Last reply Reply Quote 0
          • Joseph HalesJ
            Joseph Hales Testers
            last edited by

            Its the same on my copy of ubuntu 12.04 64bit server what version are you running?

            RTFM

            1 Reply Last reply Reply Quote 0
            • johnomazJ
              johnomaz
              last edited by

              14.04 64bit (mentioned in OP)

              1 Reply Last reply Reply Quote 0
              • Joseph HalesJ
                Joseph Hales Testers
                last edited by

                Comment it out so you can switch it back but I know its fixed simular behavior on mine. Check the wiki I know there are issues with 14 and that its not currently recomended. [url]http://www.fogproject.org/wiki/index.php/Ubuntu_14.04[/url]

                RTFM

                1 Reply Last reply Reply Quote 0
                • johnomazJ
                  johnomaz
                  last edited by

                  I’ll try it now. I know the TFTP issue exists but after I start the service manually, all seems fine.

                  [[EDIT]]

                  It was running smoother for several minutes but both CPU cores are at 100% again, inbound connections is up to 250 now with outbound at 150 (outbound was always at 1 before). The web gui is back to being unusable.

                  I was thinking of going to CentOS. If this issue is specific to Ubuntu, maybe its time to get rid of Ubuntu.

                  1 Reply Last reply Reply Quote 0
                  • Joseph HalesJ
                    Joseph Hales Testers
                    last edited by

                    Perhaps but I have good luck with 12.04 lts and its easier for me to find cut and paste solutions equal to my noob skills.

                    RTFM

                    1 Reply Last reply Reply Quote 0
                    • johnomazJ
                      johnomaz
                      last edited by

                      Ok, I got CentOS6.5 running, got FOG installed and imported my fog.sql database. The issue returns. 100% CPU usage and become nearly unusable. I have to ask the question I really dont’ want to ask. Is it my imported fog.sql database. I’ve used the same database for years and has nearly a 1000 host entries, over 200 printers configured for installation, over 100 snapin entries applied to countless computers. I really REALLY don’t want to have to recreate my database, that would be a massive amount of work but could my database be the cause? If I stop the mysql service, the computer goes back to normal.

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

                        I don’t think it’s the imported database.

                        I’m going on a limb and when you did the install, did you upgrade the system or fresh install? When we first upgraded we saw a similar issue, and all I had to do to correct the issue was allow for more hosts to connect. I think the default was 100, and we set ours to 250.

                        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
                        • johnomazJ
                          johnomaz
                          last edited by

                          This is a fresh CentOS install and a fresh fog 1.2 install. Nothing upgraded. On Ubuntu, it was a fresh install of both as well. I’ve made sure too that all passwords are the same as well.

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

                            Check your inbox, I’d rather talk over Google Hangouts or GTALK if you’re able to and sent a message to you there containing my account stuff.

                            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
                            • Joseph HalesJ
                              Joseph Hales Testers
                              last edited by

                              Just remember to post back here if you fix it so we can see the solution. 😉

                              RTFM

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

                                We fixed the issue.

                                As the db was imported, the old snapinTasks and snapinJobs tables were still there. THis was causing the hosts to checkin and repeatedly spamming for the data that was not relevant.

                                Running:

                                [code]truncate table snapinJobs;truncate table snapinTasks;[/code] fixed the problem.

                                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
                                • johnomazJ
                                  johnomaz
                                  last edited by

                                  [quote=“Joseph Hales, post: 43691, member: 18131”]Just remember to post back here if you fix it so we can see the solution. ;-)[/quote]

                                  Tom is going to post the results. it did get solved. I can’t really go into the fix as it is way above my level of knowledge but he said eh was going to post here for others to see.

                                  A big thanks to him for the help he provided.

                                  1 Reply Last reply Reply Quote 0
                                  • Joseph HalesJ
                                    Joseph Hales Testers
                                    last edited by

                                    I almost think we should make that truncate part of the upgrade script. Except it screws with the logs doesn’t it?

                                    RTFM

                                    1 Reply Last reply Reply Quote 0
                                    • johnomazJ
                                      johnomaz
                                      last edited by

                                      [quote=“Joseph Hales, post: 43723, member: 18131”]I almost think we should make that truncate part of the upgrade script.[/quote]

                                      Also part of the backup script. I backup my database every 2 weeks.

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

                                        It does screw with the logs. It should only need to be done after import/upgrade from 0.32 and even then, only if you’re having problems I think.

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

                                        215

                                        Online

                                        12.0k

                                        Users

                                        17.3k

                                        Topics

                                        155.2k

                                        Posts
                                        Copyright © 2012-2024 FOG Project