How to Restart MySQL After Editing innodb Log Size

mysql logo resized image

Sometimes, either because we’ve got a puny amount of RAM available, or because we’ve recently boosted available RAM, we want to allow MySQL a different amount of memory for it’s innodb logs. However, when we change this, restarting MySQLd can cause a hiccup or two. Namely, the MySQL service won’t restart. If this happens, what …

Read more

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

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

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

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

How to Update Linux on Amazon EC2 with Yum

It’s really quite straightforward to update your Amazon EC2 instance to the latest versions: Login with your secure key via your terminal window; then Type “Sudo -i” and hit enter Type “yum update” and hit enter Hit “Y” to agree to the updates Wait for the software to carry out the update. That’s it! The …

Read more