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

    MySQL/Wordpress issue

    IT Discussion
    mysql wordpress
    9
    119
    9.2k
    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.
    • DustinB3403D
      DustinB3403
      last edited by DustinB3403

      Installing netdata may be of use... I'm still trying to figure out where I might use it.

      Others were saying it sends anonymous data back to the developers site... but I don't know if that's true or not. Maybe a flag to disable etc..

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

        Ok yeah that still sounds like mysql just stopped responding and is just sitting there doing nothing. You first error indicates that it is not running.

        Try this: [service mysql status] from the termina. Is mysql running and active?

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

          @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?

          scottalanmillerS 1 Reply Last reply Reply Quote 0
          • DustinB3403D
            DustinB3403
            last edited by

            Running top from the cli would show you the ram usage, high ram users etc.

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

              To check all your memory at once just do this command from the terminal. [free -m ]
              That will show you the current state of your memory.
              Top command is just that. Type [top] in the terminal. Watch it for a while then hit ctrl-z to end the top session

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

                Goign to lunch, be back in a bit.

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

                  @wls-itguy said in MySQL/Wordpress issue:

                  4GB plan through Linode.

                  1GB should be plenty.

                  What's the output of sar and sar -r?

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

                    @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

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

                      Sorry I've been away. Had a morning call then hanging with my dad. I'm here now.

                      1 Reply Last reply Reply Quote 0
                      • 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
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 2 / 6
                                            • First post
                                              Last post