As you explore the ysqlsh interactive shell, it’s useful to know that you can view the SQL queries executed for each meta-command […]
Read More
Determining if a YugabyteDB Universe is Running a YSQL or YCQL Workload
The YugabyteDB Query Layer (YQL) serves as the main interface, enabling applications to interact through client drivers. This layer handles API-specific tasks, […]
Read MoreDisplay the Number of YCQL Connections
Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is best fit for internet-scale OLTP and HTAP applications needing massive […]
Read MoreANALYZE All Tables in the Current Database
In YSQL the ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system […]
Read MoreRecover Recently Deleted Data Using Follower Reads
YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit […]
Read More