If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read More
Consolidate Data From YB Catalog Tables From All Nodes To One Node
System catalogs, also referred to as system tables or system views, are essential to the internal structure and management of the database, […]
Read MoreLoad Balance YSQLSH Connections
The ysqlsh CLI is the shell for interacting with the YugabyteDB YSQL API. The -h (or –host) flag specifies the host name […]
Read MoreNavigate Wide Query Output in YSQLSH Using Your Left and Right Arrow Keys
Using ysqlsh and annoyed by wrapping lines creating difficult-to-read outputs? Try setting the PAGER environment variable, when starting ysqlsh (then you’ll be […]
Read MoreUse the YB_LOCAL_TABLETS Sytem View to Map Table Rows to their Tablets
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. […]
Read More