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

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