#dev | Logs for 2017-03-07
« return
[00:19:27] <Fnord666> TheMightyBuzzard or paulej72 - got a question for you about unix/linux log files
[00:20:54] <Fnord666> If one of you has a moment. It relates to automatically rolling logs like catalina.out from apache tomcat
[00:30:56] <TheMightyBuzzard> logrotate is your friend.
[00:46:27] <paulej72> fucking dumb ass queries
[00:54:34] <Fnord666> paulej72 - mine?
[00:56:08] <Fnord666> just want to be clear.
[01:00:36] * chromas invents syslogSQL
[01:02:04] <paulej72> TheMightyBuzzard: are you available?
[01:07:09] <Fnord666> Thanks TheMightyBuzzard
[01:24:22] <paulej72> yay, fixed some stupid queries
[01:35:10] <TheMightyBuzzard> paulej72, am now. was busy supervising the building of dinner
[01:37:48] <paulej72> Not important, I just was deploying a fix for slow queries on dev and i did not want to setp on your toes
[01:43:14] <Bytram> TheMightyBuzzard: Just read your story asking for list of bugs to refresh your memory, and saw PJ's comment therein -- good to have both of ya back in the saddle, so to speak / write.
[01:43:53] <paulej72> what comment?
[01:44:14] <Bytram> oops, not a comment - was in scroolback -- my bad.
[01:44:50] <paulej72> # Time: 2017-03-07T01:40:54.057813Z
[01:44:50] <paulej72> # User@Host: dev_reader[dev_reader] @ localhost [] Id: 1114534
[01:44:50] <paulej72> # Query_time: 49.069576 Lock_time: 0.000386 Rows_sent: 29091 Rows_examined: 60190
[01:44:50] <paulej72> SET timestamp=1488850854;
[01:44:50] <paulej72> SELECT c.cid,c.subject,ct.comment,c.points, d.sid, UNIX_TIMESTAMP(d.ts) AS time FROM comments AS c INNER JOIN comment_text AS ct ON c.cid = ct.cid INNER JOIN discussions AS d ON c.sid = d.id;
[01:45:07] <Bytram> Unfortunately, I'm still dragging. Had a long, demanding day today and am pretty well wiped out. Work tomorrow and then have some days off, with an exhausting retreat over the weekend when I will basically be unavailable fri pm thru sunday pm.
[01:45:28] <Bytram> am gonna try for an early bedtime tonight and maybe catch up a bit.
[01:46:15] <paulej72> that is one evil query
[01:46:36] <paulej72> why the fuck would we run that
[01:49:18] <TheMightyBuzzard> dunno. it looks like something to do with pulling comments but that's not the one we use for rendering them for display.
[01:49:28] <paulej72> sphinx that's why
[01:49:35] <TheMightyBuzzard> ahh
[01:50:04] <TheMightyBuzzard> the comment selecting one is nearly as bad
[01:50:04] <paulej72> should rewite that to be some sub queries
[01:50:45] <TheMightyBuzzard> nah. let the db take all of the work it can off perl. it's better at it.
[01:51:24] <paulej72> no, its all sql it just optimied for ndb tables
[01:51:42] <TheMightyBuzzard> ahh
[01:54:06] <paulej72> joins are bad subqeries are good
[01:54:47] <TheMightyBuzzard> i like joins. they make my trousers tighter.
[01:54:57] <Bytram> paulej72: I was wond4ering about that. I've always seemed tomanage justfine with subqueries (years ago) and wondered what the benefit of ane xplicit join might be.
[10:31:18] SoyGuest66465 is now known as cosurgi
[10:31:26] -!- cosurgi has quit [Changing host]
[10:31:26] -!- cosurgi [cosurgi!~cosurgi@Soylent/Staff/Misc/cosurgi] has joined #dev