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
