Posted on August 4, 2022Categories AWS, Databases, RDS, TechnologyTags , , , , , , ,   Leave a comment on Aurora MySQL Storage Monitoring & Reduction

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 the database server. One of the components it manages automatically is the volume, or disk storage, up to a maximum of 128TB. However, this does not mean volume storage is fully managed. All AWS RDS implementations have several components that can impact … Continue reading “Aurora MySQL Storage Monitoring & Reduction”

Posted on August 3, 2022Categories Docker, Plugin Development, Technology, WordPressTags , , , ,   Leave a comment on Testing MySQL Connectivity From WordPress Docker Containers

Testing MySQL Connectivity From WordPress Docker Containers

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 isolated environments for testing various concepts without the overhead of virtual machines. While we have been working on Virtualbox virtualized machines for years, Docker is far faster to spin up and far less resource intensive. Along the way we have found the … Continue reading “Testing MySQL Connectivity From WordPress Docker Containers”

Posted on July 8, 2020Categories Technology, WordPressTags , , , ,   Leave a comment on Cleaning Up WordPress – Large wp_options.idb

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 makes it surprising is when you look at your wp_options entries and discover there are only 300 rows in that table with limited text in the option_value column. Thankfully there is an easy fix as long as you can get enough disk … Continue reading “Cleaning Up WordPress – Large wp_options.idb”

Posted on November 5, 2016Categories Databases, TechnologyTags , , ,   Leave a comment on Performance Benefits Of COUNT(*) In SQL

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 add up.  For most database engines that statement incurs additional overhead as it processes logic related to a specific column containing a specific data type.   Some database engines check if the column is null for EVERY RECORD, for example.   Not a big … Continue reading “Performance Benefits Of COUNT(*) In SQL”

Posted on July 11, 2016Categories Plugin Development, Technology, WordPressTags , , , , , ,   Leave a comment on More Notes On PHP Version Switching in VVV

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 the wp-config.php file. phpbrew, however, sets the default db listener to 127.0.01 explicitly.   They do not want to change it as they claim “this is the proper default”.   As happens often with technology gurus both the VVV camp and the phpbrew camp … Continue reading “More Notes On PHP Version Switching in VVV”