PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of some plugin that is listed in the mysql.plugin table. The server executes the ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/8.0/en/using-stack-trace.html
On some operating systems, the error log contains a stack trace if mysqld dies unexpectedly. You can use this to find out where (and maybe why) mysqld died. To get a stack trace, you must not compile mysqld with the -fomit-frame-pointer option to ...If you see no messages after this, something went terribly ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-disabling.html
The X Plugin can be disabled at startup by either setting mysqlx=0 in your MySQL configuration file, or by passing in either --mysqlx=0 or --skip-mysqlx when starting the MySQL server. Alternatively, use the -DWITH_MYSQLX=OFF CMake option to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
total_latency The total wait time of timed occurrences of the statement. max_latency The maximum single wait time of timed occurrences of the statement. avg_latency The average wait time per timed occurrence of the statement. lock_latency The total ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. Consider increasing the value if you experience slower response times due to long-running ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. If a CTE is materialized by a query, it is materialized once for the query, even if the query references it several times. This is similar to automatic ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
With the first approach, the group takes the minimum time possible to secure a stable group membership after a primary failure by electing a new primary and then allowing data access immediately while it is still applying any possible backlog from ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ...If you disable a consumer, ... Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be ...