How to get size of mysql database?

Run this query and you’ll probably get what you’re looking for:

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

This query comes from the mysql forums, where there are more comprehensive instructions available.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  6. Create a new database with MySQL Workbench
  7. 1052: Column ‘id’ in field list is ambiguous
  8. 1052: Column ‘id’ in field list is ambiguous
  9. difference between primary key and unique key
  10. How to create a foreign key in phpmyadmin
  11. importing a CSV into phpmyadmin
  12. How to check if mysql database exists
  13. Is there a Profiler equivalent for MySql?
  14. How to do a batch insert in MySQL
  15. MySQL: Cloning a MySQL database on the same MySql instance
  16. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  17. Data is not constantly loading from custom wordpress table
  18. What’s a good strategy for planning WordPress DB growth?
  19. How do I load a sql.gz file to my database? (importing)
  20. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  21. MySQL Error “Operand should contain 1 column”
  22. How to use MySQL DECIMAL?
  23. MySQL ERROR 1290 (HY000) –secure-file-priv option
  24. MySQL server startup error ‘The server quit without updating PID file’
  25. Duplicating a MySQL table, indices, and data
  26. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  27. MySQL error code: 1175 during UPDATE in MySQL Workbench
  28. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  29. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  30. How to find MySQL process list and to kill those processes?
  31. MySQL Server on MAMP-Windows Will Not Start
  32. SQL statement not working – “Operand type clash: date is incompatible with int’
  33. How can I output MySQL query results in CSV format?
  34. How can I rebuild indexes and update stats in MySQL innoDB?
  35. MySQL Error 1215: Cannot add foreign key constraint
  36. select * from table where column = something or, when unavailable, column = something else
  37. Differences between utf8 and latin1
  38. There can be only one auto column
  39. WordPress will not operate correctly
  40. importing data from non-wordpress mysql db
  41. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  42. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  43. Error establishing a database connection – with Debug Data
  44. if statement on database query
  45. How to execute mulitple statement SQL queries using $wpdb->query?
  46. Database with mixed collation (utf8mb4 & utf8_general_ci)
  47. How can I make wordpress suppress mysql errors?
  48. Is it good practice to use wpdb->query() function?
  49. Migrating database / content of non-CMS site to WordPress
  50. Delete all post meta except featured image Using SQL
  51. Error while importing database
  52. Adding new row to wp_post table
  53. How do I find which articles are missing a featured image in The WordPress database?
  54. How to determine what is generating large amount of database queries?
  55. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  56. How do I get the posts within a certain year/date(with sql query)?
  57. Connect another DB and fetch records from some tables
  58. How to select from two different tables to display orders list with custom column from other table
  59. Error: MySQL shutdown unexpectedly [closed]
  60. Not connecting to database in file with multiple MySQL connections
  61. Defining the same price to all WooCommerce Products
  62. creating new field on mysql
  63. Database Structure on Different Servers
  64. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  65. SQL query to set posts in bulk based on the post content
  66. How can I detect right db type?
  67. How to insert dash (-) into database using wpdb and new_to_publish hook?
  68. MySQL: How to change url in posts from xxx.com to yyy.org?
  69. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  70. Second ezSQL initialization for MSSQL
  71. Fetch a single row from a custom table for to a given ID
  72. Database create or redirect
  73. Upgrade DB Loop – WordPress DB Version Conflict
  74. WordPress & MySQL , problem with use many array in meta_query
  75. Button writing to MYSQL database
  76. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  77. MySQL ‘duplicate entry’ error
  78. Recovery – Restore Database after moving folder location locally
  79. Performing CRUD operations on front end in wordpress
  80. What is my error trying to create a new table in the database?
  81. Deleted products from woocommerce are still in the database
  82. WordPress Dutch characters encoding problem
  83. How to show result of sql query in a page?
  84. Insert data from form to database
  85. How can I get $wpdb to show MySQL warnings?
  86. Populate custom post type/custom fields from an external database
  87. HyperDB failover Delay
  88. Select latest 2 articles, but only from given category
  89. CONCAT_WS in custom sql query
  90. How to extract some part of WordPress full source code
  91. Ordering topics by most replies in X days using MYSQL statement
  92. MySQL Select within WP Page template
  93. two wordpress sites, two themes, one database, same content
  94. MySQL database migration to WordPress
  95. Running WordPress from MySQL Cluster with HAPRoxy
  96. Custom query_posts() parameter
  97. Delete posts with word count less than x number of words
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. Display total count of products in orders of a specific order status
  100. remove wordpress post links

Leave a Comment