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/mysql-cluster-rolling-restart.html
This can be done in any of three ways: Start each data node process (ndbd or possibly ndbmtd) with the --initial option, which forces the data node to clear its file system and to reload all NDB Cluster data and metadata from the other data nodes.
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...Data_length For MyISAM, Data_length is the length of the data file, in ...See Chapter ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump command. (Ideally, the InnoDB tables should represent a substantial majority of the data.) Tables from other storage engines are copied ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
In most cases, you need to install the mysql-community-server, mysql-community-client, mysql-community-client-plugins, mysql-community-libs, mysql-community-icu-data-files, mysql-community-common, and mysql-community-libs-compat packages to get a ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
Session data are stored to a file and you specify this file when you invoke the client again. Use the ssl_session_data_print command to specify the path to a file where you can store the currently active session data securely. To reuse the session ...This section describes the conditions that are favorable for SSL session reuse, the server variables used for managing and monitoring the session cache, and the client command-line options for storing and reusing session ...Server-Side ...
https://dev.mysql.com/doc/refman/8.0/en/clone.html
CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | INSTANCE FROM 'user'@'host':port IDENTIFIED BY 'password' [DATA DIRECTORY [=] 'clone_dir'] [REQUIRE [NO] SSL] } The CLONE statement is used to clone data locally or from a ...The MySQL server requires the necessary write access to create the specified ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
Alternatively, on any version of Windows supported by MySQL, you can create a symbolic link to a MySQL database by creating a .sym file in the data directory that contains the path to the destination directory. The file should be named db_name.sym, ...Use of database symlinks on Windows is similar to their use on Unix, although the procedure for setting up the link ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. In order of occurrence, cloning operation stage events include: stage/innodb/clone (file copy): Indicates progress of the file ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
SET can also be used to persist certain global system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To augment administrative capabilities for server configuration beyond what is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
The number of bytes shown as Free extent_space is available for storing on-disk column data from the fish table only; for this reason, it is not visible when selecting from the Information Schema FILES table. In other words, 1048576 - 1044440 = 4136 ...The Version column in the output contains the table's schema object ...