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/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
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/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/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/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/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/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/programs-overview.html
Several programs perform setup operations during MySQL installation or upgrading: comp_err This program is used during the MySQL build/installation process. mysql_install_db This program initializes the MySQL data directory, creates the mysql ...
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 ...