AWS Databases RDS Technology Aurora MySQL Storage Monitoring & Reduction August 4, 2022Lance Cleveland 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…Continue readingAurora MySQL Storage Monitoring & Reduction
Docker Plugin Development Technology WordPress Testing MySQL Connectivity From WordPress Docker Containers August 3, 2022Lance Cleveland 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…Continue readingTesting MySQL Connectivity From WordPress Docker Containers
Technology WordPress Cleaning Up WordPress – Large wp_options.idb July 8, 2020Lance Cleveland 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…Continue readingCleaning Up WordPress – Large wp_options.idb
Databases Technology Performance Benefits Of COUNT(*) In SQL November 5, 2016Lance Cleveland 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…Continue readingPerformance Benefits Of COUNT(*) In SQL
Plugin Development Technology WordPress More Notes On PHP Version Switching in VVV July 11, 2016Lance Cleveland 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…Continue readingMore Notes On PHP Version Switching in VVV
