PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. MySQL Enterprise Backup performs hot backup operations for MySQL databases. For completeness, it can also back up tables from MyISAM and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-encryption.html
These functions enable Enterprise applications to perform the following operations: Implement added data protection using public-key asymmetric cryptography Create public and private keys and digital signatures Perform asymmetric encryption and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
Invoke this version instead of mysqld for debugging support, memory allocation checking, and trace file support (see Section 5.8.1.2, “Creating Trace Files”). mysqld, also known as MySQL Server, is a single multithreaded program that does most ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
On the production server: $> mysqldump --all-databases --no-create-info > dump-data.sql On the upgraded server: $> mysql < dump-data.sql Now check the table contents and run some test queries. When contemplating a MySQL upgrade, it is prudent to ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. Permitted values are 0 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
To create these names, use the QB_NAME hint, which assigns a name to the query block in which it occurs: QB_NAME(name) QB_NAME hints can be used to make explicit in a clear way which query blocks other hints apply to. One means of control over ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
(See Section 14.6.2.1, “Clustered and Secondary Indexes”.) Create an AUTO_INCREMENT column as the primary key if your primary key is long, or index a prefix of a long VARCHAR column instead of the entire column. Once your data reaches a stable ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
On the CREATE INDEX statement, use the clause USING BTREE or USING HASH. Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM ...