PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
If not, the server creates them in the data directory, populates them with metadata, and then proceeds with its normal startup sequence. Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The example uses the test.city table described in Creating a New Table and Column Mapping. When a range query finds multiple matching key-value pairs, results are returned in a key-value pair sequence. The examples use the test.city table described ... The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. In ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
The sampling-rate value in the HISTOGRAM column of the Information Schema COLUMN_STATISTICS table can be queried to determine the fraction of data that was sampled to create the histogram. row *************************** Table: employees.employees ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO OUTFILE 'file_name' ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...