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/comments.html
If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in execution of such commands, either invoke mysql with the --binary-mode option or use a reload client ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
The --skip-generated-invisible-primary-key option for mysqldump causes GIPK information to be excluded in the program's output. If you are importing a dump file that contains generated invisible primary keys and values, you can also use ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-server.html
The command mysqladmin debug dumps some information about locks in use, used memory and query usage to the MySQL log file. If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
Because these utilities create logical backups, the data dumped from encrypted tables is not encrypted. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB data-at-rest encryption? ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
The myisam_ftdump utility dumps the contents of a MyISAM full-text index. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
As a faster way of moving data than importing a dump file, which requires reinserting data and rebuilding indexes. This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
A buffer the size of this value is allocated for each thread that reads from the binary log and relay log files, including dump threads on sources and coordinator threads on replicas. MySQL allocates buffers and caches to improve performance of ...