PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-tables.html
The global_status and session_status tables have these indexes: Primary key on (VARIABLE_NAME) The status_by_thread table contains the status of each active thread. The status_by_thread table has these indexes: Primary key on (THREAD_ID, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these indexes: Primary key on (VARIABLE_NAME) The variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the system variable is defined. The ... The ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The keyword INSERT indicates the trigger event; that is, the type ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Possible values are crashed, open, changed, analyzed, optimized keys, and sorted index pages. Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. Keyfile ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
From this page, you can apply a filter to modify the Available Products list and then select one or more products to move (using arrow keys) to the Products To Be Installed list. MySQL Installer provides a wizard-like tool to install and configure ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions.html
This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a string expected to be a key string in PEM format is not a valid key. asymmetric_decrypt(algorithm, data_str, priv_key_str) ... In ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming ...