Written By:
notices and features - Date published:
6:00 am, October 4th, 2016 - 10 comments
Categories: open mike -
Tags:
The current rise of populism challenges the way we think about people’s relationship to the economy.We seem to be entering an era of populism, in which leadership in a democracy is based on preferences of the population which do not seem entirely rational nor serving their longer interests. ...
The server will be getting hardware changes this evening starting at 10pm NZDT.
The site will be off line for some hours.
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
Everything back and working again I see.
Thanks to The Standard techies are in order!
Well, almost working.
And it looks like an intermittent bug or three. You know – the ones that aren’t there when your looking 😈
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*
The October surprise – an hour long advertorial plugging a fucking book.
Alex Jones: …we got trolled by Julian Assange
Ah, Julian Assange. First “champion of the left” and now nemesis of the left. You just can’t win, membership into his cult anyone?
He’s pathetic. This was worse than Kim dot cons moment of truth.
He’s just lost legions of supporters.
“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/
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.