节点信息和管理 > SHOW QUERIES | Manticore Search Manual

SHOW META [ LIKE pattern ]

SHOW META 是一个 SQL 语句，用于显示关于处理查询的附加元信息，包括查询时间、关键词统计，以及所使用的二级索引的信息。语法为：

包含的项有：

total：实际检索并发送给客户端的匹配数。此值通常受限于 LIMIT/size 搜索选项。
total_found：
- 索引中查询的估计匹配总数。如果需要确切的匹配数，请使用 SELECT COUNT(*)，而不是依赖此值。
- 对于带有 GROUP BY 的查询，total_found 表示分组数，而非单个匹配。
- 使用 HAVING 与 GROUP BY 时，total_found 反映在应用 HAVING 过滤器后的分组数。这使得使用 HAVING 子句时能够正确分页。
- 对于 GROUP N BY 查询，total_found 仍表示分组数，与 N 的值无关。
total_relation：指示 total_found 值是确切的还是估计的。
- 如果 Manticore 无法确定精确的 total_found 值，此字段将显示 total_relation: gte，表示实际匹配数 大于等于 报告的 total_found。
- 如果 total_found 值是确切的，将显示 total_relation: eq。
time：处理搜索查询所花费的时间（秒）。
keyword[N]：搜索查询中使用的第 n 个关键词。注意关键词可以是通配符形式，例如 abc*。
docs[N]：包含搜索查询中第 n 个关键词的文档（或记录）总数。如果关键词是通配符形式，此值表示所有扩展子关键词文档数的总和，可能超过实际匹配文档数。
hits[N]：搜索查询中第 n 个关键词在所有文档中的总出现次数（或命中数）。
index：使用的索引信息（例如二级索引）。

‹›

SQL

📋

SELECT id, story_author FROM hn_small WHERE MATCH('one|two|three') and comment_ranking > 2 limit 5;
show meta;

‹›

Response

+---------+--------------+
| id      | story_author |
+---------+--------------+
|  151171 | anewkid      |
|  302758 | bks          |
|  805806 | drRoflol     |
| 1099245 | tnorthcutt   |
|  303252 | whiten       |
+---------+--------------+
5 rows in set (0.00 sec)
+----------------+---------------------------------------+
| Variable_name  | Value                                 |
+----------------+---------------------------------------+
| total          | 5                                     |
| total_found    | 2308                                  |
| total_relation | eq                                    |
| time           | 0.001                                 |
| keyword[0]     | one                                   |
| docs[0]        | 224387                                |
| hits[0]        | 310327                                |
| keyword[1]     | three                                 |
| docs[1]        | 18181                                 |
| hits[1]        | 21102                                 |
| keyword[2]     | two                                   |
| docs[2]        | 63251                                 |
| hits[2]        | 75961                                 |
| index          | comment_ranking:SecondaryIndex (100%) |
+----------------+---------------------------------------+
14 rows in set (0.00 sec)

SHOW META 可以显示 I/O 和 CPU 计数器，但仅在 searchd 是用 --iostats 和 --cpustats 开关分别启动时可用。

‹›

SQL

📋

SELECT id,channel_id FROM records WHERE MATCH('one|two|three') limit 5;
SHOW META;

‹›

Response

+--------+--------------+
| id     | story_author |
+--------+--------------+
| 300263 | throwaway37  |
| 713503 | mahmud       |
| 716804 | mahmud       |
| 776906 | jimbokun     |
| 753332 | foxhop       |
+--------+--------------+
5 rows in set (0.01 sec)
+-----------------------+--------+
| Variable_name         | Value  |
+-----------------------+--------+
| total                 | 5      |
| total_found           | 266385 |
| total_relation        | eq     |
| time                  | 0.011  |
| cpu_time              | 18.004 |
| agents_cpu_time       | 0.000  |
| io_read_time          | 0.000  |
| io_read_ops           | 0      |
| io_read_kbytes        | 0.0    |
| io_write_time         | 0.000  |
| io_write_ops          | 0      |
| io_write_kbytes       | 0.0    |
| agent_io_read_time    | 0.000  |
| agent_io_read_ops     | 0      |
| agent_io_read_kbytes  | 0.0    |
| agent_io_write_time   | 0.000  |
| agent_io_write_ops    | 0      |
| agent_io_write_kbytes | 0.0    |
| keyword[0]            | one    |
| docs[0]               | 224387 |
| hits[0]               | 310327 |
| keyword[1]            | three  |
| docs[1]               | 18181  |
| hits[1]               | 21102  |
| keyword[2]            | two    |
| docs[2]               | 63251  |
| hits[2]               | 75961  |
+-----------------------+--------+
27 rows in set (0.00 sec)

