Bingology - The Blog of Aaron 'BingoBoingo' Rogier

ADD7A9A28F85E5EF1F51904F309BB8D7F3251143
About | Contact | PGP Public Key | Archive
« Censorship Resistance In 2018 - An Introduction
Peso Watch November 2018 »

Collected Lessons About MP-WP After Rebuilding This Blog Again

After rebuilding this blog following a small disaster I allowed to happen a number of lessons about MP-WP have been collected:

The Quality of MP-WP Documentation Has Improved Through Addition

There are now several guides to setting up MP-WP. The most recent addition by billymg offers the clearest instructions for getting MP-WP running on a Rockchip and alleviating certain persistent pains. The esthlos guide remains solid in the general case. Lobbes covers yet more interesting issues to consider.

One Simple MySQL Configuration Tweak Saves Lots Of RAM

By the default configuration MySQL will default to using the InnoDB engine to store everything. This come with substantial RAM usage spent on ACID compliance and caching. In the read often write infrequently environment of blog substrate InnoDB is overkill and on a machine with a hard RAM budget like the RockChip, MyISAM appears to be a safer choice. RAM allocated to MySQL has dropped from 1.3 GB in my last stack to ~100 MB in the present stack.

In my.conf simply add

default-storage-engine = MyISAM

In the

[mysqld]

section of my.conf wherever it happens to live on your system. Probably /etc/mysql though there may be others possibilities.

Substantial MP-WP Funnctionality Needs Apache2

In my last stack I used lighttpd. Pingbacks never got sent. In this stack built on apache2 pingbacks are being sent. Substantial reading would likely be necessary to unveil what other MP-WP functions are dysfunctional on alternate httpd software.

One still further bonus is that Apache2 with mod_php is sitting in less RAM than lighttpd and it's php-fpm instances.

Edit This One File To Get A Civilized Archive Page

To get an archives page that looks like this you can use this line in your archives.php file in the default theme:


		<?php wp_get_archives( array( 'type' => 'postbypost' ) ); ?>

Conclusions

The rebuilding sucks and is a reminder that discounting the need for frequent backups doesn't kill the need. On the plus side, after this rebuild there is a whole lot more breathing room on the RockChip.

This entry was posted on Monday, November 19th, 2018 at 1:55 a.m. and is filed under Computing. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

Click here to cancel reply.

 

It's still a pleasure to read bb prose. Both well researched and well written...

- Mircea Popescu

Recent Posts

  • Dead Internet Theory And Searching For The Sticky
  • Adventures In Video
  • An Exploration In Multi Media Toilets
  • Ritalin Diaries Part 1
  • How "Therapy" Re-Fucked My Head - Short Form
  • Uruguay-SSR And The Hallucinated Seige
  • Introducing "The Montevideo Standard"
  • Qntra: A Plan For Action
  • A Homework Assignment From Diana_Coman: Trawling Ancient PMs Seeking What Worked For Early Qntra And Where I'm At On Scripting A Conversion Engine
  • Outreach Automation: A Call For Bids

Recent Comments

  • Aaron 'BingoBoingo' Rogier on The Theoretical Foundation of Social Engineering Practice
  • Aaron 'BingoBoingo' Rogier on That One Agricultural Product And Uruguay
  • Verisimilitude on How "Therapy" Re-Fucked My Head - Short Form
  • Name on How "Therapy" Re-Fucked My Head - Short Form
  • Aaron 'BingoBoingo' Rogier on How "Therapy" Re-Fucked My Head - Short Form
  • Aaron 'BingoBoingo' Rogier on How "Therapy" Re-Fucked My Head - Short Form
  • Thimbronion on How "Therapy" Re-Fucked My Head - Short Form

Feeds

  • Posts RSS
  • Comments RSS


Tip Jar: 15eVXAW7k8uKc5moDFUSc9Y3jmHFAenNXo