web analytics

Updates

Written By: - Date published: 10:18 pm, December 30th, 2009 - 7 comments
Categories: admin - Tags:

sysop

Haven’t had as much time as I’d like for updates so far – there are some who have been insisting that I be social over the break! There is also a vast oversupply of wine in cupboard, beer in the fridge, and diet forthcoming in the new year where beer is forbidden (red wine is permissible, so I’ll have to console myself with that).

However there have been a number of efficiency updates put into place.

  • The DNS entries have been shifted to a wider range (2 to 5). This caused some outages as various ISPs didn’t update fast enough. I think that I responded to everyone who e-mailed, and since the e-mails have stopped, I guess everyone is now seeing the site.
  • The search engine is now running on sphinx search. This should give a better search engine and more importantly vastly reduce the loading that the previous search engine was causing on the SQL engine. It takes a lot of grunt to index into the number of posts and comments on the site. I’m still tinkering with the parameters, but try it out and let me know what you think. [update: updates search index every 5 minutes at present. ]
  • The restriction of comment entry on to older posts has been shifted to a new system. The calculation of when a post should have its comments turned off was causing some serious SQL usage. This was mainly an issue because the  search spiders like google and its relatives were spending a lot of time looking at old posts.

This should make the site faster and require a lot less CPU to run. That is good because it therefore doesn’t need a capacity upgrade. There are a lot of other things that I’ll be tinkering with over the break.

Right now I’ve been testing MiniDLNA to allow me to push the music collection from my Ubuntu server to the Sony Bravia upstairs and then into the old valve amp. Great sound. Now for the videos…..

Talking about wine has made me thirsty, and wanting to watch UB40.

A heartfelt thanks to the people who have been popping money into the Donate button on the left. It has been considerably reducing my cost to run the site. I’ll raise a glass to you.

7 comments on “Updates ”

  1. illuminatedtiger 1

    Doing any load balancing on your SQL servers?

    • lprent 1.1

      Nope. The site runs on a single MySQL which uses replication to keep a hot site ready to start. That causes bugger all overhead as the transmitted data is low.

      Normally the major activity is just people or spiders doing a search. But I’ve noticed a steady rise in minutes over the last few months. Looks like an index was removed during wordpress updates causing the single post pages to do way too much work looking if the post should be closed or not. WordPress has added a similar feature to its core, so I switched to that.

  2. felix 2

    RED RED WINE (ORIGINAL) it says on the video title.

    God I hate being a pedant but I don’t think it’s too picky to point out that the original is Neil Diamond’s 1968 recording. http://www.youtube.com/watch?v=Ysxw7EON5xc

    (Just in case there’s any young’uns getting confused)

    Oh and as a bonus here’s Tony Tribe’s 1969 cover version in an upbeat ska styley. http://www.youtube.com/watch?v=tEAPbjcvsww

  3. lprent 3

    damn the search has failed…. Now where is the bug.

Recent Comments

