TC Slows Hacker News - Start the Arc can't scale rants.

Re:TC Slows Hacker News - Start the Arc can't scale rants. by anewaccountname on Tuesday March 11, 2008 @12:45PM (#134365)

>For that matter, you can get the same effect with the MySQL prompt and a shared-nothing PHP architecture.

I see how you could, say, drop a user from the users table using this; but how would you fix a login bug like the one under discussion?

[ Parent | on HN ]

Re:TC Slows Hacker News - Start the Arc can't scale rants. by nostrademons on Wednesday March 12, 2008 @01:18PM (#135279)

  EXPLAIN SELECT username FROM users WHERE username = $dc_user

Then look at the output, and either

  CREATE INDEX users_username ON users(username)

Or cache the result, or do something else to fix the performance problem...

If you meant "How do you find out it was in the registration check?", that's what the slow query log and query profilers are for...

[ Parent | on HN ]