A fake table that reports on the state of the instances. sysinstances includes a row for each instance defined in the cluster configuration. sysinstances contains information specific to the Cluster Edition.
Although sysinstances is a fake table, it is not impacted by the setting of set system_view, and always returns a row for each instance, regardless of the system_view setting.
The columns for sysinstances are.
Column name |
Datatype |
Description |
|---|---|---|
id |
tiny int |
ID of the instance |
name |
varchar(30) |
Name of the instance |
state |
char(17) |
State of the instance (one of |
hostname |
varchar(255) |
Name of the operating system host running this instance |
starttime |
datetime |
Date and time the instance started |
connections_active |
int |
Number of active connections on the instance |
engines_online |
smallint |
Number of online engines for this instance |
None
