Perl 6 - the future is here, just unevenly distributed

IRC log for #askriba, 2016-10-21

| Channels | #askriba index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
04:04 dboehmer joined #askriba
15:51 ribasushi frew: https://www.traviscistatus.com/
15:51 ribasushi first place to look
15:51 frew ribasushi: thanks
16:04 ribasushi frew: they are kinda like github back in the day, a week doesn't go by without some sort of calamity
16:05 frew lol
16:29 frew btw
16:29 frew it sounds like it's because of a DDoS against Dyn or something
16:29 frew lots of east coast troubles
16:30 ribasushi ah indeed could be that
16:31 frew ribasushi: you might know this, any ideas on how to build a pathologically slow mysql query?  not sleep.  Maybe some weird cartesian thing?
16:34 frew CPU pegged: `SELECT count(*) FROM user a JOIN user b;`
16:36 ribasushi ugh... not off the top of my head...
16:37 ribasushi several JOIN's over a function maybe? i.e. JOIN ... ON LOWER(...) =
16:38 frew well
16:38 frew the above works ;)
16:38 frew took 75 seconds on a smallish (50k) table
16:38 ribasushi cheers!
16:53 Topic for #askriba is now Where random Perl5-related questions get definitive answers. Planned availability: currently on business trips, thus no preset hours: just highlight my name and I'll answer ASAP \o/
17:13 frew ribasushi: you have any idea why mysql (5.6) would have a processlist_time of $large_number for a query who hasn't been running for evenclose to $large_number seconds?
17:13 frew ribasushi: we're talking about like, 97100 being the initial value of that number
17:28 ribasushi frew: iirc this counter is for "state of thread"
17:28 ribasushi it's only remotely correlated to "time of query"
17:29 frew I figured out the problem on our end
17:29 ribasushi frew: yeah, manual suggests it's something completely different
17:29 frew our extra metadata is in that comment
17:29 frew at the end of the query
17:29 frew which is super long
17:29 frew and gets truncated
17:29 frew moving the comment to SELECT -- ... \n ...
17:29 frew and I think we'll be alright.
17:31 ribasushi heh, cheers ;)
17:31 ribasushi dinner &
18:13 vanstyn oh cool, half the internet is down
18:13 * vanstyn didn't expect to arrive at that when he bagan to troubleshoot DNS on his workstation

| Channels | #askriba index | Today | | Search | Google Search | Plain-Text | summary