Open Mike 04/10/2016

10 comments on “Open Mike 04/10/2016 ”

• Comments are now closed

1. Sacha 1

   4 October 2016 at 7:19 am

   What is really stopping DHBs rostering junior doctors shorter hours in a row?
   http://www.radionz.co.nz/news/national/314784/junior-doctors-to-strike-over-long-hours
2. TheExtremist 2

   4 October 2016 at 9:38 pm

   Everything back and working again I see.

   Thanks to The Standard techies are in order!
   • Draco T Bastard 2.1

     4 October 2016 at 11:36 pm

     Well, almost working.

     And it looks like an intermittent bug or three. You know – the ones that aren’t there when your looking 😈
   • lprent 2.2

     5 October 2016 at 12:40 am

     Mostly fixed now. This was a irritating double bug.

     The first one was that the site slowed down a lot. The cause was obvious in the database. There was a SQL query that was going off into temp tables and those temp tables were spooling to disk. In other words it was getting too much data. (more on that later).

     While looking at that, amongst other things, I rebooted the server… Bad mistake because I found bug two.

     Something (unknown) had corrupted the UEFI on the basic boot disk. And

     a) It didn’t want to repair itself regardless which tools I used on it (made me long for a good old MBF)..

     b) I’d never backed that up – whatever it was.

     So I went to work late, and later in the day stopped by PBTech to pick up some other SSD drives. This evening I created a new boot disk, cloned the partitions, mirrored the drive and started it up again. And set aside the old two boot RAID disks to look at later to see how I’d fix this in the future.

     Then I got back to the original speed problem. This turned out to be the wordpress API query for the recent comments. Essentially it created a join between all million odd comments and the 20k posts on the site. Apparently this was now large enough that the query no longer fitted in memory and was spilling to temp tables on disk before being LIMITed to the 150 comments required.

     I added a 1 day limit to the where clause (I figure that would be few days where we don’t have 150 comments in the previous 24 hours), and now we have a nice fast comment collector, because I also made it cache the result for 30 seconds.

     I’d point out that this bug was in the wordpress code. It is now

     
$dq = array(
'column' => 'comment_date_gmt',
'inclusive' => true,
);
$dq['after'] = gmdate("Y-m-d H:i:s", time() - (1 * 24 * 60 * 60));
$comments = get_comments( apply_filters( 'widget_comments_args',
array( 'number' => $number,
'status' => 'approve',
'post_status' => 'publish',
'date_query' => $dq ) ) );

     *sigh*
3. joe90 3

   4 October 2016 at 10:22 pm

   The October surprise – an hour long advertorial plugging a fucking book.
   • joe90 3.1

     4 October 2016 at 10:33 pm

     Alex Jones: …we got trolled by Julian Assange
4. Tory 4

   5 October 2016 at 1:52 am

   Ah, Julian Assange. First “champion of the left” and now nemesis of the left. You just can’t win, membership into his cult anyone?
5. James 5

   5 October 2016 at 7:21 am

   He’s pathetic. This was worse than Kim dot cons moment of truth.

   He’s just lost legions of supporters.
   • alwyn 5.1

     5 October 2016 at 1:49 pm

     “He’s just lost legions of supporters.”
     That sounds very appropriate. The Lost Legion was one of the very worst films ever made, or at least that is what I have been told. Have a look at this review (bottom of the link) and see whether it describes Assange’s performance.
     http://www.imdb.com/title/tt3597732/
     • Takere 5.1.1

       6 October 2016 at 4:16 pm

       Give the man a break! He’s living in Ecuador (Embassy in London) for 6 years now going stir crazy I guess?
       He’s got the Swede’s after him for, whatever he did, consensual or not or set up?

       Billary Clinton wants him too for making her do a World Tour to apologise to all of the Governments the US has been spying on! Well psst off she is! Haha!

       I’d be happy next year when this government gets thrown out at the election to offer him & Snowden NZ citizenship & a home indefinitely.

• Comments are now closed

• Log in
• Donate
• Contribute post

• Articles RSS