Comment on TC Slows Hacker News - Start the Arc can't scale rants.parentComments−anewaccountname18y>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?−nostrademons18y 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...
Comments
>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?
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...