MySQL | DB容é‡ã€ãƒ†ãƒ¼ãƒ–ル容é‡ã®ç¢ºèªæ–¹æ³• - ã‚ãã‚ãBankDBã‚’é‹ç”¨ã—ã¦ã„ã‚‹ã¨ã€ŒDB全体ã§ä½•MB利用ã—ã¦ã„ã‚‹ã®ã ã‚ã†ï¼Ÿã€ã€Œå„テーブルã”ã¨ã«ä½•MB利用ã—ã¦ã„ã‚‹ã®ã ã‚ã†ï¼Ÿã€ã¨ã„ã£ãŸã“ã¨ã‚’確èªã™ã‚‹å¿…è¦ãŒã§ã¦ãã¾ã™ã€‚ã“ã“ã§ã¯ã€å®¹é‡ã‚’確èªã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ SELECT table_schema, floor(SUM(data_length + index_length) / 1024 / 1024) AS ALL_MB, floor(SUM((data_length) / 1024 / 1024)) AS DATA_MB, floor(SUM((index_length) / 1024 / 1024)) AS INDEX_MB FROM information_schema.tables GROUP BY table_schema ORDER BY sum(data_length + index_length) DESC; mysql> SEL
MySQLã§DBã¨ãƒ†ãƒ¼ãƒ–ルã®ã‚µã‚¤ã‚ºã‚’確èªã™ã‚‹SQL - Qiita
よã使ã†mysqldumpã®ã‚ªãƒ—ションã¨ä½¿ç”¨ä¾‹ - Qiita
xdebugを使ã£ãŸã‚³ãƒ¼ãƒ‰ã‚«ãƒãƒ¬ãƒƒã‚¸é›†è¨ˆ
MySQL 容é‡ç¢ºä¿ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿å‰Šé™¤æ–¹å¼ | Ore no homepage
Cassandraã€MongoDBã€Redisãªã©ä¸»è¦NoSQL比較 | gihyo.jp
データベースã¨ãƒ†ãƒ¼ãƒ–ルã®ã‚µã‚¤ã‚ºã‚’確èªã™ã‚‹æ–¹æ³• - Simple, Slowly
KMSãŒRDS for Oracleã¨RDS for SQL Serverã®æš—å·åŒ–ã«ã‚‚使ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—㟠| DevelopersIO
Top 84 MySQL Performance Tips | Debian Admin
{{#tags}}- {{label}}
{{/tags}}