ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MySQL/Wordpress issue

    Scheduled Pinned Locked Moved IT Discussion
    mysqlwordpress
    119 Posts 9 Posters 9.5k Views
    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.
    • scottalanmillerS
      scottalanmiller
      last edited by

      Can I get the output of **df -h ** as well?

      WLS-ITGuyW 1 Reply Last reply Reply Quote 0
      • WLS-ITGuyW
        WLS-ITGuy @scottalanmiller
        last edited by

        @scottalanmiller said in MySQL/Wordpress issue:

        @wls-itguy said in MySQL/Wordpress issue:

        @jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

        @DustinB3403 What do you mean by using top?

        The top command. But it isn't a good tool for that. For immediately memory use this instead free -m

        Total 3948 used 343

        scottalanmillerS 1 Reply Last reply Reply Quote 0
        • WLS-ITGuyW
          WLS-ITGuy @scottalanmiller
          last edited by

          @scottalanmiller said in MySQL/Wordpress issue:

          Can I get the output of **df -h ** as well?

          Filesystem Size Used Avail Use% Mounted on
          /dev/root 16G 14G 2.6G 84% /
          devtmpfs 2.0G 0 2.0G 0% /dev
          tmpfs 395M 196K 395M 1% /run
          tmpfs 5.0M 0 5.0M 0% /run/lock
          tmpfs 893M 0 893M 0% /run/shm

          1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @WLS-ITGuy
            last edited by

            @wls-itguy said in MySQL/Wordpress issue:

            @scottalanmiller said in MySQL/Wordpress issue:

            @wls-itguy said in MySQL/Wordpress issue:

            @jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

            @DustinB3403 What do you mean by using top?

            The top command. But it isn't a good tool for that. For immediately memory use this instead free -m

            Total 3948 used 343

            The full output would be best, but that gives us a starting point.

            WLS-ITGuyW 1 Reply Last reply Reply Quote 0
            • WLS-ITGuyW
              WLS-ITGuy @scottalanmiller
              last edited by scottalanmiller

              @scottalanmiller said in MySQL/Wordpress issue:

              @wls-itguy said in MySQL/Wordpress issue:

              @scottalanmiller said in MySQL/Wordpress issue:

              @wls-itguy said in MySQL/Wordpress issue:

              @jmoore It is when I restart the service. and then about 30-90 seconds later it stops again.

              @DustinB3403 What do you mean by using top?

              The top command. But it isn't a good tool for that. For immediately memory use this instead free -m

              Total 3948 used 343

              The full output would be best, but that gives us a starting point.

              root@www:~# free -m
                           total       used       free     shared    buffers     cached
              Mem:          3948        347       3601          0          5         37
              -/+ buffers/cache:        304       3644
              Swap:          511         19        492
              
              1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller
                last edited by

                Yup, that is WAY more than enough memory 🙂

                WLS-ITGuyW 1 Reply Last reply Reply Quote 2
                • WLS-ITGuyW
                  WLS-ITGuy @scottalanmiller
                  last edited by

                  @scottalanmiller said in MySQL/Wordpress issue:

                  Yup, that is WAY more than enough memory 🙂

                  Had way more before we downsized. Went the lowest I could while making sure we had enough space for the site itself.

                  1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller
                    last edited by

                    Okay, so at this point we need logs.

                    WLS-ITGuyW 1 Reply Last reply Reply Quote 1
                    • scottalanmillerS
                      scottalanmiller
                      last edited by

                      And, and those two sar reports.

                      WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                      • WLS-ITGuyW
                        WLS-ITGuy @scottalanmiller
                        last edited by

                        @scottalanmiller said in MySQL/Wordpress issue:

                        And, and those two sar reports.

                        root@www:~# sar
                        Cannot open /var/log/sysstat/sa21: No such file or directory
                        Please check if data collecting is enabled in /etc/default/sysstat

                        root@www:~# sar -r
                        Cannot open /var/log/sysstat/sa21: No such file or directory
                        Please check if data collecting is enabled in /etc/default/sysstat

                        scottalanmillerS 1 Reply Last reply Reply Quote 0
                        • WLS-ITGuyW
                          WLS-ITGuy @scottalanmiller
                          last edited by

                          @scottalanmiller said in MySQL/Wordpress issue:

                          Okay, so at this point we need logs.

                          From what location? /var/ or /etc/ ?

                          scottalanmillerS 1 Reply Last reply Reply Quote 0
                          • scottalanmillerS
                            scottalanmiller @WLS-ITGuy
                            last edited by

                            @wls-itguy said in MySQL/Wordpress issue:

                            @scottalanmiller said in MySQL/Wordpress issue:

                            Okay, so at this point we need logs.

                            From what location? /var/ or /etc/ ?

                            Logs are always in /var

                            WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                            • scottalanmillerS
                              scottalanmiller @WLS-ITGuy
                              last edited by

                              @wls-itguy said in MySQL/Wordpress issue:

                              @scottalanmiller said in MySQL/Wordpress issue:

                              And, and those two sar reports.

                              root@www:~# sar
                              Cannot open /var/log/sysstat/sa21: No such file or directory
                              Please check if data collecting is enabled in /etc/default/sysstat

                              root@www:~# sar -r
                              Cannot open /var/log/sysstat/sa21: No such file or directory
                              Please check if data collecting is enabled in /etc/default/sysstat

                              You need to enable sar collection. It's very important for all investigation.

                              WLS-ITGuyW 2 Replies Last reply Reply Quote 0
                              • WLS-ITGuyW
                                WLS-ITGuy @scottalanmiller
                                last edited by

                                @scottalanmiller said in MySQL/Wordpress issue:

                                @wls-itguy said in MySQL/Wordpress issue:

                                @scottalanmiller said in MySQL/Wordpress issue:

                                Okay, so at this point we need logs.

                                From what location? /var/ or /etc/ ?

                                Logs are always in /var

                                I'm not seeing any logs that are viewable

                                1 Reply Last reply Reply Quote 0
                                • WLS-ITGuyW
                                  WLS-ITGuy @scottalanmiller
                                  last edited by

                                  @scottalanmiller said in MySQL/Wordpress issue:

                                  @wls-itguy said in MySQL/Wordpress issue:

                                  @scottalanmiller said in MySQL/Wordpress issue:

                                  And, and those two sar reports.

                                  root@www:~# sar
                                  Cannot open /var/log/sysstat/sa21: No such file or directory
                                  Please check if data collecting is enabled in /etc/default/sysstat

                                  root@www:~# sar -r
                                  Cannot open /var/log/sysstat/sa21: No such file or directory
                                  Please check if data collecting is enabled in /etc/default/sysstat

                                  You need to enable sar collection. It's very important for all investigation.

                                  enabled now.

                                  1 Reply Last reply Reply Quote 0
                                  • jmooreJ
                                    jmoore
                                    last edited by

                                    Back from lunch. I see Scott is here and he is infinitely more qualified lol. I am betting it is the data base. Did you ever do a status on mysql to see if it was responding?

                                    WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                                    • WLS-ITGuyW
                                      WLS-ITGuy @jmoore
                                      last edited by

                                      @jmoore said in MySQL/Wordpress issue:

                                      Back from lunch. I see Scott is here and he is infinitely more qualified lol. I am betting it is the data base. Did you ever do a status on mysql to see if it was responding?

                                      root@www:~# mysqladmin -u root -p status
                                      Enter password:
                                      mysqladmin: connect to server at 'localhost' failed
                                      error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
                                      Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

                                      Even if I run service mysql restart and then run the status I get the same issue.

                                      WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                                      • WLS-ITGuyW
                                        WLS-ITGuy @WLS-ITGuy
                                        last edited by

                                        @wls-itguy said in MySQL/Wordpress issue:

                                        @jmoore said in MySQL/Wordpress issue:

                                        Back from lunch. I see Scott is here and he is infinitely more qualified lol. I am betting it is the data base. Did you ever do a status on mysql to see if it was responding?

                                        root@www:~# mysqladmin -u root -p status
                                        Enter password:
                                        mysqladmin: connect to server at 'localhost' failed
                                        error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
                                        Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

                                        Even if I run service mysql restart and then run the status I get the same issue.

                                        Except this time I did get a result:

                                        root@www:~# mysqladmin -u root -p status
                                        Enter password:
                                        Uptime: 16 Threads: 47 Questions: 2886 Slow queries: 0 Opens: 103 Flush tables: 1 Open tables: 95 Queries per second avg: 180.375

                                        1 Reply Last reply Reply Quote 0
                                        • WLS-ITGuyW
                                          WLS-ITGuy
                                          last edited by

                                          And now it is down again 😞

                                          1 Reply Last reply Reply Quote 0
                                          • WLS-ITGuyW
                                            WLS-ITGuy @scottalanmiller
                                            last edited by

                                            @scottalanmiller said in MySQL/Wordpress issue:

                                            @wls-itguy said in MySQL/Wordpress issue:

                                            @scottalanmiller said in MySQL/Wordpress issue:

                                            And, and those two sar reports.

                                            root@www:~# sar
                                            Cannot open /var/log/sysstat/sa21: No such file or directory
                                            Please check if data collecting is enabled in /etc/default/sysstat

                                            root@www:~# sar -r
                                            Cannot open /var/log/sysstat/sa21: No such file or directory
                                            Please check if data collecting is enabled in /etc/default/sysstat

                                            You need to enable sar collection. It's very important for all investigation.

                                            @wls-itguy said in MySQL/Wordpress issue:

                                            @scottalanmiller said in MySQL/Wordpress issue:

                                            @wls-itguy said in MySQL/Wordpress issue:

                                            @scottalanmiller said in MySQL/Wordpress issue:

                                            And, and those two sar reports.

                                            root@www:~# sar
                                            Cannot open /var/log/sysstat/sa21: No such file or directory
                                            Please check if data collecting is enabled in /etc/default/sysstat

                                            root@www:~# sar -r
                                            Cannot open /var/log/sysstat/sa21: No such file or directory
                                            Please check if data collecting is enabled in /etc/default/sysstat

                                            You need to enable sar collection. It's very important for all investigation.

                                            enabled now.

                                            Still cannot run the SAR or SAR -R requests. Even after an apache restart and a reboot of the server

                                            DustinB3403D scottalanmillerS 2 Replies Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 2 / 6
                                            • First post
                                              Last post