SHOW QUERIES注意:
SHOW QUERIES需要 Manticore Buddy。如果不起作用，请确保已安装 Buddy。
SHOW QUERIES 返回所有当前运行查询的信息。输出是一个具有以下结构的表格：
‹›
- SQL
- JSON
📋
⚙
mysql> SHOW QUERIES;POST /sql?mode=raw -d "SHOW QUERIES"
‹›
Response
+------+--------------+---------+----------+-----------------+
| 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)[
{
"total": 2,
"error": "",
"warning": "",
"columns": [
{
"id": {
"type": "long long"
}
},
{
"query": {
"type": "string"
}
},
{
"time": {
"type": "string"
}
},
{
"protocol": {
"type": "string"
}
},
{
"host": {
"type": "string"
}
}
],
"data": [
{
"id": 111,
"query": "select",
"time": "5ms ago",
"protocol": "http",
"host": "127.0.0.1:58986"
},
{
"id": 96,
"query": "SHOW QUERIES",
"time": "255us",
"protocol": "mysql",
"host": "127.0.0.1:33616"
}
]
}
]如需从线程本身的视角获得见解，请参阅 SHOW THREADS。
Last modified: April 13, 2026
SHOW VERSION注意：
SHOW VERSION需要 Manticore Buddy。如果无法使用，请确保已安装 Buddy。
SHOW VERSION 提供 Manticore Search 实例各个组件的详细版本信息。该命令对需要验证所运行的 Manticore Search 版本及其相关组件版本的管理员和开发人员特别有用。
输出表包含两列：
Component：此列显示 Manticore Search 的具体组件名称。Version：此列显示对应组件的版本信息。
‹›
- SQL
- JSON
📋
⚙
mysql> SHOW VERSION;POST /sql?mode=raw -d "SHOW VERSION"
‹›
Response
+------------+-------------------------------------+
| Component | Version |
+------------+-------------------------------------+
| Daemon | 13.13.4 0bc5a9641@25101507 dev |
| Columnar | columnar 8.1.0 e1522a2@25100213 |
| Secondary | secondary 8.1.0 e1522a2@25100213 |
| Knn | knn 8.1.0 e1522a2@25100213 |
| Embeddings | embeddings 1.0.1 |
| Buddy | buddy v3.35.1+25090418-41d9811f-dev |
+------------+-------------------------------------+[
{
"total": 6,
"error": "",
"warning": "",
"columns": [
{
"Component": {
"type": "string"
}
},
{
"Version": {
"type": "string"
}
}
],
"data": [
{
"Component": "Daemon",
"Version": "13.13.4 0bc5a9641@25101507 dev"
},
{
"Component": "Columnar",
"Version": "columnar 8.1.0 e1522a2@25100213"
},
{
"Component": "Secondary",
"Version": "secondary 8.1.0 e1522a2@25100213"
},
{
"Component": "Knn",
"Version": "knn 8.1.0 e1522a2@25100213"
},
{
"Component": "Embeddings",
"Version": "embeddings 1.0.1"
},
{
"Component": "Buddy",
"Version": "buddy v3.35.1+25090418-41d9811f-dev"
}
]
}
]Last modified: April 13, 2026
KILL <query id>KILL 通过其 ID 终止查询的执行，您可以在 SHOW QUERIES 中找到该 ID。
‹›
- SQL
- JSON
📋
⚙
mysql> KILL 4;
Query OK, 1 row affected (0.00 sec)POST /sql?mode=raw -d "KILL 4"
[
{
"total": 1,
"error": "",
"warning": ""
}
]Last modified: April 13, 2026
SHOW WARNINGS 语句可用于检索最新查询产生的警告。错误信息将与查询本身一同返回：
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)Last modified: August 28, 2025