PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.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/group-replication-group-membership.html
In MySQL Group Replication, a set of servers forms a replication group. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are ...A group has a name, which takes the form of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
Limiting Buffer Flushing During Idle Periods As of MySQL 8.0.18, you can use the innodb_idle_flush_pct variable to limit the rate of buffer pool flushing during idle periods, which are periods of time that database pages are not modified. In MySQL ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. Wait times for active sockets are ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. See Section 17.16, “InnoDB Integration with MySQL Performance ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
Example wait event summary information: mysql> SELECT * FROM performance_schema.events_waits_summary_global_by_event_name\G ... row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: ...