Search Results
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
INSERT is also required for the ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE table-maintenance statements. OPTIMIZE_LOCAL_TABLE Enables use of OPTIMIZE LOCAL TABLE and OPTIMIZE NO_WRITE_TO_BINLOG TABLE statements. A user with this privilege can ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
This read method is mainly used to optimize ORDER BY ... Last_query_cost The total cost of the last compiled query as computed by the query optimizer. Last_query_partial_plans The number of iterations the query optimizer made in execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
(See Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”.) Example: UPDATE t ... In general, you may be able to influence the optimizer to materialize a derived table by ...
https://dev.mysql.com/doc/refman/8.4/en/system-variables-controlling-tracing.html
The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Under those conditions, the comparison in the WHERE clause occurs in different ways for ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. If a statement uses subqueries, there can be ...row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This can be useful mark when several traces are ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Common Table Expressions Recursive Common Table Expressions Limiting Common Table Expression Recursion Recursive Common Table Expression Examples Common Table Expressions Compared to Similar Constructs For information about CTE optimization, see ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...We solve this by introducing a separate MEM_ROOT object for storing the bind parameters array, which object can be cleared (deallocating the memory) on each call to mysql_stmt_bind_param() or ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
For information about how MySQL executes statements, see Optimizing Queries with EXPLAIN. For more information about cost estimates, see The Optimizer Cost Model. No usable indexes were found for the table, which forces the optimizer to search every ... The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the extended JSON ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual Studio. 5.8.2.1.1 Microsoft Access To improve ...