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

Рекомендуем почитать
Чистим историю в базе данных zabbix

Ни для кого не секрет , что со временем база данных zabbix увеличивается. Поэтому покажу вам как ее почистить в Читать дальше...

Как сделать резервную копию MySql всех баз данных

Хочу поделится с вами небольшим скриптом для создания резервных копий всех баз данных MySql. #!/bin/bash MyUSER="dbuser" MyPASS="dbpass" MyHOST="localhost" MYSQL="$(which mysql)" Читать дальше...

Выводим список таблиц с количеством записей в mysql

Хочу привести небольшой пример запроса, с помощью которого можно получить список таблиц в mysql базе с количеством записей : SELECT Читать дальше...

Бесплатный доступ к платным сервисам во время эпидемии коронавируса

Безусловно, коронавирус повлияет на нас всех в той или иной форме. Ничего хорошего от него нет, не было и не Читать дальше...

Поделиться

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

  1. I just want to tell you that I am just all new to blogging and actually liked this blog. More than likely I’m going to bookmark your blog . You surely have remarkable posts. Thanks for sharing your web site.

  2. Youre so cool! I dont suppose Ive learn something like this before. So good to find somebody with some unique ideas on this subject. realy thank you for beginning this up. this website is something that is needed on the net, somebody with somewhat originality. helpful job for bringing something new to the internet!

  3. There are definitely a lot of information like that to take into account. That is a wonderful indicate bring up. I supply the thoughts above as general motivation but clearly there are inquiries like the one you raise where the most essential point will be working in honest good faith. I don?t understand if ideal methods have arised around things like that, yet I make certain that your work is plainly recognized as a fair game. Both kids as well as girls really feel the effect of just a moment?s pleasure, for the rest of their lives.

  4. I’m impressed, I have to admit. Truly rarely will i encounter a blog that’s both educative and entertaining, and without a doubt, you have hit the nail on the head. Your concept is outstanding; the problem is something that too few folks are speaking intelligently about. I’m delighted that we came across this within my seek out some thing relating to this.

  5. Wonderful blog post. I find out something much more difficult on different blog sites day-to-day. It will constantly be stimulating to review web content from various other authors as well as practice a little something from their shop. I?d favor to use some with the web content on my blog whether you don?t mind. Natually I?ll provide you a link on your web blog. Many thanks for sharing.

  6. This is the right blog for any person who wishes to find out about this topic. You recognize so much its almost hard to argue with you (not that I actually would want?HaHa). You absolutely placed a brand-new spin on a subject thats been discussed for years. Fantastic stuff, just wonderful!

  7. After study a few of the post on your web site now, as well as I genuinely like your method of blog writing. I bookmarked it to my bookmark web site listing as well as will be inspecting back soon. Pls take a look at my internet site too as well as let me understand what you think.

  8. I was extremely delighted to discover this web-site. I wished to many thanks for your time for this terrific read!! I definitely delighting in every bit of it and I have you bookmarked to check out new things you article.

  9. After research study a few of the article on your web site now, and also I genuinely like your means of blogging. I bookmarked it to my book marking site checklist and also will certainly be checking back soon. Pls have a look at my web site also and let me know what you think.

  10. An outstanding share, I just provided this onto a colleague that was doing a little evaluation on this. And he in fact bought me breakfast because I located it for him. smile. So let me rephrase that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly concerning it as well as love finding out more on this subject. If possible, as you end up being experience, would you mind upgrading your blog site with more details? It is highly practical for me. Large thumb up for this blog post!

  11. When I initially commented I clicked the -Inform me when new comments are included- checkbox and currently each time a remark is included I get four e-mails with the very same comment. Is there any way you can eliminate me from that service? Thanks!

  12. When I initially commented I clicked the -Inform me when new remarks are included- checkbox as well as now each time a remark is added I get four e-mails with the exact same remark. Is there any way you can remove me from that service? Thanks!

  13. I don’t know whether it’s just me or if everyone else experiencing issues with your site. It seems like some of the text in your posts are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This may be a problem with my browser because I’ve had this happen before. Thank you

  14. Oh my goodness! an amazing short article man. Thank you Nevertheless I am experiencing concern with ur rss. Don?t know why Incapable to sign up for it. Is there anyone getting similar rss issue? Anybody who knows kindly react. Thnkx

  15. I?m pleased, I must say. Really seldom do I experience a blog that?s both instructional and also enjoyable, and let me inform you, you have actually hit the nail on the head. Your suggestion is outstanding; the problem is something that inadequate individuals are speaking wisely about. I am very pleased that I came across this in my search for something relating to this.

  16. After research study a few of the post on your internet site currently, and also I truly like your method of blog writing. I bookmarked it to my bookmark site list and will certainly be examining back soon. Pls take a look at my web site too and let me understand what you assume.

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

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