Jump to content


Photo

[TRUCO MySQL] Tamaño de la Base de Datos.

Started by sir.dev.a.lot , Dec 19 2016 11:27 PM

  • Please log in to reply
No replies to this topic

#1 sir.dev.a.lot

sir.dev.a.lot

    Advanced Member

  • Miembros
  • PipPipPip
  • 545 posts
  • Location127.0.0.1

Posted 19 December 2016 - 11:27 PM

[TRUCO MySQL] Tamaño de la Base de Datos.


sql
  1. SELECT 
  2.   table_schema AS 'Nombre Db',
  3.   Round( SUM( data_length + index_length ) / 1024 / 1024, 3 ) AS 'Tamaño Db (MB)',
  4.   Round( SUM( data_free ) / 1024 / 1024, 3 ) AS 'Espacio Libre (MB)'
  5. FROM information_schema.TABLES
  6. GROUP BY table_schema ;

Saludos!


  • 1
Back to Trucos y Consejos


  1. Comunidad Delphiaccess
  2. → COLABORACIÓN
  3. → Trucos y Consejos
  4. Privacy Policy
IP.Board spam blocked by CleanTalk.