Open Mike 04/10/2016

Written By: - Date published: 6:00 am, October 4th, 2016 - 10 comments
Categories: open mike - Tags:

openmikeOpen mike is your post.

For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy).

Step up to the mike …

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

  1. Sacha 1

    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

    Everything back and working again I see.

    Thanks to The Standard techies are in order!

    • Draco T Bastard 2.1

      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

      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

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

  4. Tory 4

    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

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

    He’s just lost legions of supporters.

    • alwyn 5.1

      “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

        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.

The server will be getting hardware changes this evening starting at 10pm NZDT.
The site will be off line for some hours.