Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
When moving tablespace files to a different operating system, ensure that tablespace file names do not include prohibited characters or characters with a special meaning on the destination system. The innodb_directories variable, which defines ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community Edition of MySQL: From the MySQL software repositories: The MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different software download sites, software repositories, and so on. The following ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. A session can acquire multiple locks for the same lock ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-binary.html
(If you use a different archive program, be sure that it extracts all files and directories from the archive, and that it preserves the archive's directory structure.) When you are asked for a destination directory, enter C:\, which causes the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbinfo-select-all.html
ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ndbinfo database Not all ndbinfo tables available in the mysql client can be read by this program (see later in this section). In addition, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-logging.html
How Logging Occurs Controlling the History File syslog Logging Characteristics How Logging Occurs For each enabled logging destination, statement logging occurs as follows: Statements are logged only when executed interactively. The mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while ...