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/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/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/mysql-cluster-ndbinfo-memoryusage.html
Suppose that the cluster has 2 data nodes having node IDs 5 and 6, and the config.ini file contains the following: [ndbd default] DataMemory = 1G IndexMemory = 1G Suppose also that the value of the LongMessageBuffer configuration parameter is ...The ... Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP ...
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/group-replication-deploying-locally.html
Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and initialize each one. mysql-8.0/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-8.0 --datadir=$PWD/data/s1 ...
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/replication-options-reference.html
master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location in source's binary log, to file or table. relay_log_recovery: Whether automatic recovery of relay log files ...
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/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/serialized-dictionary-information.html
For example, if the data dictionary becomes unavailable, object metadata can be extracted directly from InnoDB tablespace files using the ibd2sdi tool. For partitioned InnoDB tables comprised of multiple tablespaces, SDI data is stored in the ... In ...SDI data is updated by DDL operations on a table or CHECK TABLE FOR ...