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

    MySQL/Wordpress issue

    Scheduled Pinned Locked Moved IT Discussion
    mysqlwordpress
    119 Posts 9 Posters 9.3k 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

      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
                            • DustinB3403D
                              DustinB3403 @WLS-ITGuy
                              last edited by

                              @wls-itguy Did you try with sudo?

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

                                @dustinb3403 said in MySQL/Wordpress issue:

                                @wls-itguy Did you try with sudo?

                                I'm logged in as root

                                But I tried anyway and it didn't change anything

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

                                  Would a re-install of MySQL help?

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

                                    Ok to me it just sounds like mysql is in a funk. It also appears it is still running. I think you should try to kill the process and then start it back up. Do this from terminal:

                                    ps aux
                                    then look for process ID of mysql
                                    from terminal : kill -9 ID
                                    then from terminal again: service start mysql

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

                                      @wls-itguy said in MySQL/Wordpress issue:

                                      @dustinb3403 said in MySQL/Wordpress issue:

                                      @wls-itguy Did you try with sudo?

                                      I'm logged in as root

                                      But I tried anyway and it didn't change anything

                                      What output are you receiving?

                                      No, don't reinstall MySQL (at least not yet. . . or without backups)

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

                                        @jmoore said in MySQL/Wordpress issue:

                                        Ok to me it just sounds like mysql is in a funk. It also appears it is still running. I think you should try to kill the process and then start it back up. Do this from terminal:

                                        ps aux
                                        then look for process ID of mysql
                                        from terminal : kill -9 ID
                                        then from terminal again: service start mysql

                                        Fails to restart

                                        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:

                                          @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

                                          They are not dependent on Apache. Not web related.

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

                                            Can you post the output of...

                                            tail -100 /var/log/messages
                                            
                                            WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 3 / 6
                                            • First post
                                              Last post