Recent Posts

  • NZ announces a third P-3 deployment in support of UN sanctions
    The Government has deployed a Royal New Zealand Air Force P-3K2 Orion (P-3) maritime patrol aircraft to support the implementation of United Nations Security Council (UNSC) resolutions imposing sanctions against North Korea, announced Minister of Foreign Affairs Winston Peters and Minister of Defence Ron Mark. “New Zealand has long supported ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Pacific trade and development agreement a reality
    Pacific regional trade and development agreement PACER Plus will enter into force in 60 days now that the required eight countries have ratified it. Trade and Export Growth Minister David Parker welcomed the announcement that the Cook Islands is the eighth nation to ratify this landmark agreement. “The agreement represents ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Securing a pipeline of teachers
    The Government is changing its approach to teacher recruitment as COVID-19 travel restrictions continue, by boosting a range of initiatives to get more Kiwis into teaching. “When we came into Government, we were faced with a teacher supply crisis,” Education Minister Chris Hipkins said. “Over the past three years, we ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Border exceptions for a small number of international students with visas
    The Government has established a new category that will allow 250 international PhD and postgraduate students to enter New Zealand and continue their studies, in the latest set of border exceptions. “The health, safety and wellbeing of people in New Zealand remains the Government’s top priority. Tight border restrictions remain ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • First COVID-19 vaccine purchase agreement signed
    The Government has signed an agreement to purchase 1.5 million COVID-19 vaccines – enough for 750,000 people – from Pfizer and BioNTech, subject to the vaccine successfully completing all clinical trials and passing regulatory approvals in New Zealand, say Research, Science and Innovation Minister Megan Woods and Health Minister Chris Hipkins. ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • International statement – End-to-end encryption and public safety
    We, the undersigned, support strong encryption, which plays a crucial role in protecting personal data, privacy, intellectual property, trade secrets and cyber security.  It also serves a vital purpose in repressive states to protect journalists, human rights defenders and other vulnerable people, as stated in the 2017 resolution of the ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Ministry of Defence Biodefence Assessment released
    The Ministry of Defence has today released a Defence Assessment examining Defence’s role across the spectrum of biological hazards and threats facing New Zealand. Biodefence: Preparing for a New Era of Biological Hazards and Threats looks at how the NZDF supports other agencies’ biodefence activities, and considers the context of ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • New Approaches to Economic Challenges: Confronting Planetary Emergencies: OECD 9 October 2020
    New Approaches to Economic Challenges: Confronting Planetary Emergencies: OECD 9 October 2020 Hon David Parker’s response following Thomas Piketty and Esther Duflo. Good morning, good afternoon, and good evening, wherever in the world you might be. I first acknowledge the excellent thought provoking speeches of Thomas Piketty and Esther ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Kaipara Moana restoration takes next step
    A Memorandum of Understanding has been signed today at Waihāua Marae between the Crown, local iwi and councils to protect, restore and enhance the mauri of Kaipara Moana in Northland. Environment Minister David Parker signed the document on behalf of the Crown along with representatives from Ngā Maunga Whakahī, Ngāti ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • New Zealand and Uruguay unite on reducing livestock production emissions
    Agriculture Minister Damien O’Connor and Uruguayan Minister of Livestock, Agriculture and Fisheries Carlos María Uriarte have welcomed the launch of a three-year project that will underpin sustainable livestock production in Uruguay, Argentina, and Costa Rica.  The project called ‘Innovation for pasture management’ is led by Uruguay’s National Institute of Agricultural ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • 3100 jobs created through marae upgrades
    Hundreds of marae throughout the country will be upgraded through investments from the Provincial Growth Fund’s refocused post COVID-19 funding to create jobs and put money into the pockets of local tradespeople and businesses, Regional Economic Development Minister Shane Jones and Māori Development Minister Nanaia Mahuta have announced. “A total ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Health volunteers recognised in annual awards
    Health Minister Chris Hipkins has announced 9 teams and 14 individuals are the recipients of this year’s Minister of Health Volunteer Awards.  “The health volunteer awards celebrate and recognise the thousands of dedicated health sector volunteers who give many hours of their time to help other New Zealanders,” Mr Hipkins ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Community COVID-19 Fund supports Pacific recovery
    The Minister for Pacific Peoples, Aupito William Sio says a total of 264 groups and individuals have successfully applied for the Pacific Aotearoa Community COVID-19 Recovery Fund, that will support Pacific communities drive their own COVID-19 recovery strategies, initiatives, and actions. “I am keen to see this Fund support Pacific ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Community benefits from Māori apprenticeships
    Up to 50 Māori apprentices in Wellington will receive paid training to build houses for their local communities, thanks to a $2.75 million investment from the Māori Trades and Training Fund, announced Employment Minister Willie Jackson today. “This funding will enable Ngāti Toa Rangatira Incorporated to provide its Ngā Kaimahi ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Training fund supports Māori jobseekers
    Rapidly growing sectors will benefit from a $990,000 Māori Trades and Training Fund investment which will see Wellington jobseekers supported into work, announced Employment Minister Willie Jackson today. “This funding will enable Sapphire Consultants Ltd. to help up to 45 Māori jobseekers into paid training initiatives over two years through ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Ruakura Inland Port development vital infrastructure for Waikato
    The Government is investing $40 million to develop an inland port at Ruakura which will become a freight super-hub and a future business, research and residential development for the Waikato, Urban Development and Transport Minister Phil Twyford, and Māori Development Minister Nanaia Mahuta announced today. The funding has been has ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Appointments made to Defence Expert Review Group
    Defence Minister Ron Mark announced today the establishment of an Expert Review Group to review a number of aspects of the New Zealand Defence Force’s (NZDF) structure, information management and record-keeping processes.  The Expert Review Group’s work arises out of the first recommendation from the Report of the Government’s Inquiry ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • No active community cases of COVID-19
    There are no active community cases of COVID-19 remaining in the country after the last people from the recent outbreak have recovered from the virus, Health Minister Chris Hipkins said today. “This is a big milestone. New Zealanders have once again through their collective actions squashed the virus. The systems ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Clean energy upgrade for more public buildings
    More public buildings will be supported by the Government to upgrade to run on clean energy, the Minister for Climate Change James Shaw announced today. Minister Shaw announced that Lincoln and Auckland universities will receive support through the Clean-Powered Public Service Fund to replace fossil fuel boilers. Southern, Taranaki, and ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Schools back donations scheme for the second year
    More schools have opted in to the donations scheme for 2021, compared to 2020 when the scheme was introduced. “The families of more than 447,000 students will be better off next year, with 94% of eligible schools and kura opting into the scheme,” Education Minister Chris Hipkins said. “This is ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Ruapehu cycle trails gets PGF boost
    The spectacular Mountains to Sea cycle trail in Ruapehu District will receive $4.6 million in funding from the Provincial Growth Fund for two additional trails, Regional Economic Development Minister Shane Jones announced today. “This is an exciting development for the local community, and one that will provide significant economic opportunities ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Update to air border order strengthens crew requirements
    Additional measures coming into effect on Monday will boost our defence against COVID-19 entering New Zealand through the air border, Health Minister Chris Hipkins said today. “As part of our precautionary approach and strategy of constant review, we’re tightening the requirements around international aircrew,” Chris Hipkins said. The COVID-19 Public ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • A true picture of Māori business activity
    A better picture of the contribution Māori businesses make to the economy will be possible with changes to the way information is collected about companies and trading enterprises. Māori Development Minister Nanaia Mahuta and Small Business Minister Stuart Nash have announced a new option for Māori enterprises who are part ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • PGF funding for Taranaki projects
    The South Taranaki museum, a New Plymouth distillery and a Pasifika building firm will benefit from a Government investment totalling more than $1 million, Regional Economic Development Minister Shane Jones says. The $1.05m in grants and loans from the Provincial Growth Fund (PGF) will help the recipients expand and create ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • Fijian Language Week 2020 inspires courage and strength during COVID-19 pandemic
    The Minister for Pacific Peoples, Aupito William Sio says the theme for the 2020 Fijian Language Week reflects the strong belief by Fijians that their language and culture inspires courage and strength that is strongly needed in times of emergencies, or through a significant challenge like the global COVID-19 pandemic ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • Trades training builds on iwi aspirations
    An investment of $2.025 million from the Māori Trades and Training Fund will support Māori to learn new skills while making a positive difference for their communities, announced Employment Minister Willie Jackson today. “K3 Development Limited Partnership will receive $2,025,000 for its Takitimu Tuanui apprenticeship programme, which will support the ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • Conservation Minister plants two millionth tree in Raglan restoration
    A long-term conservation project led by the Whaingaroa Harbour Care group in the western Waikato reaches a significant milestone this week, with the planting of the two millionth tree by the Minister of Conservation Eugenie Sage. “Planting the two millionth tree crowns 25 years of commitment and partnership involving Whaingaroa ...
    BeehiveBy beehive.govt.nz
    3 weeks ago
  • Seniors – our parents and grandparents
    International Older Persons Day is a chance to think about the individual older New Zealanders we know and to confront ageism, Seniors Minister Tracey Martin said today. “What happened around COVID-19 is a reminder that our over-65s are a very large and diverse group of people and we need to ...
    BeehiveBy beehive.govt.nz
    3 weeks ago