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/mysqlcheck.html
(This is also true for the MySQL upgrade procedure if it determines that table checking is needed because it processes tables the same way.) mysqlcheck must be used when the mysqld server is running, which means that you do not have to stop the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
To avoid this issue, either set the mysqldump option --set-gtid-purged to OFF or COMMENTED to output the second dump file without an active SET @@GLOBAL.gtid_purged statement, or remove the statement manually before replaying the dump file. This ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
Since it is possible to restore metadata and table data separately, you can in such cases restore the table schemas from a dump made using mysqldump, or by executing the necessary CREATE TABLE statements manually, then import only the table data ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
ndb_sync_excluded_objects: Shows information about NDB database objects for which automatic synchronization has failed due to permanent errors resulting from mismatches which cannot be reconciled without manual intervention; these objects are ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. The replication_applier_configuration table has these columns: CHANNEL_NAME The replication channel which this row is displaying. This is escaped so that ...Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. This is used to tell whether statements currently are accessing the function.
https://dev.mysql.com/doc/refman/8.0/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For other platforms and installation types, you must initialize the data directory manually.
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
For distributions that do not do this, you must initialize the data directory manually. To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
This statement has no effect if the server was not started with the --log-bin option to enable binary logging. If you have an active replica that currently is reading one of the log files you are trying to delete, this statement does not delete the ... PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
For example, this is permitted: LOCK TABLE old_table1 WRITE; RENAME TABLE old_table1 TO new_table1, new_table1 TO new_table2; This is not permitted: LOCK TABLE old_table1 READ; RENAME TABLE old_table1 TO new_table1, new_table1 TO new_table2; Prior ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...