PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
If the statement produces a result set, each column is converted to internal storage engine format that the FEDERATED engine expects and can use to display the result to the client that issued the original statement. A FEDERATED table consists of ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed to reproduce the original database object definitions and table data for transfer to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-troubleshooting.html
You should check that there is enough memory allocated for the backup. Important If you have set BackupDataBufferSize and BackupLogBufferSize and their sum is greater than 4MB, then you must also set BackupMemory as well. This is due to the fact ...
https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. If your table is big and important, ...With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the INFORMATION_SCHEMA database: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%'; For table definitions, see Section 24.4, “INFORMATION_SCHEMA ... This section provides information and usage examples for InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. Next, for every table in the query, we ...row ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_SCHEMA The name of the schema (database) containing the unique constraint that the constraint references. The possible values are CASCADE, SET ...
https://dev.mysql.com/doc/refman/5.7/en/firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. For a given ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting existing code that uses MySQL or the memcached API. You can perform the conversion on the application side, or by using the CAST() ...