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/server-status-variables.html
Slave_rows_last_search_algorithm_used The search algorithm that was most recently used by this replica to locate rows for row-based replication. Connection_errors_peer_address The number of errors that occurred while searching for connecting client ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/index.html
Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6 Abstract This is the MySQL Reference Manual. This manual describes features that are not included in every edition of MySQL 5.7; such features may not be included in the edition of MySQL 5.7 ...It ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group consistent. In practice, this means that a server that is leaving tells others that it is going away. This ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
You can also get this list using the mysqlshow --status db_name command. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40% to 50%. (This is also true if the InnoDB table ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
This enables you to pass values from one statement to another. (This is the same coercibility as for table column values.) Hexadecimal or bit values assigned to user variables are treated as binary strings. This does not currently include contexts ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
Installation can be performed using a graphical interface or manually: On Windows, MySQL Installer includes an option to enable MySQL Enterprise Firewall for you. Manual MySQL Enterprise Firewall installation involves running a script located in the ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.6.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
If you select this option, you are responsible for securing the Data folder and its related files manually after the server configuration finishes. This does not apply to files and directories for specific products, such as the MySQL server data ...