3 ms·
1) Sometimes MySQL is bad at things that databases should be good at it. 2) Moving stuff from your database server to your webserver is actually changing the h
by smackfu 17y ago
1) Sometimes MySQL is bad at things that databases should be good at it.
2) Moving stuff from your database server to your webserver is actually changing the hardware environment it runs on. Especially relevant if your database server isn't keeping up or is RAM constrained or whatever else is different.
- wanderr 17y agoIt's also worth considering that most big sites have more web servers than MySQL servers, and I'm sure Digg is in that boat as well. Doing your sorts on 20 front end nodes instead of 2-4 MySQL servers is obviously going to help improve performance and scaling of your MySQL servers.