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

82 комментария к “Узнать размеры всех баз 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

  17. Please let me know if you’re looking for a author for your site. You have some really good articles and I think I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some content for your blog in exchange for a link back to mine. Please blast me an email if interested. Thank you!

  18. Woah! I’m really enjoying the template/theme of this blog. It’s simple, yet effective. A lot of times it’s tough to get that “perfect balance” between user friendliness and appearance. I must say you have done a very good job with this. Additionally, the blog loads super quick for me on Opera. Superb Blog!

  19. When I originally commented I clicked the -Alert me when brand-new remarks are added- checkbox as well as now each time a remark is included I get 4 emails with the exact same comment. Is there any way you can remove me from that service? Thanks!

  20. This is the best blog for anybody who wants to find out about this subject. You understand so much its nearly difficult to argue with you (not that I really would want?HaHa). You most definitely put a new spin on a subject thats been covered for years. Terrific things, just terrific!

  21. Howdy outstanding blog! Does running a blog like this require a massive amount work? I have very little knowledge of programming but I had been hoping to start my own blog in the near future. Anyway, should you have any suggestions or techniques for new blog owners please share. I know this is off topic but I just wanted to ask. Many thanks!

  22. Have you ever thought about including a little bit more than just your articles? I mean, what you say is fundamental and all. But just imagine if you added some great visuals or videos to give your posts more, “pop”! Your content is excellent but with pics and clips, this website could undeniably be one of the most beneficial in its field. Awesome blog!

  23. Great blog you have here but I was wondering if you knew of any message boards that cover the same topics talked about in this article? I’d really like to be a part of community where I can get comments from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Bless you!

  24. Hello this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

  25. I’m really loving the theme/design of your weblog. Do you ever run into any browser compatibility problems? A number of my blog visitors have complained about my site not operating correctly in Explorer but looks great in Opera. Do you have any suggestions to help fix this issue?

  26. Hello just wanted to give you a quick heads up. The words in your post seem to be running off the screen in Ie. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The design and style look great though! Hope you get the problem solved soon. Kudos

  27. Amazing blog! Do you have any recommendations for aspiring writers? I’m hoping to start my own blog 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 choices out there that I’m totally confused .. Any recommendations? Cheers!

  28. First of all I would like to say excellent blog! I had a quick question that I’d like to ask if you do not mind. I was interested to find out how you center yourself and clear your mind prior to writing. I have had difficulty clearing my mind in getting my ideas out there. I truly do take pleasure in writing but it just seems like the first 10 to 15 minutes are generally wasted just trying to figure out how to begin. Any recommendations or tips? Cheers!

  29. I know this if off topic but I’m looking into starting my own blog and was curious what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100 positive. Any tips or advice would be greatly appreciated. Kudos

  30. Have you ever thought about creating an e-book or guest authoring on other websites? I have a blog centered on the same ideas you discuss and would love to have you share some stories/information. I know my viewers would appreciate your work. If you are even remotely interested, feel free to send me an email.

  31. Today, while I was at work, my cousin stole my iphone and tested to see if it can survive a 25 foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views. I know this is completely off topic but I had to share it with someone!

  32. Yesterday, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!

  33. Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

  34. I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz reply as I’m looking to create my own blog and would like to find out where u got this from. kudos

  35. Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

  36. Hey there just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Chrome. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The design and style look great though! Hope you get the problem solved soon. Cheers

  37. Hey there this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding know-how so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

  38. Hello, Neat post. There is a problem together with your site in web explorer, might check this? IE still is the market leader and a big component to folks will pass over your magnificent writing due to this problem.|

  39. I?m pleased, I need to claim. Really rarely do I run into a blog site that?s both informative as well as entertaining, as well as let me tell you, you have actually struck the nail on the head. Your concept is exceptional; the issue is something that insufficient individuals are talking intelligently around. I am extremely happy that I stumbled across this in my search for something associating with this.

  40. The next time I review a blog site, I wish that it doesn’t disappoint me as much as this one. I mean, I know it was my choice to review, yet I actually thought youd have something intriguing to state. All I listen to is a lot of yawping about something that you can repair if you werent as well hectic searching for focus.

  41. I?m amazed, I must state. Really seldom do I encounter a blog that?s both educative as well as entertaining, as well as let me inform you, you have struck the nail on the head. Your suggestion is exceptional; the issue is something that not enough individuals are speaking smartly around. I am very delighted that I came across this in my search for something connecting to this.

  42. This is the right blog for any person who intends to learn about this subject. You realize so much its almost tough to argue with you (not that I actually would want?HaHa). You most definitely placed a brand-new spin on a topic thats been blogged about for years. Terrific stuff, simply fantastic!

  43. Heya i’m for the first time here. I came across this board and I find It truly useful & it helped me out much. I hope to give something back and aid others like you helped me.|

  44. I am now not certain where you are getting your information, however great topic. I needs to spend some time studying more or figuring out more. Thanks for fantastic info I used to be in search of this information for my mission.|

  45. Woah! I’m really digging the template/theme of this blog. It’s simple, yet effective. A lot of times it’s very difficult to get that “perfect balance” between user friendliness and visual appearance. I must say you have done a great job with this. In addition, the blog loads extremely quick for me on Safari. Outstanding Blog!|

  46. Youre so trendy! I do not mean Ive check out anything such as this prior to. So good to discover someone with some initial thoughts on this subject. realy thank you for beginning this up. this internet site is something that is required online, somebody with a little originality. beneficial job for bringing something brand-new to the web!

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

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