|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
How can I list from command line under Linux
all currently existing MySQL databases, their maximum size and their current usage size ? Mark |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
morei@hotmail.com (Mark O'Reilly) wrote:
> How can I list from command line under Linux > all currently existing MySQL databases, their maximum size and > their current usage size ? mysql --table -e " SELECT TABLE_SCHEMA AS 'database', SUM(INDEX_LENGTH) AS 'used index', SUM(DATA_LENGTH) AS 'used data', SUM(MAX_DATA_LENGTH) AS 'max data' FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA" however the maximum size will often be arbitrary. Or it may read 0 when the engine does not have per table limits. XL -- Axel Schwenke, Support Engineer, MySQL AB Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/ MySQL User Forums: http://forums.mysql.com/ |
|
![]() |
| Outils de la discussion | |
|
|