SHOW PROXYPS

Description

You can use this statement to query information about prepared statement (PS) caches when the PS protocol is used.

Limitations

• If you log in as a normal user, you can query only information about the PS caches of the current user. For example, if you specify cs_id in a query, the query is executed only when the client session specified by cs_id belongs to the current user.

• If you log in to the sys tenant or as the root@proxysys user, you can query information about the PS caches of any user.

Syntax

SHOW PROXYPS [cs_id] [like "sql"] [tenant like "tenant_name"] [DETAIL];

Parameters

Examples

• Query with cd_id and the SQL statement specified

  SHOW PROXYPS 1 like '%select%';
  

  In this example, cs_id is 1. You can query its actual value by using the SHOW PROCESSLIST; or SHOW PROXYSESSION; statement, and the value of the Id column in the output is cs_id.

  The output of the SHOW PROXYPS statement is as follows:

  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  | cs_id | cluster_name | tanant_name | ps_id | ps_name | prepare_sql | parse_result | used_mem  | used_session |
  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  | 1     | obcluster    | mysql       |  -1   | PS1     | NULL        | NULL         | 10533     |  1           |
  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  

• Query with the SQL statement and tenant name specified

  SHOW PROXYPS like '%select%' tenant like '%mysql%';
  

  The output is as follows:

  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  | cs_id | cluster_name | tanant_name | ps_id | ps_name | prepare_sql | parse_result | used_mem  | used_session |
  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  | 1     | obcluster    | mysql       |  -1   | PS1     | NULL        | NULL         | 10533     |  1           |
  +-------+--------------+-------------+-------+---------+-------------+--------------+-----------+--------------+
  

Columns