PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
This rule set drops information events, and, for other events, removes the source_line field: SET GLOBAL dragnet.log_error_filter_rules = 'IF prio>=INFORMATION THEN drop. To construct more complex conditions, use the AND and OR operators. Both ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. Specify character settings at configuration time, if you build MySQL from source. If most ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. The ...Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-security.html
For information about the implications of this change of default plugin for server operation and compatibility of the server with clients and connectors, see caching_sha2_password as the Preferred Authentication Plugin. For general information about ...Where can I find documentation that addresses security issues for MySQL? ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
The results are already converted; # no need to repeat conversion functions and WHERE clauses each time. Values for the flags, expire_time, and cas_column fields are based on values used in the demo.test sample table. If you are using lookup values ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-tables.html
Suppose that clients named user1 and user2 each connect one time from hosta and hostb. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. Each connection table has CURRENT_CONNECTIONS and ...They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host value is always a specific nonpattern host ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...However, examining a long slow query log can be a time-consuming ...By default, administrative ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
MyISAM Limitation For very small tables, word distribution does not adequately reflect their semantic value, and this model may sometimes produce bizarre results for search indexes on MyISAM tables. For each row in the table, MATCH() returns a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring components and plugins that manage a backing store ...These keyring components are available: component_keyring_file: Stores keyring data in a file local to the server ...