PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See Section 16.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. (See also Section 16.4.1.8, “Replication of ...To ...This means that the value as returned by the call to this function on the source is replicated to the ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Cast Function and Operator Descriptions Character Set Conversions Character Set Conversions for String Comparisons Other Uses for Cast Operations Cast Function and Operator Descriptions BINARY expr The BINARY operator converts the expression to a ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Have your application connect to the database using a user name different from the one you use for ...Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character sequences in Web forms, URLs, or whatever application you have ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-user-by-current-bytes.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. current_count_used The current number of allocated memory blocks that have ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replication metadata repositories (see Section 16.2.4.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ...Event ...In addition, each wait summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
If that works, you should see some introductory information followed by a mysql> prompt: $> mysql -h host -u user -p Enter password: ******** Welcome to the MySQL monitor. To connect to the server, you usually need to provide a MySQL user name when ...Some MySQL installations permit users to connect as the anonymous (unnamed) user to the server running on the local ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ...auto_increment_offset Command-Line Format --auto-increment-offset=# System Variable auto_increment_offset Scope Global, Session Dynamic Yes Type Integer Default Value 1 Minimum Value 1 Maximum Value 65535 This variable has a default value of ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
For InnoDB tables that have a user-defined clustered index, that index can be used even when Using index is absent from the Extra column. For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the ... The ...It lists the tables in the output in the order that MySQL would read them while processing the ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
Setting a session value limits the effect of the change to your current session and does not affect other users. For key_buffer_size, you must take into account that the buffer is shared with those users. You may be able to its improve performance ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...