table_size
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| table_size [2017/02/23 08:51] – luke7858 | table_size [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| <sxh bash> | <sxh bash> | ||
| SELECT table_name AS " | SELECT table_name AS " | ||
| + | |||
| round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" | round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" | ||
| + | |||
| FROM information_schema.TABLES | FROM information_schema.TABLES | ||
| + | |||
| WHERE table_schema = " | WHERE table_schema = " | ||
| + | |||
| ORDER BY (data_length + index_length) DESC LIMIT 15; | ORDER BY (data_length + index_length) DESC LIMIT 15; | ||
| </ | </ | ||
table_size.1487839900.txt.gz · Last modified: 2024/05/23 07:26 (external edit)