[Wikipedia-l] Using database queries
brion at pobox.com
Tue Aug 27 04:58:17 UTC 2002
Tim Marklew wrote:
> LDC - could you comment on how potentially dangerous this function is in
> terms of slowing down the site for others? If a query results in a big
> table, this can slow down the server. Is there an upper limit for how
> long a query can take, or the size of a table, before it would time
> out? If so, how big is the limit?
Umm, not that I know of. I believe there's a timeout on PHP scripts, but
I'm not sure if that affects long queries on the database, which run in
a separate process.
On that note; currently the MySQL server is running at 99.5% CPU.
Whatever it's doing, it's slowing the wiki to a trickle; I can't even
get a connection through.
I note in the web server logs a POST request to the SQL-query page at
about 7:26 pm (server time, which is slight slow from PDT); from that
point on most web requests are logged with a size of "-", which means
that something croaked and no bytes were sent.
The IP address on this query looks suspiciously like yours, Tim! Exactly
what query did you run?
-- brion vibber (brion @ pobox.com)
More information about the Wikipedia-l