Aurora MySQL Storage Monitoring & Reduction

Using Aurora MySQL is a great way to host a MySQL database at low cost while providing a scalable and fault tolerant environment. Once you’ve setup your multi-zone cluster AWS takes care of much of the scaling for… Read More

Testing MySQL Connectivity From WordPress Docker Containers

cargo container lot

Moving forward with feature development for the Store Locator Plus® SaaS service includes moving forward with our tool kits and environments. Docker containers have become a bigger part of our development toolkit. They make for rapid deployment of… Read More

Cleaning Up WordPress – Large wp_options.idb

Did your tiny AWS Bitnami WordPress server run out of disk space? The culprit may be unoptimized data tables in MySQL. Finding a 4.9GB wp_options.idb file on your server is not as uncommon as you may think. What… Read More

Performance Benefits Of COUNT(*) In SQL

This is something I often come across in code.  Just came across it in our MySLP project today , in fact. SELECT count(id) FROM my_table While the performance impact of that statement in itself is negligible, it does… Read More

More Notes On PHP Version Switching in VVV

This article is a follow-on to Changing PHP Version on Vagrant . Here are some discoveries of using different versions of PHP on vagrant. Change Your Host The default vvv installation has the db_host set to ‘localhost’ in… Read More

%d bloggers like this: