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/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. This includes any default value implied for this option by the setting of the InitialLogFileGroup data node ...For ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement creates a new log file group named logfile_group having a single UNDO file named ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
REORGANIZE PARTITION: ALTER TABLE table_name REORGANIZE PARTITION partition_name INTO (partition_definition TABLESPACE=innodb_file_per_table); There must be no queries and stored program definitions from MySQL 8.0.12 or lower that use ASC or DESC ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
You cannot use the group_replication_clone_threshold system variable to deactivate cloning when the required transactions are not available in any member's binary log files, because in that situation cloning is the only alternative to transferring ...To use cloning, at least one existing group member and the joining member must be set up beforehand to support remote cloning ...If you want to use remote cloning ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html
Like ndb_print_backup_file and ndb_print_schema_file (and unlike most of the NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_redo_log_reader must be run on a cluster data node, since it ...redo log files are located in the numbered directories under the data node's data directory (DataDir); the path under this directory to the redo log files matches the pattern ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Alternatively, if you have a MySQL source distribution, you can test your setup using the demonstration certificate and key files in its mysql-test/std_data directory. (The files need not have been generated automatically; what matters is that they ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
These keyring components are available: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host. These ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Table information must be read from the data dictionary and by reading table files. Using filesort (JSON property: using_filesort) MySQL must do an extra pass to find out how to retrieve the rows in sorted order. That is, the named index covers the ... The EXPLAIN statement provides information about how MySQL executes ...Note MySQL Workbench has a Visual ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
When notified by FOR EXPORT, InnoDB writes to disk certain kinds of data that is normally held in memory or in separate disk buffers outside the tablespace files. For each table, InnoDB also produces a file named table_name.cfg in the same database ...FLUSH ERROR LOGS Closes and reopens any error log file to which the server is ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the statement, quoted references to the alias must use identifier quoting or the ...This ... An alias can be used in a query select list to give a column a different ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
To use client programs, mysqld must be running, because clients gain access to databases by connecting to the server. mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo ...