MySQL is taking up a LOT of disk space. Why?
If you’re finding that your MySQL is taking up a large amount of disk space on your servers, and you’re not running any particularly large websites, it’s likely that this is due to how InnoDB works. What may be happening is your sites are storing a lot of temporary data inside the database. Each InnoDB table […]
How to optimize databases to reduce bloat
Here at vCanopy, we’ve opted to use InnoDB as the default storage engine for SQL. It’s typically more performant than other storage engines like MyISAM. However, it does have one flaw: As you add data, the InnoDB table file is allocated more space and the file physically grows in size on the server. The InnoDB table […]
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 […]
The WP Reset Plugin and Database Bloat
Third-Party Software Notice Our support team cannot provide support for third-party software and services. However, if you need assistance or spot an issue with this article please post in the vCanopy Community Forum, and we will make necessary updates/improvements where needed. WP Reset is an interesting plugin, but at the time of writing the default […]
Using the MySQL Slow Log
Introduction MySQL slow query logging can be a highly useful tool for uncovering performance bottlenecks in your websites. The MySQL slow query log is where the MySQL database server will log all queries that exceed a time (in seconds) that you specify. This can be particularly helpful on database-intensive websites, such as WooCommerce stores, to […]