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 September 21, 2017Categories Databases, PHP, Technology, WordPressTags , , ,   Leave a comment on WordPress 4.8.2 Data Query Woes

WordPress 4.8.2 Data Query Woes

Millions of websites across the Internet were automatically updated to WordPress 4.8.2 yesterday.    Thousands of those sites have key components that are no longer working.   Many of those sites will be looking for new plugins and themes unless new patches are made to make those themes and plugins 4.8.2 compatible.   WordPress 4.8.2 Data Query WoesWordPress 4.8.2 Data Query WoesWordPress 4.8.2 Data Query Woesn the meantime there are going to be a lot more partially broken websites online … Continue reading “WordPress 4.8.2 Data Query Woes”

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”