额外值，如 predicted_time、dist_predicted_time、local_fetched_docs、local_fetched_hits、local_fetched_skips 及其对应的 dist_fetched_*，仅在 searchd 配置了预测时间成本且查询在 OPTION 子句中包含 predicted_time 时可用。

‹›

SQL

📋

SELECT id,story_author FROM hn_small WHERE MATCH('one|two|three') limit 5 option max_predicted_time=100;
SHOW META;

‹›

Response

+--------+--------------+
| id     | story_author |
+--------+--------------+
| 300263 | throwaway37  |
| 713503 | mahmud       |
| 716804 | mahmud       |
| 776906 | jimbokun     |
| 753332 | foxhop       |
+--------+--------------+
5 rows in set (0.01 sec)
mysql> show meta;
+---------------------+--------+
| Variable_name       | Value  |
+---------------------+--------+
| total               | 5      |
| total_found         | 266385 |
| total_relation      | eq     |
| time                | 0.012  |
| local_fetched_docs  | 307212 |
| local_fetched_hits  | 407390 |
| local_fetched_skips | 24     |
| predicted_time      | 56     |
| keyword[0]          | one    |
| docs[0]             | 224387 |
| hits[0]             | 310327 |
| keyword[1]          | three  |
| docs[1]             | 18181  |
| hits[1]             | 21102  |
| keyword[2]          | two    |
| docs[2]             | 63251  |
| hits[2]             | 75961  |
+---------------------+--------+
17 rows in set (0.00 sec)

SHOW META 必须在相同会话中紧接查询之后执行。由于部分 MySQL 连接器/库使用连接池，分开执行 SHOW META 可能导致意外结果，比如获取到别的查询的元数据。在这类情况下（且通常推荐），应执行包含查询和 SHOW META 的多语句。有些连接器/库支持在同一方法内多语句执行，而另一些可能需要专用方法或连接时设置特定选项来支持多语句。

‹›

SQL

📋

SELECT id,story_author FROM hn_small WHERE MATCH('one|two|three') LIMIT 5; SHOW META;

‹›

Response

+--------+--------------+
| id     | story_author |
+--------+--------------+
| 300263 | throwaway37  |
| 713503 | mahmud       |
| 716804 | mahmud       |
| 776906 | jimbokun     |
| 753332 | foxhop       |
+--------+--------------+
5 rows in set (0.01 sec)
+----------------+--------+
| Variable_name  | Value  |
+----------------+--------+
| total          | 5      |
| total_found    | 266385 |
| total_relation | eq     |
| time           | 0.011  |
| keyword[0]     | one    |
| docs[0]        | 224387 |
| hits[0]        | 310327 |
| keyword[1]     | three  |
| docs[1]        | 18181  |
| hits[1]        | 21102  |
| keyword[2]     | two    |
| docs[2]        | 63251  |
| hits[2]        | 75961  |
+----------------+--------+
13 rows in set (0.00 sec)

你也可以使用可选的 LIKE 子句，允许你只选择匹配特定模式的变量。模式语法遵循标准 SQL 通配符规则，其中 % 表示任意数量的任意字符，_ 表示单个字符。

‹›

SQL

📋

SHOW META LIKE 'total%';

‹›

Response

+----------------+--------+
| Variable_name  | Value  |
+----------------+--------+
| total          | 5      |
| total_found    | 266385 |
| total_relation | eq     |
+----------------+--------+
3 rows in set (0.00 sec)

使用分面搜索时，你可以检查 SHOW META 输出中的 multiplier 字段，以确定在优化分组中执行了多少查询。

‹›

SQL

📋

SELECT * FROM facetdemo FACET brand_id FACET price FACET categories;
SHOW META LIKE 'multiplier';

‹›

Response

+------+-------+----------+---------------------+-------------+-------------+---------------------------------------+------------+
| id   | price | brand_id | title               | brand_name  | property    | j                                     | categories |
+------+-------+----------+---------------------+-------------+-------------+---------------------------------------+------------+
|    1 |   306 |        1 | Product Ten Three   | Brand One   | Six_Ten     | {"prop1":66,"prop2":91,"prop3":"One"} | 10,11      |
...
+----------+----------+
| brand_id | count(*) |
+----------+----------+
|        1 |     1013 |
...
+-------+----------+
| price | count(*) |
+-------+----------+
|   306 |        7 |
...
+------------+----------+
| categories | count(*) |
+------------+----------+
|         10 |     2436 |
...
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| multiplier    | 4     |
+---------------+-------+
1 row in set (0.00 sec)

当基于成本的查询优化器选择使用 DocidIndex、ColumnarScan 或 SecondaryIndex 替代简单过滤时，这可以从 SHOW META 命令中反映出来。

index 变量显示了查询执行期间使用的二级索引名称及类型。百分比表示有多少磁盘块（针对 RT 表）或伪分片（针对普通表）使用了该二级索引。

‹›

SQL

📋

SELECT count(*) FROM taxi1 WHERE tip_amount = 5;
SHOW META;

‹›

Response

+----------------+----------------------------------+
| Variable_name  | Value                            |
+----------------+----------------------------------+
| total          | 1                                |
| total_found    | 1                                |
| total_relation | eq                               |
| time           | 0.016                            |
| index          | tip_amount:SecondaryIndex (100%) |
+----------------+----------------------------------+
5 rows in set (0.00 sec)

SHOW META 可用于执行 CALL PQ 语句后，其输出内容不同。

CALL PQ 后的 SHOW META 包含：

total - 匹配文档所花费的总时间
queries_matched - 匹配文档的存储查询数
document_matches - 匹配表中存储查询的文档数
total_queries_stored - 表中存储的查询总数
term_only_queries - 表中包含词项的查询数；其余查询使用扩展查询语法。

‹›

SQL

📋

CALL PQ ('pq', ('{"title":"angry", "gid":3 }')); SHOW META;

‹›

Response

+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)
+-----------------------+-----------+
| Variable name         | Value     |
+-----------------------+-----------+
| total                 | 0.000 sec |
| queries_matched       | 1         |
| queries_failed        | 0         |
| document_matched      | 1         |
| total_queries_stored  | 2         |
| term_only_queries     | 2         |
| fast_rejected_queries | 1         |
+-----------------------+-----------+
7 rows in set (0.00 sec)

使用 CALL PQ 带有 verbose 选项可以提供更详细的输出。

它包括以下额外条目：

Setup - 初始匹配过程的设置时间，例如解析文档和设置选项
Queries failed - 失败的查询数量
Fast rejected queries - 未完全评估但快速匹配并被过滤或其他条件拒绝的查询数量
Time per query - 每个查询的详细时间
Time of matched queries - 匹配任何文档的查询所花费的总时间

‹›

SQL

📋

CALL PQ ('pq', ('{"title":"angry", "gid":3 }'), 1 as verbose); SHOW META;

‹›

Response

+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)
+-------------------------+-----------+
| Variable name           | Value     |
+-------------------------+-----------+
| total                   | 0.000 sec |
| setup                   | 0.000 sec |
| queries_matched         | 1         |
| queries_failed          | 0         |
| document_matched        | 1         |
| total_queries_stored    | 2         |
| term_only_queries       | 2         |
| fast_rejected_queries   | 1         |
| time_per_query          | 69        |
| time_of_matched_queries | 69        |
+-------------------------+-----------+
10 rows in set (0.00 sec)

