Converting MyISAM to InnoDB
A lot of the times when we see a performance related issue on a website it’s related to the database not being optimized. MyISAM is often a primary culprit and is an older, less efficient, and less reliable database storage engine than the more modern InnoDB. Part of the reason for this is that MyISAM […]
Why is my WaaS network slow? Table locking and MySQL RAM allocation
WaaS networks are database intensive websites, and this is something many WaaS networks go through as they begin to grow in size and traffic. Sometimes this is because the server simply isn’t big enough for the network anymore, and sometimes it can be solved by increasing the MySQL’s RAM allocation. This article will walk you […]
vCanopy Database Rewrites and Workflow
Introduction In this article we’ll take a look at how and when vCanopy will run database rewrites on your servers, as well as how to run these operations in the most efficient way possible to improve your workflow and reduce the time it takes to run these search and replaces. TABLE OF CONTENTS vCanopy Search […]
How to Fix the PHPMyAdmin “Bad Userdata” Error
Opening PHPMyAdmin (PHPMA) for both your live websites and staging sites is usually very quick and easy – you simply click on the little database icon next to your site, and PHPMA will open up in a new window and instantly log you in. If you’re experiencing a “Bad Userdata” error when you open up […]