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/myisam-key-cache.html
(In other words, table index blocks are accessed using the same strategy as that employed for table data blocks.) An index block is a contiguous unit of access to the MyISAM index files. When data from any table index block must be accessed, the ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data directory. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups.html
For larger databases, where mysqldump would be impractical or inefficient, you can back up the raw data files instead. Using the raw data files option also means that you can back up the binary and relay logs that make it possible to re-create the ... To use replication as a backup solution, replicate data from the source to a replica, and then back up the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-delete-all.html
Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
--core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging. --no-defaults Command-Line Format --no-defaults Do not read default options from any option file other than login file. You can obtain row counts ... ndb_select_count prints the number of rows in one or more NDB ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/ndb-restore-to-different-version.html
Tables created in versions of NDB prior to 8.0 use .frm files for their metadata. These files can be read by the mysqld in NDB 8.0, which can use the information contained therein to create the .sdi files used by the MySQL data dictionary in later ...Due to changes in how the MySQL Server and NDB handle table metadata, tables created or altered using the included MySQL server binary from NDB 8.0 cannot be restored using ndb_restore to NDB 7.6 or an earlier version of NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-pitr.html
Clear the data node file systems (using ndbd --initial or ndbmtd --initial). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...# ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
This entails training each account profile individually because each one must be trained using the single account to which it applies. Group profile names are chosen by the firewall administrator with no constraints other than that their length must ...Enabling or Disabling the Firewall Assigning Firewall Privileges Firewall Concepts Registering Firewall Group Profiles Registering Firewall Account Profiles Monitoring the Firewall Migrating Account Profiles to Group Profiles Enabling or Disabling the Firewall To enable or disable the firewall, set the mysql_firewall_mode system ...