SHOW THREADS

Last modified: November 17, 2025

SHOW THREADS [ OPTION columns=width[,format=sphinxql][,format=all] ]

SHOW THREADS 是一个 SQL 语句，用于显示所有线程及其当前活动的信息。

结果表包含以下列：

TID：内核为线程分配的 ID
Name：线程名称，也可在 top、htop、ps 等进程查看工具中看到
Proto：连接协议；可能的值包括 sphinx、mysql、http、ssl、compressed、replication 或它们的组合（例如 http,ssl 或 compressed,mysql）
State：线程状态；可能的值为 handshake、net_read、net_write、query、net_idle
Connection from：客户端的 ip:port
ConnID：连接 ID（从 0 开始）
This/prev job time：当线程忙碌时 - 当前任务运行的时间；当线程空闲时 - 前一个任务的持续时间 + 后缀 prev
Jobs done：此线程已完成的任务数量
Thread status：idling 或 working
Info：查询信息，如果查询针对分布式表或实时表，则可能包含多个查询

‹›

SQL
JSON
PHP
Python
Python-asyncio
javascript
Java
C#
Rust
TypeScript
Go

📋

SHOW THREADS;

POST /cli -d "SHOW THREADS"

require_once __DIR__ . '/vendor/autoload.php';
$config = ['host'=>'127.0.0.1','port'=>9308];
$client = new \Manticoresearch\Client($config);
print_r($client->nodes()->threads());

import manticoresearch
config = manticoresearch.Configuration(
            host = "http://127.0.0.1:9308"
            )
client = manticoresearch.ApiClient(config)
utilsApi = manticoresearch.UtilsApi(client)
print(utilsApi.sql('SHOW THREADS'))

import manticoresearch
config = manticoresearch.Configuration(
            host = "http://127.0.0.1:9308"
            )
client = manticoresearch.ApiClient(config)
utilsApi = manticoresearch.UtilsApi(client)
res = await utilsApi.sql('SHOW THREADS')
print(res)

var Manticoresearch = require('manticoresearch');
var utilsApi = new Manticoresearch.UtilsApi();
async function showThreads() {
    res = await utilsApi.sql('SHOW THREADS');
    console.log(JSON.stringify(res, null, 4));
}
showThreads();

utilsApi.sql("SHOW THREADS");

utilsApi.Sql("SHOW THREADS");

utils_api.sql("SHOW THREADS", Some(true)).await;

res = await utilsApi.sql('SHOW THREADS');

apiClient.UtilsAPI.Sql(context.Background()).Body("SHOW THREADS").Execute()

‹›

Response

*************************** 1. row ***************************
                TID: 83
               Name: work_1
              Proto: mysql
              State: query
    Connection from: 172.17.0.1:43300
             ConnID: 8
 This/prev job time: 630us
       CPU activity: 94%
          Jobs done: 2490
      Thread status: working
               Info: SHOW THREADS
*************************** 2. row ***************************
                TID: 84
               Name: work_2
              Proto: mysql
              State: query
    Connection from: 172.17.0.1:43301
             ConnID: 9
 This/prev job time: 689us
       CPU activity: 89%
          Jobs done: 1830
      Thread status: working
               Info: show threads

+--------+---------+-------+-------+-----------------+--------+-----------------------+-----------+---------------+--------------+
| TID    | Name    | Proto | State | Connection from | ConnID | This/prev job time, s | Jobs done | Thread status | Info         |
+--------+---------+-------+-------+-----------------+--------+-----------------------+-----------+---------------+--------------+
| 501494 | work_23 | http  | query | 127.0.0.1:41300 | 1473   | 249us                 | 1681      | working       | show_threads |
+--------+---------+-------+-------+-----------------+--------+-----------------------+-----------+---------------+--------------+

