SHOW QUERIES
NOTE:
SHOW QUERIES
requires Manticore Buddy. If it doesn't work, make sure Buddy is installed.
SHOW QUERIES
returns information about all currently running queries. The output is a table with the following structure:
id
: Query ID that can be used in KILL to terminate the queryquery
: Query statement or a portion of ittime
: Time taken on command execution or how long ago the query was performed (in this case, the value will includeago
)protocol
: Connection protocol, with possible values beingsphinx
,mysql
,http
,ssl
,compressed
,replication
, or a combination (e.g.,http,ssl
orcompressed,mysql
)host
: Client'sip:port
- SQL
mysql> SHOW QUERIES;
+------+--------------+---------+----------+-----------------+
| id | query | time | protocol | host |
+------+--------------+---------+----------+-----------------+
| 111 | select | 5ms ago | http | 127.0.0.1:58986 |
| 96 | SHOW QUERIES | 255us | mysql | 127.0.0.1:33616 |
+------+--------------+---------+----------+-----------------+
2 rows in set (0.61 sec)
Refer to SHOW THREADS if you'd like to gain insight from the perspective of the threads themselves.
SHOW VERSION
NOTE:
SHOW VERSION
requires Manticore Buddy. If it doesn't work, make sure Buddy is installed.
SHOW VERSION
provides detailed version information of various components of the Manticore Search instance. This command is particularly useful for administrators and developers who need to verify the version of Manticore Search they are running, along with the versions of its associated components.
The output table includes two columns:
Component
: This column names the specific component of Manticore Search.Version
: This column displays the version information for the respective component.
- SQL
mysql> SHOW VERSION;
+-----------+--------------------------------+
| Component | Version |
+-----------+--------------------------------+
| Daemon | 6.2.13 61cfe38d2@24011520 dev |
| Columnar | columnar 2.2.5 214ce90@240115 |
| Secondary | secondary 2.2.5 214ce90@240115 |
| KNN | knn 2.2.5 214ce90@240115 |
| Buddy | buddy v2.0.11 |
+-----------+--------------------------------+
KILL <query id>
KILL
terminates the execution of a query by its ID, which you can find in SHOW QUERIES.
- SQL
mysql> KILL 4;
Query OK, 1 row affected (0.00 sec)
SHOW WARNINGS
statement can be used to retrieve the warning produced by the latest query. The error message will be returned along with the query itself:
mysql> SELECT * FROM test1 WHERE MATCH('@@title hello') \G
ERROR 1064 (42000): index test1: syntax error, unexpected TOK_FIELDLIMIT
near '@title hello'
mysql> SELECT * FROM test1 WHERE MATCH('@title -hello') \G
ERROR 1064 (42000): index test1: query is non-computable (single NOT operator)
mysql> SELECT * FROM test1 WHERE MATCH('"test doc"/3') \G
*************************** 1\. row ***************************
id: 4
weight: 2500
group_id: 2
date_added: 1231721236
1 row in set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS \G
*************************** 1\. row ***************************
Level: warning
Code: 1000
Message: quorum threshold too high (words=2, thresh=3); replacing quorum operator
with AND operator
1 row in set (0.00 sec)