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/replication-channels.html
When transactions from a source are received by a channel's receiver thread, they are added to the channel's relay log file and passed through to the channel's applier threads. The error codes and messages that are issued when multi-source ...The ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-crashing.html
Use the “copy and paste” method for any output and error messages from programs and log files. If you think the problem is in MySQL, you should also examine MySQL's log files. Use top, df, or a similar program to check whether you are out of ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
Find the precise binary log event position corresponding to the point in time up to which you want to restore your database. Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data ... The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
Support for XA transactions is available for the InnoDB storage engine. MySQL client programs must be able to send SQL statements and to understand the semantics of the XA statement interface. A global transaction involves several actions that are ...The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA ...In essence, this extends ACID properties “up a level” so that ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
The LATERAL keyword must precede each table to be used as a lateral derived table. If a lateral derived table is in the right operand of a join clause and contains a reference to the left operand, the join operation must be an INNER JOIN, CROSS ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Parameters in_thread_id BIGINT UNSIGNED: The thread ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. This is done ...In the latter case, you should run REPAIR TABLE on the ...
https://dev.mysql.com/doc/refman/8.0/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The available scripts differ in the file name used to refer to the script: ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
Remove (or move away) any old log files from the MySQL data directory if you need more space. The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the binary log to our bugs database using the ...For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or ...