Monday, 2019-08-26

*** jamesmcarthur has joined #storyboard00:17
*** jamesmcarthur has quit IRC01:33
*** jamesmcarthur has joined #storyboard02:14
*** jamesmcarthur has quit IRC02:37
*** jamesmcarthur has joined #storyboard03:04
*** jamesmcarthur has quit IRC03:33
*** udesale has joined #storyboard04:05
*** jtomasek has joined #storyboard07:07
*** udesale has quit IRC11:04
*** jamesmcarthur has joined #storyboard12:47
*** jamesmcarthur has quit IRC13:44
*** jamesmcarthur has joined #storyboard13:47
*** jamesmcarthur has quit IRC13:52
*** jamesmcarthur has joined #storyboard14:21
*** jamesmcarthur has quit IRC14:28
*** zigo has joined #storyboard14:34
*** jamesmcarthur has joined #storyboard15:18
*** jamesmcarthur has quit IRC15:22
*** jamesmcarthur has joined #storyboard15:22
fungiso the good news is after tweaking the long_query_time value i'm seeing entries in the mysql slow log16:24
fungithe bad news (which maybe is also good news?), is that i had to turn it waaay down to start seeing any hits16:25
fungithere was a 20s query logged yesterday, and today once activity picked up i have (so far) 6 hits where a query took barely longer than 2s to return16:26
fungiso either the server is performing much faster than it used to, or the recent-ish query improvements have made a sizeable impact16:27
fungiright now i've got it logging any query which takes at least 1 second to complete16:28
fungibecause i have a feeling many of the delays are related to making multiple moderately-sluggish queries rather than one really long query, so speeding these up further could still help a bunch16:29
*** jamesmcarthur has quit IRC16:40
*** jamesmcarthur has joined #storyboard17:04
*** jamesmcarthur has quit IRC17:29
*** jamesmcarthur has joined #storyboard17:49
*** jamesmcarthur has quit IRC17:58
*** jamesmcarthur has joined #storyboard18:12
*** jamesmcarthur has quit IRC19:53
*** tonyb has quit IRC21:39

Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!