CloudatCost Connection Slow
-
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.
-
Yeah, still waiting for the extra RAM to kick in. This is what I had about 90 seconds ago.
root@thanksaj-server-cac:~# free -m total used free shared buffers cached Mem: 993 375 618 52 17 178 -/+ buffers/cache: 178 815 Swap: 953 0 953 root@thanksaj-server-cac:~# grep MemTotal /proc/meminfo MemTotal: 1017732 kB -
It doesn't "kick in." Not sure what you are picturing happening, but that is a Dev2 instance that you are looking at. Memory does not magically increase in a running system.
