Getting Table Sizes in MySQL

Sometimes, like when evaluating an open source project, you might want to understand how the database entries grow based on your typical usage. This will allow you to find the hot tables i.e. the ones that grow the fastest and will help you plan ahead to make sure it scales. As this is something that would usually take place in a development environment or on a local machine you should have the root access to the database. The examples bellow assume your password is mypwd and schema name is schema1. ...

February 19, 2025 ยท Andrius