Advertisement
krot

SQL размер таблиц в БД

Jul 23rd, 2016
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. SELECT TABLE_NAME AS `Table` , round( (
  2. (
  3. data_length + index_length
  4. ) /1024 /1024 ) , 2
  5. ) `Size in MB`
  6. FROM information_schema.TABLES
  7. WHERE table_schema = "uTABLE"
  8. LIMIT 3000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement