![]() ![]() Depending on how many databases you have and how large they are, this command may take a minute or two to complete. 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. To find the size of each user-created database, run the following query: mysql> SELECT tableschema, ROUND(SUM(datalength+indexlength)/1024/1024/1024,2) size. SELECT TABLESCHEMA AS Database, TABLENAME AS Table, ROUND ( (DATALENGTH + INDEXLENGTH) / 1024 / 1024) AS Size (MB) FROM informationschema.TABLES ORDER BY (DATALENGTH + INDEXLENGTH) DESC Click on Go button. Using Query You need to log in to the database prompt (mysql> or MariaDB>) and type the command: SELECT tableschema AS 'Database', ROUND(SUM( datalength + indexlength) / 1024 / 1024, 2) AS 'Size (MB)' FROM informationschema. 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. There are 3 methods to display database size in MySQL/MariaDB: 1.DATA_LENGTH is the length (or size) of all data in the table (in bytes).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. 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 |