SQL Server not scaling
1
reply
2791 views
Description
I've been having bad 503 errors and SQL server errors. Seems like it might not be able to handle the current traffic load spikes?
Can be used to make Runewords:
I've been having bad 503 errors and SQL server errors. Seems like it might not be able to handle the current traffic load spikes?
I'm aware of capacity issues - it is not possible for me to simulate real traffic like this on my dev environment, so when capacity problems are reached it's usually the first time I see them (in the context of the current codebase and users).
Spent today trawling through and analysing the mysqld slow queries logs and found some rogue queries that were using up a lot of server resources. Have removed these and also enabled (yet another) cacheing layer for SQL queries. Truncated sessions table, purged entire cache, HTTPD restart and also a full rack restart.
Let me know if it feels better for you today BinaryShrub.
Spent today trawling through and analysing the mysqld slow queries logs and found some rogue queries that were using up a lot of server resources. Have removed these and also enabled (yet another) cacheing layer for SQL queries. Truncated sessions table, purged entire cache, HTTPD restart and also a full rack restart.
Let me know if it feels better for you today BinaryShrub.
Similar pages
Advertisment
Hide ads
Greetings stranger!
You don't appear to be logged in...Register an account
Start trading, earning trust, and levelling up. Get avatars, likes, bookmarks and more with an account! :)
Support Diablo2.io
You can donate to the site to help support the future of diablo2.io. Donating hides all ads forever.
Latest discussion
Biggest fail drops
Farming with a Tesladin is so Fun and Chill
[I need Dclone help!] Trusted Dclone Killers
You got really lucky? Then share it with us here =)
Frenzy Barb Merc ?
Found a bug or glitch?
If something looks broken please let me know so I can fix it :)
No matches
BinaryShrub
1