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/federated-create.html
You can either create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the CONNECTION, or you can use an existing connection that you have previously ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
(See Section 5.1.7, “Server System Variables”.) The variable value should be the path name of the file containing the stopword list, or the empty string to disable stopword filtering. The stopword list is loaded and searched for full-text ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. MySQL 5.7 supports one status variable providing information about Group Replication. This variable is described here: group_replication_primary_member Shows the primary ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
SORTLEN This is related to the amount of memory required to sort strings expressed in the character set. The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another transaction. Note This table is deprecated as of MySQL 5.7.14 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each remembered trace is a string that is extended as optimization progresses and appends data to it. The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The WAIT_TYPE value is a string that describes the type of wait, as shown in the following table. The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=9G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
(The MySQL server changes its current working directory to the data directory when it begins executing.) If you specify innodb_data_home_dir as an empty string, you can specify absolute paths for data files listed in the innodb_data_file_path value.