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

    MySQL/Wordpress issue

    Scheduled Pinned Locked Moved IT Discussion
    mysqlwordpress
    119 Posts 9 Posters 11.8k 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.
    • 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
                                      • 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
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 2 / 6
                                            • First post
                                              Last post