eva2000
Well-known member
SweetThey were moved to centminmod yesterday, and last night with over 900 online, the server load was 0.2 on a 4GB/2CPU droplet.
SweetThey were moved to centminmod yesterday, and last night with over 900 online, the server load was 0.2 on a 4GB/2CPU droplet.
Glad to hear it's working. Did anybody actually check to see what the problem was, just out of curiosity?
Why have all that memory doing nothing? Optimize your InnoDB settings to use 80% of your RAM and use query caching.
I use DO with block storage for all images and attachments and don't have any issues but I don't have nearly that many concurrent users. I do use Litespeed as well, which is a very fast alternative to Apache, especially for php setups.
Yep you are right, query cache isn't good for high concurrent connections. Has been great on my little site though, didn't know it was being deprecated though, I'll have to research that, thanks. Memory pool would be great though, maybe not such a high setting. It seemed he had moved to high RAM but wasn't taking advantage of any of it.You shouldn't have InnoDB using that much memory on a system with other services such as Apache/Nginx/PHP/Litespeed when expecting many processes. MySQL should only be given the bulk of RAM on a system with very large amounts of RAM, when it's a dedicated MySQL Server, or when MySQL is the primary process running with few other processes such as PHP.
Additionally, turn off the query cache. Do not turn it on, it will increase load during high concurrent usage. The query cache is single threaded and will block other queries while it's being searched. It was meant for performance back in the days when systems didn't have many CPU cores available. It's being deprecated and removed from MySQL. I believe it already has been in MariaDB 10.3+, not sure about MySQL as I don't follow them as closely.
You shouldn't have InnoDB using that much memory on a system with other services such as Apache/Nginx/PHP/Litespeed when expecting many processes. MySQL should only be given the bulk of RAM on a system with very large amounts of RAM, when it's a dedicated MySQL Server, or when MySQL is the primary process running with few other processes such as PHP.
Additionally, turn off the query cache. Do not turn it on, it will increase load during high concurrent usage. The query cache is single threaded and will block other queries while it's being searched. It was meant for performance back in the days when systems didn't have many CPU cores available. It's being deprecated and removed from MySQL. I believe it already has been in MariaDB 10.3+, not sure about MySQL as I don't follow them as closely.
Yep you are right, query cache isn't good for high concurrent connections. Has been great on my little site though, didn't know it was being deprecated though, I'll have to research that, thanks. Memory pool would be great though, maybe not such a high setting. It seemed he had moved to high RAM but wasn't taking advantage of any of it.
########################
# Query Cache Settings #
########################
## Turn it off 270811 ##
########################
query_cache_size = 0
query_cache_type = off
############################
# End Query Cache Settings #
############################
For one of my applications that only updates data overnight, has very low concurrent users with some large data queries on a dedicated DB server with a lot of memory it's fantastic.The query cache is the devil's spawn. TURN IT OFF. It is only good for read only workloads and definately not high volume constantly changing workloads.
Like I said, for largely read only workloads it is ok. Though the developers have now called time on a single mutex design in a multithreaded world. Good riddance.For one of my applications that only updates data overnight, has very low concurrent users with some large data queries on a dedicated DB server with a lot of memory it's fantastic.
Is that normal? Isn't that crazy low for that many concurrent users? Do you mean 900 online in a day?They were moved to centminmod yesterday, and last night with over 900 online, the server load was 0.2 on a 4GB/2CPU droplet.
What's up with all the replying to posts that are years old, that everyone's long since moved on from?Is that normal? Isn't that crazy low for that many concurrent users? Do you mean 900 online in a day?
Whoops sorry.What's up with all the replying to posts that are years old, that everyone's long since moved on from?
We use essential cookies to make this site work, and optional cookies to enhance your experience.