Search Results
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. Thus, it does not cause ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...
https://dev.mysql.com/doc/refman/8.4/en/windows-choosing-package.html
The optional MySQL test suite, MySQL benchmark suite, and debugging binaries/information components (including PDB files) are in a separate compressed file named mysql-VERSION-winx64-debug-test.zip. For MySQL 8.4, there are multiple installation ...
https://dev.mysql.com/doc/refman/8.4/en/windows-server-first-start.html
This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/index.html
Abstract This document contains release notes for the changes in MySQL 8.4. For information about changes in a different version of MySQL, see the release notes for that version. For additional MySQL 8.4 documentation, see the MySQL 8.4 Reference ...