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

    CloudatCost Connection Slow

    IT Discussion
    cloudatcost
    8
    54
    7.3k
    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.
    • thanksajdotcomT
      thanksajdotcom
      last edited by scottalanmiller

      I'm having an issue with my primary web server, which runs on CloudatCost. It's a Ubuntu 14.04 server and is running Wordpress on MySQL. The issue is that the pages take FOREVER to load. I've checked the IOPS and they don't appear to be the issue. The VM is running on an SSD, so access times shouldn't be an issue. I use a caching plugin to try and help deliver the content more quickly but I'm not sure if it's helping. Pages seem to take close to 10 seconds or more to load. Is this just me or is this a common issue for everyone? The site runs on a Dev2. It's supposed to have a 100Mb connection. Not sure why it's loading so slowly...the connection is actually much faster when I run it on my home server on that FiOS connection. Any ideas?

      Thanks,
      A.J.

      1 Reply Last reply Reply Quote 0
      • thanksajdotcomT
        thanksajdotcom
        last edited by

        I should also add that I often experience significant delay when connecting with SSH sessions to my Linux boxes. When I RDP to my DC, I don't have any of these issues.

        1 Reply Last reply Reply Quote 0
        • DanpD
          Danp
          last edited by

          Just tried and load times seem fine to me. Maybe the issue isn't with C@C but some route between you and them.

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

            That it runs on SSD doesn't help much. IOPS issues are the same regardless of what you run on. If you have a Wait State or choke on IOPS it doesn't matter what is provided them.

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

              100Mb (not MB) connection speed won't matter. It is unlikely that you are getting above 5Mb/s as web pages just aren't big enough to speed up much more than that.

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

                Likely it is MySQL processing speed. What is the output of "free -m"?

                thanksajdotcomT 1 Reply Last reply Reply Quote 0
                • thanksajdotcomT
                  thanksajdotcom @scottalanmiller
                  last edited by

                  @scottalanmiller said:

                  Likely it is MySQL processing speed. What is the output of "free -m"?

                  							total       used       free     shared    buffers     cached
                  Mem:           				 993        929         64         45          3         57
                  -/+ buffers/cache:       	 868        125
                  Swap:          				 953        171        782
                  
                  1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller
                    last edited by

                    Looks like MySQL can't load completely into memory. What do the last few lines of SAR look like?

                    thanksajdotcomT 1 Reply Last reply Reply Quote 0
                    • thanksajdotcomT
                      thanksajdotcom @scottalanmiller
                      last edited by

                      @scottalanmiller said:

                      Looks like MySQL can't load completely into memory. What do the last few lines of SAR look like?

                      I have that installed but what specific command do you want me to run? Just "sar"?

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

                        Yes, just sar.

                        1 Reply Last reply Reply Quote 0
                        • thanksajdotcomT
                          thanksajdotcom
                          last edited by

                          Didn't have data collection enabled. I've gone ahead and enabled it. I'll let you know.

                          1 Reply Last reply Reply Quote 0
                          • thanksajdotcomT
                            thanksajdotcom
                            last edited by

                            Also, I wouldn't think my MySQL databases were that big. When I do the dump of my biggest database, it's barely over 200MB...

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

                              That's a lot to have loaded into memory when you only have 1GB total, though.

                              thanksajdotcomT 1 Reply Last reply Reply Quote 0
                              • thanksajdotcomT
                                thanksajdotcom @scottalanmiller
                                last edited by

                                @scottalanmiller said:

                                That's a lot to have loaded into memory when you only have 1GB total, though.

                                Memory usage seems fine...
                                upload-5ad06380-c27c-4ba0-8bea-f5354b56ad4d

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

                                  Memory usage IS fine, but that doesn't mean that MySQL is running totally in memory. You are mixing concepts.

                                  thanksajdotcomT 1 Reply Last reply Reply Quote 1
                                  • thanksajdotcomT
                                    thanksajdotcom @scottalanmiller
                                    last edited by

                                    @scottalanmiller said:

                                    Memory usage IS fine, but that doesn't mean that MySQL is running totally in memory. You are mixing concepts.

                                    Is there a way to force it?

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

                                      @thanksajdotcom said:

                                      Is there a way to force it?

                                      No, it will detect if there is enough memory available and use it if possible.

                                      thanksajdotcomT 1 Reply Last reply Reply Quote 0
                                      • thanksajdotcomT
                                        thanksajdotcom @scottalanmiller
                                        last edited by

                                        @scottalanmiller said:

                                        @thanksajdotcom said:

                                        Is there a way to force it?

                                        No, it will detect if there is enough memory available and use it if possible.

                                        Hmmm....might have to upgrade to a Dev3...

                                        1 Reply Last reply Reply Quote 0
                                        • thanksajdotcomT
                                          thanksajdotcom
                                          last edited by

                                          The coupon here (http://mangolassi.it/topic/4295/cloudatcost-50-off-upgrades-limited-qty/3) still works. Upgrading to a Dev3 for my web server from a Dev2.

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

                                            My guess is that you will see a bit of an increase. You had stuff going out to swap to keep your cache fresh. It's enough but far from fully tuned.

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 3 / 3
                                            • First post
                                              Last post