News for hackers. Stuff that matters.
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.

Re:Scaling website (mysql) tips? by jacquesm on Wednesday July 28, 2010 @03:49PM (#1555422)
Other nasties to look out for: follow on queries that could have been done at the time of the first one and joins.