Updated on 2024-01-22 GMT+08:00

Database Status

After databases are connected, run the following commands to check the database list and synchronization status:

  • View the kernel version.
    select version();
  • Check database status.
    show databases;
  • Check synchronization status.
    Querying binlog information will occupy the hourly query quota of GaussDB(for MySQL). You are advised to run this command at most once a minute.
    show full slave status;
  • Check snapshot status.
    show snapshot status;
    The status field is valid only when snapshots are enabled.
    • READY: ready for query.
    • NOT_READY: not ready and cannot be used.
    • ERROR: synchronization or update errors.
    • RECONNECTING: Synchronization link disconnected.
    • PREPARING_UPDATE: ready for update.
    • UPDATING: updating.