![]() SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema. Suppose, we have a database named “ test” and we want to find the size of all the tables in that database, then the query to do so will be: Here, we need to replace “ database_name” with the name of the database whose table’s size we are going to find. MySQL is ideal for both small and large applications. However the database grew to 1.04 GB while my hosting server limit for databases is. MySQL is a widely used relational database management system (RDBMS). SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "database_name" ORDER BY (data_length + index_length) DESC Hi, I am using SuiteCRM for more than a year now and it serves me well. Get size (in MB) of all tables of a particular database mysql> SELECT tableschema DB Name, ROUND(SUM(datalength + indexlength) / 1024 / 1024, 1) DB Size in MB FROM informationschema.tables GROUP BY. The result will be displayed something like below: Database Name SELECT table_schema "Database Name", sum( data_length + index_length ) / 1024 / 1024 "Database Size in MB" FROM information_schema.TABLES GROUP BY table_schema ![]() It also shows the query to get the size (in MB) of all the tables present in any particular database. The phpMyAdmin administration page appears in a new window. ![]() This article shows SQL query to get size (in MB) of all MySQL databases. In the Databases section of the cPanel home screen, click phpMyAdmin. Facebook Tweet LinkedIn Pin Print Email Shares ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |