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: