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/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. Note There are easier alternatives to generating the files required for SSL than the procedure described here: Let ...The first two examples are intended for use on Unix and both use the openssl command that is part of ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ...Configure MySQL to perform a slow shutdown by setting innodb_fast_shutdown to ...In-place ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
InnoDB does not currently support foreign keys for tables with user-defined partitioning. This restriction does not apply for NDB tables that are partitioned by KEY or LINEAR KEY (the only user partitioning types supported by the NDB storage ...For ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
In the example, the trigger body is a simple SET that accumulates into a user variable the values inserted into the amount column. In a BEFORE trigger, you can also change its value with SET NEW.col_name = value if you have the UPDATE privilege for ...Here is a simple example that associates a trigger with a table, to activate for INSERT ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
--uid=name, -v Command-Line Format --uid=name The name of the user who should be the owner of any created files. In the absence of this option, files created by mysql_ssl_rsa_setup are owned by the user who executes it. It works as follows: ... This ...See Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
(See Section 4.2.2, “Specifying Program Options”.) The server also maintains a set of session variables for each client that connects. To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify ...System variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
A page can be read because it is required for a user-initiated operation such as an SQL query, or as part of a read-ahead operation performed automatically by InnoDB. If the page was read because it was required by a user-initiated operation, the ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
After the procedure returns, the effective privileges revert to those of the current user, which can still see the temporary table and perform any operation on it. One implication of this behavior is that a session can manipulate its temporary ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Unicode support for supplementary characters requires character sets that have a range outside BMP characters and therefore take more space than BMP characters (up to 4 bytes per character). utf16: The UTF-16 encoding for the Unicode character set ...For information about the Unicode Standard itself, visit the Unicode Consortium ... The Unicode Standard includes characters from the ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Queries that use different databases, different protocol versions, or different default character sets are considered different queries and are cached separately. It refers to ...