![]() ![]() We can even get a bit fancier and convert the normal size values from bytes into something more useful and understandable to most people like megabytes. In this post, we discuss different options to migrate data from a self-managed MySQL database to AWS-managed Amazon RDS for MySQL or Aurora MySQL. ![]() INDEX_LENGTH is the length (or size) of the index file for the table (also in bytes).Īrmed with this information, we can execute a query that will list all tables in a specific database along with the disk space (size) of each. Amazon RDS for MySQL and Aurora MySQL support both physical and logical migration using Percona XtraBackup and native MySQL-compatible tools.DATA_LENGTH is the length (or size) of all data in the table (in bytes). How to get the sizes of the tables of a MySQL database Ask Question Asked 11 years, 3 months ago Modified 1 year, 2 months ago Viewed 849k times 1119 I can run this query to get the sizes of all tables in a MySQL database: show table status from myDatabaseName I would like some help in understanding the results.For this tutorial, we’ll be using MySQL Workbench. A MySQL client to connect to our MySQL database in the AWS cloud. List Table Sizes From a Single DatabaseĪs can seen in the official documentation, the INFORMATION_SCHEMA.TABLES table contains around 20 columns, but for the purpose of determining the amount of disk space used by tables, we’ll focus on two columns in particular: DATA_LENGTH and INDEX_LENGTH. Advertisement An AWS account to use the AWS RDS service. For our purposes we’re particularly interested in the tables metadata, which we can query to actually extract the size of various tables in the system. Everything from views and user_privilieges to columns and tables can be found in the INFORMATION_SCHEMA. Regardless of the name, what matters is the information provided by these INFORMATION_SCHEMA tables. While most other databases refer to this information as a catalog, the official MySQL documentation refers to the INFORMATION_SCHEMA metadata as tables. Like most relational databases, MySQL provides useful metadata about the database itself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |