MySQL Innodb Tables Crashing on AWS EC2 Instance? Is Your Disk Full?

code feature banner image

We’ve been asked to troubleshoot Amazon Web Services Elastic Compute Cloud (AWS EC2) instances for a number of reasons. Recently, we took a look at an Amazon EC2 instance which was being used as a MySQL server and the task was to see why several MySQL innodb tables were crashing. The situation had got so …

Read more

Get $150 Free Credit from Cloudways – Another Black Friday Offer!

Cloudways is our top recommended host for WooCommerce. In terms of value-for-money, it doesn’t get better than this. With a full range of hosting options to choose from, there are even great datacentre selections available for regions such as Australia, which historically have been a little underserved. If you’re looking for a way to host …

Read more

How to convert colours to black in images using ImageMagick

If you want to convert PNG (or similar) files containing, for example, icons which are in one colour (say green) to black, then the command below will do this. This can be especially useful for updating logos or icons on the fly in a file system, without breaking stride, over command line (SSH). Note you …

Read more

What To Do If You Get “System Error 1” During AWS Phone Verification

Here’s a little tip for someone who encountered a strange error during AWS telephone verification… Successfully get your account setup pin after receiving an error message. Today, during a routine task we perform regularly – installing an Amazon Web Services (AWS) account on behalf of a client – we received an error message during the …

Read more

Installing PHP SOAP – Need soapclient?

The tutorial below explains how to install Soapclient for PHP in a Linux system which is showing that this is not included. This may, for our clients, show up in your WooCommerce status page, and some plugins rely upon this to go about their business. The commands below will allow sysadmin to get this installed. …

Read more

Finding Us on Automattic’s Jetpack.pro

Automattic, the owners of WordPress.com, have recently setup a WordPress professionals directory, which they’re calling Jetpack.pro. You can find us (well, me, actually, as, like with Codeable, they’ve gone down the “human profile page” route (nudge 😉 ) and our profile has a human face… mine), at the following link: https://jetpack.pro/profile/robscott/ Its pretty cool that …

Read more

How to Setup MySQL’s my.cnf for Micro AWS EC2 Instance

If you’re using a micro AWS EC2 instance to host a website which uses a database running on MySQL (yes, this is possible using WordPress on a free usage tier!), then you’ll need to configure MySQL to play nicely on such a puny setup. One very easy way to get this working relatively well is …

Read more