Difference between revisions of "Maria DB: show tables;"
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
* <code>show table status like '%';</code> (Includes [[engine type]]) | * <code>show table status like '%';</code> (Includes [[engine type]]) | ||
* <code>[[show table]] status where name = "YOUR_TABLE_NAME"</code> (Includes [[engine]] type) | * <code>[[show table]] status where name = "YOUR_TABLE_NAME"</code> (Includes [[engine]] type) | ||
+ | |||
+ | Size of MariaDB tables: | ||
+ | <pre> | ||
+ | SELECT | ||
+ | table_schema as `Database`, | ||
+ | table_name AS `Table`, | ||
+ | round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` | ||
+ | FROM information_schema.TABLES | ||
+ | ORDER BY (data_length + index_length) DESC; | ||
+ | </pre> | ||
+ | Ref: https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database | ||
Revision as of 12:41, 5 May 2021
MariaDB
show tables (example)
show table status
show table status like '%';
(Includes engine type)show table status where name = "YOUR_TABLE_NAME"
(Includes engine type)
Size of MariaDB tables:
SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;
Ref: https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database
MongoDB
See also
- MariaDB:
mariadbcheck
,mariabackup
,mysqldump
, MyRocks,show (MariaDB)
MariaDB Changelog,50-server.cnf
, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log
, MariaDB files:.frm
,.ibd
,/etc/mysql/mariadb.conf.d/50-server.cnf
, replication, MariaDB slow queries,show databases;
, Aria, MyISAM, MariaDB SkySQL, binary log, 3306 - MongoDB: MongoDB Compass,
mongo
,mongodump, mongorestore
,mongoexport
, MongoDB changelog, MongoDB Enterprise Kubernetes Operator, GridFS, MongoDB Atlas, MongoDB replication, Ops Manager, docker logs mongodb, show collections, show dbs,mongo --help
Advertising: