PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. --dns-srv-name=name Command-Line Format --dns-srv-name=name Introduced 8.0.22 Type String Specifies the name of a DNS SRV record that determines the candidate ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
In such cases, it is necessary to alter any tables using utf8mb4_ai_ci so that they use a character set supported in the older version prior to performing the backup. Due to changes in how the MySQL Server and NDB handle table metadata, tables ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-compression.html
Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ALTER TABLE. This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...