Узнать размеры всех баз 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 ;

sqlsizes

28 комментариев к “Узнать размеры всех баз mysql

  1. This is the right blog site for any individual who wants to find out about this subject. You recognize a lot its practically difficult to say with you (not that I really would want?HaHa). You most definitely placed a new spin on a topic thats been discussed for several years. Fantastic things, just wonderful!

  2. There are some intriguing times in this short article however I don?t recognize if I see all of them facility to heart. There is some validity yet I will certainly hold point of view until I check into it even more. Great short article, many thanks and also we desire extra! Added to FeedBurner too

  3. Can I just claim what a relief to discover a person who really recognizes what theyre discussing online. You certainly know how to bring an issue to light as well as make it essential. More individuals need to read this and also understand this side of the story. I cant think youre not more preferred due to the fact that you certainly have the gift.

  4. Please let me know if you’re looking for a writer for your weblog. You have some really great articles 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 articles for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Kudos!

  5. Excellent blog! Do you have any hints for aspiring writers?
    I’m planning to start my own website soon but I’m a little lost
    on everything. Would you suggest starting with
    a free platform like WordPress or go for a paid option? There are so
    many options out there that I’m totally overwhelmed ..
    Any recommendations? Kudos!

  6. Aw, this was a really good article. In concept I wish to place in composing such as this additionally? taking time and real initiative to make a great short article? however what can I say? I postpone alot and never seem to get something done.

  7. Youre so trendy! I do not suppose Ive review anything like this prior to. So nice to discover somebody with some initial ideas on this subject. realy thank you for starting this up. this site is something that is required on the web, somebody with a little creativity. beneficial job for bringing something brand-new to the internet!

  8. After research study a few of the blog posts on your site now, as well as I genuinely like your means of blog writing. I bookmarked it to my book mark site listing as well as will certainly be examining back soon. Pls look into my internet site as well and let me understand what you think.

  9. Hello would you mind letting me know which hosting company you’re working with? I’ve loaded your blog in 3 different browsers and I must say this blog loads a lot faster then most. Can you recommend a good hosting provider at a honest price? Kudos, I appreciate it!

  10. First off I would like to say awesome blog! I had a quick question which I’d like to ask if you do not mind. I was curious to find out how you center yourself and clear your mind before writing. I’ve had difficulty clearing my thoughts in getting my thoughts out there. I do enjoy writing however it just seems like the first 10 to 15 minutes are usually lost simply just trying to figure out how to begin. Any recommendations or hints? Kudos!

  11. I’m really enjoying the theme/design of your web site. Do you ever run into any internet browser compatibility problems? A handful of my blog readers have complained about my site not working correctly in Explorer but looks great in Safari. Do you have any recommendations to help fix this issue?

  12. Howdy! This post couldn’t be written any better! Reading through this post reminds me of my good old room mate! He always kept chatting about this. I will forward this write-up to him. Pretty sure he will have a good read. Thanks for sharing!

  13. Greetings from Ohio! I’m bored at work so I decided to browse your website on my iphone during lunch break. I love the info you present here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, amazing blog!

  14. Masterminding Does this press release infringe on your copyright? It is a violation of our terms and conditions for writers to submit material which they did not write and claim it as their own.

  15. *Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.

  16. Oh my goodness! an impressive post guy. Thank you Nonetheless I am experiencing concern with ur rss. Don?t understand why Unable to register for it. Exists any person getting the same rss trouble? Anybody who knows kindly respond. Thnkx

Оставить ответ

Ваш адрес email не будет опубликован. Обязательные поля помечены *