Array
(
    [0] => Array
        (
            [TID] => 506960
            [Name] => work_8
            [Proto] => http
            [State] => query
            [Connection from] => 127.0.0.1:38072
            [ConnID] => 17
            [This/prev job time, s] => 231us
            [CPU activity] => 94%
            [Jobs done] => 8
            [Thread status] => working
            [Info] => show_threads
        )
)

[{'columns': [{'TID': {'type': 'long'}}, {'Name': {'type': 'string'}}, {'Proto': {'type': 'string'}}, {'State': {'type': 'string'}}, {'Connection from': {'type': 'string'}}, {'ConnID': {'type': 'long long'}}, {'This/prev job time, s': {'type': 'string'}}, {'CPU activity': {'type': 'string'}}, {'Jobs done': {'type': 'long'}}, {'Thread status': {'type': 'string'}}, {'Info': {'type': 'string'}}], 'data': [{'TID': 506958, 'Name': 'work_6', 'Proto': 'http', 'State': 'query', 'Connection from': '127.0.0.1:38600', 'ConnID': 834, 'This/prev job time, s': '206us', 'CPU activity': '92%', 'Jobs done': 943, 'Thread status': 'working', 'Info': 'show_threads'}], 'total': 1, 'error': '', 'warning': ''}]

[{'columns': [{'TID': {'type': 'long'}}, {'Name': {'type': 'string'}}, {'Proto': {'type': 'string'}}, {'State': {'type': 'string'}}, {'Connection from': {'type': 'string'}}, {'ConnID': {'type': 'long long'}}, {'This/prev job time, s': {'type': 'string'}}, {'CPU activity': {'type': 'string'}}, {'Jobs done': {'type': 'long'}}, {'Thread status': {'type': 'string'}}, {'Info': {'type': 'string'}}], 'data': [{'TID': 506958, 'Name': 'work_6', 'Proto': 'http', 'State': 'query', 'Connection from': '127.0.0.1:38600', 'ConnID': 834, 'This/prev job time, s': '206us', 'CPU activity': '92%', 'Jobs done': 943, 'Thread status': 'working', 'Info': 'show_threads'}], 'total': 1, 'error': '', 'warning': ''}]

[
    {
        "columns": [
            {
                "TID": {
                    "type": "long"
                }
            },
            {
                "Name": {
                    "type": "string"
                }
            },
            {
                "Proto": {
                    "type": "string"
                }
            },
            {
                "State": {
                    "type": "string"
                }
            },
            {
                "Connection from": {
                    "type": "string"
                }
            },
            {
                "ConnID": {
                    "type": "long long"
                }
            },
            {
                "This/prev job time, s": {
                    "type": "string"
                }
            },
            {
                "CPU activity": {
                    "type": "string"
                }
            },
            {
                "Jobs done": {
                    "type": "long"
                }
            },
            {
                "Thread status": {
                    "type": "string"
                }
            },
            {
                "Info": {
                    "type": "string"
                }
            }
        ],
        "data": [
            {
                "TID": 506964,
                "Name": "work_12",
                "Proto": "http",
                "State": "query",
                "Connection from": "127.0.0.1:36656",
                "ConnID": 2884,
                "This/prev job time, s": "236us",
                "CPU activity": "92%",
                "Jobs done": 3328,
                "Thread status": "working",
                "Info": "show_threads"
            }
        ],
        "total": 1,
        "error": "",
        "warning": ""
    }
]

{
  columns=[
    {
      TID={
        type=string
      }
    },
    {
      Name={
        type=string
      }
    },
    {
      Proto={
        type=string
      }
    },
    {
      State={
        type=string
      }
    },
    {
      Connection from={
        type=string
      }
    },
    {
      ConnID={
        type=string
      }
    },
    {
      This/prev job time={
        type=string
      }
    },
    {
      CPU activity={
        type=string
      }
    },
    {
      Jobs done={
        type=string
      }
    },
    {
      Thread status={
        type=string
      }
    },
    {
      Info={
        type=string
      }
    }
  ],
  data=[
    {
      TID=82,
      Name=work_0,
      Proto=http,
      State=query,
      Connection from=172.17.0.1:60550,
      ConnID=163,
      This/prev job time=105us,
      CPU activity=45%,
      Jobs done=849,
      Thread status=working,
      Info=show_threads
    }
  ],
  total=0,
  error=,
  warning=
}

