How to check Database size in Linux
We can check all the sizes of databases through execute a simple query in mysql server
Step 1: Login with mysql server
Login to mysql server by putting the mysql server credentials
# mysql -u username -p Enter Password:
Step 2: Execute the Query
Execute the mysql query in mysql server.
mysql> SELECT table_schema "Data Base Name",
-> sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
-> sum( data_free )/ 1024 / 1024 "Free Space in MB"
-> FROM information_schema.TABLES
-> GROUP BY table_schema ;
+---------------------------------+----------------------+------------------+
| Data Base Name | Data Base Size in MB | Free Space in MB |
+---------------------------------+----------------------+------------------+
| about_demo_conf | 0.11203384 | 0.02596664 |
| appstore | 0.02434349 | 0.00234127 |
| cacti | 0.95234585 | 0.00552368 |
| growingfeet | 0.10937500 | 11765.00000000 |
| information_schema | 0.00781250 | 0.00000000 |
| lotus_to_mysql | 0.47713852 | 0.00000000 |
| moderapp_log | 0.00230408 | 0.00000000 |
| moedeogeventmessen | 0.13060379 | 0.00000000 |
| mysql | 0.66061878 | 0.00000000 |
| vsftpd | 0.00310898 | 0.00000000 |
| what2do | 0.03068542 | 0.00035095 |
+---------------------------------+----------------------+------------------+
Please let me know if you’re looking for a article author for
your weblog. You have some really great posts and I
think I would be a good asset. If you ever want to take some of the load
off, I’d love to write some material for your blog in exchange for
a link back to mine. Please blast me an email if interested.
Many thanks!
This is a topic that’s near to my heart… Thank you!
Where are your contact details though?
khushimuhammad_5@yahoo.com
+923224720203
آموزش پاکسازی پوست طرف مقابل
obviously like your website however you need to check the spelling on several
of your posts. Many of them are rife with spelling problems and I find it very bothersome to tell
the truth nevertheless I’ll certainly come back again.
Asking questions are actually nice thing if you are not understanding something
fully, however this piece of writing provides nice understanding yet.
Trend News