Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
Explicit Error Log Configuration Note This configuration method is supported for backward compatibility. [mysqld] log_error_services='log_filter_internal; log_sink_internal; log_sink_json' Note To use the JSON log sink (log_sink_syseventlog) instead ... In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
For example: 2020-08-06T14:25:02.835618Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2020-08-06T14:25:02.936146Z 0 [Warning] [MY-010068] [Server] CA certificate /var/mysql/sslinfo/cacert.pem is self signed. 2020-08-06T14:25:03.109022Z 5 ... Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the content of the messages: The information available to the log ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
Note MySQL Workbench has a Visual Explain capability that provides a visual representation of EXPLAIN output. Note that this column is totally independent of the order of the tables as displayed in the output from EXPLAIN. Note An antijoin is the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
Note An API node is any application that makes direct use of Cluster data nodes for data storage and retrieval. Note NDB Cluster Disk Data tables (that is, tables created with TABLESPACE ... In the following section, we answer questions that are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Note In a replication environment, the source and each replica must have its own undo tablespace file directory. Note The InnoDB recovery process requires that undo tablespace files reside in known directories. DROP UNDO TABLESPACE tablespace_name; ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Note The procedure shown here does not set up any passwords for MySQL accounts. Then perform the following steps as the mysql user, except as noted. If you do reconfigure, take note of the following: If CMake is run after it has previously been run, ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
Note Configuring a session setting for internal_tmp_mem_storage_engine requires the SESSION_VARIABLES_ADMIN or SYSTEM_VARIABLES_ADMIN privilege. Note temptable_max_ram does not account for the thread-local memory block allocated to each thread that ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product. Note Only one keyring component or plugin should be enabled at a time. component_keyring_oci is part of the component ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
Distribution specific instructions are shown below: Red Hat Linux, Fedora, CentOS Note For a number of Linux distributions, you can install MySQL using the MySQL Yum repository instead of the platform's native software repository. Debian, Ubuntu, ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
Note RPM distributions of MySQL are also provided by other vendors. Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...