PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-session-account-connect-attrs-table.html
For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. The session_account_connect_attrs table contains connection attributes only for the current session, and other sessions associated with ... Application programs can provide key-value connection attributes to be passed to the server at connect ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-session-connect-attrs-table.html
For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. To see connection attributes only for the current session, and other sessions associated with the session account, use the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-consumers-table.html
The setup_consumers table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_consumers table. For detailed information about the effect of enabling different consumers, see Section 29.4.7, “Pre-Filtering by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.0/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. Some variable changes require that you rebuild the FULLTEXT indexes in your tables. Note Minimum and maximum ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or ...