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/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. This procedure disables binary logging during its execution by manipulating the ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
Legal hexadecimal literals: X'01AF' X'01af' x'01AF' x'01af' 0x01AF 0x01af Illegal hexadecimal literals: X'0G' (G is not a hexadecimal digit) 0X01AF (0X must be written as 0x) Values written using X'val' notation must contain an even number of digits ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ... The scope of a local variable is the BEGIN ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only the effected partitions to be locked. For example, a SELECT from a partitioned MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute a definer-context stored procedure that executes with the privileges of a user who does have CREATE TEMPORARY TABLES and that creates a ... You ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. These files therefore are owned by the user who executes mysqldump. This section describes how ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use InnoDB on both the source and replica. It is possible to use replication in a way where the storage engine on the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
If the tablespace is not empty, DROP TABLESPACE returns an error. DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. It is supported with all MySQL NDB ...