Outdated Version
You are viewing an older version of this section. View current production version.
SHOW DATABASES
Shows the list of databases that exist on this MemSQL instance.
Syntax
SHOW DATABASES [EXTENDED]
[LIKE 'pattern']
Remarks
- The
EXTENDED
suffix is a MemSQL-only extension that displays extra information about each database. - This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands).
Output (EXTENDED option)
Column | Description |
---|---|
Database |
Name of a database in the MemSQL instance |
Commits |
Number of committed transactions |
Role |
Database replication role |
State |
Current state (Database States) |
Position |
Current position in the transaction log, formatted as <LogFileId>:<ByteOffsetInLogFile> |
Details |
Optional message about the current state |
AsyncSlaves |
Number of currently attached asynchronous replicas |
SyncSlaves |
Number of currently attached synchronous replicas |
Examples
memsql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| memsql |
| test |
+--------------------+
3 rows in set (0.00 sec)
memsql> SHOW DATABASES EXTENDED;
+--------------------+---------+-------------+---------------------+----------+-------------------------+-------------+------------+
| Database | Commits | Role | State | Position | Details | AsyncSlaves | SyncSlaves |
+--------------------+---------+-------------+---------------------+----------+-------------------------+-------------+------------+
| information_schema | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| memsql | 3 | master | online | 0:183 | NULL | 0 | 0 |
| foo | 112 | master | online | 1:202 | NULL | 1 | 0 |
| bar | NULL | master | recovering snapshot | 2:89123 | Recovery progress 17.2% | 0 | 1 |
| example_slave | 37 | async slave | replicating | 0:8870 | NULL | 0 | 0 |
+--------------------+---------+-------------+---------------------+----------+-------------------------+-------------+------------+