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/mysqlbinlog.html
If you send the output to the same MySQL server, this may lead to an endless loop. The server's binary log consists of files containing “events” that describe modifications to database contents. To display their contents in text format, use the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
One implication of the non-use of mysqld_safe on platforms that use systemd for server management is that use of [mysqld_safe] or [safe_mysqld] sections in option files is not supported and might lead to unexpected behavior. mysqld_safe is the ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
Namespace-specific address spaces can lead to problems when MySQL connections cross namespaces. A network namespace is a logical copy of the network stack from the host system. Network namespaces are useful for setting up containers or virtual ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
Leading and trailing spaces not inside double quotation marks are ignored. Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
When you specify the number of partitions for the table, this must be expressed as a positive, nonzero integer literal with no leading zeros, and may not be an expression such as 0.8E+01 or 6-2, even if it evaluates to an integer value. This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
With each iteration, investigation should lead closer and closer to the root cause of the problem, as the “signal/noise” ratio improves, making analysis easier. The Performance Schema is a tool to help a DBA do performance tuning by taking real ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
If the server has insufficient resources for the plugin's instruments and you do not explicitly allocate more using --performance_schema_max_mutex_classes=N, loading the plugin leads to starvation of instruments. Names for these variables have ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
This is less efficient; it may also lead to the parameter's (or variable's) actual type to vary, and thus for results to be inconsistent, with subsequent executions of the prepared statement. PREPARE stmt_name FROM preparable_stmt The PREPARE ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Prior to MySQL 8.0, any user could execute the XA RECOVER statement to discover the XID values for outstanding prepared XA transactions, possibly leading to commit or rollback of an XA transaction by a user other than the one who started it. The ...