php - 为什么mysql解释分析不起作用？

Question

除了拥有 mariadb 10.1.36-MariaDB 之外，我还收到以下错误。

EXPLAIN ANALYZE select 1
MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ANALYZE select 1' at line 1

我还需要在这里做什么。我的 PHP 版本是 7.2.11。

Answer 1

正如您在文档中看到的 https://mariadb.com/kb/en/explain-analyze/

The syntax for the EXPLAIN ANALYZE feature was changed to ANALYZE statement, available since MariaDB 10.1.0. See ANALYZE statement.

所以只需使用 ANALYZE ...如果没有解释关键字，您将获得与过去相同的输出。
在 the analyze docs您有 ANALYZE 的信息声明，您可以看到它与已弃用的 EXPLAIN ANALYZE 相同.

The ANALYZE statement is similar to the EXPLAIN statement. ANALYZE statement will invoke the optimizer, execute the statement, and then produce EXPLAIN output instead of the result set. The EXPLAIN output will be annotated with statistics from statement execution.

The syntax is

ANALYZE explainable_statement;

where the statement is any statement for which one can run EXPLAIN.