# Information Schema GLOBAL\_STATUS and SESSION\_STATUS Tables

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `GLOBAL_STATUS` and `SESSION_STATUS` tables store a record of all [status variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables) and their global and session values respectively. This is the same information as displayed by the [SHOW STATUS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status) commands `SHOW GLOBAL STATUS` and `SHOW SESSION STATUS`.

They contain the following columns:

| Column          | Description              |
| --------------- | ------------------------ |
| VARIABLE\_NAME  | Status variable name.    |
| VARIABLE\_VALUE | Global or session value. |

## Example

```sql
SELECT * FROM information_schema.GLOBAL_STATUS;
+-----------------------------------------------+--------------------+
| VARIABLE_NAME                                 | VARIABLE_VALUE     |
+-----------------------------------------------+--------------------+
...
| BINLOG_SNAPSHOT_FILE                          | mariadb-bin.000208 |
| BINLOG_SNAPSHOT_POSITION                      | 369                |
...
| THREADS_CONNECTED                             | 1                  |
| THREADS_CREATED                               | 1                  |
| THREADS_RUNNING                               | 1                  |
| UPTIME                                        | 57358              |
| UPTIME_SINCE_FLUSH_STATUS                     | 57358              |
+-----------------------------------------------+--------------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}