Database Size in MB or GB | Data Management | Software

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 2
 
  Database Size in MB or GB in MySQL
Share
Transcript
  SELECT ROUND(SUM(data_length+index_length)/1024/1024)S t!tal_ #$ROUND(SUM(data_length)/1024/1024) S data_ #$ROUND(SUM(index_length)/1024/1024) S index_ #%ROM &N%ORMT&ON_SC'EMta#le*SELECT ROUND(SUM(data_length+index_length)/1024/1024/1024)S t!tal_g#$ROUND(SUM(data_length)/1024/1024/1024) S data_g#$ROUND(SUM(index_length)/1024/1024/1024) S index_g#%ROM &N%ORMT&ON_SC'EMta#le*dit ,!- data#ae i.e &n MSELECT ta#le_he a$ engine$ROUND(SUM(data_length+index_length)/1024/1024) S t!tal_ #$ROUND(SUM(data_length)/1024/1024) S data_ #$ROUND(SUM(index_length)/1024/1024) S index_ #$COUNT() S ta#le%ROM in3!- ati!n_he ata#leROU5 6 ta#le_he a$ engineORDER 6 7 DESC*&n SELECT ta#le_he a$ engine$ROUND(SUM(data_length+index_length)/1024/1024/1024) S t!tal_g#$ROUND(SUM(data_length)/1024/1024/1024) S data_g#$ROUND(SUM(index_length)/1024/1024) S index_ #$COUNT() S ta#le%ROM in3!- ati!n_he ata#leROU5 6 ta#le_he a$ engineORDER 6 7 DESC*Ta#le Si.e in   8ei3, the data#ae and ta#le na eSELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024/1024)$ 2) 9Si.e in 9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <la-it,_8-!dti!n< ND ta#le_na e ; <in=i-ie<*&n SELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024/1024)$ 2) 9Si.e in 9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <-!>d<SELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024/1024)$ 2) 9Si.e in 9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <?i-ad#<  &n MSELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024)$ 2) 9Si.e in M9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <-!>d<*SELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024)$ 2) 9Si.e in M9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <?i-ad#<*SELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024/1024)$ 2) 9Si.e in 9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <-@in3!d#<*AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA6! an e thi =e-, t! h!> the i.e !3 a ta#le (alth!gh ,! need t! #tittethe @a-ia#le 3i-t)SELECT ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024)$ 2) 9Si.e in M9 %ROM in3!- ati!n_he aTLES :'ERE ta#le_he a ; <BD_NME< ND ta#le_na e ; <BTLE_NME<*!- thi =e-, t! lit the i.e !3 e@e-, ta#le in e@e-, data#ae$ la-get 3i-tSELECT ta#le_he a a 9Data#ae9$ ta#le_na e S 9Ta#le9$ -!nd(((data_length + index_length) / 1024 / 1024)$ 2) 9Si.e in M9 %ROM in3!- ati!n_he aTLES ORDER 6 (data_length + index_length) DESC*
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x