PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. When you use a ... For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
The file I/O summary tables have these indexes: file_summary_by_event_name: Primary key on (EVENT_NAME) file_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for file ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
REQUIRE_TABLE_PRIMARY_KEY_CHECK Whether the channel requires primary keys always, never, or according to the source's setting (CHANGE REPLICATION SOURCE TO option: REQUIRE_TABLE_PRIMARY_KEY_CHECK, CHANGE MASTER TO option: ... This table shows the ...
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/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/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 ...