PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system database. For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such ...Setting this variable does not in itself enable the logs; they must be enabled ... MySQL Server provides flexible control over the destination of output ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
In all cases where the source and target tables do not have identical definitions, the database and table names must be the same on both the source and the replica. In addition, when the replica's copy of the table has more columns than the source's ...In addition, corresponding table columns on the source and the replica can use different data types, subject to certain ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. If the private and public key files are located in the data directory and are named ...RSA ...
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 ...
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/mysql-cluster-overview.html
In a shared-nothing system, each component is expected to have its own memory and disk, and the use of shared storage mechanisms such as network shares, network file systems, and SANs is not recommended or supported. NDB Cluster integrates the ...
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/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. This facility is often used to move the data and index files to a ...
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 ...