{
  columns=[
    {
      TID={
        type=string
      }
    },
    {
      Name={
        type=string
      }
    },
    {
      Proto={
        type=string
      }
    },
    {
      State={
        type=string
      }
    },
    {
      Connection from={
        type=string
      }
    },
    {
      ConnID={
        type=string
      }
    },
    {
      This/prev job time= {
        type=string
      }
    },
    {
      Jobs done={
        type=string
      }
    },
    {
      Thread status={
        type=string
      }
    },
    {
      Info={
        type=string
      }
    }
  ],
  data=[
    {
      TID=83,
      Name=work_1,
      Proto=http,
      State=query,
      Connection from=172.17.0.1:41410,
      ConnID=6,
      This/prev job time=689us,
      Jobs done=159,
      Thread status=working,
      Info=show_threads
    }
  ],
  total=0,
  error="",
  warning=""
}

{
  columns=[
    {
      TID={
        type=string
      }
    },
    {
      Name={
        type=string
      }
    },
    {
      Proto={
        type=string
      }
    },
    {
      State={
        type=string
      }
    },
    {
      Connection from={
        type=string
      }
    },
    {
      ConnID={
        type=string
      }
    },
    {
      This/prev job time= {
        type=string
      }
    },
    {
      Jobs done={
        type=string
      }
    },
    {
      Thread status={
        type=string
      }
    },
    {
      Info={
        type=string
      }
    }
  ],
  data=[
    {
      TID=83,
      Name=work_1,
      Proto=http,
      State=query,
      Connection from=172.17.0.1:41410,
      ConnID=6,
      This/prev job time=689us,
      Jobs done=159,
      Thread status=working,
      Info=show_threads
    }
  ],
  total=0,
  error="",
  warning=""
}

[
    {
        "columns": [
            {
                "TID": {
                    "type": "long"
                }
            },
            {
                "Name": {
                    "type": "string"
                }
            },
            {
                "Proto": {
                    "type": "string"
                }
            },
            {
                "State": {
                    "type": "string"
                }
            },
            {
                "Connection from": {
                    "type": "string"
                }
            },
            {
                "ConnID": {
                    "type": "long long"
                }
            },
            {
                "This/prev job time, s": {
                    "type": "string"
                }
            },
            {
                "CPU activity": {
                    "type": "string"
                }
            },
            {
                "Jobs done": {
                    "type": "long"
                }
            },
            {
                "Thread status": {
                    "type": "string"
                }
            },
            {
                "Info": {
                    "type": "string"
                }
            }
        ],
        "data": [
            {
                "TID": 506964,
                "Name": "work_12",
                "Proto": "http",
                "State": "query",
                "Connection from": "127.0.0.1:36656",
                "ConnID": 2884,
                "This/prev job time, s": "236us",
                "CPU activity": "92%",
                "Jobs done": 3328,
                "Thread status": "working",
                "Info": "show_threads"
            }
        ],
        "total": 1,
        "error": "",
        "warning": ""
    }
]

[
    {
        "columns": [
            {
                "TID": {
                    "type": "long"
                }
            },
            {
                "Name": {
                    "type": "string"
                }
            },
            {
                "Proto": {
                    "type": "string"
                }
            },
            {
                "State": {
                    "type": "string"
                }
            },
            {
                "Connection from": {
                    "type": "string"
                }
            },
            {
                "ConnID": {
                    "type": "long long"
                }
            },
            {
                "This/prev job time, s": {
                    "type": "string"
                }
            },
            {
                "CPU activity": {
                    "type": "string"
                }
            },
            {
                "Jobs done": {
                    "type": "long"
                }
            },
            {
                "Thread status": {
                    "type": "string"
                }
            },
            {
                "Info": {
                    "type": "string"
                }
            }
        ],
        "data": [
            {
                "TID": 506964,
                "Name": "work_12",
                "Proto": "http",
                "State": "query",
                "Connection from": "127.0.0.1:36656",
                "ConnID": 2884,
                "This/prev job time, s": "236us",
                "CPU activity": "92%",
                "Jobs done": 3328,
                "Thread status": "working",
                "Info": "show_threads"
            }
        ],
        "total": 1,
        "error": "",
        "warning": ""
    }
]

Info 列显示：

通过 Manticore SQL 接口执行的查询的原始文本
通过内部 Manticore 二进制协议运行的查询的完整文本语法、注释和数据大小（例如，来自远程 Manticore 实例的查询）

可以通过指定 columns=N 选项来限制 Info 列的最大宽度。

默认情况下，查询以原始格式显示。然而，当使用 format=sphinxql 选项时，查询将以 SQL 格式显示，而与执行时使用的协议无关。

使用 format=all 将显示所有线程，而没有此选项时，空闲和系统线程将被隐藏（例如，那些忙于 OPTIMIZE 的线程）。

‹›

SQL
JSON
PHP
Python
Python-asyncio
javascript
Java
C#
Rust
TypeScript
Go

📋

SHOW THREADS OPTION columns=30\G

POST /cli -d "SHOW THREADS OPTION columns=30"

$client->nodes()->threads(['body'=>['columns'=>30]]);

utilsApi.sql('SHOW THREADS OPTION columns=30')

await utilsApi.sql('SHOW THREADS OPTION columns=30')

res = await utilsApi.sql('SHOW THREADS OPTION columns=30');

utilsApi.sql("SHOW THREADS OPTION columns=30");

utilsApi.Sql("SHOW THREADS OPTION columns=30");

utils_api.sql("SHOW THREADS OPTION columns=30", Some(true)).await;

res = await utilsApi.sql('SHOW THREADS OPTION columns=30');

apiClient.UtilsAPI.Sql(context.Background()).Body("SHOW THREADS OPTION columns=30").Execute()

SHOW META SHOW QUERIES

Last modified: August 28, 2025

SHOW QUERIES

注意: SHOW QUERIES 需要 Manticore Buddy。如果不起作用，请确保已安装 Buddy。

SHOW QUERIES 返回所有当前运行查询的信息。输出是一个具有以下结构的表格：

id: 可用于在 KILL 中终止查询的查询 ID
query: 查询语句或其一部分
time: 命令执行所花时间或查询执行多久之前（在这种情况下，值将包含 ago）
protocol: 连接协议，可能的值为 sphinx、mysql、http、ssl、compressed、replication 或它们的组合（例如 http,ssl 或 compressed,mysql）
host: 客户端的 ip:port

‹›

SQL

📋

mysql> 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)

如需从线程本身的视角获得见解，请参阅 SHOW THREADS。

SHOW THREADS SHOW VERSION

Last modified: August 28, 2025

SHOW VERSION

注意：SHOW VERSION 需要 Manticore Buddy。如果无法使用，请确保已安装 Buddy。

SHOW VERSION 提供 Manticore Search 实例各个组件的详细版本信息。该命令对需要验证所运行的 Manticore Search 版本及其相关组件版本的管理员和开发人员特别有用。

输出表包含两列：

Component：此列显示 Manticore Search 的具体组件名称。
Version：此列显示对应组件的版本信息。

‹›

SQL

📋

mysql> SHOW VERSION;

‹›

Response

+------------+--------------------------------+
| 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       |
| Embeddings | embeddings 1.0.0               |
| Buddy      | buddy v2.0.11                  |
+------------+--------------------------------+

SHOW QUERIES KILL

Last modified: August 28, 2025

SHOW META

SHOW META 和 facets

SHOW META 和查询优化器

SHOW META 用于 PQ 表

显示线程

显示查询

SHOW VERSION