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/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic function loading during server startup and manual loading thereafter. While a loadable function is loaded, information about ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-enabling.html
The innodb_file_format configuration option enables an InnoDB file format for file-per-table tablespaces. Note The innodb_file_format configuration option is deprecated and may be removed in a future release. You can set the value of ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host address. Start the MySQL server with an appropriate bind_address setting to permit it to accept ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_native_password, which ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/reset.html
reset_option: { MASTER | QUERY CACHE | SLAVE } The RESET statement is used to clear the state of various server operations. The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE. Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. This ...