Re:Scaling website (mysql) tips?
by CaanaCast on Wednesday July 28, 2010 @10:16AM
(#1554362)
Peak hours would be 100 queries a second minimum. Static content is served by 2 different servers (1 img, 1 html). I did not know of the slow query log parameters (but will enable it now).
When starting we were pulling too many rows, but we quickly realized that and lowered scripts that display too much content that is not needed, we are also using proper indexes.
When starting we were pulling too many rows, but we quickly realized that and lowered scripts that display too much content that is not needed, we are also using proper indexes.