CloudatCost Connection Slow
-
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.
-
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.
-
Likely it is MySQL processing speed. What is the output of "free -m"?
-
@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 -
Looks like MySQL can't load completely into memory. What do the last few lines of SAR look like?
-
@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"?
-
Yes, just sar.
-
Didn't have data collection enabled. I've gone ahead and enabled it. I'll let you know.
-
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...
-
That's a lot to have loaded into memory when you only have 1GB total, though.
-
@scottalanmiller said:
That's a lot to have loaded into memory when you only have 1GB total, though.
Memory usage seems fine...
-
Memory usage IS fine, but that doesn't mean that MySQL is running totally in memory. You are mixing concepts.
-
@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?
-
@thanksajdotcom said:
Is there a way to force it?
No, it will detect if there is enough memory available and use it if possible.
-
@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...
-
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.
-
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.
-
Of course the extra core won't hurt either. Now Apache and MySQL aren't going to fight for context.
-
@scottalanmiller said:
Of course the extra core won't hurt either. Now Apache and MySQL aren't going to fight for context.
Server is upgraded and I've rebooted.
-
Give it a few minutes and see what "free -m" has to say now.
