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/channels-startup-options.html
The values set for the following startup options apply on each channel; since these are mysqld startup options, they are applied on every channel. --slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check ...The following startup settings must be configured correctly to use multi-source ... This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. The replica checks for and evaluates table options only if either ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...See ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. You can ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ...(Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or CURRENT_USER is ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. Whether a word is too short is determined from ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
A more flexible method for query optimization enables the user to control how exhaustive the optimizer is in its search for an optimal query evaluation plan. If you are unsure of what a reasonable value is for optimizer_search_depth, this variable ... The task of the query optimizer is to find an optimal plan for executing an SQL ...The general idea is that the fewer plans ...