Sql

Search

mariadb used space

mysql> select table_schema, sum((data_length+index_length)/1024/1024) AS MB from information_schema.tables group by 1;
+--------------------+-----------------+
| table_schema       | MB              |
+--------------------+-----------------+
| prod               | 298025.72448921 |
| information_schema |      0.00781248 |
| maatkit            |     70.77330779 |
| mysql              |      0.66873168 |
| test               |   4752.31449127 |
+--------------------+-----------------+
5 rows in set (0.01 sec)

Comment

PREVIOUS	NEXT

Code Example
Sql :: Create parameterized VIEW in SQL Server
Sql :: how to get last element sql
Sql :: flask sqlalchemy remove duplicates
Sql :: view column type sql server
Sql :: import Data in MySQL without using any other software
Sql :: automate mysql cli query
Sql :: into operator in sql
Sql :: how to convert null to float in mysql
Sql :: mysql in clausule string array
Sql :: mysql multiple left joins on same table
Sql :: sql select statements
Sql :: drop unique
Sql :: postgresql create user roles
Sql :: sqlalchemy orm duplicate
Sql :: Remove duplicate old value in mysql
Sql :: mysql date comparison with formatting
Sql :: cast in sql server
Sql :: creating database with -
Sql :: mysql order by list
Sql :: oracle sql distinct vs unique
Sql :: mysql with docker
Sql :: stored procedure
Sql :: mac mysql this is incompatible with sql_mode=only_full_group_by
Sql :: how to define a non primary composite key in sql
Sql :: select from table and insert into table in sql
Sql :: insert overwrite table in mysql in nifi
Sql :: exectuer myssql .sql
Sql :: order child below the parent in mysqli
Sql :: mysql set session timeout
Sql :: leftjoin in sql

Search

SQL

mariadb used space

ADD CONTENT