The server at ilx.wh3rd.net is taking too long to respond.

Message Bookmarked

Bookmark Removed

I'm getting this quite often lately, is it just me? (usually, refreshing a little later (minute or so) solves the problem. Don't have this with other sites, just ilx)

― StanM (StanM), Thursday, 8 February 2007 11:47 (eighteen years ago)

stop stealing wifi

― the kwisatz bacharach (sanskrit), Thursday, 8 February 2007 15:27 (eighteen years ago)

The count of long-running queries soared this morning. I'll find out what it was later.

― stet (stet), Thursday, 8 February 2007 15:41 (eighteen years ago)

isn't there a way to set up the sql server to kill long running queries automatically?

― Charmmy Kitty's Hermetic Order of the Golden Dawn (ex machina), Thursday, 8 February 2007 16:38 (eighteen years ago)

Yes. It's already done, I think.

One in ten of the queries is doing a tablespace scan. Is the slow query log turned on (I don't think it is)? Adding an index should help (unless it's a small table), but we'd need to work out which one it was.

― KeefW (kmw), Thursday, 8 February 2007 17:55 (eighteen years ago)

Though the above isn't you're problem, unless someone just introduced it...

― KeefW (kmw), Thursday, 8 February 2007 17:56 (eighteen years ago)

Actually, talking about killing long running queries, this was done I think when search was still available, so IIRC it was set at about 30 seconds. It should probably be set at about 5.

― KeefW (kmw), Thursday, 8 February 2007 17:58 (eighteen years ago)

sanskrit: I'm not stealing it, it's the wifi router at work (but this only ever happens with ilx, so I don't think it's the router's fault)

― StanM (StanM), Thursday, 8 February 2007 20:48 (eighteen years ago)

hotlinking external images is bandwdith theft

― the kwisatz bacharach (sanskrit), Thursday, 8 February 2007 23:04 (eighteen years ago)

This thread has been locked by an administrator

You must be logged in to post. Please either login here, or if you are not registered, you may register here.