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/server-shutdown.html
For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. If the SQL thread is in the middle of a transaction at this point, the server waits until the current replication event group (if any) has finished executing, ...If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. On Windows, MySQL Installer interacts with the user and creates a file named ...
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/show-engine.html
An internal buffer that is exposed as a table in the performance_schema database is named after the table, without parentheses. The Status information is in the form of comma-delimited set of name/value pairs. SHOW ENGINE engine_name {STATUS | ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. INET6_NTOA(expr) Given an IPv6 or IPv4 network address ...The ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ...For ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
Only use an innodb_force_recovery setting of 4 or greater on a production server instance after you have successfully tested the setting on a separate physical copy of your database. If you encounter a runaway rollback caused by a failing mass ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If statement-based binary logging format is in use on the source (binlog_format=STATEMENT), the replica evaluates the INSERT operation using the default database, which was set by the USE statement to db1 and has not been changed. The effect of the ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before ...