*** jamesmcarthur has joined #storyboard | 00:17 | |
*** jamesmcarthur has quit IRC | 01:33 | |
*** jamesmcarthur has joined #storyboard | 02:14 | |
*** jamesmcarthur has quit IRC | 02:37 | |
*** jamesmcarthur has joined #storyboard | 03:04 | |
*** jamesmcarthur has quit IRC | 03:33 | |
*** udesale has joined #storyboard | 04:05 | |
*** jtomasek has joined #storyboard | 07:07 | |
*** udesale has quit IRC | 11:04 | |
*** jamesmcarthur has joined #storyboard | 12:47 | |
*** jamesmcarthur has quit IRC | 13:44 | |
*** jamesmcarthur has joined #storyboard | 13:47 | |
*** jamesmcarthur has quit IRC | 13:52 | |
*** jamesmcarthur has joined #storyboard | 14:21 | |
*** jamesmcarthur has quit IRC | 14:28 | |
*** zigo has joined #storyboard | 14:34 | |
*** jamesmcarthur has joined #storyboard | 15:18 | |
*** jamesmcarthur has quit IRC | 15:22 | |
*** jamesmcarthur has joined #storyboard | 15:22 | |
fungi | so the good news is after tweaking the long_query_time value i'm seeing entries in the mysql slow log | 16:24 |
---|---|---|
fungi | the bad news (which maybe is also good news?), is that i had to turn it waaay down to start seeing any hits | 16:25 |
fungi | there 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 return | 16:26 |
fungi | so either the server is performing much faster than it used to, or the recent-ish query improvements have made a sizeable impact | 16:27 |
fungi | right now i've got it logging any query which takes at least 1 second to complete | 16:28 |
fungi | because 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 bunch | 16:29 |
*** jamesmcarthur has quit IRC | 16:40 | |
*** jamesmcarthur has joined #storyboard | 17:04 | |
*** jamesmcarthur has quit IRC | 17:29 | |
*** jamesmcarthur has joined #storyboard | 17:49 | |
*** jamesmcarthur has quit IRC | 17:58 | |
*** jamesmcarthur has joined #storyboard | 18:12 | |
*** jamesmcarthur has quit IRC | 19:53 | |
*** tonyb has quit IRC | 21:39 |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!